Platform Access

Tabular Editor 3: Beginner to Advanced

Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services

Enroll Now
course on how to use tabular editor in power bi

Here's What You'll Get

With The Course

3 hours of intensive training videos

Resource pack of dataset and data model for practical application

 Tabular Editor 3: Beginner to Advanced

Master the most powerful Power BI tool ever developed

  • TE3 provides a state-of-the-art Dax Integrated Development Environment in place of the nearly featureless native DAX editor.
  • Dramatically speed up your development process by mastering this tool.

Details Of What You Will Learn

During This Course

  • Learn - how to install and configure TE
  • Write - better DAX measures quickly and visualize them with DAX queries
  • Create - DAX calculations and KPIs
  • Enhance - the security of your DAX reports with RLS and OLS
  • Optimize - your reports with the integrated Best Practices Analyzer and Vertipaq Analyzer
  • Automate - DAX coding and formatting with scripting
Tabular Editor 3: Beginner to Advanced

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

This course is designed for those who have little to no knowledge of Tabular Editor 3 but are working in data-driven environment.

LEARN HOW TO

Utilize the key features within the Tabular Editor 3

 Tabular Editor 3: Beginner to Advanced
  • DAX coding and formatting with scripting
  • Learn how Install and configure TE
  • Mastering the use of DAX Integrated Development Environment
  • Enhance DAX reports with RLS and OLS security
  • Integrated Best Practices Analyzer and Vertipaq Analyzer
  • TE3 replaces the nearly featureless native DAX editor 

Course Curriculum

1. Resources

  • How to get certified for this course?
  • Tabular Editor 3 - Resource Pack

2. Introduction to the Course

  • Introduction
  • Pricing
  • Let's fall in love with TE3
  • TE2 vs TE3

3. Setup

  • Installing Tabular Editor 3
  • Installing Tabular Editor 2
  • Sales Data Demo

4. Getting Started w/ TE3

  • Opening Tabular Editor
  • Panes in Tabular Editor
  • Changing themes
  • Workspaces
  • Moving tabs
  • Customizing toolbars
  • Raising issues

5. DAX and Data Model

  • Preview Data
  • Diagram view
  • Creating measures
  • Unsupported features
  • Creating calculated columns
  • Create calculated tables
  • Deleting tables and columns
  • Creating relationships
  • Creating folders and sub folders
  • Moving measures and folders
  • Measure dependencies
  • Formatting DAX
  • Right click options
  • Querying with Tabular Editor
  • Scripting DAX Part 1
  • Scripting DAX Part

6. Security

  • Implementing OLS
  • Implementing RLS
  • Publishing to Web

7. Calculation Groups

  • Show measures selected in the slicer
  • Reducing measures

8. KPI

  • Creating KPI

9. BPA

  • BPA Rules Examples
  • BPA Part 2
  • Importing rules from a file
  • Importing rules from web
  • Fixing issues with generate fix

10. C# Scripting

  • C# scripts - getting started
  • Time Intelligence Measures
  • Time Intelligence Measures
  • Format DAX and disable default summarization
  • Format DAX
  • Saving macro
  • C# resources

11. Vertipaq Analyzer

  • Collecting information
  • Exporting details

What our Students Say

Your Instructor

Antriksh Sharma

  • 2+ years of experience in Power BI, Power Pivot, Power Query and SSAS
  • 2+ years of experience in DAX, optimizing DAX, and SQL language. Likes to read DAX blogs, articles, and books in free time.
  • Keen interest in Data Modelling, Data preparation, and Data clean-up using various tools.
  • 1+ years of experience in Core Python and approx. 6 months of experience in Pandas/NumPy/Matplotlib/Seaborn etc. Python libraries for Data Analytics.
  • Super User at Microsoft’s Power BI community platform with over 80 solutions, 50 PBI solutions at Enterprise DNA’s community, and approx. 30 PBI solutions on other platforms. Passionately believes in sharing everything he knows.
  • 4+ years of experience in excel automation through VBA, likes to read VBA blogs in free time.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA Membership Subscription.

  • Can I purchase a single course instead of the full Enterprise DNA membership? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full membership here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA Membership or CoE access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA Center of Excellence platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

membership enterprise dna

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace