Data Analysis Introduction

This course is an introduction to data analysis and building business intelligence reports with Microsoft Power BI.

Overview

This course introduces users to Microsoft Power BI and teaches how to use and build business intelligence reports. Expanding your skills in this area is a valuable endeavor to meet today’s increasing demands for data analysis and business intelligence within any organization.

Audience

This course is designed for Excel users wanting to understand and produce business intelligence reports using Microsoft Power BI.

Length

2 days

Outline

Get started building with Power BI

  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service

Get data with Power BI Desktop

  • Overview of Power BI Desktop
  • Explore Power BI Desktop
  • Connect to data sources
  • Get data from Excel
  • Transform data to include in a report
  • Combine data from multiple sources
  • Clean data to include in a report

Model data in Power BI

  • Introduction to modeling your data
  • How to manage your data relationships
  • Create calculated columns
  • Optimize data models
  • Create measures
  • Create calculated tables
  • Explore time-based data

Use visuals in Power BI

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Create slicers
  • Map visualizations
  • Matrices and tables
  • Create scatter, waterfall, and funnel charts
  • Modify colors in charts and visuals
  • Page layout and formatting

Explore data in Power BI

  • Introduction to the Power BI service
  • Quick insights in Power BI
  • Create and configure a dashboard
  • Ask questions of your data with natural language
  • Create custom Q&A suggestions
  • Share dashboards with your organization
  • Display visuals and tiles in full screen
  • Edit tile details and add widgets
  • Get more space on your dashboard

Publish and share in Power BI

  • Introduction to using workspaces
  • Publish Power BI Desktop reports
  • Print and export dashboards and reports
  • Introducing Power BI Mobile
  • Create workspaces in Power BI
  • Build apps
  • Use apps
  • Integrate OneDrive for Business with Power BI
  • Publish to web