There is a lot of talk about how as a professional Power BI developer, you should use Tabular Editor. Yet when you open it, it’s daunting. Where do you start, what do these buttons do, how long is it going to take for me to learn this, is it really worth it?

In this session, we will run through the core components of Tabular Editor in normal non programming language. We look at how you can utilise this software to save you time in working with Power BI.

Session Objectives:

- Understand the Tabular Editor 3 interface and its various elements
- Learn how to use Tabular Editor 3 to create and manage Tabular models
- Learn how to use key features of Tabular Editor 3, including the formula bar, expression editor, and DAX functions
- Understand how Tabular Editor 3 can be integrated with Microsoft Analysis Services and Power BI.

Session Plan:

Introduction:

- Brief overview of the session
- Introduce Tabular Editor 3 and its key features and functionalities

Tabular Editor 3 Interface:

- Demonstrate the Tabular Editor 3 interface and its various elements, including the tree view, formula bar, property grid, and expression editor
- Explain how to use the interface to create and manage Tabular models

Creating and Managing Tabular Models:

- Demonstrate how to create a new Tabular model using Tabular Editor 3
- Explain how to add tables, columns, and relationships to the model
- Discuss best practices for organizing and managing models

Using Key Features of Tabular Editor 3:

- Demonstrate how to use the formula bar and expression editor to create and edit DAX expressions
- Explain how to use key DAX functions, such as CALCULATE, SUMX, and AVERAGE
- Discuss other key features, such as the script editor, perspectives, and translations

Integration with Analysis Services and Power BI:

- Explain how Tabular Editor 3 can be integrated with Microsoft Analysis Services and Power BI
- Discuss the benefits of using Tabular Editor 3 with Analysis Services and Power BI
- Demonstrate how to use Tabular Editor 3 to deploy and manage Tabular models in Analysis Services and Power BI

Conclusion:

- Recap key points covered in the session
- Provide resources for further learning and exploration, such as documentation and online communities.

(50 mins)