|
|
What is a Data Mart ?
- Data Marts are a Repository of summary, total and detailed data to meet User Requirements for Reports.
- They always have a standard structure, called Dimensional Data Models, which means that it is possible
to use Generic Software and adopt a common Approach based on Templates.
- Describing a Data Mart is a good way to get User buy-in because they can easily be explained in a logical
manner which is very user-friendly.
- A Data Mart is a Repository of total and detailed data to meet User Reports requirements.
- It always a standard structure which means can have generic software and a common approach based on Report Templates
- A Data Mart design is simple and can be described to get User buy-in
Why is this Stage important ?
- It provides a single point of reference for all the data available within the organisation for producing Reports
How do we get Started ?
- Get a broad understanding of User's Data Requirements
- Establish a common view of the Data Platform
- Determine the available Data
- Reconcile standards, reference data
- Choose the product or use bespoke SQL
- Use Templates and agree design with Users
- Populate Templates with sample data
- Get sign-off on demo specs in 1 month, aim for results for champion in 3 months and final results in 6 months.
- Adjust timescales in light of experience
|
|
|
|