
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

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.
SmartDraw includes a large collection of symbols and templates to help users get started quickly and easily without extensive training. In addition to floor plans, site plans, landscapes, and other layouts, users can create flowcharts, organizational charts, mind maps, project charts, technical engineering diagrams, IT diagrams, and more. SmartDraw also allows users to create custom shapes using their own product catalog or other existing assets. Users can import PDFs, images, Google Maps, Visio files, and Visio stencils to build on existing plans and workflows. Drawings can be created to any scale, ensuring accuracy for every use case.
SmartDraw makes it easy to enrich drawings with data, enabling more informative and dynamic visuals. Users can also generate manifests and bills of materials directly from their diagrams to support planning , procurement, oversight, and compliance. The app can automatically generate diagrams from data, including organizational charts, AWS and Azure architectures, PI Boards, class diagrams, ERDs, and more. In addition, users can use natural language prompts to instantly generate diagrams like flowcharts and mind maps with AI.
Files can be saved directly to SmartDraw or the user's preferred storage provider like OneDrive, SharePoint, or Google Drive for better data security. SmartDraw also integrates with the Microsoft and Google enterprise tech stacks, as well as tools like Confluence and Jira. SmartDraw works hand in glove with your existing IT infrastructure without disruption to maximize what you've already invested in.
Learn more
ERDPlus
ERDPlus is a web-based application designed for database modeling that simplifies the development of entity relationship diagrams, relational schemas, star schemas, and SQL DDL statements. This user-friendly platform allows individuals to quickly create Entity Relationship Diagrams (ERDs) with ease. It supports a range of contemporary relational database management systems, including Oracle, MySQL, Microsoft SQL Server, PostgreSQL, Teradata, IBM DB2, Microsoft Access, and more. The tool's notation system effectively captures both regular and weak entities, while also accommodating a variety of attribute types such as unique, multi-valued, derived, composite, and optional attributes, along with all cardinality constraints for relationships, which encompass both mandatory and optional associations. Moreover, ERDPlus simplifies the process of establishing foreign keys and maintaining referential integrity through intuitive click-and-connect features, enhancing the development of relational schemas. The notation also improves visualization by distinguishing between fact tables and dimension tables, using a thicker border around fact tables to facilitate better comprehension of database structures. In addition, the platform's versatility and ease of use make it an indispensable resource for database designers aiming for both efficiency and accuracy in their projects. Ultimately, ERDPlus proves to be an essential tool for anyone involved in database design and management.
Learn more
Galaxy Modeler
Galaxy Modeler is an intuitive and contemporary desktop application that facilitates schema design specifically for GraphQL data modeling. Users can craft GraphQL diagrams, visualize current schema configurations, and produce both documentation as well as schema definition scripts effortlessly. This application is designed to work seamlessly with GraphQL.
Notable features include the ability to design schemas tailored for GraphQL, import and visualize pre-existing schemas, and pull structures from online platforms. Additionally, it provides functionality for creating interactive documentation, generating scripts to establish schemas, and producing reports in multiple styles. Users can choose from various display modes and also benefit from support for sub-diagrams, enhancing the overall usability of the application. With these comprehensive features, Galaxy Modeler stands out as a powerful tool for developers working within the GraphQL ecosystem.
Learn more