• Present Your Data and Excel Dashboard Online Courses

    اتعلم مهارة عرض البيانات فى صورة

    Dashboard

     

    و تقديمها في شكل قصة بسيطة وجذابة تخلي المتلقي سواء عميلك أو مديرك قادر إنه يتفاعل معاك ويشاركك أفكارك ووجهه نظرك ويقتنع بيها كمان, وبالتالى تحقق أهدافك

    Turn Your Data Into Effective Dashboard in 3 Steps

  • Get These AMAZING Results in Excel

     

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

    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

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

    [email protected]

     

  • Download Now

    You can add any link or even upload a file to this button!

    All Posts
    ×