
AnalyticsCreator is a metadata-driven design application for data warehouse automation and data product engineering across the Microsoft data stack.
Its Governed Control Model connects business meaning, data structures, transformation rules, dependencies, lineage and technical implementation in one controlled project model. Data teams design the required architecture in AnalyticsCreator, then generate native Microsoft assets from that design.
Generated outputs can include SQL Server objects, SSIS packages, Azure Data Factory pipelines, supported Microsoft Fabric components, deployment artefacts and Power BI semantic models. AnalyticsCreator supports dimensional, 3NF and hybrid modelling approaches together with ingestion, transformations, delta loading, historisation, Slowly Changing Dimensions, snapshots and repeatable data-processing patterns.
Because generated outputs are native Microsoft technology, no AnalyticsCreator runtime is required in production. Organisations retain ownership of the resulting implementation and can integrate generated assets into Git, Azure DevOps and CI/CD workflows.
Lineage, documentation and dependency information remain connected to the design, helping teams understand change impact before regenerating affected assets.
Design Intelligence extends this governed project context into AI-assisted data engineering by providing authorised AI tools and agents with structured access to metadata, lineage, dependencies and design rules.
Typical use cases include enterprise data warehouse development, Microsoft Fabric adoption, SQL Server and SSIS modernisation, governed Power BI delivery and repeatable data product engineering.
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, 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
Learn more
Huawei Cloud Data Lake Governance Center
Transform your big data processes and create intelligent knowledge repositories with the Data Lake Governance Center (DGC), a comprehensive platform for managing all facets of data lake operations, including design, development, integration, quality, and asset management. With its intuitive visual interface, you can establish a robust data lake governance framework that enhances the efficiency of your data lifecycle management. Leverage analytics and metrics to uphold strong governance throughout your organization, while also defining and tracking data standards with the ability to receive real-time alerts. Accelerate the development of data lakes by easily configuring data integrations, models, and cleansing protocols to facilitate the identification of trustworthy data sources. Enhance the overall business value derived from your data assets. DGC enables the creation of tailored solutions for various applications, such as smart government, smart taxation, and smart campuses, while providing valuable insights into sensitive information across your organization. Additionally, DGC empowers businesses to establish comprehensive catalogs, classifications, and terminologies for their data. This holistic approach ensures that data governance is not just a task, but a core aspect of your enterprise's strategy.
Learn more
Delta Lake
Delta Lake serves as an open-source storage layer that integrates ACID transactions into Apache Spark™ and big data operations. In typical data lakes, multiple pipelines operate simultaneously to read and write data, which often forces data engineers to engage in a complex and time-consuming effort to maintain data integrity because transactional capabilities are absent. By incorporating ACID transactions, Delta Lake enhances data lakes and ensures a high level of consistency with its serializability feature, the most robust isolation level available. For further insights, refer to Diving into Delta Lake: Unpacking the Transaction Log. In the realm of big data, even metadata can reach substantial sizes, and Delta Lake manages metadata with the same significance as the actual data, utilizing Spark's distributed processing strengths for efficient handling. Consequently, Delta Lake is capable of managing massive tables that can scale to petabytes, containing billions of partitions and files without difficulty. Additionally, Delta Lake offers data snapshots, which allow developers to retrieve and revert to previous data versions, facilitating audits, rollbacks, or the replication of experiments while ensuring data reliability and consistency across the board.
Learn more