Mastering Tabular Editor 3

Tabular Editor 3 is the productivity tool every DAX, Power BI and Power Pivot developer should be using

4.85 (66 reviews)
Udemy
platform
English
language
Other
category
instructor
363
students
4 hours
content
Feb 2022
last update
$44.99
regular price

What you will learn

The New Visual Studio Like Experience

The DAX Editor (Such an improvement over the Power BI editor)

Best Practices Analyzer

Data Preview and Pivot Grids

Scripting

Diagrams

Calculation Groups

Description

Tabular Editor is an editor alternative to SSDT or Power BI for authoring Tabular models for Analysis Services, with or without an Analysis Server server running.

Tabular Editor 2 is an open source project that can edit a BIM file without accessing any data. This offline capability makes any change very quick when applying the change to the BIM file, especially when you manipulate and manage measures, calculated columns, display folders, perspectives and translations.

Tabular Editor 3 is a wonderful evolution of the popular community tool that is Tabular Editor 2. It is very lightweight, fast, intuitive and already in use by thousands of BI professionals worldwide.  It includes premium features not found in Tabular Editor 2 that will make your life as a Tabular Model author even better! It has a Visual Studio like IDE, theming (dark mode!!), high-DPI and multi-monitor support, full and sophisticated auto completion, formatting, data preview, pivot grids, refactoring and a superb DAX editor, and so much more. You will never want to write DAX using any other editor ever again.

When Tabular Editor 3 is connected to Analysis Services or the XMLA endpoint of Power BI Premium, you will also be able to work with the data in your model. You can also initiate and monitor data refresh operations from within Tabular Editor. Testing and verifying that your model works the way you want it to has never been easier or more efficient.

Tabular Editor supports the compatibility level 1200 or newer (JSON format), including the 1500 required by calculation groups.

Content

Introduction

Introduction
Why Use Tabular Editor?
Tabular Editor Version 2 vs. Version 3
Pricing
Tabular Models
The Tabular Object Model (TOM)

Working with Tabular Editor

The Contoso Database Used in this Course
Overview
Setting Some Important Preferences
Configurability
DAX Editor - Part 1
DAX Editor - Part 2
DAX Editor - Part 3
Table Preview and Pivot Grid
Executing DAX Queries
Diagram View
Scripting
Calculation Groups
Best Practices Analyzer
Vertipaq Analyzer

Miscellaneous Items

Scripting Multiple Measures at the Same Time
Formatting Values
Searching
Source Control with Tabular Editor (Sort of)

New Versions

v3.0.5 (9-June, 2021)

Time for Some Practice

Practice #1
Practice #2
Practice #3
Practice #4
Practice #5
Practice #6
Practice #7
Practice #8

Screenshots

Mastering Tabular Editor 3 - Screenshot_01Mastering Tabular Editor 3 - Screenshot_02Mastering Tabular Editor 3 - Screenshot_03Mastering Tabular Editor 3 - Screenshot_04

Reviews

Roger
August 17, 2022
Excellent tutorial, was hoping for some more in depth examples with the dax debugger and the same for creating measure with multiple VAR when testing them on the fly regards Roger
Riaan
June 17, 2022
Needs some updating. I'm on version 3.3.0. Recurring issue of Expression Editor window has been resolved.
J.W.
June 4, 2022
There doesn't seem to be much content so far, just setting up TE3, options, and several sections repeat statements made earlier.
Jonas
December 29, 2021
Thanks for this course. Randy take you through TE3 in a walkthroughpath and talks abut it! Thank you Randy!
William
July 8, 2021
Randy does a great job overviewing and demonstrating key concepts which I can use in my day to day work as a developer. Course was just the right length and revealed many subtle features that could be easily missed.

Charts

Price

Mastering Tabular Editor 3 - Price chart

Rating

Mastering Tabular Editor 3 - Ratings chart

Enrollment distribution

Mastering Tabular Editor 3 - Distribution chart

Related Topics

4106636
udemy ID
6/7/2021
course created date
6/14/2021
course indexed date
Bot
course submited by