FB Instagram Twitter Youtube Linkedin Data Analysis by using Excel | E3melbusiness Medical

Data Analysis by using Excel

Home | Courses | Data Analysis by using Excel

Data Analysis by using Excel

( 11479)

Course Summary

  • 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

Course Details

                                                  

Number of lectures : 4 Lectures

Course duration : 11:34:05 Hour

Course Content

01 Course Main Outlines ( 19:04 )
02 Power Pivot ( 15:54 )
03 Power Query ( 14:19 )
04 Power Query (2) ( 12:37 )
05 Dealing With Text ( 13:07 )
06 Dealing with Numbers ( 13:21 )
07 Dealing with dates ( 09:10 )
08 index column ( 17:42 )
09 Pivoting and unpivoting data ( 11:36 )
10 Merge queries ( 13:42 )
11 Right outer ( 13:32 )
12 Appending ( 21:49 )
13 Exercise Start training
01 Data Modeling ( 14:19 )
02 Merge Vs. Relationships ( 16:44 )
03 Modifying Relationships ( 10:58 )
04 Filter Direction ( 12:59 )
05 Exercise Start training
01 Insert Pivot Table ( 12:19 )
02 Calculated Columns ( 19:18 )
03 Measures ( 13:30 )
04 Create Measures ( 11:44 )
05 Understand filter context ( 11:07 )
06 DAX Syntax ( 08:26 )
07 Math ( 17:45 )
08 Count Functions ( 14:03 )
09 Logical Functions ( 19:03 )
10 Example ( 07:12 )
11 Switch and Switch(true) ( 18:04 )
12 Text Functions ( 13:54 )
13 Calculate ( 11:34 )
14 Using filter with calculated function ( 13:46 )
15 All function ( 14:36 )
16 X functions ( 20:04 )
17 Data and time functions ( 09:16 )
18 Time intelligence ( 21:37 )
19 Time intelligence (2) ( 14:37 )
20 KPI ( 22:32 )
21 Target break down ( 15:03 )
22 Target break down (2) ( 17:49 )
23 Exercise Start training
01 Dealing With PT Details ( 12:15 )
02 Dealing With PT Details (2) ( 13:53 )
03 Dealing With PT Details (3) ( 15:27 )
04 Filter and Sort Data ( 10:59 )
05 Data Grouping ( 15:59 )
06 Show Value As ( 18:17 )
07 Example ( 12:04 )
08 Calculated field and item ( 20:33 )
09 Slicer ( 16:26 )
10 Exercise Start training
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

Inquiries about the training course

Training course lecturers

Mina Mourad
Mina Mourad
    • مدرب معتمد من مايكروسوفت منذ عام 2010
    • خبرة 11 سنة في مجال تدريب برمجيات مايكروسوفت أوفيس
    • حاصل على 5 شهادات دولية متخصصة في برمجيات مايكروسوفت أوفيس
    • قمت بتدريب العشرات من الموظفين والقيادات الإدارية للعديد من المؤسسات مثل سكة حديد مصر، مترو الأنفاق، البنك الأهلي المصري، CEMEX ، إدارة التطوير بالتربية والتعليم والعديد من مديري مبيعات الشركات الإنترنشونال مثل MSD , Sanofi , Novartis
    • صاحب ومؤسس كورس Excel and PowerPoint for medical reps  أول كورس Excel تم تصميمه مخصصًا للعاملين في مجال الدعاية الدوائية ومجال المبيعات لإدارة عملية البيع بشكل كامل عن طريق الاكسل

Your evaluation of the course :

  • Lecturer
    • Mina Mourad
  • Course duration
    11:34:05
  • Number of lectures
    4 Lectures
  • Language
    Arabic
  • Certificates
    Yes
Join now