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.
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
Contact Us or Live Chat if you have questions or concerns about Microsoft Technical Course.
Need help picking the right course?
800-453-596 (Toll Free)
Train Your Team