Database Answers  
You are not logged in: login | why register ?
Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us
Data Governance
BI+Performance Rpts
Data Marts
Data Integration
Data Sources
Information Catalogue


Architecture
 
    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
 

© Database Answers Ltd. 2010

Home Ask a Question Careers Clients Community Data Models Search Site Map Contact Us