BISM Normalizer is a free and open-source tool to manage Microsoft Analysis Services tabular models


Download from VS Gallery

BISM Normalizer Comparison

Database compare

What is the Analysis Services equivalent to Schema Compare in SSDT? There is none. Correction: there is now! BISM Normalizer.

Code merging

Merge branched models. Manage production branches for bug fixes. Allow multiple developers to work on the same project (there is one .BIM file).

Easy deployment

Deploy bug fixes and partial releases. Other deployment methods are “all-or-nothing”, which are less flexible. Retain partitions to avoid reprocessing partitioned tables.

Source-control integration

Tabular projects in Visual Studio can act as source/target databases. This implies tight integration with source control/TFS

Reuse definitions

Reuse definitions between tabular models for alignment with common business definitions in an enterprise organization.

Self-service to corporate BI

Bridge the gap between self-service and corporate BI. Merge models migrated from Power Pivot into existing Analysis Services models.