Power BI Online Training

1
What is Power BI?
www.onlineitguru.com
2
Power BI Introduction Power BI is a Microsoft
tool introduced by Microsoft Company. It consists
set of software services like power BI App for
share point and connectors work together will
change the unrelated data converted into
reasonable information. It is Microsoft latest
cloud-based system with fast access to data in
Analytics and reporting tool. Some of Power BI
features included in this service such as power
BI Desktop, power BI Query, power pivot, Data
Analysis.
www.onlineitguru.com
3

• Power BI Architecture
• Power Bi is completely built in a cloud by Azure.
  The power BI basic architecture was on two
  clusters. First one is web front-end cluster and
  second is back-end cluster.
• Web front end device is used for initial
  connection and authentication process. Whereas
  back end device maintains Data storage,
  visualizations, data refresh and data connection.
• By using these power BI service one can store
  the complete organization information in the
  cloud with Power BI gateway path.
• Power BI Desktop is an enlargement tool that used
  to generate dashboards and reports. Power BI
  applications will be access by other users
  through desktop and mobile devices.

www.onlineitguru.com
4

• What are Power BI Components?
• Power BI components are 5 main components
  released in the market. These components are
  separately entered into the market and they are
  used one by one.
• Power Query
• Power Map
• Power BI Mobile Apps
• Power Pivot
• Power View

www.onlineitguru.com
5
Power Query  Power Query is a data
transformation and mashes up. It can extract the
data from various sources. One can read data from
databases like SQL Server, My SQL, and DB2 with
several databases. It will fetch the data from
files Text, Excel and provides a graphical user
interface for transform the data required and
adding columns, changing types with different
operations. Power Map Power Map means to get the
picture of Geo-spatial information in 3D data
visualization tool. It works with Bing map to get
good visualization at Geographical latitude and
longitude or street address information. Power BI
Mobile Apps They are supported in Windows phone,
Apple phone, and Android mobile. it provides an
interactive view of dashboards and reports in
Power BI that can share from a mobile app.
www.onlineitguru.com
6
Power Pivot It is a data modeling engine that
works on X-velocity at memory based tabular form
engine. In memory engine Power Pivot generate
super fast response time power pivot uses data
analysis expression language to measure. Power
View The central data visualization component of
Power BI tool is a power view. Power view
consists of data visualization will collect data
source and get back the metadata can be used for
data analysis.
www.onlineitguru.com
7

• Power BI Advantages
• Power BI sets business intelligence tools in
  creation with hands of analysts.
• It extracts the data and creates the dataset,
  transform or change the data, visualizes the data
  to publish resulting reports and dashboards.
• The top most benefit is providing a basic
  capability for achieving self-service BI by
  question and answer.
• Dashboard visualization is top in class with
  regularly updated with the community. Geomaps
  visualization was empowering by Bing search
  engine maps.
• Data Analysis expressions scripting language is
  simple to construct and used to create calculated
  columns and measures

www.onlineitguru.com
8
Prerequisites While attending to the practical
Training One should have basic knowledge on Ms
Office. But it is Not Mandatory and there is no
necessity for the Knowledge  of Programming
Language. Online IT Guru have their presence
in various major cities in India like New Delhi,
Mumbai, Kolkata, Chennai, Hyderabad, Pune, Bhopal
and many other cities. Enroll now for a free
DEMO on Power BI Online Training
www.onlineitguru.com
9
www.onlineitguru.com