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
BigQuery is a serverless, multicloud data warehouse that makes working with all types of data effortless, allowing you to focus on extracting valuable business insights quickly. As a central component of Google’s data cloud, it streamlines data integration, enables cost-effective and secure scaling of analytics, and offers built-in business intelligence for sharing detailed data insights. With a simple SQL interface, it also supports training and deploying machine learning models, helping to foster data-driven decision-making across your organization. Its robust performance ensures that businesses can handle increasing data volumes with minimal effort, scaling to meet the needs of growing enterprises.
Gemini within BigQuery brings AI-powered tools that enhance collaboration and productivity, such as code recommendations, visual data preparation, and intelligent suggestions aimed at improving efficiency and lowering costs. The platform offers an all-in-one environment with SQL, a notebook, and a natural language-based canvas interface, catering to data professionals of all skill levels. This cohesive workspace simplifies the entire analytics journey, enabling teams to work faster and more efficiently.
Learn more
dbt
dbt Labs is redefining how data teams work with SQL. Instead of waiting on complex ETL processes, dbt lets data analysts and data engineers build production-ready transformations directly in the warehouse, using code, version control, and CI/CD. This community-driven approach puts power back in the hands of practitioners while maintaining governance and scalability for enterprise use.
With a rapidly growing open-source community and an enterprise-grade cloud platform, dbt is at the heart of the modern data stack. It’s the go-to solution for teams who want faster analytics, higher quality data, and the confidence that comes from transparent, testable transformations.
Learn more
Peekdata
It takes only days to wrap any data source with a single reference Data API and simplify access to reporting and analytics data across your teams. Make it easy for application developers and data engineers to access the data from any source in a streamlined manner.
- The single schema-less Data API endpoint
- Review, configure metrics and dimensions in one place via UI
- Data model visualization to make faster decisions
- Data Export management scheduling API
Our proxy perfectly fits into your current API management ecosystem (versioning, data access, discovery) no matter if you are using Mulesoft, Apigee, Tyk, or your homegrown solution.
Leverage the capabilities of Data API and enrich your products with self-service analytics for dashboards, data Exports, or custom report composer for ad-hoc metric querying. Ready-to-use Report Builder and JavaScript components for popular charting libraries (Highcharts, BizCharts, Chart.js, etc.) makes it easy to embed data-rich functionality into your products.
Your product or service users will love that because everybody likes to make data-driven decisions! And you will not have to make custom report queries anymore!
Learn more
