Tabular Editor 3 for Power BI & SQL Server Analysis Services

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Chapter 2: Configuring Working Environment

Lecture 1: Downloads

Lecture 2: Tabular Editor 3

Lecture 3: Update on Developer Account

Lecture 4: Power BI Service Developer Account

Lecture 5: SQL Server & Analysis Services

Lecture 6: Visual Studio, C# and SSAS Extension

Lecture 7: Creating our First Power BI & SSAS Model

Lecture 8: Data Gateway

Lecture 9: Premium Workspace

Lecture 10: Connecting TE to different Tabular Models

Chapter 3: Tabular Editor Introduction

Lecture 1: TE 3 UI Intro & Setup

Lecture 2: Understanding TOM – Tabular Object Model

Lecture 3: Understanding TE vs Non TE approach

Lecture 4: Serializing Model for CI/CD and DevOps

Lecture 5: TE3 version 3.8.0

Chapter 4: Developing Data Model

Lecture 1: Sneak Peak of the underlying data

Lecture 2: Relationships

Lecture 3: Diagrams

Lecture 4: Measures

Lecture 5: Detail Rows Expression

Lecture 6: Unsupported Modeling Features

Lecture 7: Refresh Tables

Lecture 8: Import Tables

Lecture 9: Using Tabular Model Scripting Language

Lecture 10: Write vs Read mode

Lecture 11: Calculated Columns

Lecture 12: Calculated Tables

Lecture 13: Calculated Tables & Columns Script

Lecture 14: Object Dependencies, Mark as Date, and Update Table Schema

Lecture 15: User Hierarchies

Lecture 16: Modify PBI Service Connection String & Parameters

Lecture 17: Perspectives

Lecture 18: Keep Unique Rows, Key, Group By Properties

Lecture 19: Key Performance Indicators aka KPI

Chapter 5: Querying, Visualizing and Debugging

Lecture 1: EVALUATE, DEFINE & MEASURE

Lecture 2: COLUMN & TABLE

Lecture 3: Import Tables w DAX Queries

Chapter 6: Securing Data Model with Roles

Lecture 1: Model Access & Security – SSAS

Lecture 2: Server or Database Administrator with None Permission

Lecture 3: Model Access & Security – Power BI Service

Lecture 4: Object Level Security

Lecture 5: Static Row Level Security

Lecture 6: Dynamic Row Level Security

Chapter 7: Calculation Groups

Lecture 1: Measure Selector

Lecture 2: Time Intelligence Variations

Lecture 3: Categorize Fields & Trendy vs Others

Lecture 4: Switch Relationships

Chapter 8: C# Scripts

Lecture 1: Output, Selected, Select, and Recording Macros

Lecture 2: Data Types & Variables & a small application

Lecture 3: Importing Libraries and using InputBox and MessageBox

Lecture 4: Referencing objects

Lecture 5: LINQ

Lecture 6: Accessing Data Model with Visual Studio

Lecture 7: Create Methods that Print Tables, Columns, and Measures

Lecture 8: Create Functions that returns different objects

Lecture 9: Add New Measures & Calculated Columns

Lecture 10: Refresh Model Objects

Lecture 11: EvaluateDax & Export to CSV

Lecture 12: Hide Columns used in Relationships

Lecture 13: Create Variations of Selected Measures

Lecture 14: Create Measures from Selected Columns & based on Data Types

Lecture 15: Format DAX & Disable default summarization

Chapter 9: Vertipaq Analyzer

Lecture 1: Summary

Lecture 2: Tables

Lecture 3: Attribute Hierarchy – IsAvailableInMDX

Lecture 4: Calculated Columns vs M/SQL Columns

Lecture 5: Relationships Pane

Lecture 6: Incremental Refresh Partitions

Lecture 7: SSAS Tabular Partitions

Lecture 8: Optimizing Data Model

Chapter 10: Final Thoughts

Lecture 1: Thank you!