DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!
ExcelIsFun ExcelIsFun
992K subscribers
14,078 views
0

 Published On Apr 7, 2024

DAME 01: Data Analysis Terms & the Awesome Microsoft Power Tools!
Download files: https://people.highline.edu/mgirvin/A...
Pdf notes to read online: https://people.highline.edu/mgirvin/A...
Alternative link for zipped folder: https://excelisfun.net/files/Video01-...

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, Dynamic Spilled 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 Grain?
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

show more

Share/Embed