1­-855­-778­-7246

Analyzing Data with Power BI (20778)

 

Course Overview

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.
Module 1: Introduction to Self-Service BI Solutions

  • Lesson 1: Introduction to Business Intelligence
  • Lesson 2: Introduction to Data Analysis
  • Lesson 3: Introduction to Data Visualization
  • Lesson 4: Overview of Self-Service BI
  • Lesson 5: Considerations for Self-Service BI
  • Lesson 6: Microsoft Tools for Self-Service BI
  • Lab: Exploring an Enterprise BI Solution

Module 2: Introducing Power BI

  • Lesson 1: Power BI
  • Lesson 2: The Power BI Service
      [list]
    • Lab: Creating a Power BI Dashboard
    Module 3: Power BI Data
    • Lesson 1: Using Excel as a Data Source for Power BI
    • Lesson 2: The Power BI Data Model
    • Lesson 3: Using Databases As a Data Source for Power BI
    • Lesson 4: The Power BI Service
    • Lab: Importing Data into Power BI
    Module 4: Shaping and Combining Data
    • Lesson 1: Power BI Desktop Queries
    • Lesson 2: Shaping Data
    • Lesson 3: Combining Data
    • Lab: Shaping and Combining Data
    Module 5: Modeling Data
    • Lesson 1: Relationships
    • Lesson 2: DAX Queries
    • Lesson 3: Calculations and Measures
    • Lab: Modeling Data
    Module 6: Interactive Data Visualizations
    • Lesson 1: Creating Power BI Reports
    • Lesson 2: Managing a Power BI Solution
    • Lab: Creating a Power BI Report
    Module 7: Direct Connectivity
    • Lesson 1: Cloud Data
    • Lesson 2: Connecting to Analysis Services
    • Lab: Direct Connectivity
    Module 8: The Developer API
    • Lesson 1: The Developer API
    • Lesson 2: Custom Visuals
    • Lab: Using the Developer API
    Module 9: Power BI Mobile
    • Lesson 1: Power BI Mobile Apps
    • Lesson 2: Using the Power BI Mobile App
    • Lesson 3: Power BI Embedded

A qui s'adresse cette formation

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data at course completion

Pré-requis

Before attending this course, students must have:

  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Familiarity with Microsoft Office applications – particularly Excel

Objectifs

After completing this course, students will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI developer API.

Outline: Analyzing Data with Power BI (20778)

Module 1: Introduction to Self-Service BI Solutions

  • Lesson 1: Introduction to Business Intelligence
  • Lesson 2: Introduction to Data Analysis
  • Lesson 3: Introduction to Data Visualization
  • Lesson 4: Overview of Self-Service BI
  • Lesson 5: Considerations for Self-Service BI
  • Lesson 6: Microsoft Tools for Self-Service BI
  • Lab: Exploring an Enterprise BI Solution

Module 2: Introducing Power BI

  • Lesson 1: Power BI
  • Lesson 2: The Power BI Service
      [list]
    • Lab: Creating a Power BI Dashboard
    Module 3: Power BI Data
    • Lesson 1: Using Excel as a Data Source for Power BI
    • Lesson 2: The Power BI Data Model
    • Lesson 3: Using Databases As a Data Source for Power BI
    • Lesson 4: The Power BI Service
    • Lab: Importing Data into Power BI
    Module 4: Shaping and Combining Data
    • Lesson 1: Power BI Desktop Queries
    • Lesson 2: Shaping Data
    • Lesson 3: Combining Data
    • Lab: Shaping and Combining Data
    Module 5: Modeling Data
    • Lesson 1: Relationships
    • Lesson 2: DAX Queries
    • Lesson 3: Calculations and Measures
    • Lab: Modeling Data
    Module 6: Interactive Data Visualizations
    • Lesson 1: Creating Power BI Reports
    • Lesson 2: Managing a Power BI Solution
    • Lab: Creating a Power BI Report
    Module 7: Direct Connectivity
    • Lesson 1: Cloud Data
    • Lesson 2: Connecting to Analysis Services
    • Lab: Direct Connectivity
    Module 8: The Developer API
    • Lesson 1: The Developer API
    • Lesson 2: Custom Visuals
    • Lab: Using the Developer API
    Module 9: Power BI Mobile
    • Lesson 1: Power BI Mobile Apps
    • Lesson 2: Using the Power BI Mobile App
    • Lesson 3: Power BI Embedded
Formation en ligne

Durée 3 jours

Prix
  • Country: CA
    CAD 1 995,-
  • SA Voucher: 3
Dates et Inscription
Classroom training

Durée 3 jours

Prix
  • Canada:
    Country: CA
    CAD 1 995,-
  • SA Voucher: 3
Dates et Inscription
 
Agenda

Actuellement aucune session planifiée  Demande de date