Reference no: EM13756380
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 |
| |
|
|
|
|
|
|
| |
|
|
|
|
|
What are the strengths and weaknesses of this rfp
: What are the strengths and weaknesses of this RFP and Does the RFP expressly state organization and user needs? If so, what are these? If not, why is the RFP failing to do so
|
|
Briefly discusses a matrix organizational structure
: Outline a sales leadership plan for a food co-packing manufacturer that briefly discusses a matrix organizational structure, a (challenger) sales representative profile, recruitment, training, compensation type, and motivation. Explain how you would ..
|
|
Strategic management and empowerment
: A manager is interested in moving his software company away from physical CD copies of is products into entirely online distribution. He contacts a number of technical experts to discuss the feasibility of his plan and also begins to create budget to..
|
|
How much is fact and speculation in robin hood
: How much is fact and speculation in robin hood? If there is a site you know, please let me know asap! My school homework is due on the 7th January 2013.
|
|
Identify the primary key of mpd
: 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
|
|
Different tools of total quality management
: There are different tools of Total Quality Management (TQM) that are used in manufacturing and service improvement initiatives: check sheets, scatter diagrams, cause-and-effect diagrams, histograms and statistical process control (SPC). While each ha..
|
|
What were some key beliefs of confucianism
: What were some key beliefs of Confucianism and who was its founder?
|
|
Experiencing challenges with its compensation-benefit system
: Select an organization that either has or is experiencing challenges with its compensation and benefit system. The student will provide a brief historical view of the organization.
|
|
Differences in fuel efficiency affect the price of a car
: You want to see how differences in fuel efficiency affect the price of a car - Calculate the OLS estimates β^0 and β^1 for the following model using the sample of 11 cars (you must show some of your work):
|