Power BI Desktop is a fantastic tool for getting started with data modeling - but if you want to take the next step as a Power BI professional, you need to move beyond its limitations.

This full-day training will teach you how to use Tabular Editor 2 (free and open-source) as your primary development environment for Power BI semantic models. You’ll learn how separating metadata from data opens the door to advanced modeling patterns, productivity boosts, source control, and automation.

Through a series of demos and hands-on exercises, we’ll build a semantic model step by step, while introducing advanced concepts and best practices along the way.

Topics covered include:
• Why Tabular Editor? Benefits of metadata-driven development
• Productivity features: multi-select editing, scripting, Best Practice Analyzer
• Advanced modeling patterns: role-playing dimensions, many-to-many, calculation groups
• Perspectives and partitions for user-friendly and scalable models
• VertiPaq storage engine basics and optimization techniques
• Object-level security and governance considerations
• Deployment workflows and integration with source control/DevOps

By the end of the day, you’ll know:
• How to use Tabular Editor 2 for everyday development
• How to design higher-quality, more maintainable models
• How to integrate your modeling work into professional DevOps processes

This training is the perfect bridge for anyone who knows Power BI Desktop and wants to take the next step towards professional-grade semantic model development.

Take your semantic modeling skills beyond Power BI Desktop and learn how to build better, faster, and more maintainable models using the free and open-source Tabular Editor.