Transitioning from Excel to Power BI for Government Agencies

Significant requirements in large data reporting are changing for the modern agency.

Course Description

Significant requirements in large data reporting are changing for the modern agency. Power BI will help you harness the rapidly transforming information needed to see at the past, present, and make informed future decisions. As an analyst, your data is provided in Excel. Learn how to transform your Excel data in the Power BI Power Query Editor.  Create many visualizations that will become an interactive report.

Excel to Power BI Introduction

• Custom visuals not available in Excel
• Filtering, Bookmarks, and Drill-through
• Publish and Share to the Power BI Service

Data modeling in Power BI Desktop

• Get Data from Excel or CSV File
• Set Options and Settings for Data Load
• Import Power Query, Power Pivot, and Power View from Excel
• Edit Imported Queries
• Build a Dates Table
• Load the prepared Data to Power BI Desktop

Design Interactive Reports in Power BI Desktop

• Use the Visualizations Pane to create a Multi-page Report
• Apply Conditional Formatting
• Create Small Multiples in Charts
• Setup an AI/Decomposition Tree
• Import Custom Visuals
• Create What-If Scenarios

Formatting & Custom Settings

• Alignment and Grouping
• Apply Power BI Themes
• Insert Custom Graphics & Buttons

Create and Manage Workspaces

• Creating Workspaces
• Sharing and Managing Assets

• Map security principals to dataset roles
• Share a dashboard
• Publish an App

Related Certifications:
Microsoft Certified: Power Platform Fundamentals(PL-900)
PL-900 Learning Paths
PL-900 Credly & Job Opportunities
Microsoft Certified: Power Platform Developer Associate(PL-400)
PL-400 Learning Paths
PL-400 Credly & Job Opportunities