55163: Preparing Your Data for Power BI Training


Power BI



Course Description

The course introduces Learners to SQL BISM (Business Intelligence Semantic Model) Tabular model, DAX and data modelling.

This training is designed based on the objectives of the course variant 55163A.

Who should attend this course?

The course is created for business intelligence developers, analysts and SQL professionals.


Oct 28, 2021
9:00 am - 5:30 pm EST
Request Batch

What you will learn

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

With Microtek Learning, you’ll receive:

  • Certified Instructor-led training
  • Industry Best Trainers
  • Official Training Course Student Handbook
  • Pre and Post assessments/evaluations
  • Collaboration with classmates (not available for a self-paced course)
  • Real-world knowledge activities and scenarios
  • Exam scheduling support*
  • Learn and earn program*
  • Practice Tests
  • Knowledge acquisition and exam-oriented
  • Interactive online course.
  • Support from an approved expert
  • For Government and Private pricing*
Request Call

Our Clients

For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.

  • 300+ enterprise clients
  • 100,000+ professionals trained
  • Service 70 of the Fortune 100
  • 96% of our clients would recommend us
our clients

Our Awards

our awards
why choose us


This module explains how the class will be structured and introduces course materials and additional administrative information.

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

    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.
  • 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 we’ll dive deeper into the tabular model as that is the focus for this course.

  • Analysis Services Installation and Architecture: One Product, Two Models
  • Version Changes: SQL Server Analysis Services
  • Important Terms
  • SQL Server Data Tools for Tabular
  • Lab: 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.
  • In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.

  • Projects
  • Importing
  • Loading Data
  • Examining Views
  • Deployment
  • Lab: Working in Tabular

  • Creating a Tabular Project
  • 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.
  • In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.

  • 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: Understanding Loading Data From Different Sources

    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.
  • 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 we’ll cover DAX and walk-through how to use this powerful language.

  • Querying with MDX
  • Basic DAX Syntax
  • Evaluation Context
  • Calculate Function
  • Time Intelligence
  • Lab: 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.
  • In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.

  • Importing Related Tables
  • Creating Relationships
  • Hierarchies
  • Direct Query
  • KPIs
  • Drillthrough
  • Perspectives
  • Lab: Building Data Models

  • Creating Relationships
  • Hierarchies
  • After completing this module, students will be able to:

  • 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.
  • In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.

  • Working with PowerPivot
  • Working with Pivot Tables
  • Working with PowerView
  • Lab: 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.


    I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.



    • (5)

    I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.

    Prince N.


    • (5)

    I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.

    Marsh George


    • (5)
    Accredited By

    Course Details

    • Start Date: Oct 28, 2021
    • Duration: 2 Days
    • Enrolled: 1212
    • Price: $1150
    side post

    Talk to Learning Advisor

    Get In Touch

    * I authorize Microtek Learning to contact me via Phone/Email