Power BI
$1150
Per Participant
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.
The course is created for business intelligence developers, analysts and SQL professionals.
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
This module explains how the class will be structured and introduces course materials and additional administrative information.
Lab: Course Overview
After completing this module, students will be able to:
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.
Lab: What is the Tabular Model?
After completing this module, students will be able to:
In this module, we cover the specifics of creating projects, discuss options to either import or load data, and explore deployment.
Lab: Working in Tabular
After completing this module, students will be able to:
In this module, we will explore data sources, the credentials needed to access them, and cover a few of the most common sources available.
Lab: Understanding Loading Data From Different Sources
After completing this module, students will be able to:
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.
Lab: Using DAX and MDX
After completing this module, students will be able to:
In this module, we will discuss data modeling basics and explore how to utilize these concepts effectively.
Lab: Building Data Models
After completing this module, students will be able to:
In this module, we will discuss utilizing DAX with PowerPivot, pivot tables, and Power View.
Lab: Excel PowerPivot and Tabular
After completing this module, students will be able to:
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
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.
Texas
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.
MARTIN
TORONTO, CANADA