Download files: DAME01zip Pdf notes to read online: DAME01pdfNotes
\nFree YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught my Excel MVP and Highline College Professor, Mike \u201cexcelisfun\u201d Girvin.
\nIn 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!
\nTopics:
\n1. (00:00) DAME Intro Song
\n2. (00:12) Introduction
\n3. (01:18) Table terminology
\n4. (04:52) What is Grian?
\n5. (06:41) SQL database as a data source
\n6. (07:55) Columnar Database in the Data Model in Power Pivot and Power BI
\n7. (08:57) The many types of source data
\n8. (09:37) On-premises or Online data source?
\n9. (10:44) Structure or Schema of tables, files and databases
\n10. (11:23) Csv File
\n11. (11:34) Txt File
\n12. (11:48) Xml File
\n13. (12:11) Json File
\n14. (12:36) Excel file
\n15. (13:03) Define Data Analysis and Business Intelligence
\n16. (13:49) Steps in data analysis process
\n17. (14:39) Examples of data analysis and end result.
\n18. (15:23) Data modeling defined
\n19. (15:43) Data cleaning and transforming
\n20. (16:03) Star Schema data model
\n21. (16:30) Steps to build data model
\n22. (16:51) Define reports, visuals, dashboards
\n23. (17:10) Dashboard terminology by Microsoft confusing?
\n24. (17:37) Excel and worksheet formulas
\n25. (18:33) Power Query and M Code formulas
\n26. (19:24) PivotTable as functional language
\n27. (19:59) Data model and DAX formulas
\n28. (20:48) Look at projects that we will complete in next video.
\n29. (23:09) Summary
\n30. (23:21) Conclusion<\/p>\n

#data #dataanalysis #dataanalytics #freeclass #freeclasses #freecourse #microsoftexcel #microsoftmvp #microsoft #powerquery #worksheet #datamodel #datamodelling #powerbi #powerbidesktop #dataflow<\/p>\n","protected":false},"excerpt":{"rendered":"

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 \u201cexcelisfun\u201d 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, […]<\/p>\n","protected":false},"author":3,"featured_media":6716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,21],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2024\/04\/ja68xMpabQA.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-1Kj","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6715"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=6715"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/6715\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/6716"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=6715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=6715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=6715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}