Dimodelo Data Warehouse Studio for Azure Synapse

Quickly deliver a modern Data Warehouse on the Azure Synapse platform while avoiding the usual hassle, cost and drudgery. Respond to your most demanding users without compromising on design. Dimodelo Data Warehouse Studio is a dedicated Data Warehouse development tool that helps you easily capture your design and generate a best practice Data Warehouse architecture, utilizing Azure Data Lake, Polybase and Azure SQL Data Warehouse to deliver a high-performance, modern Data Warehouse in the Cloud.

Dimodelo Data Warehouse Studio for Azure Synapse Analytics


Dimodelo Data Warehouse Modeler

Dimodelo Data Warehouse Modeler is more than 7x faster at modelling and deploying data warehouse tables than an ordinary Visual Studio database project. 

  • Import Schema from Source Systems
  • Set management columns defaults.
  • Set storage defaults (Columnstore, Indexes, Schema etc)
  • One-click deployment

Dimodelo Data Warehouse Modeler


SSAS Documentation Generator

The SSAS document generator is a simple command line script that generates a Data Dictionary for an SSAS Cube. The Data Dictionary is output in HTML, with links between entities. You can modify the style of the HTML to suit your requirements.

lSSAS Documentation Generator

Automate build and deployment of SSAS Cubes using MSBUILD

This post describes how to use MSBUILD to automate the build and deployment of a SSAS Analysis Services Cube.

Automate build and deployment of SSAS Cubes using MSBUILD