AnalyticsCreator builds with metadata, Microsoft Fabric governs with metadata. This dual perspective is key for modern data teams. AnalyticsCreator ensures that data warehouses, data products, and analytical models are generated automatically from a metadata model. Microsoft Fabric, in turn, provides governance and oversight by cataloging workspace assets such as datasets, reports, and semantic models. These capabilities store every item in OneLake, surface ownership and sensitivity, and even capture subartifact metadata in Power BI semantic models.
Together, this means users can automate their path into Fabric while ensuring centralized governance and compliance. Metadata is no longer an afterthought—it is both the engine for automation and the backbone of governance.
For years, metadata was treated as documentation—useful for auditors and architects, but rarely central to how data systems were built. In modern data engineering, that perspective no longer holds. Metadata is the driver, not the byproduct. It powers automation, governance, and scalability across the Microsoft data stack, including Microsoft Fabric.
In traditional approaches, building pipelines, historization logics, and lineage documentation required manual coding. AnalyticsCreator immediately creates the first draft of the data warehouse when the source metadata is read. Users can then continue data modeling and refining using this metadata, which drives automation across multiple dimensions:
Pipeline generation: ELT pipelines can be created and versioned automatically, based on the source metadata definitions. This eliminates repetitive coding and ensures that new or changing sources can be integrated quickly.
Data historization: Consistency is ensured across all entities without rewriting logic. Metadata captures historization rules once, and AnalyticsCreator applies them uniformly across tables and domains, reducing errors and ensuring compliance.
Lineage and governance: Visualizations are derived directly from metadata, always up to date. Users get end-to-end transparency of data flows, making audits, troubleshooting, and impact analysis straightforward.
CI/CD alignment: Metadata definitions generate deployable artifacts for DevOps workflows. This allows seamless integration with Azure DevOps or GitHub pipelines, ensuring that metadata-driven changes are automatically versioned, tested, and deployed.
Fabric integration: Rather than rebuilding pipelines and semantic models in Fabric, users can reuse the metadata-defined logic from AnalyticsCreator. Fabric’ then catalogs these artifacts as workspace assets (dataset, report, models) with its scanenr APIs. This creates a clear and efficient flow: build automatically with AnalyticsCreator, govern with Fabric.
AnalyticsCreator treats traditional data marts as data products—domain-specific, governed, and ready for consumption. This approach shifts the focus from purely technical constructs to business-ready outputs that are easier to manage, govern, and deliver to stakeholders. Metadata makes this possible by ensuring every product is built consistently, traceable back to its sources, and adaptable to changes without fragile rewrites. Within Microsoft Fabric, this alignment means data products can be seamlessly consumed across Synapse, Power BI, and other Fabric-native services.
At the heart of AnalyticsCreator is a metadata model that defines the entire data warehouse lifecycle. From this model, the platform automatically generates:
SQL artifacts and ELT workflows.
Data Pipelines (ADF, SSIS).
Semantic models (Power BI, Tableau, Qlik).
Built-in Documentation and lineage diagrams.
With Fabric integration, AnalyticsCreator also ensures that metadata-driven definitions extend into OneLake and Fabric data products, providing a unified and governed layer across SQL-based and lakehouse architectures. This hybrid approach—automation powered by metadata, combined with engineer flexibility—means speed without compromising precision.
Metadata-driven automation transforms how data teams build, govern, and scale solutions. It’s not just a framework; it’s the foundation for data product engineering. With AnalyticsCreator and its integration into Microsoft Fabric, metadata becomes the engine behind automation, governance, and delivery—accelerating outcomes while ensuring consistency across both warehouse and lakehouse environments.