What is Power BI?
www.onlineitguru.com
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
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
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
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
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
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
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
www.onlineitguru.com