Data Warehouse Automation

“What used to take 6 weeks, now takes 6 days!

Design and Build a Data Warehouse fast. Stay focused on delivering impressive Reporting and Analytics, not stuck in Data Warehouse code.

Start your Free 30 day Trial TODAY!
  • Free Trial benefits:
  • + Risk Free (keep the generated code)
  • + Access to tutorials and user guide
  • + Personal support

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, build and generate 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.

 

dimension-fact
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.

 

 

arrow-top

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

arrow-bottom

 

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…

 

 

Stay focused on Reporting and Analytics… not lost in code
  • Design logical models instead of physical models.
  • ETLDefine data mappings and select ETL patterns instead of coding SSIS packages.
  • Generate the Staging and Data Warehouse database synchronization code, instead of writing manual scripts.
  • One click deployment instead of lengthy, error prone deployment routines.
  • Simplified ETL batch workflow configuration. No more master SSIS packages.
  • Inbuilt batch execution, logging and management framework.
Start your Free 30 day Trial TODAY!

 

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 Cube
79 Days

 

Case Study RSL Care

 

67 Staging tables
28 Dimensions
13 Facts
1 Cube
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.

15 + 13 =