Wednesday, August 5, 2020

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 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
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)