Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Data Visualisation & Modelling

Next Step Power BI Tabular model development

Description

Today most people use Power BI Desktop to develop datasets. While Power BI Desktop is a great tool for the citizen developer it also has limitations. If you want to take your development skills to the next level, you should consider using Tabular Editor (free or paid version) to develop your data models.

Tabular Editor is a tool for developing tabular data models (Power BI or Analysis Services). It allows the developer to be more productive by separating the model metadata and the actual data. This allows for scripting, multiselect editing and best practice analyzing. Since you are only working with metadata it allows for easier integration with source control and DevOps.

This training day will help you transition from Power BI Desktop to Tabular Editor. You will be much more productive and will (optionally) be able to integrate data model development into DevOps processes. We will start by developing a simple data model and gradually introduce advanced data modelling techniques in Tabular Editor.

In this training the following topics will be covered:
• Benefits of Tabular Editor
• Role playing dimensions
• Multiple fact tables at different granularity
• Many-to-many relationships
• Perspectives and partitions
• Best practice analyzer
• Advanced scripting
• VertiPaq storage engine
• Deployment and DevOps
• Object level security
• Calculation Groups

At the end of this training day the attendee will come away with the following knowledge:
• Why use Tabular Editor
• How to use Tabular Editor to develop tabular models
• How to further the quality of tabular models

Learning Objectives

At the end of this training day the attendee will come away with the following knowledge:
• Why use Tabular Editor
• How to use Tabular Editor to develop tabular models
• How to further the quality of tabular models

Previous Experience

The delegates should have a basic understanding of tabular models (in Power BI or Analysis Services). They need to understand how to develop a tabular model using Power BI Desktop. To get the most out of the session the attendee should have access to Power BI Premium/Premium Per User workspace. If the attendee does not have that we will provide a Premium Per User workspace from our training tenant

Tech Covered

Azure, Power BI, deployment, Modern Analytics, Modelling, Optimising, Data Visualisation & Modelling, DataOps & Automation