
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

SCIKIQ is one of the most innovative AI-native Data & Intelligence platforms for enterprises, built to make enterprise data AI-ready in weeks, not years.
Recognized by Forrester among leading AI-augmented data platforms, NASSCOM League of 10, YourStory Tech30, Inc42 and DataIQ, SCIKIQ is trusted by leading global enterprises across the USA, India, UK and UAE.
SCIKIQ brings Data Integration, Data Quality, Data Governance, Metadata Management, Data Lineage, Semantic Intelligence, Knowledge Graphs, Conversational Analytics, Generative AI, Data Products and AI Agents together in one unified platform. Unlike traditional data platforms that require enterprises to move or rebuild their technology stack, SCIKIQ works with what you already have. Connect SAP, Salesforce, Oracle, Snowflake, Databricks, AWS, Azure, GCP, data lakes, warehouses and enterprise applications through 200+ pre-built connectors, with no rip-and-replace.
What makes SCIKIQ different is Contextual Intelligence.
SCIKIQ doesn't just connect data; it helps AI understand its business meaning. Its semantic layer combines business terms, KPI definitions, metadata, lineage, ownership, rules, ontologies and relationships to create a trusted foundation for enterprise AI. Business users can talk to their data in natural language, investigate KPIs, discover root causes and generate insights without SQL. Data teams gain enterprise-grade governance, quality, lineage and control. AI teams get trusted, contextual data for building GenAI applications and intelligent AI agents.
Why enterprises choose SCIKIQ
AI-ready in 3–6 weeks | 167+ connectors | 99.9% availability | Multi-cloud | No-code | No vendor lock-in | No replatforming
Proven production deployments across Manufacturing retail, airlines, logistics, BFSI, Healthcare and others
Learn more
dbt
dbt is the leading analytics engineering platform for modern businesses. By combining the simplicity of SQL with the rigor of software development, dbt allows teams to:
- Build, test, and document reliable data pipelines
- Deploy transformations at scale with version control and CI/CD
- Ensure data quality and governance across the business
Trusted by thousands of companies worldwide, dbt Labs enables faster decision-making, reduces risk, and maximizes the value of your cloud data warehouse. If your organization depends on timely, accurate insights, dbt is the foundation for delivering them.
Learn more
erwin Data Marketplace
The erwin Data Marketplace, part of erwin Data Intelligence by Quest, serves as an intuitive platform for data consumers of all skill levels to discover, select, and obtain curated, high-quality datasets, data products, and AI solutions. This self-service approach enhances the data discovery process while promoting data literacy, ensuring governance, and increasing the overall business value that can be extracted from data. Key features include dynamic filtering tools, automated evaluations of data worth, user-generated feedback through ratings and reviews, and access to additional insights like mind maps and data lineage tracking. Users can easily compare various data assets side-by-side to identify the best fit for their individual needs. Data stewards and owners benefit from improved curation and governance tools, enabling them to create data products, manage relationships, categorize information, assign searchable tags, and oversee governance duties. Moreover, integrated workflows facilitate the processes of data access requests, approvals, and documentation, which are vital for compliance management. Consequently, this platform not only cultivates a collaborative atmosphere for data sharing but also enables organizations to harness their data assets effectively for strategic decision-making. With a commitment to continuous improvement, the marketplace is designed to adapt to the evolving needs of its users.
Learn more