Completed
4. Why use Worksheet as a data analysis solution?
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
