E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations

How to get Free Power BI Desktop:
1. When you want to update each month, you have to re-download and re-install.
1. This download will automatically update each month.

This video is an introduction to Data Modeling and Visualization in Power BI Desktop. Learn how to use Power Query to import Excel Files from a Folder. Learn how to build DAX Formulas. Lean how to create an entire Data Model and then build Data Model Visualizations.
This class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools - Excel Data Analysis Basics = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more.
Topics:
1. (00:15) Introduction to Power BI and Interactive Visuals
2. (01:14) Download Files
3. (01:56) Overview of Power BI project
4. (02:38) Excel PowerPivot or Power BI Desktop?
5. (04:20) Power BI History
6. (04:51) Different Versions of Power BI
7. (06:33) Download Free Power BI
8. (07:07) Open Blank File and name “.pbix” file.
9. (07:39) First Look at Power BI Desktop User Interface.
10. (08:45) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
11. (15:21) Import Dimension tables from single Excel Workbook.
12. (15:57) Create Relationships between Dimension & Fact Tables
13. (16:11) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,
14. (21:30) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.
15. (27:20) Hide Tables and Fields that are not used in Reports and Visualizations
16. (28:10) Add new Tabs, Sheets, Pages (all synonyms)
17. (28:26) Create Gross Profit Interactive Visualization
18. (33:29) Create Units Analysis Interactive Visualizations.
19. (33:39) Create Hierarchy
20. (36:17) Summary

[excelisfun]

Topics:
1. (00:15) Introduction to Power BI and Interactive Visuals
2. (01:14) Download Files
3. (01:56) Overview of Power BI project
4. (02:38) Excel PowerPivot or Power BI Desktop?
5. (04:20) Power BI History
6. (04:51) Different Versions of Power BI
7. (06:33) Download Free Power BI
8. (07:07) Open Blank File and name “.pbix” file.
9. (07:39) First Look at Power BI Desktop User Interface.
10. (08:45) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
11. (15:21) Import Dimension tables from single Excel Workbook.
12. (15:57) Create Relationships between Dimension & Fact Tables
13. (16:11) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,
14. (21:30) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.
15. (27:20) Hide Tables and Fields that are not used in Reports and Visualizations
16. (28:10) Add new Tabs, Sheets, Pages (all synonyms)
17. (28:26) Create Gross Profit Interactive Visualization
18. (33:29) Create Units Analysis Interactive Visualizations.
19. (33:39) Create Hierarchy
20. (36:17) Summary

[ruizlandera]

this teaching methodology makes the most of my limited available time..awesome..

[edge]

Thank you Mike... good thing you have the files we can download... thank you for taking time doing this for everybody.

[excelbear]

i wonder if your 1 dislike is the same person who always rushes to watch your video (seems like it always happen pretty early!). Power BI looks awesome!

[TSquared]

This is timely as I'm getting some "stolen" learning on this.

[simfinso]

Amazing.I Always learn From this Most professional You tube channel. Excel is Fun.Many Working Professional Watches Your Videos Carefully In India.

[westernmedicalcentre]

Mike the best teacher ever i have found on YouTube. when i watch one videos it clears many things to me.
thumbs up. whoever ask me about excel i just say excel is fun as mike has already make excel fun and suggest them this subscribe excel is fun.
thanks mike once again

[SyedMuzammilMahasanShahi]

Thanks again Mike this EXCELlent video. You are the best, you know that :P

[ConanNYC]

Great video and love the homework assignment too!!

[entertainmentgalaxy]

Beautiful . thanks for sharing Power bi Fun.

[evgeniam]

WHAT AN AMAZING VIDEO!! I followed along each step and it was -OMG- so fun! Thank you a million times Mike!! :)

[StopWhining]

I've been watching your videos for years and am amazed how you've refined the course navigation to make all of your videos more accessible. Thanks for your continued generosity to the YouTube community.

[wayneedmondson]

Another great one Mike. Thanks for the complete intro to PBID and the comparison to Power Pivot. Thumbs up!

[EcoTechLearningHub]

The drag-and-drop way of creating a hierarchy did not work for me. I got stuck at that point. Is there a way around it? Thank you for your videos.

[brand]

I really like the black background where the fields, and visualizations are located. The updated version of Power BI no longer has it, or I haven't been able to find it in settings to change it to black background

[pabeader]

Good video! One note. You don't have to click in the white space to deselect a filter or highlight. Just reselect the same item again and it will toggle off.

[zhouyinwei]

Great video as always, and the number of like drops obviously from E-DAB 09, not due to the content but because the course is more and more difficult I guess, I had to review and practice a bit previous course to make myself catch up with this one. And for sure will continue to learn further. Thanks again for the value of the series.

[RobMichaels]

I like that you frequently pointed out differences between Excel PowerPivot and Power BI because although they can do the same thing they also have subtly different function names, syntax, and formatting options. Another great video...thanks!

[Chamchijjige]

Completed with fun.Thank you very much.

[rohitvashist]

hi garvin..what happens when there is more than one object in our excel workbook? i made a copy of our sheet in 2014 workbook nad a blank sheet and then tried to remove them but i could not..there are no options to remove rows in power query