
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

SmartDraw makes professional drawings and diagrams accessible to everyone. Non-technical users can quickly create floor plans, while professionals get the precision and scale they require. With industry-leading floor planning tools and an intuitive interface for traditional diagramming like flowcharts and organizational charts, SmartDraw delivers enterprise-ready power without unnecessary complexity.
Key features:
- Large collection of symbols and templates
- Ability to create custom shapes
- Import PDFs, images, Google Maps, Visio files, Visio stencils
- Draw to any scale
- Enrich drawings with data
- Generate manifest and bills of materials
- Generate diagrams from data automatically like org charts, AWS, Azure, PI Boards, and more
- Use natural language text prompts to generate diagrams with AI
- Save files directly to OneDrive, SharePoint, or Google Drive, or other preferred provider
- Integrations with the Microsoft and Google enterprise stack plus Confluence and Jira
SmartDraw supports a wide range of industries and real-world use cases, helping teams plan, document, and communicate more effectively. Construction professionals use it to create scaled floor plans, site layouts, and electrical and plumbing drawings. Fire departments rely on it for fire pre-planning and incident documentation, while police departments use it for accident reconstruction and crime scene diagrams. IT teams build network diagrams and cloud architectures, HR leaders create organizational charts, and product managers map out processes and workflows. From physical layouts to business processes, SmartDraw provides a single platform that adapts to the needs of each role and industry.
Learn more
DbSchema
DbSchema is an innovative tool designed for collaborative visual schema design, deployment, and documentation within teams. Its various integrated features, such as data exploration, a visual query editor, and data generator, make it an essential resource for anyone working with databases on a daily basis. Supporting a wide range of both relational and No-SQL databases—including MySQL, PostgreSQL, SQLite, Microsoft SQL Server, MongoDB, MariaDB, Redshift, Snowflake, and Google—DbSchema caters to diverse database needs. One of its standout capabilities is reverse-engineering database schemas and representing them visually through diagrams. Users can engage with their databases through these diagrams and other visual tools. The DbSchema model maintains its version of the schema structure, which is distinct from the actual database, enabling seamless deployment across various databases. This feature allows users to save design models as files, store them in GIT, and collaborate on schema design without needing a direct database connection. Additionally, users can easily compare different schema versions and generate SQL migration scripts, enhancing their workflow efficiency. Ultimately, DbSchema empowers teams to streamline their database management processes effectively.
Learn more
ER/Studio Data Architect
ER/Studio Data Architect is an enterprise data modeling solution that helps organizations design, document, and manage data architecture across modern platforms. It enables data architects and database professionals to create conceptual, logical, and physical data models that connect business meaning with technical implementation. By defining entities, relationships, and standards before systems are built, ER/Studio helps ensure consistent definitions, accurate reporting, and reliable analytics.
A core capability of ER/Studio Data Architect is logical data modeling, which defines business concepts independently of technology. Logical models act as a semantic foundation for the organization, helping teams align on the meaning of key entities such as customers, products, and transactions. This approach reduces ambiguity, prevents semantic drift across systems, and improves the reliability of analytics and AI initiatives.
The platform provides powerful forward and reverse engineering capabilities. Architects can generate database schemas from models or reverse engineer existing databases to document and analyze current structures. Schema compare and merge tools detect differences between versions and generate scripts to apply updates efficiently.
ER/Studio Data Architect supports major platforms including SQL Server, Oracle, PostgreSQL, Snowflake, Databricks, and JSON-based systems. Automation features such as macros, data lineage, and impact analysis help teams understand dependencies and reduce manual work. The platform also includes ERbert, an AI-powered data modeling assistant that can generate logical models from natural language prompts, accelerating model creation while maintaining structured data architecture.
Learn more