Microsoft Power BI Course: For Data Analysts

Welcome to the Power BI Tutorial.

Power BI is a business intelligence tool that gets data from different sources, such as Excel, JSON, PDF, etc., and can be analyzed and converted to meaningful reports, dashboards, charts, etc. This assists in making business decisions by tracking performance.

This Power BI complete course guide will allow you to kickstart or take your career in the related sector to the next stage:

• Data Analyst Beginners
• Data Science Enthusiasts
• Business Intelligence Beginners

What you'll learn

• Learn Power BI to create dashboards and reports
• Learn a Business Intelligence Tool
• Learn Data Analysis
• Clean the data
• Analyze the data
• Get data from different sources, like Excel, CSV, JSON, SQL, etc.
• Convert the data into charts, reports, and dashboards easily.
• Become a BI expert

Material Includes

• 2.5 hours of on-demand video
• Access on mobile and TV
• Full lifetime access
• Certificate of completion

Note: All the excel files used in this course are shared as a Google Drive link in the Get Data lesson

Certificate of Completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

• Power BI – Overview & Setup 27:25

  • 1: Course Intro Preview 01:10
  • 2: Power BI – Introduction & Features Preview 09:51
  • 3: Power BI - Types & Components 03:06
  • 4: Power BI vs Tableau vs Excel Preview 03:59
  • 5: Power BI - Versions Preview 02:46
  • 6: Install Power BI on Windows 10 03:09
  • 7: Install Power BI on Windows 11 03:24

• Power BI – Get Data 04:34

  • 8: Get the Data from Excel 04:34

• Power BI – Visualizations 17:25

  • 9: Create a Gauge Chart 07:56
  • 10: Create a Column Chart 09:29

• Power BI – Cards 09:41

  • 11: Create a card 03:22
  • 12: Format the cards 03:56
  • 13: Update the cards 02:23

• Power BI – Tables 16:20

  • 14: Create a Table 03:48
  • 15: Format the table 05:51
  • 16: Table Conditional Formatting 06:41

• Power BI – Filters 07:08

  • 17: Create a Filter 07:08

• Power BI – Slicer 12:33

  • 18: Create a slicer 05:33
  • 19: Select multiple values from a slicer 02:24
  • 20: Set a chart with a slicer 04:36

• Power BI – Data Transformation 16:35

  • 21: What is Data Transformation in Power BI 05:46
  • 22: Group rows 03:38
  • 23: Pivot columns 03:35
  • 24: Create custom columns 03:36

• Power BI – DAX 20:54

  • 25: What is DAX in Power BI 02:31
  • 26: DAX Calculated Tables 06:10
  • 27: DAX Calculated Columns 06:06
  • 28: DAX Measures 06:07

• Power BI – Reports and Dashboards 24:41

  • 29: What is a Report in Power BI 01:49
  • 30: Create a Report and Publish in Power BI Service Account 13:17
  • 31: Create a Dashboard from Report in Power BI Service 02:53
  • 32: Subscribe to Report 06:42

• Power BI – Update to a newer version 03:16

  • 33: Update Power BI 03:16

Power BI was developed by Microsoft in 2011 to analyze and visualize a large amount of data and generate meaningful insights helpful for organizations in scaling. Power BI Desktop version is freely available and, in this tutorial, we will understand it thoroughly with examples.

Data Analysts are hired mostly to work on such BI tools, therefore let us first understand the role of a data analyst in an organization.

Tasks of a Data Analyst

The role of a Data Analyst is quite crucial for any organization. The Data Analyst understands the data and gets valuable insights from it that help track the performance and scale the organization. The data analysis process includes:

• Data Preparation: The first step is to prepare the data. It includes profiling, cleaning, and transforming the data. This makes the data ready. Data preparation takes the raw data and converts it into useful, easy-to-understand information. This process fixes the inaccurate data, identifies missing data, corrects the wrong data, etc.
• Model: The data gets ready to be modelled after the preparation step. This determines how the tables are related to each other by defining and creating relationships between them.
• Visualize: The graphics are easier to understand than the textual data, correct? The visualization steps bring data to life and represent it in the form of reports. This makes it quite easier to understand and make better decisions. This step designs and creates reports for accessibility.
• Analyse: Analysing the data helps in finding insights, identifying patterns, and predicting outcomes. Interpret the information displayed in the report with the analysis step. With advanced analytics, business decisions become easier with meaningful results.
• Management:If you are the Data Analyst of an organization, then you need to manage the reports, dashboards, semantic models, etc. of the Power BI. You need to supervise the sharing the distribution of reports and dashboards.

What is BI

Business intelligence, as the name suggests is to analyze the data and display it in a way it speaks i.e., in the form of dashboards, charts, reports, etc. Such a form of data that is easy to understand helps the founders to track performance, remove any issues, and prepare themselves for market changes.

What is Power BI

Power BI is a tool that helps people understand a large amount of data and build reports. PowerBI is a collection of components:

• Power Query (ETL tool to extract transform, and load the data i.e., clean the data from null values, empty records, and unclean data for visualization)
• Power Pivot (Data Modelling – connect data from multiple data sources and create relationships)
• Power Views (Create 200+ charts i.e. visualization)
• PowerBI Service (allows users to communicate with reports)

Features of Power BI

• Data Visualization: Create interactive reports and dashboards with a wide range of visualizations.
• Data Connectivity: Connect to various data sources like Excel, databases, and cloud services3.
• AI-Driven Analytics: Use AI to uncover patterns and insights in your data.
• Custom Visualizations: Create custom visualizations using R and Python.
• Power Query: Easily source and transform data.
• Data Refresh: Automatically refresh data to keep reports up-to-date.
• Mobile App: Access reports and dashboards on the go with the Power BI mobile app.
• Integration with Microsoft Products: Seamlessly integrate with other Microsoft products like Excel, SharePoint, and Azure.
• Collaboration: Share reports and collaborate with others in real time.
• Security: Robust security features to ensure data protection and compliance.

Note: In this course, we will work on the free plan.

The following lessons are covered in the Power BI tutorial:

Course Lessons

Power BI – Overview & Setup

1. Power BI – Introduction & Features
2. Power BI – Types and Components
3. Power BI vs Tableau vs Excel
4. Power BI vs Power BI Pro vs Power BI Premium
5. Install Power BI on Windows 10
6. Install Power BI on Windows 11

Power BI – Get Data

1. Get Data from Excel

Power BI – Visualizations

1. Create a Gauge Chart
2. Create a Column Chart

Power BI – Cards

1. Create a card
2. Format the cards
3. Update the cards

Power BI – Tables

1. Create a Table
2. Format the table
3. Table Conditional Formatting

Power BI – Filters

1. Create a Filter

Power BI – Slicer

1. Create a slicer
2. Select multiple values from a slicer
3. Set a chart with a slicer

Power BI – Data Transformation

1. What is Data Transformation
2. Group rows
3. Pivot columns
4. Create custom columns

Power BI – DAX

1. What is DAX
2. DAX Calculated Tables
3. DAX Calculated Columns
4. DAX Measures

Power BI – Reports and Dashboards

1. What is a Report in Power BI
2. Create a Report and Publish in Power BI Service Account
3. Create a Dashboard from Report in Power BI Service
4. Subscribe to Report

Power BI – Update to a newer version

1. Update Power BI

Let us begin!

Learn business intelligence and data analysis with Power BI’s free plan. Become a BI expert.

With this Power BI Course, learn data analysis. Become a Business Intelligence expert and track your company’s performance easily.

• Data Analysis Beginners
• Business Intelligence Beginners
• Beginners who want to learn Business Intelligence
• Those who want to create reports and dashboards for their company
• Students who want to learn a data analysis tool
• Startup owners who want to track performance with Power BI, a BI tool

• Knowledge of basic computer usage
• Basic internet usage

This Power BI complete course complete guide will allow you to kickstart or take your career in the related sector to the next stage:

• Data Analyst Beginners
• Data Science Enthusiasts
• Business Intelligence Beginners

Currently there are no Q&As for this course. Be the first to ask a question.