
AnalyticsCreator helps Microsoft data teams turn governed design into deployable data solutions without introducing a proprietary runtime layer.
Teams use AnalyticsCreator to define warehouse structures, transformation logic, historisation rules, relationships and dependencies in a central model. From that model, the application can generate native implementation assets for technologies such as SQL Server, SSIS, Azure Data Factory, Microsoft Fabric and Power BI.
The approach is designed for organisations that want to standardise how data warehouses and data products are engineered while keeping full control of the resulting code and project artefacts. Generated outputs can be integrated into existing Git, Azure DevOps and CI/CD workflows for versioning, review and controlled deployment across environments.
AnalyticsCreator supports dimensional, 3NF and hybrid modelling as well as common engineering patterns including delta loading, Slowly Changing Dimensions, snapshots and historisation. Documentation, lineage and dependency information are maintained alongside the project design, making it easier to assess the impact of proposed changes and keep implementation aligned with the underlying model.
The AnalyticsCreator Governed Control Model provides the foundation for this process by keeping business meaning, technical structures and implementation logic connected. Design Intelligence builds on that context by making governed project metadata, lineage, dependencies and design rules available to authorised AI tools and agents.
Typical use cases include modernising SQL Server and SSIS estates, building Microsoft Fabric solutions, standardising Power BI delivery and creating repeatable data warehouse and data product engineering processes.
Learn more

BigQuery serves as a serverless, multicloud data warehouse that simplifies the handling of diverse data types, allowing businesses to quickly extract significant insights. As an integral part of Google’s data cloud, it facilitates seamless data integration, cost-effective and secure scaling of analytics capabilities, and features built-in business intelligence for disseminating comprehensive data insights. With an easy-to-use SQL interface, it also supports the training and deployment of machine learning models, promoting data-driven decision-making throughout organizations. Its strong performance capabilities ensure that enterprises can manage escalating data volumes with ease, adapting to the demands of expanding businesses.
Furthermore, Gemini within BigQuery introduces AI-driven tools that bolster collaboration and enhance productivity, offering features like code recommendations, visual data preparation, and smart suggestions designed to boost efficiency and reduce expenses. The platform provides a unified environment that includes SQL, a notebook, and a natural language-based canvas interface, making it accessible to data professionals across various skill sets. This integrated workspace not only streamlines the entire analytics process but also empowers teams to accelerate their workflows and improve overall effectiveness. Consequently, organizations can leverage these advanced tools to stay competitive in an ever-evolving data landscape.
Learn more
Astera Data Warehouse Builder
Astera Data Warehouse Builder is a next-generation AI platform that transforms how organizations build and manage data warehouses. It enables teams to design data models, automate ETL and ELT pipelines, and deploy production-ready warehouses using simple conversational prompts. The platform leverages agentic AI to handle data consolidation, modeling, and orchestration end to end. Astera supports integration with hundreds of data sources, including databases, files, cloud applications, and legacy systems. Advanced automation enables self-driving warehouse maintenance, monitoring, and optimization with minimal human intervention. The solution supports modern data architectures, Data Vault modeling, and seamless migration from legacy systems. Metadata-driven development ensures governance, lineage, and auditability across all processes. Astera significantly reduces warehouse build time, lowers total cost of ownership, and minimizes ongoing maintenance. Users can deploy on-premises or in the cloud depending on business needs. The platform is designed to scale with enterprise data volumes and complexity. With no coding required, Astera empowers both technical and non-technical teams to deliver analytics-ready data faster. Overall, Astera Data Warehouse Builder makes AI-driven data warehousing practical, efficient, and reliable.
Learn more
IRI RowGen
IRI RowGen creates billions of safe and intelligent rows of test data tailored for various targets such as databases, flat files, and formatted reports by leveraging metadata instead of actual data. This powerful tool synthesizes and fills databases with accurate relational test data that mirrors the characteristics of your production data. By utilizing existing metadata or generating it dynamically, RowGen can either randomly create structurally and referentially accurate test data or select it from real datasets. Moreover, it offers the flexibility to customize data formats, volumes, ranges, distributions, and additional properties either on the fly or through reusable rules, which aids in achieving key objectives like application testing and subsetting. Powered by the IRI CoSort engine, RowGen ensures the fastest generation, transformation, and bulk loading of large test datasets available in the market. Developed by experts in data modeling, integration, and processing, RowGen is designed to efficiently produce compliant test sets in both production-ready and customized formats. With RowGen, you can easily generate and provision synthetic test data that is safe and intelligent for various purposes, including DevOps, database validations, data visualizations, and data warehousing prototypes, all without needing access to production data. This capability not only enhances testing efficiency but also significantly reduces the risks associated with using sensitive production data.
Learn more