4.6 out of 5 stars
(46 Ratings)
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 about AnalyticsCreator
4.4 out of 5 stars
(570 Ratings)
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 about SmartDraw
ERBuilder
ERBuilder Data Modeler is a graphical interface tool that enables developers to create, visualize, and design databases through the use of entity relationship diagrams. It also has the capability to automatically produce the most frequently used SQL databases. Make sure to distribute the data model documentation among your team members. Additionally, you can enhance your data model by utilizing sophisticated features such as schema comparison, schema synchronization, and the generation of test data, ensuring a more efficient workflow. This comprehensive tool helps streamline the database design process significantly.
Learn more about ERBuilder
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 about ERDPlus