In a matter of 1 hour, I have been able to use Dimodelo to perform the transformations and additional metrics I wanted, deployed and tested in UAT. This would have taken me the best part of 2 days traditionally…

- Nigel Rablin. Business Intelligence Specialist

Introducing Dimodelo Architect

Watch us design and build a Data Warehouse in less than 10 minutes… Seriously!

Dimodelo Architect is a Data Warehouse Automation tool for the Microsoft platform. Use Dimodelo Architect to design, generate, deploy and run a Data Warehouse. Dimodelo Architect captures your entire Data Warehouse design in a single Visual Studio project, then generates the staging and data warehouse databases, and high performance, industry best practice SSIS Packages. Dimodelo Architect manages the deployment of the solution to a server, and the execution of ETL batches. Start your Free 30 day trial Today >>

Build a Data Warehouse… Fast

Dimodelo Architect dramatically reduces the effort required to design, build, deploy and run a Data Warehouse. Deliver the benefits of a data warehouse at the speed of delivering a self-service BI solution.

How Fast

In real life implementations we are averaging 6.4 hours per dimension/fact. That’s designed, built, tested, scheduled and deployed to production.

But it’s not all about speed … it’s about quality and agility too!

Dimodelo Architect is truly agile

Make a design change…

Change automatically
propagates throughout solution

Re-generate code

One click
deployment to Test

Done in 5 minutes…

(get a coffee, read the news)

Be Agile

“Software applications developed through the agile process have three times the success rate of the traditional waterfall method…”

Standish CHAOS Report 2011.

Dimodelo Architect allows you to be truly agile. Respond to change and iterate quickly through releases.

In the end, it’s all about staying focused on delivering value to the business…

Concentrate your efforts on empowering the business with impressive Reporting and Analytics. Stay focused on business requirements and design, not lost in code.

Case Study Legal Aid Queensland

113 Staging tables
28 Dimensions
20 Facts
1 Cube79 Days

Data Warehouse Built for Legal Aid Queensland

Legal Aid Queensland built a data warehouse with 28 Dimension and 20 Facts in just 79 days. The effort included gathering requirements, installing and configuring an SQL Server 2012/SharePoint environment, developing the Data Warehouse and ETL using Dimodelo Architect covering 7 business areas (including legal case work, legal advice, duty lawyer, conferencing, time recording, lawyer income, financial provisioning and payroll), creating a cube with many complex measures, data security, several reports, implementing the ETL workflow and deploying to a UAT and Production environments. Dimodelo Solutions mentored 2 data analysts through the development process providing hands on training and helping them become self-sufficient.

Effort: 79 Days

Case Study RSL Care

67 Staging tables
28 Dimensions
13 Facts
1 Cube29 Days

Data Warehouse Built for RSL Care

RSL Care built a Data Warehouse in 29 days yielding 28 Dimension and 13 Facts. The effort included gathering requirements, developing the Data Warehouse and ETL using Dimodelo Architect, creating a cube with several complex measures, implementing the ETL workflow and deploying to a UAT environment. Dimodelo Solutions mentored RSL Care through the development process providing hands on training to their Business Intelligence specialist. RSL Care have now decided to consolidate existing legacy Data Warehouses into the Dimodelo Architect generated Data Warehouse.

Effort: 29 Days

Existing Data Warehouse? Extend or Redesign

If you already have a Data Warehouse, Dimodelo Architect can help you leverage your existing investment. You have a choice to either extend your existing data warehouse, or quickly migrate it to Dimodelo Architect and redesign.

To redesign

You can import your existing data warehouse schema into a new Dimodelo Architect project, and then quickly define ETL to migrate the existing data.

To extend

To extend, you can create a new Dimodelo Architect project, design new facts and dimensions, and associate new facts to existing dimensions in an existing data warehouse i.e. conformed dimensions. Deploy the new data warehouse tables to the existing data warehouse database, or a new database. Combine the two data warehouses in the SSAS/Tabular data source view. Orchestrate existing SSIS packages in a new ETL batch managed by Dimodelo Architect.

Please contact us to discuss your current requirements. We can recommend an approach to get the best leverage from your existing investment.