MIST 7770 - Texas Christian University
Coffee Chain Exercise
For this exercise we will use the Access database (CoffeeChain) found on the course website.
Questions:
1) Your VP is interested in finding out if total sales by product type is impacted by market size? Please create a report showing that. Show it both as a table and as a chart. What type of chart did you use? Why?
2) Which product types are doing better in small markets vs. large markets? Why do you think this is the case?
3) How are the total sales related to total profit by product type? Which product type has the highest profit vs. highest sales?
4) You are interested in finding out more about business in California. Show the profit margin and profit by Product and Product type. In which product/type the company is losing money in California?
5) Product manager responsible for coffee is interested in sales of coffee across all the states. Which state has the highest coffee sales? Show it on a geo graph and a table. From the geo graph, can you identify the top 5 states for the highest coffee sales?
6) Look at Profit by Regions (Market) by Product Type and Product. Can you identify a region with a negative Profit? Can you drill down and find out what is causing it? Find out which product and which state is causing negative sales?
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- colorado christian university blackboard
- colorado christian university online
- colorado christian university online program
- colorado christian university log in
- colorado christian university student portal
- colorado christian university email account
- colorado christian university online degrees
- colorado christian university student email
- colorado christian university website
- my colorado christian university blackboard
- colorado christian university my ccu
- colorado christian university athletics