Data Consolidation

SOURCE TYPE

CHARACTERISTIC

QUESTIONS

SOURCE TYPE

CHARACTERISTIC

QUESTIONS

Datamart(s)

Usage

  • Do you use datamarts within the enterprise? What types of data were captured?

  • Do you use datamarts within the pricing team?

  • Do you use data warehouses within the finance team?

  • What is datamart used for? Who uses it?

 

Consolition

  • Does data in these datamarts come from multiple sources? How many?

  • Who manages the consolidation?

  • How trustworthy is the datamart data?

 

Processes

  • Is the data population for the datamarts automated?

  • Who created the population method? Who maintains it?

  • What is the automated process for the datamart population?

 

Ownership

  • Who owns the datamart?

  • Who owns the source data feeding into the datamart?

  • Are there one or more data owners?

Data Warehouse(s)

Usage

  • Do you use data warehouses within the enterprise?

  • Do you use data warehouses within the pricing team?

  • Do you use data warehouses within the finance team?

  • What are the warehouses used for? Who uses it?

 

Consolition

  • Do they integrate data from multiple systems? How many?

  • Who manages the consolidation?

  • How trustworthy is the warehouse's data?

 

Process

  • Is the data population for the warehouses automated?

  • Who created the population method? Who maintains it?

  • Describe the automated process for warehouse population.

 

Ownership

  • Who owns the data warehouses?

  • Who owns the source data feeding into the data warehouses?

  • Are there one or more data owners?

Data Warehouse (Cross-Enterprise)

Usage

  • Do you use data lakes within the enterprise?

  • Do you use data lakes within the pricing team?

  • Do you use data lakes within the finance team?

  • What are the data lakes used for? Who uses them?

 

Consolition

  • Do they integrate data from multiple systems? How many?

  • Who manages the consolidation?

  • How trustworthy is the data lake data?

 

Process

  • Is the data population for the data lake automated?

  • Who created the population method? Who maintains it?

  • Describe the automated process for the data lake population.

 

Ownership

  • Who owns the data lake?

  • Who owns the source data feeding into the data lake?

  • Are there one or more data owners?

 

Â