Module 1 – Introduction to Power
BI
Copyright Intellipaat. All rights
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
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
What is Business
Intelligence?
Copyright Intellipaat. All rights
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
Stages of Business
Intelligence
Copyright Intellipaat. All rights
Stages of Business Intelligence
Business Intelligence is generally divided into four
stages:
Collection
Decision-
Data
m a k i n g /
Cleansing
Prediction
Reporting/
Visualization
Copyright Intellipaat. All rights
Stages of Business Intelligence
Collection
Collection
Decision- Data
making/ Cleansing
Predictio
n
Reporting/
Data is collected either from the existing sources,
Visualization
such as ERP data, company database, etc., or
externally through polls, forms, and others
Copyright Intellipaat. All rights
Stages of Business Intelligence
Data Cleansing
Collection
Data
Decision-
Cleansing
making/
Prediction Reporting/ Identifying irrelevant parts of the data and
Visualization
modifying, deleting, or replacing
the coarse data
Copyright Intellipaat. All rights
Stages of Business Intelligence
Reporting/Visualizat
ion
Collection
Decision-
Data
making/
cleansing
Prediction
Reporting/ Graphical representation of data using visual
Visualization elements such as charts, graphs,
tables, etc.
Copyright Intellipaat. All rights
Stages of Business Intelligence
Decision-
making/Prediction
Collection
Decision-
Data
making/ Cleansing
Prediction
The last stage is making business decisions and monitoring
Reporting/ and predicting business trends based on the report
Visualization developed
Copyright Intellipaat. All rights
BI Use Cases
Copyright Intellipaat. All rights
BI Use Cases
BI is everywhere!
Performance
Management Financial Analysis Education
Copyright Intellipaat. All rights
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
BI Use Cases
Source:
Copyright Intellipaat. All rights
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
BI Use Cases
Source: Copyright Intellipaat. All rights
Various BI Tools
Copyright Intellipaat. All rights
BI Tools
These are the most commonly used BI
tools
Copyright Intellipaat. All rights
Why Power BI?
Copyright Intellipaat. All rights
Why Power BI?
01 Affordability
02 Natural Language
Query
03 Real-time
Streaming
04 Custom Visualization
Copyright Intellipaat. All rights
Why Power BI?
Affordability
01 Affordability
The Power BI Desktop version is available for free,
which can be used for report building on a
02 Natural Language Query computer. If we want to use more 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
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
0 Natural Language useful in getting quick insights from data
2 Query
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights
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
02 Natural Language them make timely business decisions
Query
0 Real-time
3 Streaming
04 Custom Visualization
Copyright Intellipaat. All rights
Why Power BI?
Custom Visualization
01 Affordability
Power BI has visualizations that are made by
developers for specific use cases. These custom
02 Natural Language Query visualizations are available in Power BI
Marketplace
03 Real-time Streaming
04 Custom Visualization
Copyright Intellipaat. All rights
Introduction to Power BI
Copyright Intellipaat. All rights
Introduction to Power BI
Power BI is a Business Intelligence platform, which
provides tools
for aggregating, analyzing, visualizing and sharing data
Data Data
Sharing Reports
Transformation Visualization
Data
Data Connection
Modeling
Copyright Intellipaat. All rights
Power BI Components
Copyright Intellipaat. All rights
Power BI Components
Power BI Desktop Power BI Service Power BI Power BI Report
Gateway Server
Power BI Power Power BI Report Power BI
Mobile App Query Builder Embedde
d
Power BI Embedded
Copyright Intellipaat. All rights
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
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
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 Query
Power BI accepts data from a variety of
other
data sources such as excel. Power Query
allows
you to search data from various sources such
as Copyright Intellipaat. All rights
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
Power BI Pricing
Copyright Intellipaat. All rights
Power BI Pricing
Features Power BI Power BI Power BI Power BI
Free Pro Premium Premium
License Per user Per user Capacity based Per User
70+ data sources
Ability to publish reports to
share and collaborate
Cost Free US$9.99/mo US$4,995/mo
nth nth US$20/mon
th
Storage limit 10 GB 10 GB 100 TB 100 TB
Data refresh rate 8/day 8/day 48/day 48/day
Ability to export content to
Excel and CSV files Copyright Intellipaat. All rights
Building Blocks of Power BI
Copyright Intellipaat. All rights
Building Blocks of Power BI
Visualization Datasets Dashboards
Visualization is the A datasets is the A dashboard collects
graphical representation of container of the data. the most important
information and data using It can be Excel metrics on one
charts, graphs, maps, etc. sheets or a company screen to answer
- owned database of users’ questions or to
customers tell them a story
Reports Tiles
A report is a A Power BI tile
multi- is a snapshot of
perspective the data
view with pinned to the
dashboa
visuals that rd
represent
different
Copyright Intellipaat. All rights
Architecture of Power BI
Copyright Intellipaat. All rights
Architecture of Power BI
Data Sources
Power BI
Service
Access
Connect Power BI Gateway
Publish
Multiple
Devices
Power BI Desktop
Copyright Intellipaat. All rights
Power BI Desktop
Copyright Intellipaat. All rights
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
Power BI Desktop
Installation
Copyright Intellipaat. All rights
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
Demo: Installing Power BI
Desktop
Copyright Intellipaat. All rights
Creating Reports in Power BI
Copyright Intellipaat. All rights
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
Creating Reports in Power
BI
Connect to Data
Sources
Connect to With Power BI Desktop, we can connect to many
different data sources to collect data
Data
Sources
Transform Data Database
SaaS
into a Model Connections Connectors
Azure Data
Add Online Sources
Visualization Services
File
Connectors
Copyright Intellipaat. All rights
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
Sources model
Transform Data
into a Model Group Fill
by
Add Visualization Pivot Transpose
and
unpivot
Merge
Copyright Intellipaat. All rights
Creating Reports in Power
BI
Add
Visualization
Connect to Data Data visualizations bring data to life, using colors
Sources and shapes
Transform Data into
a Model Cards
Charts
Add Visualization Tables
Maps
Trees
Copyright Intellipaat. All rights
Demo: Creating a Report in
Power BI
Copyright Intellipaat. All rights
India: +91-7847955955
US: 1-800-216-8930 (TOLL FREE)
sales@[Link]
24/7 Chat with Our Course Advisor
Copyright Intellipaat. All rights