• No products in the cart.

A tabular data model is used for accessing your date intuitively especially if you want to organize large volumes of data. You will learn how Analysis Services work to be able to develop a tabular model.


You are provided in this [course_title] with lessons to import tables of data from different sources to maximize your access. This will help you enhance your model with business logic to ensure that you will succeed in the industry you are part of.


This course does not involve any written exams. Students need to answer 5 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work.


Edukite courses are free to study. To successfully complete a course you must submit all the assignment of the course as part of the assessment. Upon successful completion of a course, you can choose to make your achievement formal by obtaining your Certificate at a cost of £49.

Having an Official Edukite Certification is a great way to celebrate and share your success. You can:

  • Add the certificate to your CV or resume and brighten up your career
  • Show it to prove your success

Course Credit: Microsoft

Course Curriculum

Introducing Analysis Services
Lesson Introduction 00:01:00
Introducing Data Models 00:05:00
Demo: Exploring a Tabular Model 00:03:00
Introducing Analysis Services 00:06:00
Goals of Analysis Services 00:03:00
Developing and Managing Tabular Databases 00:02:00
Reporting with Microsoft Reporting Tools 00:02:00
Lesson Introduction 00:01:00
Delivering Tabular Model Solutions 00:02:00
Preparing Supporting Database Schemas 00:01:00
Demo: Introducing the Finance Schema 00:03:00
Creating Tabular Projects 00:02:00
Demo: Creating a Tabular Project 00:07:00
Review 00:01:00
Lesson Introduction 00:01:00
Importing Data 00:07:00
Demo: Importing Data 00:12:00
Creating Relationships 00:06:00
Demo: Creating Relationships 00:03:00
Review 00:01:00
Lab 1 Introduction 00:01:00
Lab 2 Introduction 00:01:00
Designing Tabular Models
Lesson Introduction 00:01:00
Configuring Table and Column Properties 00:10:00
Demo: Configuring Table and Column Properties 00:07:00
Defining Date Tables 00:02:00
Demo: Defining a Date Table 00:03:00
Creating Hierarchies 00:02:00
Demo: Creating Hierarchies 00:04:00
Creating Perspectives 00:01:00
Demo: Creating Perspectives 00:02:00
Creating Translations 00:02:00
Demo: Creating Translations 00:03:00
Review 00:01:00
Lesson Introduction 00:01:00
Introducing DAX 00:09:00
Creating Calculated Columns 00:01:00
Demo: Creating Calculated Columns 00:06:00
Creating Calculated Tables 00:02:00
Creating Measures 00:02:00
Demo: Creating Measures 00:13:00
Creating KPIs 00:02:00
Demo: Creating a KPI 00:04:00
Review 00:01:00
Lab 3 Introduction 00:01:00
Managing Tabular Models
Lesson Introduction 00:01:00
Scripting Administrative Tasks 00:01:00
Demo: Generating a Script 00:01:00
Configuring Partitions 00:02:00
Demo: Configuring Partitions 00:03:00
Configuring Processing 00:05:00
Demo: Configuring Processing 00:07:00
Configuring Permissions 00:03:00
Demo: Configuring Permissions 00:06:00
Deploying Tabular Databases 00:02:00
Demo: Deploying Tabular Databases 00:03:00
Managing Tabular Databases 00:03:00
Demo: Programmatically Working with SSAS 00:03:00
Review 00:26:00
Delivering Secure Data to PowerBI 00:04:00
Describing DirectQuery Mode 00:01:00
Use Cases for DirectQuery Mode 00:01:00
Creating Models with DirectQuery Mode 00:02:00
Demo: Working With DirectQuery Mode 00:06:00
Review 00:01:00
Lab 4 Introduction 00:01:00
Making Architectural Decisions
Lesson Introduction 00:01:00
Introducing Azure Analysis Services 00:01:00
Deploying Tabular Models to Azure 00:03:00
Demo: Deploying to Azure Analysis Services 00:05:00
Lesson Introduction 00:01:00
Selecting the Right Model Type 00:11:00
Comparing Supported SSAS Editions 00:01:00
Review 00:01:00
Lesson Introduction 00:01:00
Registering SSAS with Azure Data Catalog 00:11:00
Review 00:03:00
Submit Your Assignment 00:00:00
Certification 00:00:00

Course Reviews


9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

©2021 Edukite. All Rights Resereved
Edukite is A Part Of Ebrahim College, Charity Commission
Reg No 110841