Analyzing Data with Power BI vB

Course information
Price: € 645.00
Day(s): 2
Course Code: M10989-OD
Version: B
Delivery Method: E-learning (Self-Paced)

Overview

This Microsoft On-Demand course provides students with the knowledge and skills analyze data with Power BI.

Pre-Requisites

  • Basic knowledge of the Microsoft Windows operating systems and its core functionality.
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming concepts such as looping and branchging.
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

These prerequisites can be achieved by attending courses:

  • 20761A - Querying Data with Transact-SQL
  • 20767A - Implementing a SQL Server Data Warehouse

Content

Module 1: Introduction to Self-Service BI Solutions

In this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Lab : Exploring an enterprise BI solution

Module 2: Introducing Power BI

This module introduces Power BI.

  • Power BI
  • The Power BI service
  • Power BI mobile apps
  • Lab : Cresting a Power BI dashboard

Module 3: Power BI Data

This module describes Power BI data sources.

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Lab: Import data into Power BI

Module 4: Shaping and Combining Data

This module describes how to shape and combine data.

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Lab: Shaping and combining data

Module 5: Modelling Data

This module describes how to model data in Power BI.

  • Relationships
  • DAX queries
  • Calculations and measures
  • Lab: Modelling data

Module 6: Interactive Data Visualizations

This module describes Power BI visualizations.

  • Creating Power BI reports
  • Managing a Power BI solution
  • Lab: Creating a Power BI report


Objectives

After completing this course, students will be able to:

  • Describe key features of a self-service BI solution
  • Describe Power BI and its data sources
  • Model, shape, and combine data
  • Describe Power BI data visualizations

Target Audience

The primary audience for this MOC-OD course is BI professionals who need to analyze data utilizing Power BI. The secondary audiences for this course are technically proficient business users.

Add to Basket

Key to symbols +

  • gauranteed Indicates a guaranteed course
  • special offer Indicates a special offer
  • late availability Indicates a late availability course
  • GTC What are GTCs?

Course description

Download a PDF document of the complete course description: Analyzing Data with Power BI vB

Dates for all Delivery Formats
Date & Location Language Ver Delivery Method
May
11 May - 12 May, 2017
Virtual Training
ver A Virtual Learning

This item has been added to your basket