Course Information
Code10989
FeeSee particular events - prices exclude VAT
Duration2 Day(s)
Delivery MethodInstructor-led
Scheduled DatesCurrently there are no scheduled events for this course - please contact us for information
Referral Fee£50 Amazon Voucher! - refer a friend or colleague
Related LinksN/A
MS 10989 Analyzing Data Power BI SQL Course Sheffield London Manchester Leeds Yorkshire Book Your Course Now!

Rezound provide official 10989 Analyzing Data with Power BI training for Sheffield, London, Leeds, Manchester, Yorkshire and at your site in the UK.

Course Details

Introduction

This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.

Related Certifications and Examinations

There can be many combinations for how a course's content maps to the various examinations and related certifications.

We have listed as many of the primary ones as possible and continually update our database - please contact us for further information.

Related Examinations

  • There are no listed related examinations

Related Certifications

  • There are no listed related certifications

Audience

The primary audience for this course is BI professionals who need to analyze data utilizing Power BI.

The secondary audiences for this course are technically proficient business users.

At Course Completion

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

Prerequisites

Before attending this course, students should ideally have:

  • Basic knowledge of the Microsoft Windows operating system 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 branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with Microsoft Office applications – particularly Excel
  • These prerequisites can be achieved by attending courses:
  • 20761A – Querying Data with Transact-SQL
  • 20767A - Implementing a SQL Server Data Warehouse

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Course Outline

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.

Lessons and Activities

  • 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.

Lessons and Activities

  • Power BI
  • The Power BI service
  • Power BI mobile apps

Lab : Creating a Power BI dashboard

Module 3: Power BI Data

This module describes Power BI data sources.

Lessons and Activities

  • 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.

Lessons and Activities

  • 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.

Lessons and Activities

  • Relationships
  • DAX queries
  • Calculations and measures

Lab : Modelling data

Module 6: Interactive Data Visualizations

This module describes Power BI visualizations.

Lessons and Activities

  • Creating Power BI reports
  • Managing a Power BI solution

Lab : Creating a Power BI report


Copyright © + Design: Rezound Limited | MS 10989 Analyzing Data with Power BI Course Sheffield London Manchester Leeds Yorkshire