Use Power BI: Data Analysis Professional course and lab to explore and visualize data with Power BI. The lab is cloud-based, device-enabled, and can easily be integrated with an LMS. The Power BI course provides knowledge and skills required to analyze data with self-service BI, connect to data sources, perform advanced data modeling and shaping, perform advanced analysis, publish and share reports and dashboards, extend access to Power BI, and more.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

In this course, you will analyze data with Microsoft Power BI. You will:
Analyze data with self-service BI.
Connect to data sources.
Perform data cleaning, profiling, and shaping.
Visualize data with Power BI.
Enhance data analysis by adding and customizing visual elements.
Model data with calculations.
Create interactive visualizations.
Use advanced analysis techniques.
Enhance reports and dashboards.
Publish and share reports and dashboards.
Extend Power BI beyond the desktop.

1

  • Introduction

  • Course Description
    How to Use This course
    Course-Specific Technical Requirements
2

  • Analyzing Data with Self-Service BI

  • Topic A: Data Analysis and Visualization for Business Intelligence
    Topic B: Self-Service BI with Microsoft Power BI
    Summary
3

  • Connecting to Data Sources

  • Topic A: Create Data Connections
    Topic B: Configure and Manage Data Relationships
    Topic C: Save Files in Power BI
    Summary
4

  • Performing Data Cleaning, Profiling, and Shaping

  • Topic A: Clean, Transform, and Load Data with the Query Editor
    Topic B: Profile Data with the Query Editor
    Topic C: Shape Data with the Query Editor
    Topic D: Combine and Manage Data Rows
    Summary
5

  • Visualizing Data with Power BI

  • Topic A: Create Visualizations in Power BI
    Topic B: Chart Data in Power BI
    Summary
6

  • Enhancing Data Analysis

  • Topic A: Customize Visuals and Pages
    Topic B: Incorporate Tooltips
    Summary
7

  • Modeling Data with Calculations

  • Topic A: Create Calculations with Data Analysis Expressions (DAX)
    Topic B: Create Calculated Measures and Conditional Columns
    Summary
8

  • Creating Interactive Visualizations

  • Topic A: Create and Manage Data Hierarchies
    Topic B: Filter and Slice Reports
    Topic C: Create Dashboards
    Summary
9

  • Using Advanced Analysis Techniques

  • Topic A: Create Calculated Tables, Variables, and Parameters
    Topic B: Enhance Visuals with Statistical Analysis
    Topic C: Perform Advanced Analysis
    Summary
10

  • Enhancing Reports and Dashboards

  • Topic A: Enhance Reports
    Topic B: Enhance Dashboards
    Summary
11

  • Publishing and Sharing Reports and Dashboards

  • Topic A: Publish Reports
    Topic B: Create and Manage Workspaces
    Topic C: Share Reports and Dashboards
    Summary
12

  • Extending Power BI Beyond the Desktop

  • Topic A: Use Power BI Mobile
    Topic B: Extend Access with the Power BI API
    Summary

Audience

This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel or SQL Server Reporting Services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...