Completed
9. #4: Json data, Power Pivot, Data Model, DAX formulas, Row Context and Filter Context for creating Data Model PivotTable Reports.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Data Analysis Tools: Excel, Power Query, Power BI, Dataflow, DAX and M Code
Automatically move to the next video in the Classroom when playback concludes
- 1 1. Introduction
- 2 2. List of MS Power Tools taught in video
- 3 3. Preview of 7 examples
- 4 4. Why use Worksheet as a data analysis solution?
- 5 5. #1 Worksheet Formula solutions: XLOOKUP to do data modeling , PivotTables, dynamic spilled array formulas, and the GROUPBY and PIVOTBY functions
- 6 6. #2: Power Query to import data .txt & .xlsx, transform the data create a report.
- 7 7. #3: Use Power Query to load a table to the PivotTable Cache.
- 8 8. Fix broken On Premises File Path: Data Source Settings.
- 9 9. #4: Json data, Power Pivot, Data Model, DAX formulas, Row Context and Filter Context for creating Data Model PivotTable Reports.
- 10 10. #5 Xml data, Power BI Desktop, Data Model, DAX formulas and Interactive Visuals. Visualization tips too.
- 11 11. #6 Power BI Online Services
- 12 12. #7 Dataflow Online Power Query
- 13 13. Summary
- 14 14. Conclusion
