FB Instagram Twitter Youtube Linkedin Data Analysis by using Excel | Yotta Medical School
Skip to content Skip to main navigation

Data Analysis by using Excel

Mastering in deep Data analysis by using Microsoft Excel Business intelligent tools such as Pivot table , Power query , Power Pivot and DAX functions
Subscribe NOW

Course Details

  • Get and Transform data by using power query
  • Types of data connections
  • Data Modeling
  • Data View Vs. Diagram View
  • Power Pivot and DAX functions
  • Normal Pivot Vs. Power Pivot
  • Mastering Pivot Tables
  • Design and Formatting

                                                  

  • Number of lectures 4
  • Number of hours 11:34:05

Course Topics

  • 01 Course Main Outlines   19:04 Listen Watch
  • 02 Power Pivot   15:54 Listen Watch
  • 03 Power Query   14:19 Listen Watch
  • 04 Power Query (2)   12:37 Listen Watch
  • 05 Dealing With Text   13:07 Listen Watch
  • 06 Dealing with Numbers   13:21 Listen Watch
  • 07 Dealing with dates   09:10 Listen Watch
  • 08 index column   17:42 Listen Watch
  • 09 Pivoting and unpivoting data   11:36 Listen Watch
  • 10 Merge queries   13:42 Listen Watch
  • 11 Right outer   13:32 Listen Watch
  • 12 Appending   21:49 Listen Watch
  • 13 Exercise   Start exam
  • 01 Data Modeling   14:19 Listen Watch
  • 02 Merge Vs. Relationships   16:44 Listen Watch
  • 03 Modifying Relationships   10:58 Listen Watch
  • 04 Filter Direction   12:59 Listen Watch
  • 05 Exercise   Start exam
  • 01 Insert Pivot Table   12:19 Listen Watch
  • 02 Calculated Columns   19:18 Listen Watch
  • 03 Measures   13:30 Listen Watch
  • 04 Create Measures   11:44 Listen Watch
  • 05 Understand filter context   11:07 Listen Watch
  • 06 DAX Syntax   08:26 Listen Watch
  • 07 Math   17:45 Listen Watch
  • 08 Count Functions   14:03 Listen Watch
  • 09 Logical Functions   19:03 Listen Watch
  • 10 Example   07:12 Listen Watch
  • 11 Switch and Switch(true)   18:04 Listen Watch
  • 12 Text Functions   13:54 Listen Watch
  • 13 Calculate   11:34 Listen Watch
  • 14 Using filter with calculated function   13:46 Listen Watch
  • 15 All function   14:36 Listen Watch
  • 16 X functions   20:04 Listen Watch
  • 17 Data and time functions   09:16 Listen Watch
  • 18 Time intelligence   21:37 Listen Watch
  • 19 Time intelligence (2)   14:37 Listen Watch
  • 20 KPI   22:32 Listen Watch
  • 21 Target break down   15:03 Listen Watch
  • 22 Target break down (2)   17:49 Listen Watch
  • 23 Exercise   Start exam
  • 01 Dealing With PT Details   12:15 Listen Watch
  • 02 Dealing With PT Details (2)   13:53 Listen Watch
  • 03 Dealing With PT Details (3)   15:27 Listen Watch
  • 04 Filter and Sort Data   10:59 Listen Watch
  • 05 Data Grouping   15:59 Listen Watch
  • 06 Show Value As   18:17 Listen Watch
  • 07 Example   12:04 Listen Watch
  • 08 Calculated field and item   20:33 Listen Watch
  • 09 Slicer   16:26 Listen Watch
  • 10 Exercise   Start exam
  • Course Presentation Download
  • KPI's Download
  • Append Download
  • Merge 1 Download
  • Merge 2 Download
  • Merge 3 Download
  • Merge 4 Download
  • Merge 5 Download
  • Merge 6 Download
  • Bricks Download
  • Calendar Download
  • Distributor Download
  • Medical_Rep_lookup Download
  • Pharmacies_lookup Download
  • Products_Lookup Download
  • Region-Lookup Download
  • Returns-2017-2018 Download
  • Show Value As Download
  • Unpivot Download
  • 11 Final Exam   Start exam

    • Course Instructor

    Mina Mourad

    Mina Mourad

    • More than 12 years of experience in the field of training for individuals and companies.
    • Certified as official trainer from microsoft from 2010 and official microsoft learning consultant from 2011.
    • Microsoft office specialist expert which trained more than 5000 candidates with 98% customer satisfaction average rate.
    • Working as expert training consultant freelancer in many national and international companies. 
    • He designs and trains a full courses and programs for medical field for all field force and managerial levels that working in different Pharmaceutical companies such as Sanofi , Novartis , MSD , chemipharm , October … Etc.

    For Asking Question:

    *

    *

    You must be logged in first. Log In?
    image