Transitioning from Excel to Power BI for Government Agencies

Course: 2308

Power BI will help you harness the rapidly transforming information needed to see at the past, present, and make informed future decisions.

Download PDF
  • Duration: 1 day
  • Price: $595.00
Get This Course $595.00
January 15

9:00 AM – 4:00 PM CST

February 12

9:00 AM – 4:00 PM CST

March 11

9:00 AM – 4:00 PM CST

April 8

9:00 AM – 4:00 PM CST

May 13

9:00 AM – 4:00 PM CST

June 10

9:00 AM – 4:00 PM CST

July 8

9:00 AM – 4:00 PM CST

August 12

9:00 AM – 4:00 PM CST

September 9

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961