Master the most powerful tool for data modeling and DAX calculations in Power BI and Analysis Services
Learn how to install and configure Tabular Editor
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
In this course, you will learn how to effectively use all the capabilities of the most powerful Power BI tool ever developed – Tabular Editor 3. TE3 replaces the nearly featureless native DAX editor with a state-of-the-art DAX Integrated Development Environment. Mastering the use of this tool will provide you a visual window into what your DAX measures measures are actually doing, as well as dramatically speeding your development process in a number of different ways.
What you get with the course
• Over 3 hours of intensive training videos
• Resource pack of dataset and data model for practical application
Testimonials
“I recently came across the Enterprise DNA while looking for Power BI and Data Analytics courses and I’ve been enjoying it since day one. I’m basically a beginner and having the opportunity to start this experience for free is very appealing. I am amazed at the amount of learning possibilities available through which I can improve my skills at a faster rate. Congratulations on this amazing project!” – Filipa Martins
“Enterprise DNA courses give you the confidence to learn an outstanding skill that you can use throughout your career. The time that you put into learning different techniques will only enhance your reporting capabilities but it will also provide in-depth view of your data that you could be missing.” – John Gibbons
“I am so happy I stumble across Enterprise DNA on the web, and I am yet to recover from my experience. Power BI, to me before was like a rocket science, with the introductory course on Power BI, all I want now is to go further in the
program.” – Albert
English
Language
Introduction
Resource Pack
Introduction
Pricing
Let’s fall in love with TE3
TE2 vs TE3
Setup
Installing Tabular Editor 3
Installing Tabular Editor 2
Sales Data Demo
Getting Started w/ TE3
Opening Tabular Editor
Panes in Tabular Editor
Changing themes
Workspaces
Moving tabs
Customizing toolbars
Raising issues
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 2
Security
Implementing OLS
Implementing RLS
Publishing to Web
Calculation Groups
Show measures selected in the slicer
Reducing measures
KPI
Creating KPI
BPA
BPA Rules Examples
BPA Part 2
Importing rules from a file
Importing rules from web
Fixing issues with generate fix
C# Scripting
C# scripts – getting started
Time Intelligence Measures
Time Intelligence Measures 2
Format DAX and disable default summarization
Saving macro
C# resources
Vertipaq Analyzer
Collecting information
Exporting details
The post Mastering Tabular Editor 3 in Power BI first appeared on StudyBullet.