Downloads

HomeDownloads

Tool downloads that help development of DAX as well as Power Pivot and Tabular data models!

We will attempt to consolidate all of the best, most useful tool downloads we and others have utilized when developing.  There are some great tools out there and I am sure there are more coming with time.

If there are any downloads that you feel as though we missed, let us know and we can add it.  We will have articles coming for each of these tools to include a quick overview of the features and functionality of each.  Check back often or subscribe so you don’t miss out!

daxstudio

DAX Studio

A tool for running DAX queries against Excel PowerPivot models or Analysis Services Tabular models. It is an Excel add-in or a standalone tool for Power Pivot and Tabular models that provides an object browser, editor, and execution environment for DAX queries

Link

 

visual-studio

DAX Editor

A Visual Studio extension that simplifies editing of DAX measures in a Tabular project.

Link

 

excel

OLAP PivotTable Extensions

An Excel add-in that incorporates extra functionality into pivot tables connected to Analysis Services data sources including the ability to capture the MDX generated by the pivot table.

Link

 

ntcore

NTCore 4GB Patch

This very little tool patches x86 executables in order to let them have 4GB (instead of only 2) of virtual memory on x64 platforms. Use this to increase the amount of memory your 32 bit Excel can handle for Power Pivot modeling. **DISCLAIMER:  Use at your own risk.  We have seen successful use of this but third party utilities is risky and can cause issues with other addins.

Link

 

Tabular Editor

Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server.

Link

bids-helper

BIDS Helper

An amazing tool that extends the functionality of an SSAS tabular data model. A Visual Studio add-in that improves productivity when editing Tabular models. It provides access to several features implemented in the Tabular engine but not available in the Visual Studio user interface (for example, drillthrough, translations, display folders, and editing of HideMemberIf property)

Link
 

 

bism-normalizer

BISM Normalizer

A Visual Studio extension that helps when comparing two Tabular databases, enabling the creation of scripts with changes/migrations between two versions.

Link

 

Workbook Size Optimizer

Workbook Size Optimizer

The workbook size optimizer inspects the composition of the data model within your Power Pivot or Power View enabled workbook, sees if the data in it can take less space and if possible, enables better compression.

Link

 

Power BI Helper

Power BI Helper

An awesome tool that parses your Power BI data model to find fields and tables that are utilized.  This allows you to clean up your model by removing unused tables/columns to reduce the model size and improve performance.

Link

 

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.

Link

 

Vertipaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular.

Link