12. Different Dimensions The focus of data warehousing is to extend the transformation of data into information. Data warehouses offer strategic level, external, integrated, and historical data so businesses can make projections, identify trends, and make key business decisions. The data warehouse collects and stores integrated sets of historical data from multiple operational systems and feeds them to one or more data marts. It may also provide end user access to support enterprisewide views of data. You are currently working on a marketing team for a large corporation that sells jewelry around the world. Your boss has asked you to look at the following dimensions of data to determine which ones you want in your data mart for performing sales and market analysis (see Figure 6.33). As a team, categorize the different dimensions, ranking them from 1 to 5 , with 1 indicating that the dimension offers the highest value and must be in your data mart, and 5 indicating that the dimension offers the lowest value and does not need to be in your data mart. FIGURE 6.33 Data Warehouse Data Data Warehouse Data If you are looking for Access projects to incorporate into your class, try any of the following after reading this chapter. Read the "Different Dimension" on page 265 . Select two dimensions that you consider as the most valuable to be in your data mart. For each dimension you selected, provide at least one strategic question relating to that dimension, and explain why those strategic questions are critical to the bottom line of the company. 12. Different Dimensions The focus of data warehousing is to extend the transformation of data into information. Data warehouses offer strategic level, external, integrated, and historical data so businesses can make projections, identify trends, and make key business decisions. The data warehouse collects and stores integrated sets of historical data from multiple operational systems and feeds them to one or more data marts. It may also provide end user access to support enterprisewide views of data. You are currently working on a marketing team for a large corporation that sells jewelry around the world. Your boss has asked you to look at the following dimensions of data to determine which ones you want in your data mart for performing sales and market analysis (see Figure 6.33). As a team, categorize the different dimensions, ranking them from 1 to 5 , with 1 indicating that the dimension offers the highest value and must be in your data mart, and 5 indicating that the dimension offers the lowest value and does not need to be in your data mart. FIGURE 6.33 Data Warehouse Data Data Warehouse Data If you are looking for Access projects to incorporate into your class, try any of the following after reading this chapter. Read the "Different Dimension" on page 265 . Select two dimensions that you consider as the most valuable to be in your data mart. For each dimension you selected, provide at least one strategic question relating to that dimension, and explain why those strategic questions are critical to the bottom line of the company