V.2.7.1 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. V.1.9 VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. A complete description and short tutorial is available in the article.

V.2.6 Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server. V.1.08 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. V.2.0 DAX Editor is an extension to SSDT that makes it easier to edit DAX measures in a Microsoft Analysis Services Tabular project. V.4.0 ISM Normalizer is a free and open-source tool to manage Microsoft Analysis Services tabular models.

V.1.1.3 SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools for a Tabular model in compatibility version 1200 or later. SSAS Events Analyzer is a simple monitoring system that can be easily applied to any SSAS server with a minimal effort. V.1.1.0.0 SSAS Activity Monitor is an open source tool to monitor the current activity (sessions, transactions, connections, and locks) on an Analysis Services instance. It works for both Tabular and Multidimensional mode. V.0.4.15 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. V.1.0 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 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. V.1.0 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. V.1.0 Distinct is a partially blocking component that remove duplicates from one flow. V.1.0 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. V.0.6 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. V.1.1 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. Wireframesketcher License Key Generator there.

All cheat sheets, round-ups, quick reference cards, quick reference guides and quick reference sheets in one page. Download the latest from Windows, Windows Apps, Office, Xbox, Skype, Windows 10, Lumia phone, Edge & Internet Explorer, Dev Tools & more.