Power BI Tutorial

This MS Power BI Tutorial helps you to learn this tool from basic to advanced. Below set of Power BI 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 step by step.

Power BI 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, and produce beautiful reports.

Power BI also allows you to publish them 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 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 Power BI desktop, we can connect to different data sources such as text files, databases, excel files, etc. Next, we use this data to build Power BI 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

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 Power BI 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 Power BI 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. 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 Chart
12. Line and Stacked Column Chart
13. Matrix
14. Multi-Row Card
15. Pie Chart
16. Ribbon Chart
17. Stacked Area Chart
18. Scatter Chart
19. Stacked Bar Chart
20. Stacked Column Chart
21. Table
22. Tree Map
23. Waterfall Chart
24. 100% Stacked Bar Chart
25. 100% Stacked Column Chart
26. Map
27. Filled Map

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

Sometimes, we don’t get the columns that we need to perform visualization. In these situations, we can create Power BI calculated fields that we have shown below. Within these columns, we can write simple arithmetic operations or the most powerful Power BI 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

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

Power BI tutorial on Reports and Datasets

In this 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

Sharing Power BI Work

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

Power BI Tutorial on Subscriptions

1. Subscribe Dashboard
2. Subscribe Report

Power BI Q&A

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

MS Power BI DAX Tutorial

DAX means Data Analysis Expressions. In Power BI, we have to use the DAX functional language formulas to create calculations on table data. Like any other language, Power BI 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 functions with examples.

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

Microsoft Power BI FAQ’s

These are the list of frequently asked questions in Power BI. Use hyperlinks to learn them

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