Microsoft 365
Power BI
Connect, shape, and model data in Power BI Desktop to build accurate, interactive reports and dashboards.
Standard version
Showing the standard description, objectives, and outcomes. Switch to Federal for the version tailored to federal agencies.
This program introduces participants to the essential tools and techniques of Microsoft Power BI Desktop. Participants will learn how to connect data sources, transform and model data, and design interactive reports and dashboards that communicate insights clearly. The course emphasizes the Power BI workflow, from data acquisition to visualization, and the best practices that ensure accuracy, performance, and clarity in reporting.
What you'll learn
- Describe the Power BI ecosystem and distinguish between Desktop, Service, and
- Import, clean, and shape data using Power Query.
- Create and manage data models using relationships and DAX calculations.
- Design and format reports and dashboards using visual best practices.
- Apply strategies for publishing, sharing, and maintaining reports securely in Power
What you'll be able to do
- Build a complete Power BI report from raw data to visual insights.
- Use Power Query and DAX to prepare and calculate key performance indicators.
- Apply consistent design standards, hierarchies, and themes for clarity and impact.
- Interpret data using filters, drilldowns, and interactive visuals.
- Share dashboards responsibly using Power BI Service and appropriate governance
Power BI helps federal teams turn data into interactive reports and dashboards that support decisions. This course introduces the Power BI workflow, from connecting and cleaning data to modeling it and designing clear reports. Participants practice with realistic data and learn how to share dashboards in line with their agency's data and access requirements.
What you'll learn
- Describe the Power BI workflow and its main components.
- Import, clean, and shape data using Power Query.
- Create data models using relationships and basic calculations.
- Design clear, interactive reports and dashboards.
- Share reports in line with agency data and access requirements.
What you'll be able to do
- Connect and prepare data for reporting.
- Build dashboards that answer leadership questions.
- Present data clearly and interactively.
- Reduce time spent on manual reporting.
- Handle data in line with agency requirements.