Your industrial supply company wants to create a data warehouse where management can obtain a single corporate-wide view of critical sales information to identify bestselling products, key customers, and sales trends. Your sales and product information are stored in two different systems: a divisional sales system running on a UNIX server and a corporate sales system running on an IBM mainframe. You would like to create a single standard format that consolidates these data from both systems.
1. Identify the primary key of MPD. Sales table.
2. Create a SQL Select Query to pull Product_ID, Product_Description and Units_Sold for Product 85773 from the CSS.Sales table. Hint: do not use the CSS prefix in your query.
3. Identify the data problems that must be resolved as you determine the system of record for each of the attributes in the proposed data warehouse. Who should make those decisions, the database specialist or the business manager leading this data warehouse project? Why?
4. What business problems are created by having two disparate sales systems?
5. List and describe how each of the five business intelligence reports covered in section 10.2 of your text will leverage the information below to provide actionable information.
Sample data warehouse layout for this company. You are not required to fill out this table.
Proposed Data Warehouse Format
Product_ID |
Product_Description |
Cost_Per_Unit |
Units_Sold |
Sales_Region |
Division |
Customer_ID |
| |
|
|
|
|
|
|
| |
|
|
|
|
