
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
Lucidchart
Lucidchart is the next-generation diagramming tool that combines artificial intelligence, data integration, and intuitive design to help businesses streamline workflows, optimize processes, and improve collaboration. From AI-generated diagrams to seamless real-time collaboration, Lucidchart provides everything you need to create professional, data-driven visuals. It supports a wide range of use cases, including creating process maps, technical diagrams, organizational structures, and systems planning, all within an easy-to-use platform. With powerful features like AI diagramming, data linking, and integration with popular business apps like Jira, Confluence, Slack, and Teams, Lucidchart ensures your teams stay aligned and informed, driving smarter decisions and faster innovation across the board.
Learn more
DTM Data Modeler
DTM Data Modeler is a specialized CASE tool tailored for database developers, supporting both forward and reverse engineering tasks. This intuitive application facilitates the manipulation of logical and physical data models, which are represented through entity-relationship diagrams. Targeting database architects and developers, it establishes seamless connections with data sources via the ODBC interface, ensuring it works well with modern database management systems. Beyond handling essential model properties like entities and their relationships, the software allows the creation of indexes and triggers at the physical level that correspond with the designed database tables. Its foreign key migration feature significantly enhances schema development by offering a more user-friendly and visual method, thereby reducing the likelihood of integrity issues within the model. Additionally, users can produce database schema objects directly within the database or generate SQL scripts that mirror the model and comply with custom user-defined configurations, making the overall workflow more efficient and cohesive. In summary, DTM Data Modeler provides developers with an extensive array of tools essential for proficient database design and management, ensuring they can meet the demands of complex projects with ease. This comprehensive approach not only simplifies the development process but also promotes better collaboration among team members involved in database projects.
Learn more