Microtek Learning Logo

55163: Preparing Your Data for Power BI Training

4.8
(4.8)

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

  • Accredited By :
  • Category : Power BI

Course Price : $1150 Per Participant

Course Description

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

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

 

Training Exclusives

  • Live instructor-led interactive sessions with Microsoft Certified Trainers (MCT).
  • Access to Microsoft Official Courseware (MOC).
  • Real-time Virtual Lab Environment.
  • Experience 24*7 Learner Support.
  • Self-paced learning and flexible schedules.
Microsoft Course Microsoft Course
100+

Microsoft Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

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

Prerequisites

  • Working knowledge of SQL Server

Who should attend this course?

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

Microsoft Certified Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

  • Sep 21, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Oct 05, 2023
  • 9:00 am - 5:00 pm EST
  • online
GTR
  • Oct 19, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Nov 02, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Nov 23, 2023
  • 9:00 am - 5:00 pm EST
  • online
  • Dec 07, 2023
  • 9:00 am - 5:00 pm EST
  • online

Can’t Find The Batch You’re Looking For?

Request a Batch

Curriculum

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.
  • With Microtek Learning, you’ll receive:

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

    Call Us For Professional, Flexible and Cost-Effective Courses

    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 We Are Best To Choose?

    Best Price Guarantee Best Price Guarantee

    Best Price Guarantee

    We guarantee that you'll find the lowest price and better offers here than in the marketplace.

    Guaranteed to Run Guaranteed to Run

    Guaranteed to Run

    All our courses are assured to proceed on mentioned dates by the delivery methods, i.e., classroom, virtual and e-learning.

    Professional Team Support Professional Team Support

    Professional Team Support

    We have a program expert counselling team to give you round-the-clock prompt support with the best offers as we value your time and money.

    Experienced Trainers Experienced Trainers

    Experienced Trainers

    We have a team of Certified Expert Trainers with 5 to 15 years of Real Industry Experience.

    100% Satisfaction Guarantee 100% Satisfaction Guarantee

    100% Satisfaction Guarantee

    We believe in our courses and our instructor's skill; that's why we guarantee 100% Satisfaction to our customers.

    Real-World Experience Real-World Experience

    Real-World Experience

    Our training modules are based on current industry standards live industry projects, and we follow the authorized curriculum given to us by our training partner.

    Best Price Guarantee Best Price Guarantee

    Best Price Guarantee

    We guarantee that you'll find the lowest price and better offers here than in the marketplace.

    Guaranteed to Run Guaranteed to Run

    Guaranteed to Run

    All our courses are assured to proceed on mentioned dates by the delivery methods, i.e., classroom, virtual and e-learning.

    Professional Team Support Professional Team Support

    Professional Team Support

    We have a program expert counselling team to give you round-the-clock prompt support with the best offers as we value your time and money.

    Experienced Trainers Experienced Trainers

    Experienced Trainers

    We have a team of Certified Expert Trainers with 5 to 15 years of Real Industry Experience.

    Course Details

    • enroll enroll-green
      Enrolled: 1212
    • duration duration green
      Duration: 2 Days

    Mode Of Training

    training

    Classroom

    training

    Online
    Instructor-led

    training

    Online
    Self-Paced

    training

    Onsite

    Talk to Learning Advisor