Tools for DAX and Tabular Developers

This page contains descriptions and links to necessary tools and resources for DAX and Tabular developers.

DAX Studio

http://daxstudio.codeplex.com/
DAX Studio is a free tool for running DAX queries against Excel PowerPivot models or Analysis Services Tabular models. It includes an Object Browser, query editing and execution, formula and measure editing and syntax highlighting.

DAX Formatter

http://www.daxformatter.com/
DAX Formatter is a free service that transform your raw DAX formulas into clean, beautiful and readable code. The syntax rules used improves the readability of the expressions. More details on Rules for DAX Code Formatting.

DAX Editor

https://visualstudiogallery.msdn.microsoft.com/356e3b3a-ccaa-4331-aec5-a446d8eefeaf
DAX Editor is a Visual Studio extension that implements a language service for DAX language for SQL Server Analysis Services. You can edit the DAX measures of a project in a text file, format the code (optionally using the DAX Formatter service), and deploy changes to the original project and/or to a SSAS Tabular server.

DAX Patterns

http://www.daxpatterns.com/
DAX Patterns is a collection of ready-to-use data models and formulas in DAX. Each article describes one pattern in detail, including several use cases and sample files for both Excel 2010 and Excel 2013 (which you can easily import in a Visual Studio project for Analysis Services Tabular).

SSAS Tabular Translator

http://www.sqlbi.com/tools/vertipaq-analyzer/
Analysis Services 2016 and later versions have a feature to translate metadata in different languages. SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools for a Tabular model created in the new compatibility model (1200) for Analysis Services 2016.

VertiPaq Analyzer

http://www.sqlbi.com/tools/ssas-tabular-translator/
VertiPaq Analyzer provide internals information about memory used and compression rates of a model created in Analysis Services Tabular or Power BI.

BIDS Helper

http://bidshelper.codeplex.com/
BIDS Helper is a Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI). It provides several features for a Tabular project that would not be available otherwise in the Visual Studio user interface: Actions Editor, Display Folders, Translations Editor, and HideMemberIf property. It also contains other useful features such as Unused Columns Report and Sync Descriptions.

BISM Normalizer

http://bism-normalizer.com/
BISM Normalizer manages Analysis Services tabular models, comparing different versions and merging differences in a safe way. This tool is available in a 20-day trial version.

OLAP PivotTable Extensions

http://www.sqlbi.com/tools/power-pivot-utilities/
Power Pivot Utilities in an Excel add-in (based on a collection of VBA macros) that helps documenting PowerPivot models and facilitates the creation of pivot tables connected to the data model.

Power Pivot Utilities

http://www.microsoft.com/en-us/download/details.aspx?id=38793
The workbook size optimizer is a tool that inspects the composition of the data model within a Power Pivot workbook, providing suggestions to reduce memory and improve compression.

Workbook Size Optimizer

http://www.microsoft.com/en-us/download/details.aspx?id=38793
The workbook size optimizer is a tool that inspects the composition of the data model within a Power Pivot workbook, providing suggestions to reduce memory and improve compression.