Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Preparing Your Data for Power BI

  • Tuition USD $1,090 Save $109
  • Reviews star_rate star_rate star_rate star_rate star_half 329 Ratings
  • Course Code 55163
  • Duration 2 days
  • Available Formats Classroom

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX and to compare working in SQL Tabular mode to Excel PowerPivot.

Skills Gained

  • Understand Analysis Services Installation and Architecture: One Product, Two Models.
  • Understand version changes: SQL Server Analysis Services.
  • Understand important terms.
  • Understand and utilize SQL Server Data Tools for Tabular.
  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.
  • Understand and utilize data sources.
  • Understand and utilize data credentials.
  • Understand and utilize SQL as a source.
  • Understand and utilize Excel as a source.
  • Understand and utilize Flat Files as a source.
  • Understand and utilize Azure as a source.
  • Understand and utilize SharePoint as a source.
  • Understand and utilize sorting during load.
  • Understand querying with MDX.
  • Understand and utilize DAX syntax.
  • Understand and utilize DAX data types and operator overloading.
  • Understand and utilize DAX operators.
  • Understand and utilize DAX values.
  • Understand and utilize measures.
  • Understand and utilize calculated columns.
  • Understand evaluation contexts.
  • Understand and utilize date calculations.
  • Understand and utilize importing related tables.
  • Understand and utilize creating relationships.
  • Understand and utilize hierarchies.
  • Understand Direct Query.
  • Understand and utilize KPIs.
  • Understand drillthrough.
  • Understand perspectives.
  • Understand and utilize PowerPivot.
  • Understand and utilze Pivot Tables.
  • Understand and utilize Power View.

Who Can Benefit

The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Prerequisites

  • A working knowledge of SQL Server

Course Details

Outline


Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Lab 1: Course Overview
  • None
After completing this module, students will be able to:
  • Successfully log into their virtual machine.
  • Have a full understanding of what the course intends to cover.

Module 2: What is the Tabular Model?
SQL Server Analysis Services (SSAS) provides two different approaches for data modeling: multidimensional and tabular. While there is substantial overlap between them, there are also significant differences. In this module, we discuss feature comparisons and explain each approach, then well dive deeper into the tabular model as that is the focus for this course.
Lessons
  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular

Lab 1: What is the Tabular Model?
  • SQL Server Data Tools for Tabular
After completing this module, students will be able to:
  • Understand Analysis Services Installation and Architecture: One Product, Two Models.
  • Understand version changes: SQL Server Analysis Services.
  • Understand important terms.
  • Understand and utilize SQL Server Data Tools for Tabular.

Module 3: Working in Tabular
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Lessons
  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment

Lab 1: Working in Tabular
  • Creating a Tabular Project

Module 4: Working in Tabular
After completing this module, students will be able to:
  • Understand and utilize projects.
  • Understand and utilize importing.
  • Understand and utilize loading data.
  • Understand and utilize examining views.
  • Understand and utilize deployment.

Module 5: Understanding Loading Data From Different Sources
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.
Lessons
  • Data Sources
  • Data Credentials
  • SQL as a Source
  • Excel as a Source
  • Flat Files as a Source
  • Azure as a Source
  • SharePoint as a Source
  • Sorting During Load

Lab 1: Understanding Loading Data From Different Sources
  • None
After completing this module, students will be able to:
  • Understand and utilize data sources.
  • Understand and utilize data credentials.
  • Understand and utilize SQL as a source.
  • Understand and utilize Excel as a source.
  • Understand and utilize Flat Files as a source.
  • Understand and utilize Azure as a source.
  • Understand and utilize SharePoint as a source.
  • Understand and utilize sorting during load.

Module 6: Using DAX and MDX
In this module, we will discuss two different languages; DAX and MDX. We will briefly explore MDX and its use with a tabular model, then well cover DAX and walk-through how to use this powerful language.
Lessons
  • Querying with MDX
  • Basic DAX Syntax
  • Evaluation Context
  • Calculate Function
  • Time Intelligence

Lab 1: Using DAX and MDX
  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values
  • Measures
  • Calculated Columns
  • Evaluation Contexts
  • Date Calculations
After completing this module, students will be able to:
  • Understand querying with MDX.
  • Understand and utilize DAX syntax.
  • Understand and utilize DAX data types and operator overloading.
  • Understand and utilize DAX operators.
  • Understand and utilize DAX values.
  • Understand and utilize measures.
  • Understand and utilize calculated columns.
  • Understand evaluation contexts.
  • Understand and utilize date calculations.

Module 7: Building Data Models
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Lessons
  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives

Lab 1: Building Data Models
  • Creating Relationships
  • Hierarchies
After completing this module, students will be able to: Lessons
  • Understand and utilize importing related tables.
  • Understand and utilize creating relationships.
  • Understand and utilize hierarchies.
  • Understand Direct Query.
  • Understand and utilize KPIs.
  • Understand drillthrough.
  • Understand perspectives.

Module 8: Excel PowerPivot and Tabular
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Lessons
  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView

Lab 1: Excel PowerPivot and Tabular
  • Importing Data
  • Importing Large Datasets
  • Importing Data with a Query
  • Creating Relationships
  • Creating a Cascading Relationship
  • Power View
After completing this module, students will be able to:
  • Understand and utilize PowerPivot.
  • Understand and utilze Pivot Tables.
  • Understand and utilize Power View.

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Great instruction on AWS DevOps, even added more to the presentation for better understanding. The teacher was well informed and technically savvy to assist students on the fly through hiccups.

Awesome instructor with in-depth knowledge and the ability to present in a meaningful & understandable way. This course will provide a solid foundation within DataStage that can be used immediately. I highly recommend this course.

The presenter was knowledgeable and professional. The duration of the course, the pace and venue was suitable also

The exit certified aws course provided a good introduction to the tools available on aws.

Warm greeting and excellent help. The eating area is always clean and well stocked

0 options found

undo
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward