Tabular Editor A lightweight editor for SSAS Tabular

Tabular Editor A lightweight editor for SSAS Tabular Models built in. NET / Win. Forms

About me. . . • Senior Business Analytics Architect @ www. kapacity. dk • SQL Server and MS BI fanatic • C#. NET developer • Author of Tabular Editor • https: //tabulareditor. github. io/ • Father of 2, husband of 1 • Glider pilot • Twitter: @DOtykier

Tabular Editor – Basic Features • Load/save models • View options / filtering • Edit properties • Drag and drop • Save changes / server-side validation • Create / delete objects • Undo / redo • Copy-pasta • Perspectives, translations and roles • Context menu • • Duplicate Batch rename Visibility / perspectives Show dependencies • (Limited) Power BI support

Tabular Editor – Advanced Features • • Compatibility Level 1400 features C# scripting • Column/Hierarchy reuse Custom Actions • Date Relationships Best Practice Analyzer • Object Level Security • Variations Deployment and TMSL scripting • M expressions (no Power Query UI ) Command Line Build and Deployment • Plug-in framework ”Save to folder”

Demo time!

Tabular Editor - Roadmap • Better UI for visualizing tables and relationships • Especially suited for large models (100+ tables) • Offline DAX syntax checking and data type inference • DAX Intelli. Sense • Better support for calculated tables • Better DAX dependency resolution and formula fix-up • Easier deployment/installation using official AMO lib from Nu. Get • Scripting using CSX (C# scripting concept)

Just like Jimi Hendrix … We love to get feedback Please complete the session feedback forms

SQLBits - It's all about the community. . . Please visit Community Corner, we are trying this year to get more people to learn about the SQL Community, equally if you would be happy to visit the community corner we’d really appreciate it.

Thank you!