fbpx

Power BI Tutorial 2022

Power BI has been evolving rapidly. That’s why I created the new Power BI Tutorial 2022 – which is based upon July 2022 updated version. We cover the entire data lifecycle as shown below.

Data life cycle covered in Power BI Tutorial 2022
This is a 50+ minute video with step-by-step instructions. You can follow along.

Power BI Tutorial Video (53 minutes)

Watch the video on YouTube.

Download sample files

For this tutorial, you need two files. One CSV containing transactions data and one Excel file containing the location data. Using this file you will create a new Power BI report file (PBIX). I have also included a completed PBIX file for your reference. These three files are available as a zip file (740kb) for download.

Power BI Tutorial: Table of Contents

Go to a specific topic in the video directly. Use the contents link below.

  1. Introduction – 00:00
  2. Sign in and Install Power BI – 00:34
  3. Power BI Desktop Menus – 03:44
  4. View all Data Sources – 04:20
  5. Import Transactions CSV – 05:14
  6. Clean up transaction file – 06:02
  7. Import Location data from Excel file – 09:49
  8. Create relationship between tables – 13:01
  9. Field List – 14:31
  10. Hide unwanted columns – 15:07
  11. Shaping data – 16:23
  12. Set Data Categories – 16:56
  13. Set default summarization – 18:59
  14. Save file as PBIX – 20:27
  15. Report tab Menus and Panes – 20:50
  16. Date Hierarchy – 21:42
  17. Create a visual – 22:21
  18. Create card visual to show total amount – 23:44
  19. Add Transaction Count card – 26:48
  20. Create Pie chart – 27:47
  21. Create Column Chart – 30:16
  22. Add Data Labels – 31:42
  23. Create a Map – 32:09
  24. Cross Filtering – 35:26
  25. Map Auto Zoom – 37:08
  26. Rectangle selection in map – 37:33
  27. Add a slicer – 38:58
  28. Using Bookmarks for storytelling – 40:59
  29. Sharing Power BI reports – 43:54
  30. Publish to Power BI portal – 44:50
  31. Share report from Power BI portal – 45:58
  32. Sharing the dataset with others – 49:12
  33. Use Power BI dataset inside Excel – 50:24
  34. Refreshing the data and report – 51:41
  35. Summary – 51:58

This Power BI Tutorial is updated based upon the 2022 version of PBI desktop. Power BI has come a long way. Hundreds of new features have been added over the last decade. However, the core concepts are still the same. Here are some related articles and videos which are still relevant and important.

  1. Power BI for Excel users – Democratizing BI – Best Practices
  2. How to use Power BI free of cost
  3. Excel vs Power BI – differences and common features
  4. Get data from website – Excel and Power BI

Queries | Comments | Suggestions | Wish list

Efficiency Book Cover
0
Efficiency Best Practices by Dr Nitin

Released!

Efficiency book by

Dr Nitin Paranjape

0
Efficiency Best Practices