Data Modeling and Design

Home »
Solutions »
Data Modeling and Design

Innovations process of Data Design is about addressing the requirements or gaps in the data, that were discovered during the discovery phase and developing a plan of action. The Design phase involves building a data model, defining ETL transformations and mappings between source data and the data warehouse tables, defining metadata requirements and designing dashboards and reports.

Innovations follows Ralph Kimball’s Star Schema data modeling practice. It uses conforming dimensions and creates federated data warehouses to provide single version of truth.

Case Studies

Information Management: From Data to Decisions to Profits.