Microsoft Power BI for Beginners - 2 Hour Power BI Crash Course!

In this Introduction to Power BI, we teach you 5 of the important Power BI Parts, namely Power Query, Data Modelling, DAX Expressions, Reporting Features, and Publishing to Power BI Service. Power BI is a very powerful business intelligence tool. If Excel isn’t cutting it for your data analysis and modeling, then you likely need to move up to Power BI.

With this 2-hour crash course, you will learn how to import CSV, Excel, and Text files in Power BI and how to transform the data using Power Query. We then look at creating Lookup Tables and Merging Queries. We also cover Data Modelling basics such as creating Relationships between tables and creating a dynamic Date Table using DAX, as well as other DAX Power BI Formulas.

The second half of this video defines Calculated Columns vs Measures and how to create a Key Measures Table. We also teach you how to build a Power BI Report, including adding Visualizations, adding Pages, Bookmarks, and Buttons, and Formatting. Finally, we show you how to pin Visualizations to a Dashboard before Publishing Reports to the Power BI Service.

We've even included downloadable course files so you can follow along in this course. This will help you put what you are learning into practice and master Power BI.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

0:00:00 - Introduction to Power BI Desktop Part 1
0:01:51 - Agenda
0:03:59 - What is Power BI?
0:08:31 - Acquiring Power BI
0:15:16 - Importing CSV Files and Transforming Data
0:29:00 - Importing Excel Files and Text Files
0:32:21 - Creating Lookup Tables
0:40:21 - Merging Queries
0:46:42 - Data Modelling: Creating Relationship Between Tables
0:49:05 - Date Table Using DAX Expressions
0:59:32 - Introduction to Power BI Desktop Part 2
1:02:00 - Agenda
1:03:20 - Recap of Part 1
1:05:55 - Calculated Columns vs Measures
1:15:05 - Creating a Key Measures Table
1:19:07 - Adding Visualizations
1:28:17 - Adding Pages, Bookmarks, and Button
1:36:15 - Adding Filters
1:38:46 - Displaying and Formatting Overview Statistics
1:53:55 - Publishing Report to the Power BI Service
1:58:10 - Pinning Visualizations to a Dashboard

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[rabeehaithamrashid]

Probably one of the absolute best instructors in her field, clear and calm voice, pedagogical and focuses on much like "story telling" method, easy to follow and remember, EXCELLENT! :)

[sachinh]

I have been doing analytics last 15 years..This is great ..very simple, precise & neat...1.20.15 this is exactly what I tell my team ..you hit the 🎯the approach & plan before designing the dashboard is really important.

[conzo]

Where did the UnitPrice, Unit Cost and Sales Quantity come from? They aren't in the table that I downloaded.

[jdo]

A big thank you to my favourite online tutor ''DEB''. You make the course so enjoyable.

[ruksanakabir]

I took her excel course in Alison... I amazed by her easy way teaching stuffs.. now I found here want to learn power bi more from her

[alialharthi]

Part 2 data is not consistent with part 1 data. It is difficult to match the two parts.

[davebatuli]

Such a very informative tutorial. Just very disappointed because on the part 2 of the course there is a complete new dataset that is being used by the instructor that was not used in part 1 and unfortunately that is where the tutorial had to end because we cant follow along anymore😮‍💨😮‍💨

[mehrnooshzahedi]

Wonderful training, you are the best Deb. I learnt a lot, thanks for your complete description of every thing. You explain every thing for every one, from the beginner to advanced level.

[dandavissales]

This started out so well but at the halfway point the data files changed and you can no longer follow along. I managed to add in the missing date columns in the calendar table on my own but there is not enough info to create the columns that are missing on the sales table. Plus there is an error somewhere in the first half causing the data view on the sales table to appear blank although the data is still there. Wish I had read the other comments first...

[ToanTran-pedm]

how to create calculated fields (Unit Cost, Unit Price, Sales Quantity) ?, my dataset not have these column

[naletaporter]

Can I just add? I am so grateful for this course however, it is really frustrating where the materials that you provide does not go with the video. Unit price, unit cost, sales quantity was not shown. Please can you upload that bit of information so I can complete this course? Thank you.

[mohammadhossain]

Hi, I am trying to create a measure using count rows formula. It is giving me all the time 1 as output. I am not sure what I am doing wrong. Also, I have created date table as you have demonstrated in the video and I created a column called week and tried to keep the unique data according to the week column but I am not being able to see that as the table is not visible to the power query editor. I will really appreciate if you can assist me to solve the issues. Thank you in advance.

[aaronjohnbolival]

Thank you for sharing :)
I am newbie in Power Platforms, I just have a few question because im confused in some parts of power bi and just want different opinions/answers .
1. in your opinion is power bi can support large data?
2. if there is a data inserted in excel is power bi automatically update the published reports or the user need to reupload the excel ?
3. I saw in the video that you unable the data load of the sales_prep table but there is new a new table Sales which refered to sales_prep table, the sales_prep table is connected to the imported excel(2016, 2017 etc) if the user insert a new data in the sales.xlsx is the power bi data automatically update or not?

[kabgraphics]

You're helping me build my future today 😍😍😍🙏🙏🙏🙏🙏

[manishsharma-qtvf]

Your videos are very informative. .i want to learn tableau also, if possible do guide me...Thanks Simon ....keep up the good work

[bvdqbqv]

excellent but can't we split date and timestamp during date table creation in data modelling likewise we did split location and country

[AjitSingh-APS]

I love the way you teach Deb, wish I could learn everything from you, thank you 🥰😍

[TariqueZuberi]

From where did you get Unit Cost, Unit Price, and Sales Quantity?

[JAMESCEDRICREMULTA]

there are some new data column in the part2 that are not in the part1 like sales quantity, unit price and cost it's hard to catch up when we can't follow the data

[idowumayowadavid]

Please can I get the two different datasets for the sessions in the video?
I haven't gotten a feedback since I requested the files so as follow along