Separating Data into Data Marts Research Paper Example | Topics and Well Written Essays - 500 words

Separating Data into Data Marts - Research Paper Example This happens in the early stages of the design. It is necessary to develop a plan for delivery before implementing a data mart. This entails information requirements and prioritizing the user’s needs. It is also necessary to develop a corporate philosophy that embraces true value on an optimized environment. For future growth, data needs to be integrated and managed consistently from across an organization. For instance, a financial data mart needs to provide equal access to common financial data that would be the foundation for corporate performance management. Other areas would include data marts to assist in decision making while screening the complexities associated with access to top corporate data structure. Corporate experts should assist in organizing the data marts. End users should have direct access to the information they need to deliver relevant business decisions. Future data mart designs should incorporate the process of logical design. This will involve arranging data into a set of logical relationships called entities and attributes. This is particularly crucial in keeping the business requirements on hand throughout the design process. It is necessary to make a wish list of data elements from the business’ user needs. This involves setting up a list of data elements, data attributes, grouping data reasonably and setting up relationships between data. It is essential to understand the source of data; this can be done by categorizing them by size (Kimball & Ross, 2002). Classification of data involves traditional presentation of facts, dimensions, and relationships between them in data mart applications. The figure below is a complete description of energy consumption per person type for floors in a building. The benchmarks can be created over floors. It draws a clear picture of energy consumption and