• 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!

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.

Download Free trial software >>

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!

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 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 RSL Care

    67 Staging tables
    28 Dimensions
    13 Facts
    1 Cube
    29 Days
  • Case Study Legal Aid Queensland

    113 Staging tables
    28 Dimensions
    20 Facts
    1 Cube
    79 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.