Dynamics 365
Power BI & Apps
Azure
Microsoft 365 (Office)
Cyber Security
Government Solutions
Solutions

Transitioning from Excel to Power BI for Government Agency Users

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

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 Courses:

DA-100 Analyzing Data with Microsoft Power BI

PL-100 Microsoft Power Platform App Maker

PL-200 Microsoft Power Platform Functional Consultant

PL-600 Microsoft Power Platform Solution Architect

 

Related Certifications:

Contact Us or Live Chat if you have questions or concerns about Microsoft Technical Course.

Need help picking the right course?

Give us a call!
408-684-5250 or 
800-453-596 (Toll Free) 

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Register Now

Price:

$695.00

Duration:
5 days

    Print

    202 S.E. Church Street, Suite 203 Leesburg, VA 20175
    800-453-5961 (Toll Free)
    202-410-6400
    https://www.dynamicsedge.com/
    sales@dynamicsedge.com
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram