Download files: DAME01zip Pdf notes to read online: DAME01pdfNotes
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught my Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about data analysis terms and all the amazing Microsoft Power Tools such as: Excel, Power Query, Power Pivot, Power BI, Dataflow, Worksheet formulas, Dyanamic Spileld Array Formulas, M Code formulas, DAX formulas, and much more!
Topics:
1. (00:00) DAME Intro Song
2. (00:12) Introduction
3. (01:18) Table terminology
4. (04:52) What is Grian?
5. (06:41) SQL database as a data source
6. (07:55) Columnar Database in the Data Model in Power Pivot and Power BI
7. (08:57) The many types of source data
8. (09:37) On-premises or Online data source?
9. (10:44) Structure or Schema of tables, files and databases
10. (11:23) Csv File
11. (11:34) Txt File
12. (11:48) Xml File
13. (12:11) Json File
14. (12:36) Excel file
15. (13:03) Define Data Analysis and Business Intelligence
16. (13:49) Steps in data analysis process
17. (14:39) Examples of data analysis and end result.
18. (15:23) Data modeling defined
19. (15:43) Data cleaning and transforming
20. (16:03) Star Schema data model
21. (16:30) Steps to build data model
22. (16:51) Define reports, visuals, dashboards
23. (17:10) Dashboard terminology by Microsoft confusing?
24. (17:37) Excel and worksheet formulas
25. (18:33) Power Query and M Code formulas
26. (19:24) PivotTable as functional language
27. (19:59) Data model and DAX formulas
28. (20:48) Look at projects that we will complete in next video.
29. (23:09) Summary
30. (23:21) Conclusion
#data #dataanalysis #dataanalytics #freeclass #freeclasses #freecourse #microsoftexcel #microsoftmvp #microsoft #powerquery #worksheet #datamodel #datamodelling #powerbi #powerbidesktop #dataflow