Download the free course files to follow along ️https://www.simonsezit.com/power-bi-crash-course-instructor-files/

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.

https://www.simonsezit.com/power-bi-crash-course-instructor-files/

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

Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for data visualization https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2

Power BI Tutorials for Beginners video playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s

Microsoft Excel Beginner's Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Data Analysis using Microsoft Tools here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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