Changes

Jump to navigation Jump to search
294 bytes removed ,  14:22, 14 April 2023
no edit summary
Line 1: Line 1: −
==Introduction - Power BI==
+
__TOC__
 +
__NOEDITSECTION__
 +
 
 +
=Introduction - Power BI=
 
Power BI is an MS365 application that allows users to connect to and visualize any data using a scalable platform for self-service and enterprise business intelligence (BI). This platform is easy to use, is unified and helps you gain deeper data insight. Microsoft defines Power BI as a visual tool to bridge the gap between data and decision-making.<ref name=":0">https://docs.microsoft.com/en-us/power-bi/</ref>   
 
Power BI is an MS365 application that allows users to connect to and visualize any data using a scalable platform for self-service and enterprise business intelligence (BI). This platform is easy to use, is unified and helps you gain deeper data insight. Microsoft defines Power BI as a visual tool to bridge the gap between data and decision-making.<ref name=":0">https://docs.microsoft.com/en-us/power-bi/</ref>   
    
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. It converts data from different sources to build interactive dashboards and Business Intelligence reports.<ref name=":1">https://docs.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview</ref>
 
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. It converts data from different sources to build interactive dashboards and Business Intelligence reports.<ref name=":1">https://docs.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview</ref>
__TOC__[[File:PowerBI eng.png|thumb|<big>'''How does Power BI Work?'''                                                                                           When data is entered into Power BI, the software creates a dynamic visualization</big>|alt=|450x450px|center]]
+
[[File:PowerBI eng.png|thumb|<big>'''How does Power BI Work?''' When data is entered into Power BI, the software creates a dynamic visualization</big>|alt=How does Power BI Work?|450x450px|none]]
    
==Power BI at work ==
 
==Power BI at work ==
Line 9: Line 12:     
If you are a developer, you might use Power BI APIs to push data into datasets or to embed dashboards and reports into your own custom applications.<ref name=":1" />
 
If you are a developer, you might use Power BI APIs to push data into datasets or to embed dashboards and reports into your own custom applications.<ref name=":1" />
[[File:Main functionality for Power BI.png|thumb|<big>'''Main functionalities for Power BI'''                                                                                In the image summarized the main functionalities of Power BI</big>|alt=|450x450px|center]]
     −
==='''''What are the main functionalities of Power BI'''''<ref>https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi</ref>===
+
==What are the main functionalities of Power BI==  
'''1. Access to Volumes of Data from Multiple Sources'''
      +
[[File:Main functionality for Power BI.png|thumb|<big>'''Main functionalities for Power BI are summarized below'''</big> <ref>https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi</ref>|alt=Main functionalities for Power BI|450x450px|none]]
 +
 +
===1. Access to Volumes of Data from Multiple Sources===
 
Power BI can access big data from a variety of sources. It allows you to view, analyze, and visualize vast quantities of data that cannot be opened, or processed in Excel. Some of the important data sources available for Power BI are Excel, XLS, TXT, CSV, XML, JSON, pdf, etc. Power BI uses powerful compression algorithms to import and cache the data within the PBIX file.
 
Power BI can access big data from a variety of sources. It allows you to view, analyze, and visualize vast quantities of data that cannot be opened, or processed in Excel. Some of the important data sources available for Power BI are Excel, XLS, TXT, CSV, XML, JSON, pdf, etc. Power BI uses powerful compression algorithms to import and cache the data within the PBIX file.
   −
'''2. Interactive user interface or user experience (UI/UX) features'''
+
===2. Interactive user interface or user experience (UI/UX) features===
 
+
Power BI makes things visually more appealing. It has an easy drag and drop functionality, with features that allow you to copy all formatting across similar visualizations.[[File:PowerBI2.png|thumb|<big>'''Power BI accessibility across multiple devices''' Power BI can be accessible in laptops, tablets or mobile phones using the MS365 environment</big>|alt=Power BI accessibility across multiple devices|450x450px|none]]
Power BI makes things visually more appealing. It has an easy drag and drop functionality, with features that allow you to copy all formatting across similar visualizations.[[File:PowerBI2.png|thumb|<big>'''Power BI accessibility across multiple devices'''                                                     Power BI can be accessible in laptops, tablets or mobile phones using the MS365 environment</big>|alt=|450x450px|center]]'''3. Exceptional Excel Integration'''
      +
===3. Exceptional Excel Integration===
 
Power BI helps to gather, analyze, publish, and share Excel business data. Anyone familiar with Office 365 can easily connect Excel queries, data models, and reports to Power BI Dashboards.
 
Power BI helps to gather, analyze, publish, and share Excel business data. Anyone familiar with Office 365 can easily connect Excel queries, data models, and reports to Power BI Dashboards.
   −
'''4. Accelerate Big Data Preparation with Azure'''
+
===4. Accelerate Big Data Preparation with Azure===
 
   
Using Power BI with Azure allows you to analyze and share massive volumes of data. Azure data sets can reduce the time it takes to get insights and increase collaboration between business analysts, data engineers, and data scientists.
 
Using Power BI with Azure allows you to analyze and share massive volumes of data. Azure data sets can reduce the time it takes to get insights and increase collaboration between business analysts, data engineers, and data scientists.
   −
'''5. Turn Insights into Action'''
+
===5. Turn Insights into Action===
 
   
Power BI allows you to gain understanding of your data and turn that information into actions to make data-driven business decisions.
 
Power BI allows you to gain understanding of your data and turn that information into actions to make data-driven business decisions.
   −
'''6. Real-time Stream Analytics'''
+
===6. Real-time Stream Analytics===
 +
Power BI will enable you to perform real-time stream analytics. It helps you fetch data from multiple sources, including social media, or social engagement tools to get access to real-time analytics, so you are always ready to make business decisions based on your BI.
   −
Power BI will enable you to perform real-time stream analytics. It helps you fetch data from multiple sources, including social media, or social engagement tools to get access to real-time analytics, so you are always ready to make business decisions based on your BI. 
   
==Power BI - Training Materials==
 
==Power BI - Training Materials==
Below is a collection of Power BI training products to support public servants. Click on one of the following resources or feel free to add your own.  
+
Below is a collection of Power BI training products to support public servants.  
 +
 
 +
===Virtual Training===
 +
[[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Home/Training]]
   −
==Articles and other Documents==
+
===Additional Resources===
*[https://support.office.com/en-us/article/Use-the-Power-BI-web-part-32D8B85F-094D-4152-8E3B-DF641CCF3968 Use the Power BI web part]
+
'''Disclaimer''': SSC provides these links to resources for your convenience. However, these resources reside outside of the Government of Canada and may not adhere to GC standards.
*[https://support.microsoft.com/en-us/office/add-a-power-bi-tab-to-teams-708ce6fe-0318-40fa-80f5-e9174f841918?ui=en-us&rs=en-us&ad=us Add a Power BI tab to Teams]
     −
==Guided Learning==
+
# [https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview What is Power BI? (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/explore-power-bi-service Explore Power BI (60 minutes)]
+
# [https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started Get started with Power BI Desktop (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/analyze-data-power-bi Analyze data Power BI (50 minutes)]
+
# [https://support.office.com/en-us/article/Use-the-Power-BI-web-part-32D8B85F-094D-4152-8E3B-DF641CCF3968 Use the Power BI web part (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/get-started-with-power-bi Get started building with Power BI (32 minutes)]
+
#[https://support.microsoft.com/en-us/office/add-a-power-bi-tab-to-teams-708ce6fe-0318-40fa-80f5-e9174f841918?ui=en-us&rs=en-us&ad=us Embed Power BI content in Microsoft Teams (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/get-data-power-bi Get data with Power BI (60 minutes)]
+
# [https://learn.microsoft.com/en-us/power-bi/fundamentals/videos Power BI videos (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi Model data in Power BI (52 minutes)]
+
# [https://learn.microsoft.com/en-us/power-platform/developer/get-started Introduction to Microsoft Power Platform for developers (Microsoft)]
*[https://docs.microsoft.com/en-us/learn/modules/visuals-in-power-bi Use visuals in Power BI (110 minutes)]
  −
*[https://docs.microsoft.com/en-us/learn/modules/explore-data-power-bi Explore data in Power BI (43 minutes)]
  −
*[https://docs.microsoft.com/en-us/learn/modules/publish-share-power-bi Publish and share in Power BI (54 minutes)]
  −
*[https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodax?tutorial-step=1 Introduction to DAX (97 minutes)]
  −
*[https://www.microsoft.com/videoplayer/embed/RE4Jq7h?autoplay=1&enablejsapi=1&rel=0 What is the Power Platform and how does it integrates Power Tools (3 minutes)]  
     −
==Learning Paths==
+
===Learning Paths===
{|
+
#[https://learn.microsoft.com/en-us/training/browse/?term=Power%20BI&terms=Power%20BI&resource_type=learning%20path Click here to find over 20 learning Path modules (Microsoft)]
|-
+
#[https://learn.microsoft.com/en-us/training/paths/get-started-power-bi/ Get started with Power BI (Microsoft)]
|'''Get started building with Power BI'''|| ||'''Introduction to Power Platform'''||  ||'''Explore what Power BI can do for you'''
+
#[https://learn.microsoft.com/en-us/training/modules/get-data-power-bi/ Get data with Power BI Desktop (Microsoft)]
|-
+
#[https://learn.microsoft.com/en-us/training/modules/explore-data-power-bi/ Explore data in Power BI (Microsoft)]
|[[Image:1._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/modules/get-started-with-power-bi/]]||[[Image:Blank.png|30px]]||[[Image:2._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/modules/introduction-power-platform/]]||[[Image:Blank.png|30px]]||[[Image:3._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/modules/explore-power-bi-service/]]
+
#[https://learn.microsoft.com/en-us/training/modules/explore-power-bi-service/ Explore what Power BI can do for you (Microsoft)]
|-
+
#[https://learn.microsoft.com/en-us/training/modules/publish-share-power-bi/ Publish and share in Power BI (Microsoft)]
|'''Create and use analytics reports'''|| ||'''Analyze data with Power BI'''|| ||'''Consume data with Power BI'''
+
#[https://learn.microsoft.com/en-us/training/paths/dax-power-bi/?tutorial-step=1 Use DAX in Power Bi Desktop (Microsoft)]
|-
+
#[https://learn.microsoft.com/en-us/training/paths/consume-data-with-power-bi/ Consume data with Power BI (Microsoft)]
|[[Image:4._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/paths/create-use-analytics-reports-power-bi/]]||[[Image:Blank.png|30px]]||[[Image:5._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/modules/analyze-data-power-bi/]]||[[Image:Blank.png|30px]]||[[Image:6._LP_-_PowerBI_-_EN.PNG|245px|link=https://docs.microsoft.com/learn/paths/consume-data-with-power-bi/]]
+
#[https://learn.microsoft.com/en-us/training/modules/introduction-power-platform/ Describe the business value of the Microsoft Power Platform (Microsoft)]
|}
+
#[https://docs.microsoft.com/learn/paths/create-use-analytics-reports-power-bi/ Create and use analytics reports with Power BI (Microsoft)]
   −
==Discussion Board==
+
===Discussion Board===
Do you have a question about PowerBI? Simply [https://community.powerbi.com/ '''click here'''] to join the community and get started.
+
Do you have a question about Power BI? Simply [https://community.powerbi.com/ '''click here to join the Microsoft Power BI Community hub'''] to join the community and get started.
    
==Contact Us==
 
==Contact Us==

Navigation menu

GCwiki