
Model First. Then Generate.
AnalyticsCreator is a metadata-driven design application for data warehouse automation and data product engineering across the Microsoft data stack.
Develop business, logical, physical and semantic models using intelligent wizards. The corresponding implementation code evolves with the model and remains visible during development. From this governed design, AnalyticsCreator generates native Microsoft artefacts for the selected target environment.
Model-driven data engineering
- Data modelling: Dimensional, normalised, layered and hybrid warehouse architectures, supported by intelligent modelling wizards.
- Source metadata: Define and maintain supported source connections, structures, relationships and mappings.
- Transformations: Develop transformation logic, data preparation, calculated fields and processing dependencies.
- Historisation: Configure slowly changing dimensions, snapshots and historical data processing.
- Semantic modelling: Maintain supported facts, dimensions, relationships, hierarchies and measures alongside the underlying warehouse design.
Native Microsoft code generation
AnalyticsCreator generates implementation artefacts for supported Microsoft technologies, including:
- SQL Server and Azure SQL: Database structures, views, stored procedures and processing logic.
- Microsoft Fabric: Warehouse structures, SQL processing and supported Fabric Data Factory pipelines.
- Azure Data Factory and SSIS: Generated data ingestion, transformation and orchestration packages.
- Power BI: Semantic-model definitions, including supported PBIP and TMDL output.
- SQL Server Analysis Services: Supported Tabular and Multidimensional models.
- Deployment: DACPAC packages and other supported deployment artefacts.
The specific outputs depend on the selected technology, architecture and project configuration.
Governance, lineage and change control
AnalyticsCreator maintains connections between source metadata, data structures, transformations, dependencies and analytical definitions.
Teams can inspect recorded dependencies, review the impact of source or model changes, generate documentation and incorporate supported project artefacts into version-controlled development workflows.
Data warehouse testing
AnalyticsCreator supports repeatable data warehouse tests using defined input data and expected results.
Developers can generate SQL test procedures, compare actual warehouse output with expected values, investigate differences and review execution logs. Test procedures can also be executed within configured SQL-based testing workflows.
Design Intelligence and AI-ready project context
AnalyticsCreator Design Intelligence extends the model-driven approach by making supported saved-project context available to authorised MCP-compatible AI agents.
This can provide access to recorded model definitions, relationships, lineage and transformation context. Available coverage depends on the project and implementation, and proposed changes remain subject to review and authorisation.
Design in AnalyticsCreator. Execute in Microsoft technology.
AnalyticsCreator is a design-time application, not a proprietary data-processing runtime.
Generated implementations operate in their supported Microsoft environments without requiring AnalyticsCreator to run in production.
Source connectivity, generated implementation targets and downstream reporting applications have different support requirements.
For technology-specific capabilities, prerequisites and limitations, see the Platform Support documentation.
Resources for developer - Function & Feature list
For access to this area we ask you to register only with your e-mail address.
We will only ask this once.
If you delete your cookies you must enter your e-mail address again
Link
Youtube
On the AnalyticsCreator YouTube channel you will find recordings of our online events, virtual classrooms and tutorials. These are organized by different source systems, technologies and frontends. These can be used for learning purposes.
Docs
The AnalyticsCreator Wiki available on Microsoft DevOps provides detailed step-by-step instructions on how to use AnalyticsCreator.
GitHub Source
On GitHub, source code examples for specific use cases have been provided by partners. Here you can see only the public area.