AnalyticsCreator
Accelerate your data journey with AnalyticsCreator—a metadata-driven data warehouse automation solution purpose-built for the Microsoft data ecosystem. AnalyticsCreator simplifies the design, development, and deployment of modern data architectures, including dimensional models, data marts, data vaults, or blended modeling approaches tailored to your business needs.
Seamlessly integrate with Microsoft SQL Server, Azure Synapse Analytics, Microsoft Fabric (including OneLake and SQL Endpoint Lakehouse environments), and Power BI. AnalyticsCreator automates ELT pipeline creation, data modeling, historization, and semantic layer generation—helping reduce tool sprawl and minimizing manual SQL coding.
Designed to support CI/CD pipelines, AnalyticsCreator connects easily with Azure DevOps and GitHub for version-controlled deployments across development, test, and production environments. This ensures faster, error-free releases while maintaining governance and control across your entire data engineering workflow.
Key features include automated documentation, end-to-end data lineage tracking, and adaptive schema evolution—enabling teams to manage change, reduce risk, and maintain auditability at scale. AnalyticsCreator empowers agile data engineering by enabling rapid prototyping and production-grade deployments for Microsoft-centric data initiatives.
By eliminating repetitive manual tasks and deployment risks, AnalyticsCreator allows your team to focus on delivering actionable business insights—accelerating time-to-value for your data products and analytics initiatives.
Learn more
dbt
dbt Labs is redefining how data teams work with SQL. Instead of waiting on complex ETL processes, dbt lets analysts and 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 Labs 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
Luna Modeler
Luna Modeler is an easy-to-use data modeling tool for your favorite databases.
Design and visualize database structures, generate SQL scripts, and create interactive documentation.
Perfect for both pros and beginners, Luna Modeler makes data modeling simple!
Supported platforms:
- Oracle Database
- SQL Server
- PostgreSQL
- MySQL
- MariaDB
- SQLite
Key features:
- Database modeling and design
- Reverse engineering from Oracle, SQL Server, PostgreSQL, MySQL, MariaDB
- Import from SQLite files
- Support for SSH/SSL/TLS connections
- Generation of interactive HTML reports
- Generation of SQL scripts
- Project update
- Various themes and styles for reports
- Multiple display modes
- Support for sub-diagrams
- Generation of alter scripts for selected database platforms
Learn more
Lucidchart
Lucidchart is a comprehensive visual collaboration platform that empowers teams to create intelligent, data-driven diagrams for process mapping, team planning, systems architecture, and more. With features like AI-powered diagram generation, real-time collaboration, and data integration, Lucidchart helps users quickly visualize their systems and workflows with ease. Whether you’re building technical diagrams or mapping out complex organizational structures, Lucidchart streamlines the process, saving you time and improving clarity. It integrates with a variety of popular tools such as Jira, Slack, Confluence, and Notion, making it an invaluable tool for enhancing teamwork, driving decisions, and accelerating innovation across your organization.
Learn more