Join Our Most Professional Telegram Group. Only Learning. No Nonsense. https://t.me/TheExcelism

Topic: Power Query & Power Pivot I Mode: Online LIVE I Date: 17th Aug to 1st Sep I Time: 6:30 AM to 8:00 AM I Fees: INR 4,000

ENROLL

---

SYLLABUS:

Section 1: Intro to Power Features
1. Versions and Compatibility
2. Intro to ETL Concepts
3. Around Get & Transform Data Tab

​Section 2: Working with Power Query
4. Power Query Editor and User Interface
5. Manage Columns and Rows
6. Transform Table, Column etc
7. Transform Text, Number and Date Columns
8. Column from Example vs Flash Fill

​Section 3: Combine with Power Query
9. Append Queries
10. Case Studies on Append Queries
a) Many Tables Data from Same Worksheet
b) Data from Different Sheets of Same Workbook
c) Data from Difference Workbook
d) Data from Multiple Sheets of Different Workboooks
11. Concept of Merge
12. Different Types of Joining Queries
a) Left Outer Join
b) Right Outer Join
c) Full Join
d) Inner Join
e) Left Anti Join
f) Right Anti Join
13. Fuzzy Matching
​14. Practical Case Studies

Section 4: Importing of Data into Power Query
15. Importing of Excel Files
16. Importing of Text Files
17. Connecting to the Folder
18. Connecting to the Web Pages

​Section 6: Transformation Techniques
19. Concept of Split with delimited, positions, characters
20. Concept of Unpivot and Pivot
21. Concept of Group by
22. Using Standard transformation features
23. Practical Case Studies
24. Diff b/w Transform Tab vs Add Column Tab
25. Duplicate vs Reference Query

​Section 7: Mash-up Language
26. Intro to M-Formula
27. Understanding the "let..in.." statements
28. Writing Custom Functions
29. Invoking Custom Functions
30. Practical Case Studies

​Section 6: Power Pivot
31. Intro to Power Pivot
32. Data Modeling Concept
33. Relationships in Pivot Tables
34. Calculated Item and Calculated Field in traditional Pivot Tables
35. Calculated Column vs Calculated Field (Measures)
36. Intro to Data Analysis Expressions (DAX)
37. Important DAX Formulas and Functions
38. Practical Case Studies using Power Pivot
39. Usage of KPI