ثلاث مراحل عشان تعمل

dashboard

عشان تقدر تعمل التقرير اللي يوصلك لكل النتائج اللي فوق، محتاج تمر ب 3 مراحل من التعلم

1- Visualization Concepts

ودي هتتعلم فيها العناصر الخمسة الأساسية عشان تعرف تعرض بياناتك بصورة واضحة وبسيطة

2-Data Analysis

هتتعلم إزاي تحلل البيانات اللي عندك وتطلع السبب الحقيقي وراء حالة البيزنس باستخدام

pivot tables

وإزاي هتصنفها باستخدام ال

Scatter plot charts

3-Dashboard Creation

هتتعلم إزاي تصمم

dashboard

وإزاي تعمل

summary dashboard

وإزاي تحط النتائج اللي طلعت بيها في ال

dashboard

بطريقة واضحة و بسيطة وجذابة

تفاصيل الكورس

Present Your Data Outline

Sٍtep 1: Visualization Concepts

1. Tell Your Story
build a compelling story to communicate your data in a more appealing way by learning the following:
- Story structure
- How to craft a story
- How to tell a story

2. Keep It Simple
- Know the different chart types
- When to use every chart
- How to transform complex chart to simple chart

3. Using Colors
- The role of the colors
- Colors meanings
- Colors schemes

4. Drive the Focus
- How to grab the attention of your customer by using different techniques

5. Say It with Pictures
- Know how to use pictures to make your story more powerful

Step 2: Data Analysis

1. Explore Pivot Table Options

2. Chart Formatting

3. Formatting Numbers

4. Root Cause Analysis Using Pivot Table
- How to extract insights from your data using a pivot table

5. Scatter Plot Analysis
- How to use the scatter plot chart to do segmentation for the data

Step 3: Dashboard Creation

1. How to Design a Dashboard

2. Create a Summary Dashboard

3. Visualize the Insights in a Detailed Dashboard

Excel Dashboard Outline

1. Pivot Table

1. Create Pivot Table

2. Pivot Table Calculations

- How to do calculations on Pivot Table

3. Pivot Table Relationships

- How To create relationships between sheets in the Excel and link it to 1 pivot table

4. Distinct Count

- How to do distinct (unique) count for customers or transactions

2. Excel Dashboard Creation

1.Create Slicer

- How to create dynamic filters and link them to different charts

2. Dynamic Data Selection

- Use Excel functions to make the data in the excel dashboard dynamic

3. Dount and Progress Bar Chart

4. Link and Hide Sheets

النتائج اللي خرج بيها الناس اللي طبقت المراحل ال3 لل

Data Visualization

Mohammed Khairuldin

Company: Saudia Airlines

Job Title: Station Executive Supervisor

“New way to present the data, a new technique for deep analysis, as a Station Supervisor in an airlines industry we present the operational performance and analyze it and this course was very helpful”

Noha Kamal

Company: Chemical Industries Holding Company

Job Title: General Manager of Technical Office

“It made me Focus on the presentation's goals and align them with the company. gives new perspective for how to make a dashboard and the effective colors, size of chats, size of texts and the impersonation it leaves at the audios”

Ahmed Essawy

Job Title: Bidding Director

“The simplicity and focusing on the course target, it’s highly recommended to corporates team to improve their performance and professionalism”

Naglaa Ismail Abdulla

Company: Chemical Industries Holding Company

Job Title: General Director

“Recorded videos are very helpful I would like to thank the expert MR Ahmed Emad for his efforts and excellent methods and great experience that make the course very specific in Data Analysis using Excel Dashboard and that helped us to recognize the field of data analysis and data visualization”

Mahmoud Amin

Job Title: Field Sales Manager

“The way of communication through weekly online meeting for discussion & questions”

Anwar Assal

Job Title: Managing Director

“Straight to the point content and very helpful to present an executive dashboard summary to my managing partners”

Tariq Robeen

Company: Al Andalus Trading Co.

Job Title: Sales Manager

“The simplicity of presenting the information and the short time of the video lectures which was very valuable”

Mohamed Essam

“The mind shift that happened through this workshop is very significant, as it taught me how to think differently and how to see the data in a different way and gain insights and deliver them properly for the target audience”

Heba Muhammed

“The style of the delivery is very simple, to the point with no much details. Very valuable resources”

Rached Arfaoui

“Everything is perfect and the way presented step by step helps students to learn faster and in an efficient manner. Great Job PI team”

Karim Ahmed Abdo

Company: Pharma Overseas

Job Title: HR Manager

“التواصل وعرض ماتم تنفيذه وتصحيح الاخطاء اولا بأول - اسلوب الشرح متميز”

About The Instructor

Ahmed Emad is a professional data visualization expert and the founder of Powerful Insights

Ahmed has been dedicatedly developing business intelligence projects in the Middle East. One of his best projects was crafted when he was joining SAP as Performance Analytics Consultant, where he developed a set of 10 end to end BI projects using SAP BI tools; two of them won SAP bronze quality award

Empowered with over 10 years of experience in visualizing data, Ahmed is utilizing his long experience and wide knowledge to boost business ROIs using the powers of visualizing data. He believes that transforming regular reports into perfectly visualized ones can be a turning point for the future of every business. His goal is to spread such powerful solution among those whose jobs include communicating with data

شرح الكورس: بالعربى

مدته الكورس

Present Your Data & Excel Dashboard

5.5 ساعات

الكورس فيديوهات مسجلة تقدر تتفرج عليها اونلاين فى اى وقت من غير تحميل

Tools المستخدمة فى الكورس

Microsoft Excel and PowerPoint 2016

يفضل استخدام

Excel 2016 or 2013

مميزات اضافية لما تشترك فى الكورس

فيسبوك جروب تقدر تسأل عليه اى سؤال وكمان بنحط عليه معلومات جديدة باستمرار

اجتماع اونلاين شهرى لكل الناس اللى اخدت الكورس سواء اونلاين او حضرته علشان لو عندك اى سؤال او اسفسار

فى عرض حاليا على الاجمتماع الاونلاين هيكون مرتين فى الاسبوع خلال شهر ابريل ومايو علشان نساعدك اكثر

تكلفة الكورسين

Present Your Data and Excel Dashboard

70% عرض لفترة محدودة خصم

500 جنية

( $دولار 30)

بدل من السعر الاساسى

Present Your Data 950 جنية

($55)

+

Excel Dashboard 700 جنية

($45)

=

1,650 جنية

($100)

تقدر تسترد فلوسك في حالة انك مستفدتش من الكورس فى خلال 30 يوم من الدفع

طرق الدفع

Credit Card (USD) or PayPal: https://bit.ly/2wo6hjj

Credit Card (EGP): https://bit.ly/322dUGu

Vodafone Cash: 01097976655

للاستفسار كلمنا على

+201097976655

او ابعتلنا على

ahmed.emad@powerful-insights.com

Hospital Performance Dashboard

Analysis for 2018 and 2017