What Is Power BI? | Introduction To Power BI | Power BI Tutorial For Beginners | Simplilearn

2. What’s in it for you? Why Power BI? What is Power BI? Features of Power BI Components of Power BI Architecture of Power BI Power BI Service Power BI Dashboard Power BI Case Study - Meijer Power BI Demo

3. Why Power BI? 1 Power BI allows you to view, analyze, and visualize huge quantities of data that cannot be opened in Excel. Power BI uses powerful compression algorithms to import and cache the data within the .PBIX file Access vast volumes of data from multiple sources

4. Click here to watch the video

5. Why Power BI? 2 Power BI makes things visually appealing. It has easy drag and drop functionality, with features that allow you to copy all formatting across similar visualizations Interactive UI/UX features

6. Why Power BI? 3 Anyone who’s familiar with Office 365 can easily connect Excel queries, data models, and reports to Power BI Dashboards—helping to quickly gather, analyze, publish, and share Excel business data in new ways Exceptional Excel integration

7. Why Power BI? 4 Using Power BI with Azure allows you to analyze and share large volumes of data. With Azure data lake, you can reduce the time it takes to get insights and increase collaboration between business analysts, data engineers, and data scientists Accelerate big data preparation with Azure

8. Why Power BI? 5 Power BI allows you to get insights from data and turn insights into actions to take data-driven business decisions Turn insights into action

9. Why Power BI? 6 Power BI fetches data from factory sensors and social media sources to get access to real-time analytics so you are always ready to make timely business decisions Real-time stream analytics

10. What is Power BI?

11. What is Power BI? Power BI is a business analytics service provided by Microsoft that lets you visualize your data and share insights

12. What is Power BI? Power BI is a business analytics service provided by Microsoft that lets you visualize your data and share insights Data

13. What is Power BI? Power BI is a business analytics service provided by Microsoft that lets you visualize your data and share insights Data Visualization

14. Features of Power BI

15. Features of Power BI Power BI Desktop Power BI Desktop allows you to build reports by accessing data easily. You do not need advanced report designing, or query skills to build a report

16. Features of Power BI Power BI Desktop Stream analytics Power BI Desktop allows you to build reports by accessing data easily. You do not need advanced report designing, or query skills to build a report From factory sensors to social media sources, Power BI supports real-time analytics to make timely decisions

17. Features of Power BI Multiple data sources Power BI Desktop Stream analytics Power BI Desktop allows you to build reports by accessing data easily. You do not need advanced report designing, or query skills to build a report From factory sensors to social media sources, Power BI supports real-time analytics to make timely decisions Power BI supports various sources of data such as Excel, CSV, SQL Server, Web files, etc. to create interactive visualizations

18. Features of Power BI Custom Visualization Multiple data sources Power BI Desktop Stream analytics Power BI’s default standard might not be enough in some cases due to complex data. But you can access the custom library of visualization that meets your needs Power BI Desktop allows you to build reports by accessing data easily. You do not need advanced report designing, or query skills to build a report From factory sensors to social media sources, Power BI supports real-time analytics to make timely decisions Power BI supports various sources of data such as Excel, CSV, SQL Server, Web files, etc. to create interactive visualizations

19. Components of Power BI?

20. Components of Power BI Power View Power Query Power Pivot Power BI Desktop Power Q&A Power Map

21. Components of Power BI Power View Power Query Power Pivot Power Query is the data transformation and mash up engine. It can be downloaded as an add-in for Excel or be used as part of Power BI Desktop Power BI Desktop Power Q&A Power Map

22. Components of Power BI Power View Power Query Power Pivot Power Pivot is a data modeling and calculation engine. It uses Data Analysis Expression (DAX) language to model simple and complex data Power BI Desktop Power Q&A Power Map

23. Components of Power BI Power View Power Query Power Pivot Power View is the data visualization component that can connect to data sources and can filter data for each data visualization element or for the entire report Power BI Desktop Power Q&A Power Map

24. Components of Power BI Power Map is used to visualize geospatial data in 3D mode. Power Map works with Bing maps to get best visualization based on latitude, longitude or country, state, city, and street address information Power View Power Query Power Pivot Power BI Desktop Power Q&A Power Map

25. Components of Power BI Power BI Desktop is a development tool for Power Query, Power Pivot and Power View. With Power BI Desktop, you have everything under a same solution, and it is easier to develop BI and data analysis experience Power View Power Query Power Pivot Power BI Desktop Power Q&A Power Map

26. Components of Power BI Power Q&A is a natural language engine for questions and answers to your data model. Once you’ve built your data model and deployed that into Power BI website, then you can ask questions and get answers easily Power View Power Query Power Pivot Power BI Desktop Power Q&A Power Map

27. Power BI Service

28. Power BI Service Power BI service is the Software as a Service (SaaS) part of Power BI. It is also referred as Power BI online You can access it from app.powerbi.com

29. Power BI Service Power BI service is the Software as a Service (SaaS) part of Power BI. It is also referred as Power BI online You can access it from app.powerbi.com • It allows you to do the following: • Connect to data • Create reports • Create dashboards • Ask questions of your data

30. Power BI Dashboard

31. Power BI Dashboard Power BI Dashboard is a single page visualization to tell a story

32. Power BI Dashboard Power BI Dashboard is a single page visualization to tell a story The visualizations on a dashboard are generated from reports and each report is based on one dataset. A single page dashboard is known as a canvas

33. Power BI Dashboard Power BI Dashboard is a single page visualization to tell a story The visualizations you see on the dashboard are called tiles and are pinned to the dashboard by report designers

34. Create and publish reports in Power BI Dashboards Power BI allows you to create different reports on Power BI Desktop. These reports can be published on to Power BI dashboard using Power BI service

35. Create and publish reports in Power BI Dashboards Power BI allows you to create different reports on Power BI Desktop. These reports can be published on to Power BI dashboard using Power BI service Power BI report created on Power BI Desktop. Click on Publish. This will take you to Power BI service where you can build a dashboard

36. Create and publish reports in Power BI Dashboards Power BI allows you to create different reports on Power BI Desktop. These reports can be published on to Power BI dashboard using Power BI service Power BI report created on Power BI Desktop. Click on Publish. This will take you to Power BI service where you can build a dashboard Single page Power BI dashboard on Power BI service

37. Power BI Architecture

38. Power BI Architecture Data Sources Power BI Desktop

39. Power BI Architecture Power BI Services Connect Data Sources Power BI Gateways Publish Power BI Desktop

40. Power BI Architecture Power BI Services Connect Access Data Sources Power BI Gateways Publish Power BI Desktop

41. Power BI Case Study

42. Power BI Case Study Meijer is one of the US’s largest supermarket chains

43. Power BI Case Study It had become dependent on its IT organization to extract insights from its data

44. Power BI Case Study It was time consuming to wait for IT to build every report It had become dependent on its IT organization to extract insights from its data

45. Power BI Case Study It was time consuming to wait for IT to build every report It had become dependent on its IT organization to extract insights from its data They were unable to do ad hoc analysis easily

46. Power BI Case Study Meijer connected Power BI to an on-premises SQL Server Analysis Services cube

47. Power BI Case Study Meijer connected Power BI to an on-premises SQL Server Analysis Services cube It allowed them to refresh 20 billion rows of data in near-real time

48. Power BI Case Study Meijer connected Power BI to an on-premises SQL Server Analysis Services cube With Power BI, teams can pull in the data faster and perform real-time analysis to derive insights from data It allowed them to refresh 20 billion rows of data in near-real time

49. Power BI Case Study A bakery department used Power BI to compare its sales with regional performance

50. Power BI Case Study They analyzed where Meijer was behind the regional trends, focus on the problem and create a solution A bakery department used Power BI to compare its sales with regional performance