Excel & Power BI Data Analysis Complete Class in One Video - 365 MECS 04

This video is a comprehensive lesson in Data Analysis in Excel and Power BI.

Topics in video:
1. (00:00) Introduction
2. (03:52) What is Data Analysis?
3. (04:37) Sorting and Filtering. Example 1 & 2
4. (13:24) FlashFill. Example 3.
5. (15:58) Standard PivotTable with Summarize Values By and Show Values As calculations. Example 4.
6. (20:25) Power Query to import, clean, transform and refresh data and load to Excel Worksheet. Complete Introduction to Power Query. Example 5.
7. (34:07) First look at Power Query’s Functional Language: M Code
8. (55:05) Power Query to Import and combine 12 tables into one table and load directly to a PivotTable Report & Excel Chart Visualization. Example 6.
9. (01:10:18) Excel Line Chart Visualization based on PivotTable
10. (01:14:04) Data Modeling for Examples 7, 8 & 9
11. (01:17:51) XLOOKUP function, PivotTable and Excel Charts to build report and visualization. Example 7.
12. (01:28:37) Power Pivot, Data Model, Relationships and DAX Formulas to build Data Model PivotTable Reports. Power Query to import Excel data. Complete Introduction to Power Pivot. Example 8.
13. (01:55:51) Sort By Column Feature for Data Field in Data Table
14. (01:57:21) Filter Context for DAX Formulas in Data Model
15. (02:02:04) Implicit Measures and Automatic Date Grouping: Dangers of Data Models
16. (02:05:54) Mark As Date Table
17. (02:07:05) Send Data Model to Power BI Desktop to make Interactive & Sharable Dashboard. Example 9.
18. (02:07:32) Complete Introduction to Power BI Desktop, Including how to download free app
19. (02:18:53) Building Interactive Visuals
20. (02:29:08) Stacked Bar/Chart Vs. Clustered Bar/Chart
21. (02:34:48) Complete Introduction Power BI Online and Workspaces to share Power BI Desktop files, Excel files, dashboards and data models easily online.
22. (02:43:00) What is a Dashboard?
23. (02:48:06) Connect to Data Models stored at Power BI Online in Excel and Power BI Desktop
24. (02:51:46) Refresh Excel Power Pivot, Power BI Desktop and Power BI Online when Source Data Changes
25. (02:57:08) Power BI Desktop and Power Query to import 7 million rows of SQL Database sales data and build Interactive Gross Profit Dashboard. Example 10.
26. (02:59:43) What is a Columnar Database?
27. (03:01:15) Idea behind DAX Revenue Formula (Measure)
28. (03:02:53) Log in to SQL Database, Import 7 million rows of data with Power Query in Power BI Desktop
29. (03:07:33) Build DAX Date Table
30. (03:12:33) Row Context in DAX Calculated Columns and DAX Iterator Functions
31. (03:17:48) Hide Fields in Report View
32. (03:19:10) Two-Step DAX Revenue Measure using ROUND and RELATE#D DAX functions
33. (03:26:18) One-Step DAX Revenue Measure using SUMX DAX function
34. (03:28:32) Compare One-Step and Two-Step Measures. Which is better?
35. (03:31:26) Create four Remaining Measures in Report View
36. (03:34:18) What is Gross Profit? Two Measures for Gross Profit.
37. (03:38:51) Create Two Power BI Reports, including Map Report
38. (03:41:23) Map Visual
39. (03:43:19) Conclusion
40. (03:43:44) Closing and Video Links

#MikeGirvin
#excelisfun
#MikeexcelisfunGirvin
#Microsoft365Excel
#FreeDataAnalysisClass
#DataAnalysisOnlineCourse
#pivottables
#powerquery
#powerpivot
#powerbi
#powerbidesktop
#DAXMeasures
#DAXFormulas
#mcode
#PowerQueryFormulas
#sort
#filter
#filterfunction
#flashfill
#LearnDataAnalysis
#datascience
#YouTubeDataAnalysis
#BusinessIntelligence
#dataanalytics
#dataanalysis
#dataanalyst
#ExcelMVP
#xlookup
#SUMX
#related
#COUNTROWS
#relationships
#datamodel
#datamodeling
#DataModelinginPowerBI
#freeclass
#FreePowerBIClass
#visualization
#powerbidesktop
#mcode
#excel
#dax
#learndax
#daxfunctions
#measure
#daxmeasure

[excelisfun]

Two Notes: 1) Homework practice problems to the end of the workbook file: "04-M365ExcelClass.xlsx". 2) There is a Video Progress Checklist that can help to track progress through this long video. The "ProgressChecklist" worksheet is in the file "04-M365ExcelClass.xlsx" and is in a separate stand alone file named: (Checklist idea came from Dom Tomoff at LinkedIn).

[mr.d]

Folks, I've made an entire career using Excel with the help of these videos. This man is the best I've seen. Thank you for everything you do!!

[lenamanh]

I'm too broke to pay for online courses. Watched a lot of other videos on YouTube, but they just beat around the bush.


Then I see this video. 4 hours straight to the point. No courses mentioned. No bs. Sir, you dropped this 👑

[mahamohan]

There is a saying “Nothing comes free”. But you are proving it’s wrong. Your commitment in providing free Excel education to all is a matter of delight to interested students.

[aruneshbahadur]

Hope your mom is feeling better Mike. Thank you for teaching the world how to unleash the power of excel!

[sujeetsamal]

Respected sir...you are raising the standard of education in your videos day by day... when we use these tricks in office, people think us whizard also.... your teaching skill is better then the masters from whom even you learn..🙏🙏

[alioukane]

Never had to comment on YouTube. Mr. Girvin has to gift to teach, to connect with students along with the ability to explain very clearly.
He purchased the latest book just because the author is, Mr. Mike Girvin.
Thank you for being able to help.
You are an outstanding teacher, and you got me hook on YouTube, but now I will focus on that great book that you put out there for us.
Respect

[idesignestudios]

This Man knows what he says. He teaches with passion. 1 Million stars 🙂👏

[TheBrownAntiHero]

Sir, I don't usually comment but I just want to say thank you so much for putting this out on Youtube for free. This was immensely helpful. Your hard work has not gone unappreciated!!

[GazaAli]

Thank you so much Mike. How the world needs more people like you

[devisistech]

I had an assignment in data analytics but had no idea where to start from. This video is by far the best.

[meniporat]

From one teacher to another:
You are the eighth wonder of the world
❤❤❤

[patrickschardt]

I am new to Power Query. I tackled almost all the new dynamic array formulas and some older formulas. Now I need to learn PQ, BI, and VBA.

I have found PQ to be fairly easy for simple tasks and relatively straightforward for more complex situations.
I have found if there’s something that you going to be doing multiple times, like changing field names, changing data types, etc, do as many as possible in one step. Delete all unnecessary columns before doing any further manipulation. Delete unneeded created columns all at once too

[festusraphael]

Prof. Mike you are great. You engrafted and endeared excel to me some years ago. You have never failed to amaze me with your free contents that would have cost a fortune to learn elsewhere. Thank you so much and God bless you.

[VishalKumar-kvdp]

I should call it the HOLY BIBLE OF EXCEL... I have gone through umpteen videos but never ever came across such an effortful, useful, and easy to understand tutorial on the subject. I thank you from the bottom of my heart for bringing this video... God bless you 🙏

[zt.]

Astonishingly rich content (in the entire 365 collection, but this one is par excellence). Very motivating to work along using all the files. Thank you.

[martyc]

This is a brilliant video if your learning power bi - I’m fairly handy at power bi now but I still picked up quite a few tricks watching this.

[MT]

This was such an amazing video! Complete, fun, exceptionally well explained. I love the fact that you word your steps on each occasion, so they are easy to remember and elaborate despite the complexity of the subject. Thank you again Mike, you are really the best!

[IceColdProfessional]

I never knew data could be so fun! What a time to be alive!

[RogerStocker]

Extraordinary amazing! tanks for this updated version of older video series. I definitly watched the whole session not in a row but in about 5 parts. I enjoyed how you taught us through the topic.