Power BI Tutorial

This MS Power BI Tutorial helps you to learn this tool from basic to advanced. Below set of Power BI tutorial links will show you the step by step approach to connecting with multiple data sources, data transformations, and creating reports like charts, tables, matrix, maps, etc with screenshots. Use them to learn Power BI tutorial step by step.

It is one of the most popular Data Visualization tool, and a Business Intelligence Tool. This ms Power BI tool is a collection of data connectors, apps, and software services, which are used to get data from a different source, transforms data, data modeling, and produce beautiful reports.

It also allows data analysts to publish reports for your organisation. So that you can access them using mobiles, tablets etc. This MS Power BI tutorial explains this steps as well. So, read this tutorial completely to learn Power BI

Power BI Desktop Tutorial

We can install the Power BI desktop on our local computer to create our reports. By using this desktop, we can connect to different data sources such as text files, databases, excel files, etc. Next, we use this data to build reports by dragging the required charts. Finally, we can share those reports across the organization.

This section of Power BI tutorial covers the establishing connections, preparing data etc

  1. Download and Install BI Desktop
  2. Add, Rename, Duplicate, and Delete Pages
  3. Connect to SQL Server
  4. Connect to Multiple Excel Sheets
  5. Get Data from Excel Files
  6. Get Data from Text Files
  7. Load Data from Multiple Data Sources
  8. Remove Unwanted Columns from Tables

Power BI Transformations Tutorial

In real-time, we don’t get the data that we can directly use in the reports. I mean, we have to clean that data to meet our business standards. Within the desktop, we have a power query editor to perform all the operations that we needed. This section of the Power BI tutorial explains most of the data transformations that you need.

  1. Bins
  2. Change the Data type of a Column
  3. Combine Multiple Tables
  4. Clusters
  5. Enter data or Copy & Paste data from Clipboard
  6. Format Dates
  7. Groups
  8. Hierarchies
  9. Joins
  10. Pivot Table
  11. Query Groups
  12. Reorder or Remove Columns
  13. Rename Column Names
  14. Rename Table Names
  15. Split Columns
  16. UnPivot Table

Power BI Charts Tutorial

Within the desktop visualization tab, you can see the small icons each represents one chart. Simply clicking that image will create a chart, or dragging appropriate measures or dimensions will also create a basic chart.

The following are the list of charts that are available to work. This section of Power BI tutorial covers the definition and the configuration of each and every chart.

  1. Power BI tutorial about Area Chart
  2. Bar Chart
  3. Card
  4. Clustered Bar Chart
  5. Clustered Column Chart
  6. Column Chart
  7. Donut Chart
  8. Funnel Chart
  9. Heat Map
  10. Line Chart
  11. Clustered Column and Line
  12. Line and Stacked Column
  13. Matrix
  14. Multi-Row Card
  15. Pie Chart
  16. Ribbon Chart
  17. Stacked Area
  18. Scatter Chart
  19. Stacked Bar Chart
  20. Stacked Column
  21. Table
  22. Tree Map
  23. Waterfall Chart
  24. 100% Stacked Bar
  25. 100% Stacked Column
  26. Map
  27. Filled Map

The following Power BI tutorial section covers the formatting options for the data analytics charts.

  1. Format Area Chart
  2. Format Bar Chart
  3. Formatting Card
  4. Format Clustered Bar
  5. Format Cluster Column
  6. Formatting Column
  7. Format Donut Chart
  8. Format Funnel Chart
  9. Formatting Line Chart
  10. Format Line & Clustered Column
  11. Format Line & Stacked Column
  12. Formatting Matrix
  13. Format Multi-Row Card
  14. Format Pie Chart
  15. Formatting Ribbon
  16. Format Stacked Area
  17. Formatting Scatter
  18. Format Stacked Bar
  19. Format Stacked Column
  20. Formatting Table
  21. Format Tree Map
  22. Formatting Waterfall
  23. R Script
  24. Format Map
  25. Format Filled Map

Power BI Filters Tutorial

The following power bi tutorial section explains you about the types of Filters with a practical example

  1. Slicer
  2. Basic Filters
  3. Advanced Filters
  4. Top N Filters
  5. Filters on Measures
  6. Page Level Filters
  7. Report Level Filters
  8. Drill through Filters

Power BI Tutorial on Calculated Fields

It converts the Power BI tutorial about calculated fields. Sometimes, we don’t get the columns that we need to perform visualization. In these situations, we can create calculated fields that we have shown below. Within these columns, we can write simple arithmetic operations or the most powerful DAX functions.

  1. Calculated Columns
  2. Conditional Columns
  3. Calculated Measures
  4. Calculated Tables
  5. Custom Columns

Power BI Tutorial on Dashboards

The Power BI tutorial on Dashboards, adding report items to the dashboard, and publishing them.

  1. Register to Pro Service
  2. Dashboard Introduction
  3. Connect Desktop with BI Service or Pro
  4. Publish Desktop Reports
  5. Create a Workspace
  6. Create a Dashboard
  7. Favourites

Learn working with Power BI Dashboards

This Power BI tutorial section is about the Dashboard creation, adding content, deleting items etc.

  1. Dashboard Actions
  2. Add Reports to a Dashboard
  3. Add Title to Dashboard
  4. How to Add Image to Dashboard
  5. Add Video to Dashboard
  6. Add Web Content to Dashboard
  7. Dashboard Settings
  8. Delete a Dashboard
  9. Pin Report to a Dashboard

Reports and Datasets

In this tutorial section, learn Power BI report creation, datasets creation etc.

  1. Creating a Report
  2. Creating a Report using Excel Data
  3. Upload Excel Files to Dashboard
  4. Upload Workbook
  5. Pin Workbook to Dashboard
  6. Rename a Dataset
  7. Rename a Report
  8. Get Insights of a Dataset
  9. Get Insights of a Report

Learn Power BI Work Sharing

This Power Bi tutorial section covers the sharing of Work. I means, sharing reports, Dashboards, apps, Workspaces etc.

  1. Share a Dashboard
  2. Share a Report
  3. Sharing Workspace
  4. Publish App
  5. View Published App
  6. Edit App


  1. Subscribe Dashboard
  2. Subscribe Report

Q&A Section

  1. Q&A
  2. Customize Q&A Suggestions
  3. Advanced Q&A

MS Power BI DAX Tutorial

DAX means Data Analysis Expressions. And, we have to use the DAX functional language formulas to create calculations on table data. Like any other language, DAX supports many built-in functions to work on Numeric, String, and Object data. This section of Power BI tutorial covers most of the commonly used DAX business analytics functions with examples.

  1. Aggregate Functions
  2. Date Functions
  3. Logical Functions
  4. Math Functions
  5. String Functions
  6. Trigonometric Functions

Learn Microsoft Power BI FAQ’s

These are the list of frequently asked questions. Use hyperlinks to learn these Power Bi tutorial topics.

  1. Add Alternative Row Colors to a Table
  2. Add Data Bars to Table
  3. Drill up and Drill Down Reports
  4. Sort Chart in Asc or Desc Order
  5. Show Empty Records in a Report