Datamart Development

A local financial institution

Customer has a long-developed data warehouse (DWH) which allows authorized staffs from different teams to extract data for analysis and reporting.  However, each team has their own data interpretations and there is no aligned KPIs definition.

​

One option is to redesign and rebuild the whole data warehouse but customer has no data analytics team to lead the project and IT resources to implement.  It is also costly to revamp the whole data warehouse.

We offered a turnkey consultation and implementation service to the customer. 

​

We interviewed customer's key stakeholders and conducted workshops to understand their business objectives.  Rather than revamping the data warehouse, our recommendation is to build datamarts with aligned data definitions and calculated fields overlaying the data warehouse for different teams to consume. 

​

We analyzed the raw data, design the datamarts based on stakeholders' needs and implemented the ETL (extract, transform & load) process setup.  Those datamarts now become the single source of truth for data analysis and reporting throughout customer's organization.​

• A trusted data source with aligned field definitions across the organization

• A standardized data access approach established within the company

• A lower cost solution versus revamping data warehouse