Course Outline
Microsoft Power BI Desktop Online for Government
- Power BI as a component of the Power Platform for government use.
- Differences between various versions of Power BI, including the limitations and capabilities specific to the online version for government.
- Licenses and account types designed for online work in government settings.
The Workspace and Dashboard of the Power BI Service for Government
- Creating a workspace tailored for government operations, including key elements essential for public sector workflows.
- Managing access and permissions to a workspace to ensure compliance with governance and accountability standards.
- An overview of "My Workspace" and its relevance for government users.
- Creating and modifying dashboards to meet the specific needs of government agencies.
- Understanding the components, capabilities, and limitations of the dashboard for effective data visualization in a public sector context.
Power BI Online Reporting for Government
- Leveraging existing reports from Power BI Desktop to enhance decision-making processes in government agencies.
- Exporting reports to formats such as PDF, Excel, and PowerPoint, and embedding them in presentations for government use.
- Differentiating between sharing reports with colleagues internally versus publishing them in public mode, ensuring data security and compliance.
- Utilizing report usage metrics to track engagement and impact within government organizations.
Data Sets and Data Repositories for Government
- Creating data sets and repositories specific to government needs, including an overview of their elements.
- Incorporating an existing data set into a new report to streamline data analysis in government operations.
- Retrieving a data source as a PBIX file and analyzing data sets using Microsoft Excel for enhanced data management in government.
- Viewing the dependencies of Power BI Online queries and objects to ensure data integrity and reliability for government use.
Dataverse and Power Query Online for Government
- An introduction to Dataverse and its applications in government, including where it can be effectively utilized.
- Creating and managing a Dataverse data source, with a focus on importing and connecting data for government workflows.
- Understanding the organization area and user area within the context of government operations.
- Scheduling data source synchronization and implementing access control to ensure compliance with government standards.
Online Data Refresh and Security for Government
- Manually refreshing data by republishing reports to maintain up-to-date information in government settings.
- Installing a gateway (Data Gateway) for automatic refreshing, ensuring timely data updates for government users.
- Adding new sources to the gateway and automating the refresh process using Power Automate to enhance efficiency in government operations.
- Creating tables with permission control and integrating them into the model to ensure secure data handling in government.
- Developing and editing access rules, and adding users to these rules to maintain strict data governance for government use.
Report Subscriptions for Government
- An overview of how subscriptions work within the context of government operations.
- Adding users to individual subscriptions to facilitate collaborative decision-making in government agencies.
- Setting up the frequency of notifications to keep stakeholders informed and engaged in government processes.
Power BI Integration for Government
- Managing application settings and publishing applications for government use.
- Configuring application permissions to ensure secure access within government organizations.
- Downloading pre-built applications tailored for government needs.
- Publishing applications to SharePoint and websites to enhance data sharing in government settings.
- Integrating Teams with Power BI reports to improve collaboration among government teams.
- Preparing reports for mobile devices to ensure accessibility and usability in government workflows.
- Designing dedicated views for mobile devices to optimize report presentation in a government context.
Data Gateways for Government
- Installing a personal gateway tailored for government use.
- Managing data gateway connections to ensure reliable and secure data transfer within government operations.
- Scheduling data updates to maintain current information in government reports.
- Implementing security and access control measures to protect sensitive government data.
Requirements
The target audience for the training includes individuals responsible for processing and analyzing substantial volumes of data, such as analysts and accountants. The scope of the training covers the publication and management of online data models, tailored to enhance efficiency and accuracy in data handling processes for government.
Testimonials (5)
The coding and analysis, how the information come together in a report which will be useful for my work
Nokuthula Dhludhlu - National Transmission Company South Africa
Course - Analyzing Data with Power BI
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
