|
|
| (13 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | <!-- This template is used on https://wiki.gccollab.ca/M365/PowerBI, Do NOT delete. --> | + | <!-- This template is used on https://wiki.gccollab.ca/M365/Forms, Do NOT delete. --> |
| − | =Introduction - Power BI= | + | =Microsoft Forms - Training Materials= |
| − | 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>
| + | Below is a collection of Microsoft Forms training products to support public servants. |
| | | | |
| − | 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>
| + | ==Virtual Training== |
| − | [[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]] | + | [[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Training-Formation]] |
| − | | |
| − | ==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. <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" />
| |
| − | | |
| − | ==What are the main functionalities of Power BI<ref>https://www.simplilearn.com/tutorials/power-bi-tutorial/what-is-power-bi</ref>==
| |
| − | | |
| − | [[File:Main functionality for Power BI.png|thumb|<big>'''Main functionalities for Power BI are summarized below'''</big>|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.
| |
| − | | |
| − | ===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]]
| |
| − | | |
| − | ===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=== | + | ==Departmental Resources== |
| − | 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.
| + | Various departments and agencies across the GC have developed content to support the adoption of M365 applications. If you have drafted content, please consider sharing it for your colleagues. '''[[M365/Resources-Ressources|Click here to see other Departments' Resources or to add your own]].''' |
| | | | |
| − | ==Power BI - Training Materials== | + | ==Additional Resources== |
| − | Below is a collection of Microsoft Power BI training products to support public servants.
| + | '''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. |
| | | | |
| − | ===Virtual Training===
| + | * [https://support.microsoft.com/en-us/office/sign-in-to-microsoft-forms-620daa7a-3e03-4013-8f92-5cce86210ef6 Microsoft Forms Quick Start (Microsoft)] |
| − | [[Image:Virtual_Training.PNG|alt="Virtual Training"|Virtual Training|100px|link=https://wiki.gccollab.ca/M365/Training-Formation]]
| + | * [https://support.microsoft.com/en-us/office/add-a-poll-to-your-teams-channel-or-chat-a3f9112c-01e1-4ee4-bd88-25e4e243b80b Add a poll to your Teams channel or chat (Microsoft)] |
| − | | + | * [https://support.microsoft.com/en-us/office/poll-attendees-during-a-teams-meeting-9923b7d4-ea97-4aa2-b8b8-b45fefe7d454 Poll attendees during a Teams meeting (Microsoft)] |
| − | ===Additional Resources===
| + | * [https://create.microsoft.com/en-us/forms-templates Create feature-packed forms with templates (Microsoft)] |
| − | '''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/forms Microsoft Forms help & learning (Microsoft)] |
| − | | |
| − | * [https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview What is Power BI? (Microsoft)] | |
| − | * [https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-getting-started Get started with Power BI Desktop (Microsoft)]
| |
| − | * [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://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://learn.microsoft.com/en-us/power-bi/fundamentals/videos Power BI videos (Microsoft)] | |
| − | * [https://learn.microsoft.com/en-us/power-platform/developer/get-started Introduction to Microsoft Power Platform for developers (Microsoft)] | |
| | | | |
| | ===Accessibility=== | | ===Accessibility=== |
| − | * [https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-overview Overview of accessibility in Power BI (Microsoft)] | + | * Screen reader support for Microsoft Forms (Microsoft) |
| − | * [https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports Design Power BI reports for accessibility (Microsoft)]
| + | ::[https://support.microsoft.com/en-us/office/screen-reader-support-for-microsoft-forms-a77e8a20-ce55-4f93-99a2-96bd688b86f3#PickTab=Windows (Windows)] [https://support.microsoft.com/en-us/office/screen-reader-support-for-microsoft-forms-a77e8a20-ce55-4f93-99a2-96bd688b86f3#PickTab=macOS (macOS)] [https://support.microsoft.com/en-us/office/screen-reader-support-for-microsoft-forms-a77e8a20-ce55-4f93-99a2-96bd688b86f3#PickTab=iOS (iOS)] [https://support.microsoft.com/en-us/office/screen-reader-support-for-microsoft-forms-a77e8a20-ce55-4f93-99a2-96bd688b86f3#PickTab=Android (Android)] |
| − | * [https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools Consume Power BI reports by using accessibility features (Microsoft)] | + | * [https://support.microsoft.com/en-us/office/accessibility-video-training-71572a1d-5656-4e01-8fce-53e35c3caaf4 Accessibility video training (Microsoft)] |
| − | | + | * [https://support.microsoft.com/en-us/accessibility Accessibility help & learning (Microsoft)] |
| − | ===Learning Paths===
| |
| − | {{M365_LP_PowerBI_EN}}
| |
| | | | |
| | ===Communities=== | | ===Communities=== |
| − | *[[gccollab:groups/about/4590555|Clicks and Tips (GCcollab)]]
| + | * [https://techcommunity.microsoft.com/t5/microsoft-forms/bd-p/MicrosoftForms Microsoft Forms Community Hub (Microsoft)] |
| − | *[https://www.gcpedia.gc.ca/wiki/Clicks_and_Tips_for_PC Clicks and Tips for PC (GCpedia)] | + | * [https://www.youtube.com/user/officevideos/playlists Microsoft 365 YouTube Channel (YouTube)] |
| − | *[https://answers.microsoft.com/en-us/search/search?SearchTerm=Power%20BI&tab=&status=all&advFil=&IsSuggestedTerm=false&isFilterExpanded=undefined&CurrentScope.ForumName=all&CurrentScope.Filter=&ContentTypeScope=QnA&page=1&sort=Relevance&dir=Desc Microsoft Power BI Answers (Microsoft)]
| |
| − | *[https://community.powerbi.com/ Microsoft Power BI Community Hub (Microsoft)]
| |
| − | * [https://www.linkedin.com/showcase/microsoft-power-platform/ Microsoft Power Platform Profile (LinkedIn)] | |
| − | * [https://www.youtube.com/@MicrosoftPowerBI/playlists Microsoft Power BI YouTube Channel (YouTube)]
| |
| − | * [https://www.facebook.com/groups/powerbi/ Microsoft Power BI Facebook Group (Facebook)]
| |
| | | | |
| | ==Contact Us== | | ==Contact Us== |
| − | [mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback&body=https://wiki.gccollab.ca/M365/PowerBI M365 Training Feedback] | + | [mailto:dcc.accessibility-accessibilite.cnn@ssc-spc.gc.ca?Subject=M365%20Training%20Feedback%20-%20Forms&body=https://wiki.gccollab.ca/M365/Forms M365 Training Feedback] |
| | | | |
| | ==Attributions and Sources== | | ==Attributions and Sources== |
| | [[M365/Attributions|Attributions and Sources]] | | [[M365/Attributions|Attributions and Sources]] |
| | | | |
| − | ==References and other resources==
| |
| − | <references />
| |
| | [[Category:M365]] | | [[Category:M365]] |
| − | [[Category:Power Platform]] | + | [[Category:MS Forms]] |
| | + | [[Category:Training]] |
| | [[Category:Microsoft]] | | [[Category:Microsoft]] |
