Power BI - Introduction to Interaction with Power BI

Power BI Overview, Power BI Introduction, Power BI Dashboard, Power BI Benefits, Features of Power BI
Components of Power BI
Power BI Platforms
How Power BI works
Business Analyst Role
Interaction with Power BI

1. MICROSOFT POWER BI Dr. M. Jaithoon Bibi Assistant Professor Department of Computer Science with Cognitive Systems Sri Ramakrishna College of Arts & Science [email protected]

2. Live Example of Data Vs Dashboard What is Power BI? What is BI? What Power BI Dashboard? Why Power BI Dashboard? Benefits of Power BI Training Features of Power BI Components of Power BI Power BI Platforms How Power BI works Business Analyst Role Interaction with Power BI Agenda

3. Excel Dataset

4. SQL Dataset

5. Power BI – Power Query(ETL)

6. Power BI Dashboard

7. Business Intelligence Reporting Tool To Create Visualization/ Reports and Dashboard Provided by Microsoft Power BI is a collection of components . Example:- Power Query, Power Pivot, Power View, Power BI Desktop, Power BI Gateway, Power BI Mobile Apps and Power BI Service. What is Microsoft Power BI?

8. Power BI is a Data Visualization and Business Intelligence tool which helps to convert data from different data sources into interactive dashboards and BI Reports What is Power BI Dashboard?

9. Power Bi supports 100+ of data sources Example: Oracle, SQL, CSV, Excel etc.. All business Enterprises and departments need extensive business insights Convert the data into a report, graph, or data visualization as needed Faster than any other BI tools in the market Does not need any technical knowledge or IT support Provides customizable Dashboard – Multiple Drill down, Color Definitions, Formulas and etc., Share reports with others Why Power BI Dashboard?

10. Upskills your knowledge Get the work done without being the business intelligence Professionals Quick Analysis of large volumes of data by generating reports and dashboards Benefits of Power BI Training

11. It is a business analytics solution that lets you visualize your data and share insights across your organization. Embed your Visuals in Applications or Websites. Perform 1200 functions and can create approximately 280 visuals and charts. You can import data from 100 different data sources. Power BI is a cheapest tool as compare to other visualization tools. Features Of Power BI?

12. Power Query. Power Pivot. Power View. Power Map. Power BI Desktop. Power Q and A. Components of Power BI

13. Power Query: It is an ETL tool (Extract Transfer Load) to data transformation and data preparation engine, its helps you to clean, summarize and filter data in a table. Power Pivot: Power Pivot is used in data modeling technology that lets you create data models, establish relationships, and create calculations Power View: By using it, we can analyze, visualize and display the data as an interactive data visualization. Power Map: It brings the data to life with interactive geo-graphical visualization. Power BI Desktop: It is a development tool for Power Query, Power Pivot and Power View. Power BI Q and A: Power BI Q and A is a natural language engine for questions and answers to the data model. Components of Power BI

14. Power Query Power Query is an ETL tool (Extract Transfer Load) to data transformation and data preparation engine Its helps you to clean, summarize and filter data in a table.

15. Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment. What is Power Pivot?

16. Power View is a data visualization technology that lets you create interactive charts, graphs, maps, and other visuals. Power View is available in Excel, in SharePoint, SQL Server, and Power BI. What is Power View?

17. Power Map is a visualization tool in Power BI that allows you to plot geographic and temporal data on a 3-D globe or custom map What is Power Map?

18. Power BI Desktop Power BI Desktop: It is a development tool for Power Query, Power Pivot and Power View.

19. Power BI Q&A Power BI Q and A: Power BI Q and A is a natural language engine for questions and answers to the data model.

20. Power BI Desktop ( A desktop applications) Power BI Services ( Software as a services) Power BI Mobiles ( For iOS and Android devices) Microsoft Offers three types of Power BI Platforms

21. How Power BI works?

22. Microsoft Power BI https://powerbi.microsoft.com/en-us/desktop/ (OR) Download it from Windows Microsoft Store Easy To Get Started Benefits from continuous updates and community-driven innovation. Streamlined for no-codes advanced analytics. Built-in intelligence to speed up your analysis. Automatic updates from windows store.