Module 1 – Introduction to Power BI
Copyright Intellipaat. All rights reserved.
Agenda
What is Business Stages of Business
01 Intelligence? 02 Intelligence
03 BI Use Cases 04 Various BI Tools
Introduction to
05 Why Power BI? 06 Power BI
Copyright Intellipaat. All rights reserved.
Agenda
07 Power BI Components 08 Power BI Pricing
Building Blocks of Architecture of
09 10 Power BI
Power BI
Power BI Desktop
11 Power BI Desktop 12 Installation
Creating Reports in
13 Power BI
Copyright Intellipaat. All rights reserved.
What is Business
Intelligence?
Copyright Intellipaat. All rights reserved.
What is Business Intelligence?
Business Intelligence (BI) is a set of processes, architectures, and technologies that help in the
collection, integration, analysis, and presentation of business information. The purpose of Business
Intelligence is to enable stakeholders make better business decisions
Copyright Intellipaat. All rights reserved.
Stages of Business
Intelligence
Copyright Intellipaat. All rights reserved.
Stages of Business Intelligence
Business Intelligence is generally divided into four stages:
Collection
Decision-
Data
making/
Cleansing
Prediction
Reporting/
Visualization
Copyright Intellipaat. All rights reserved.
Stages of Business Intelligence
Collection
Collection
Decision- Data
making/ Cleansing
Prediction
Reporting/ Data is collected either from the existing sources, such as ERP
Visualization data, company database, etc., or externally through polls, forms,
and others
Copyright Intellipaat. All rights reserved.
Stages of Business Intelligence
Data Cleansing
Collection
Decision-
Data
making/
Cleansing
Prediction
Reporting/ Identifying irrelevant parts of the data and modifying, deleting,
Visualization or replacing the coarse data
Copyright Intellipaat. All rights reserved.
Stages of Business Intelligence
Reporting/Visualization
Collection
Decision-
Data
making/
Cleansing
Prediction
Reporting/ Graphical representation of data using visual elements such as
Visualization charts, graphs, tables, etc.
Copyright Intellipaat. All rights reserved.
Stages of Business Intelligence
Decision-
making/Prediction
Collection
Decision-
Data
making/
Cleansing
Prediction
Reporting/ The last stage is making business decisions and monitoring and
Visualization predicting business trends based on the report developed
Copyright Intellipaat. All rights reserved.
BI Use Cases
Copyright Intellipaat. All rights reserved.
BI Use Cases
BI is everywhere!
Performance
Management Financial Analysis Education
Copyright Intellipaat. All rights reserved.
BI Use Cases
Data Semantics makes use of BI for sales reporting and
sales prediction dashboards
Business Intelligence allows the company to make
decisions at the right time
BI also allows the company to discover why its sales are
dropping in a particular domain and helps it understand
where it needs to perform better
Copyright Intellipaat. All rights reserved.
BI Use Cases
Source: Microsoft
Copyright Intellipaat. All rights reserved.
BI Use Cases
Dell uses Business Intelligence in its education data
management
It uses various dashboards and KPIs to improve student
performance, monitor the efficiency of programs, and
help identify the students who need assistance
Copyright Intellipaat. All rights reserved.
BI Use Cases
Source: Microsoft Copyright Intellipaat. All rights reserved.
Various BI Tools
Copyright Intellipaat. All rights reserved.
BI Tools
These are the most commonly used BI tools
Copyright Intellipaat. All rights reserved.
Why Power BI?
Copyright Intellipaat. All rights reserved.
Why Power BI?
01 Affordability
02 Natural Language Query
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights reserved.
Why Power BI?
Affordability
01 Affordability
The Power BI Desktop version is available for free, which can be
used for report building on a computer. If we want to use more
02 Natural Language Query Power BI services, then we can buy Power BI Service at an
affordable cost
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights reserved.
Why Power BI?
Natural Language
Query
01 Affordability
This feature allows users to type questions and get answers in a
user-specific format. This is mainly useful in getting quick
02 Natural Language Query insights from data
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights reserved.
Why Power BI?
Real-time Streaming
01 Affordability
This feature allows users to stream real-time data and update
dashboards in real time, which helps them make timely business
02 Natural Language Query decisions
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights reserved.
Why Power BI?
Custom Visualization
01 Affordability
Power BI has visualizations that are made by developers for
specific use cases. These custom visualizations are available in
02 Natural Language Query Power BI Marketplace
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights reserved.
Introduction to Power BI
Copyright Intellipaat. All rights reserved.
Introduction to Power BI
Power BI is a Business Intelligence platform, which provides tools for
aggregating, analyzing, visualizing, and sharing data
Data Data
Transformation Visualization
Data Data Sharing
Connection Modeling Reports
Copyright Intellipaat. All rights reserved.
Power BI Components
Copyright Intellipaat. All rights reserved.
Power BI Components
Power BI Report
Power BI Desktop Power BI Service Power BI Gateway
Server
Power BI Mobile Power BI Excel Power BI Report Power BI
App Publisher Builder Embedded
Power BI Embedded
Copyright Intellipaat. All rights reserved.
Power BI Components
Power BI Desktop
It is a free application that helps us connect to
multiple data sources and transform and visualize
our data
Power BI Service
It is a cloud-based service where users view and
share their reports and dashboards
Copyright Intellipaat. All rights reserved.
Power BI Components
Power BI Gateway
It is mainly used for scheduled data referesh
Power BI Report Server
It is an on-premises web interface and an alternate for
Power BI Service
Copyright Intellipaat. All rights reserved.
Power BI Components
Power BI Mobile App
Power BI offers a set of mobile apps for Android,
iOS, and Windows mobile devices through which
users can securely access and view their live
dashboards and reports
Power BI Excel Publisher
It is mainly used for ingtegrating MS Excel with
Power BI
Copyright Intellipaat. All rights reserved.
Power BI Components
Power BI Report Builder
It helps in developing paginated reports such as
invoices, receipts, delivery notes, etc.
Power BI Embedded
It helps in the integration of BI reports with other
applications
Copyright Intellipaat. All rights reserved.
Power BI Pricing
Copyright Intellipaat. All rights reserved.
Power BI Pricing
Features Power BI Free Power BI Pro Power BI Premium
License Per user Per user Capacity based
70+ data sources
Ability to publish and consume content
from app workspaces and dashboards
Cost Free US$9.99/month US$4,995/month
Storage limit 10 GB 10 GB 100 TB
Data refresh rate 8/day 8/day 48/day
Ability to export content to Excel and CSV
files
Copyright Intellipaat. All rights reserved.
Building Blocks of Power BI
Copyright Intellipaat. All rights reserved.
Building Blocks of Power BI
Visualization Datasets Dashboards
Visualization is the A datasets is the container A dashboard collects the
graphical representation of of the data. It can be Excel most important metrics on
information and data using sheets or a company- one screen to answer
charts, graphs, maps, etc. owned database of users’ questions or to tell
customers them a story
Reports Tiles
A report is a multi- A Power BI tile is a
perspective view snapshot of the data
with visuals that pinned to the
represent different dashboard
findings and
insights from the
dataset
Copyright Intellipaat. All rights reserved.
Architecture of Power BI
Copyright Intellipaat. All rights reserved.
Architecture of Power BI
Data Sources
Power BI
Service
Access
Connect Power BI Gateway
Publish
Multiple Devices
Power BI Desktop
Copyright Intellipaat. All rights reserved.
Power BI Desktop
Copyright Intellipaat. All rights reserved.
Power BI Desktop
Power BI Desktop combines Microsoft Query Engine (M) with visualization
and data modeling for creating interactive reports
Power BI
Copyright Intellipaat. All rights reserved.
Power BI Desktop
Installation
Copyright Intellipaat. All rights reserved.
Power BI Desktop Installation
• Go to Microsoft’s official website, and select Power BI Desktop
• Select the language of your choice to download Power BI
• Choose the file based on your operating system
• Then, download and install it on your local machine
Copyright Intellipaat. All rights reserved.
Demo: Installing Power BI
Desktop
Copyright Intellipaat. All rights reserved.
Creating Reports in Power BI
Copyright Intellipaat. All rights reserved.
Creating Reports in Power BI
The three-step process in creating reports in Power BI are:
Connect to Data Sources
Transform Data into a
Model
Add Visualization
Copyright Intellipaat. All rights reserved.
Creating Reports in Power BI
Connect to Data Sources
Connect to Data With Power BI Desktop, we can connect to many different data
sources to collect data
Sources
Transform Data into a Database
SaaS
Model Connections Connectors
Azure
Add Visualization Online Data
Services Sources
File
Connectors
Copyright Intellipaat. All rights reserved.
Creating Reports in Power BI
Transform Data into a
Model
Connect to Data Power Query Editor in Power BI Desktop helps us transform the
data into a model
Sources
Transform Data into a
Fill
Model Group by
Add Visualization Pivot and Transpose
unpivot
Merge
Copyright Intellipaat. All rights reserved.
Creating Reports in Power BI
Add Visualization
Connect to Data Data visualizations bring data to life, using colors and shapes
Sources
Transform Data into a
Cards
Model Charts
Add Visualization Tables
Maps
Trees
Copyright Intellipaat. All rights reserved.
Demo: Creating a Report in
Power BI
Copyright Intellipaat. All rights reserved.
India: +91-7847955955
US: 1-800-216-8930 (TOLL FREE)
sales@intellipaat.com
24/7 Chat with Our Course Advisor
Copyright Intellipaat. All rights reserved.
