Learn DAX in Toronto!

Our 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.

MDX Studio


MDX Studio is a tool that has been developed by Mosha Pasumansky, a former developer of Analysis Services.

This is an invaluable tool to write a MDX query: you have a code formatting feature, an embedded system to analyze query performance and many other features for writing MDX queries.

DAX Studio


DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.

It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing and query execution breakdowns.



DtsToSsis-Prepare is a command line tool that prepares a DTS package for a better migration to an SSIS package.

This article describes the needs for this tool and how to use it.

The project is freeware, full source code is available.


Beta 1

MirrorManager is a tool that implements the Mirror phase of the SQLBI Methodology in a semi-automated way. It handles partitioning and aging of imported data.

Visio Forward Engineer

Visio Forward Engineer is an Office 2010 add in that provides Visio the ability to script the database creation of a data model. Even if it contains several limitations, it helps Office Visio users to create simple data models using the Visio interface without the need to install the older 2003 Enterprise Architect version.



SqlBiDtExec is a tool that makes it easy to launch SSIS packages on a remote server, using WCF as the transport media to both request package execution and fetch all the logs and events from the package in order to use them at the client side.


FlowSync is a component that will make two or more flows of data in an SSIS data flow package run at the same speed, by stopping one flow if the others run too slow.

The project is freeware, full source code is available.


TableDifference is an SSIS custom component designed to simplify the management of slowly changing dimensions and – in general – to check the differences between two tables or data flow with SSIS.



Distinct is a partially blocking component that remove duplicates from one flow.



MdxScriptUpdater is a simple C# class that simplifies updating MDX Scripts into a cube in a production environment. MdxScriptUpdater is provided in form of a sample source code as is.

DateTool Dimension


DateTool is a special dimension containing regular members that act as calculated members similar to those generated by Time Intelligence Wizard, without some of the limitations of the Time Intelligence Wizard.



SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.