Difference between revisions of "M365/Home/PowerBI"

From wiki
< M365‎ | Home
Jump to navigation Jump to search
m
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
{{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}}
 
{{DISPLAYTITLE:<span style="position: absolute; clip: rect(1px 1px 1px 1px); clip: rect(1px, 1px, 1px, 1px);">{{FULLPAGENAME}}</span>}}
−
[[Image:MS365_Banner_-_PowerBI.png|920px|https://wiki.gccollab.ca/M365/Home]]
+
'''Old Page Alert:''' ''Please note that you are currently on our old page. Our new and improved page can now be found at https://wiki.gccollab.ca/M365. Please update your bookmark.''
−
__NOTOC__
 
−
__NOEDITSECTION__
 
−
[[FR:M365/Accueil/PowerBI]]
 
−
{{MS_icons_EN}}
 
  
−
==Introduction - Power BI==
+
'''Alerte à l’ancienne page :''' ''Veuillez noter que vous êtes actuellement sur notre ancienne page. Notre nouvelle page améliorée se trouve maintenant à https://wiki.gccollab.ca/M365. Veuillez mettre à jour votre signet.''
  
 +
<multilang>
 +
<!-- English section starts here -->
 +
@en|
 +
<!-- English template -->
 +
[[Image:MS365_Banner_-_PowerBI.png|alt="M365 Home"|M365 Home|920px|link=https://wiki.gccollab.ca/M365/Home]]
 +
{{MS_icons_EN}}
 +
{{PowerBI_EN}}
  
−
Power BI is an MS365 application that allows users to connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that is easy to use and helps you gain deeper data insight. Microsoft defines it as a tool to bridge the gap between data and decision making.<ref name=":0">https://docs.microsoft.com/en-us/power-bi/</ref> 
+
<!-- French section starts here -->
−
 
+
@fr|
−
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>   
+
<!-- French template -->
−
 
+
[[Image:MS365_Banner_-_PowerBI.png|alt="Accueil M365|Accueil M365|920px|link=https://wiki.gccollab.ca/M365/Accueil]]
−
[[File:PowerBI eng.png|thumb|'''How does Power BI Works'''|alt=|left|450x450px]]
+
{{MS_icons_FR}}
−
 
+
{{PowerBI_FR}}
−
==Power BI at work ==
+
</multilang>
−
How you use Power BI may depend on your role in a project or on a team. 
 
−
 
 
−
For example, you might primarily use the Power BI service to view reports and dashboards. Your coworkers might make extensive use of Power BI Desktop or Power BI Report Builder to create reports, then publish those reports to the Power BI service, where you can view them. Another coworker, in purchases, might mainly use the Power BI phone app to monitor progress on sales quotas, and to drill into new lead details. <ref name=":0" />
 
−
 
 
−
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|'''Main functionalities for Power BI'''|alt=|left]]
 
−
 
 
−
==='''''What are the main functionalities of Power BI'''''<ref>https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi</ref>===
 
−
'''1. Access to Volumes of Data from Multiple Sources'''
 
−
 
 
−
Power BI can access vast volumes of data from multiple sources. It allows you to view, analyze, and visualize vast quantities of data that cannot be opened in Excel. Some of the important data sources available for Power BI are Excel, CSV, XML, JSON, pdf, etc. Power BI uses powerful compression algorithms to import and cache the data within the PBIX file.
 
−
 
 
−
'''2. Interactive UI/UX Features'''
 
−
 
 
−
Power BI makes things visually appealing. It has an easy drag and drops functionality, with features that allow you to copy all formatting across similar visualizations.
 
−
 
 
−
'''3. Exceptional Excel Integration'''[[File:PowerBI2.png|thumb|Power BI accessibility across multiple devices|alt=|left]]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'''
 
−
 
 
−
Using Power BI with Azure allows you to analyze and share massive volumes of data. An azure data lake 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'''
 
−
 
 
−
Power BI allows you to gain insights from data and turn those insights into actions to make data-driven business decisions.
 
−
 
 
−
'''6. Real-time Stream Analytics'''
 
−
 
 
−
Power BI will enable you to perform real-time stream analytics. It helps you fetch data from multiple sensors and social media 
 
−
 
 
−
sources to get access to real-time analytics, so you are always ready to make business decisions.
 
−
==Power BI - Training Materials==
 
−
Below is a collection of PowerBI training products to support public servants. Click on one of the following resources or feel free to add your own.
 
−
 
 
−
==Articles and other Documents==
 
−
*[https://support.office.com/en-us/article/Use-the-Power-BI-web-part-32D8B85F-094D-4152-8E3B-DF641CCF3968 Use the Power BI web part]
 
−
*[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://docs.microsoft.com/en-us/learn/modules/explore-power-bi-service Explore Power BI (60 minutes)]
 
−
*[https://docs.microsoft.com/en-us/learn/modules/analyze-data-power-bi Analyze data Power BI (50 minutes)]
 
−
*[https://docs.microsoft.com/en-us/learn/modules/get-started-with-power-bi Get started building with Power BI (32 minutes)]
 
−
*[https://docs.microsoft.com/en-us/learn/modules/get-data-power-bi Get data with Power BI (60 minutes)]
 
−
*[https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi Model data in Power BI (52 minutes)]
 
−
*[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)]
 
−
 
 
−
==Recorded Webinars==
 
−
[[Image:MS_Webinar_-_EN.png|245px|link=https://docs.microsoft.com/en-us/power-bi/webinars]]
 
−
 
 
−
==Learning Paths==
 
−
{|
 
−
|-
 
−
|'''Get started building with Power BI'''|| ||'''Introduction to Power Platform'''||  ||'''Explore what Power BI can do for you'''
 
−
|-
 
−
|[[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/]]
 
−
|-
 
−
|'''Create and use analytics reports'''|| ||'''Analyze data with Power BI'''|| ||'''Consume data with Power BI'''
 
−
|-
 
−
|[[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/]]
 
−
|}
 
−
 
 
−
==Discussion Board==
 
−
Do you have a question about PowerBI? Simply [https://community.powerbi.com/ '''click here'''] to join the community and get started.
 
−
==References and other resources==
 
  
−
<references />
+
<!-- Templates used on this page -->
 +
<!-- English: https://wiki.gccollab.ca/Template:PowerBI_EN -->
 +
<!-- French: https://wiki.gccollab.ca/Template:PowerBI_FR --->

Latest revision as of 09:05, 1 June 2023

Old Page Alert: Please note that you are currently on our old page. Our new and improved page can now be found at https://wiki.gccollab.ca/M365. Please update your bookmark.

Alerte à l’ancienne page : Veuillez noter que vous êtes actuellement sur notre ancienne page. Notre nouvelle page améliorée se trouve maintenant à https://wiki.gccollab.ca/M365. Veuillez mettre à jour votre signet.

"M365 Home"

"Teams" "Word" "PowerPoint" "Excel" "SharePoint" "OneNote" "Outlook" "OneDrive" "Planner" "Power BI" "Power Automate" "Power Apps"


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.[1]

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.[2]

How does Power BI Work?
How does Power BI Work? When data is entered into Power BI, the software creates a dynamic visualization

Power BI at work

How you use Power BI may depend on your role in a project or on a team. For example, you might primarily use the Power BI service to view reports and dashboards. Your coworkers might make extensive use of Power BI Desktop or Power BI Report Builder to create reports, then publish those reports to the Power BI service, where you can view them. Another coworker, in procurement, might mainly use the Power BI phone app to monitor progress on sales quotas and to drill into new lead details. [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.[2]

What are the main functionalities of Power BI[3]

Main functionalities for Power BI
Main functionalities for Power BI are summarized below

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.

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.

Power BI accessibility across multiple devices
Power BI accessibility across multiple devices Power BI can be accessible in laptops, tablets or mobile phones using the MS365 environment

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.

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.

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.

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 - Training Materials

Below is a collection of Microsoft Power BI training products to support public servants.

Virtual Training

"Virtual Training"

Additional Resources

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.

Learning Paths

Discussion Board

Do you have a question about Power BI? Simply click here to join the Microsoft Power BI Community hub to join the community and get started.

Contact Us

M365 Training Feedback

References and other resources

  1. ↑ 1.0 1.1 https://docs.microsoft.com/en-us/power-bi/
  2. ↑ 2.0 2.1 https://docs.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview
  3. ↑ https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi



Retrieved from "https://wiki.gccollab.ca/index.php?title=M365/Home/PowerBI&oldid=99864"