Learn Professional IT Courses Online in 35 Hours 
                     Click to edit Master title style
POWER BI
www.rhsofttech.com
+91 9356913849 [email protected]
Click to edit Master title style
Power BI
Business intelligence is a technology-driven method 
which helps you to analyze data and to provide 
actionable information which helps corporate executives, 
business managers, and other users to make informed 
business decisions.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Why use Power BI?
Here, are the most prominent reasons for using Power BI tool:
•Pre-built dashboards and reports for SaaS Solutions
•Power BI allows real-time dashboard updates.
•Offers Secure and reliable connection to your data sources in the cloud or on-
  premises
•Power BI offers Quick deployment, hybrid configuration, and secure environment.
•Allows data exploration using natural language query
•Offers feature for dashboard visualization regularly updated with the community.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Types of Power BI tools
Some Important Power BI tools are:
Power BI Desktop
Power BI desktop is the primary authoring and publishing tool for Power BI. Developers and power users use it to 
create brand new models and reports from scratch.
Power BI service
Online Software as a Service (SaaS) where Powe Bl data models, reports, dashboards are hosted. Administration, 
sharing, collaboration happens in the cloud.
Power BI Data Gateway
Power BI Data Gateway works as the bridge between the Power Bl Service and on-premise data sources like 
DirectQuery, Import, Live Query. It is Installed by Bl Admin.
Power BI Report Server
It can host paginated reports, KPIs, mobile reports, & Power Bl Desktop reports. It is updated every 4 months and 
installed/managed by the IT team. The users can modify Power Bl reports other reports created by the development 
team.
Power BI Mobile Apps
Power BI mobile app is available for iOS, Android, Windows. It can be managed using Microsoft Intune. You can use 
this tool to view reports and dashboards on the Power Bl Service Report Server.
4
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Data sources for the Power BI
Data sources Description
Excel (.xlsx, xlxm)   : A workbook can have data entered manually or data, which is queried 
and loaded from external data sources.
Comma Separated  : Files are simple text files with rows of data. Every row can contain one 
Value (.csv) or more values, which is separated by a comma.
Power BI You can use Power BI Desktop to query and load data from external 
Desktop (.pbi)      :
data sources.
Databases in It allows you to connect live to Azure SQL Database, Azure SQL Data 
the Cloud             : Warehouse, etc.
Databases on
-premises            : You can connect directly to SQL Server Analysis Services Relational 
model databases. A Power BI Enterprise Gateway is required.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Term Description
Visualization      : A visual display of information to achieve one or more objective. It offers a 
single-screen display of information. It alerts users on issues or problems 
Operational, Performance, Personal, etc.
Datasets     : A dataset is something which you import or connect to. Datasets can be 
renamed, refreshed, removes, and explored.
Dashboard    : The dashboard is a collection which contains zero or more tiles and 
widgets. It is used to represent a customized view of some subset of the 
underlying datasets.
Reports    : A Power BI report is one or multiple pages of visualizations. It can be 
created from scratch, imported to a dashboard, and created using 
datasets
Tile       : It a single visualization found in a report or on a rectangular dashboard box 
which contains each visual.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
History of Power BI
Power BI was conceptualized by Ruler and Dhers Netz of the SQL 
server coverage services team at Microsoft.
It was designed by West Chadic George in the year 2010 and named 
as a Project Crescent.
In 2011, It was bundled with SQL Server Codenamed Mount McKinley.
Microsoft unveiled the first preview to Power BI in September 2014.
The first version of Power BI released on 24 July 2015. It was based on 
Excel Based Add-ins like Power Query, Pivot, view, and Map.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Data Integration:
An organization needs to work with data which comes from different sources which can be in various 
file formats. The data should be extracted from a different source which can be from different servers 
or databases. This data is integrated into one standard format in a common staging area.
Data Processing:
•In this stage, the integrated data is still not prepared for visualization as the data needs processing. 
This data is pre-processed. For example, redundant values, missing values will be removed from the 
data set.
•The business rule should be applied to the data when the data is cleaned. You can load that data 
back to Data Warehouse.
Data Presentation
Once the data is loaded and processed, it can be visualized much better with use of various 
visualization that Power Bi has to offer. Use of dashboard and report helps one represent data more 
intuitively. This visual report helps business end users to take business decision based on the 
insights.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Power Bl Desktop is an enlargement tool used to generate dashboards and reports. Power Bl 
applications will be accessed by other users through desktop and mobile devices.
There are Power BI components are 5 main components released in the market.
Power Query: It can be used to search, access, and transform public and/ or internal data sources.
Power Pivot: It is used for data modeling for in-memory analytics.
Power View: This component allows you to visualize, analyze, and display data.
Power Map: It brings data to life with interactive geographical visualization.
Power BI Service: It allows you to share data views and workbooks, which you can refresh from 
on-premises and cloud-based data sources.
Power BI Q&A: It allows you to ask questions and get immediate answers using a natural language 
query.
Data Management Gateway: It offers periodic data refreshers, view data feeds, expose tables.
Data Catalog: This component allows the user to discover and reuse queries using the Data 
Catalog. Metadata can be facilitated for search functionality.
+91 9356913849 [email protected]
Click to edit Master title style Power BI
What is Dax Function?
DAX is a formula expression language which is called (DAX) which can be used with various visualization tools 
like Power BI. It is also known as a functional language, where the full code is kept inside a function. DAX 
programming formulas contain two data types: Numeric and Other.
There are 3 things in Power BI where you can use
•DAX –
•Calculated Columns
•Measures
•Tables
Let see all these all of them see how DAX functions works.
Calculated Columns
Calculated column allows you to create new columns based on the given data.
For example, there is no ' Final price' column available in the Items table. Here, the DAX function is used to 
calculate a new column when only total price & quantity are available.
+91 9356913849 [email protected]
PowerBI vs. Tableau
Click to edit Master title style Power BI
Parameters Power BI Tableau
Year of establishment 2013 2003
Application Complete Dashboards for Allow Ad Hoc Analysis
analysis
Use by Technical or Non Technical Only use by Analysts
users
Support Very limited Full support
Scalability Good Excellent
Infrastructure SaaS Flexible
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Who uses Power BI?
Here, are an important professional who uses Power BI tool:
•PMO - Project and Portfolio Manager
•Business & Data Analyst
•Developer & Database Administrator
•IT Team, IT Professional
•Consumer for End User Report
•Data Scientist
+91 9356913849 [email protected]
Click to edit Master title style Power BI
Disadvantages of Power BI
Here, are Cons/drawbacks of using Power BI are:
•Dashboards and reports only shared with users having the same email domains.
•Power Bl will not mix imported data, which is accessed from real-time 
connections.
•Power Bi will not accept the file larger than 250MB and zip file which compressed 
by the data of X-velocity in-memory database.
•Power BI can't accept file size larger than 1 GB.
•Dashboards never accept or pass user, account, or other entity parameters.
•Very few data sources that permit real-time connections to Power BI reports and 
dashboard
+91 9356913849 [email protected]
Click to edit Master title style Power BI
What are you waiting for:
Click Here To Book A Demo
Thank You 
+91 9356913849 [email protected]