UBC Coca Cola Beverage Industry Data Sets & Quality & Collecting Data Discussion

1) Briefly identify and describe the enterprise and its industry in a short paragraph.

2) Identify 10 data sets you would ideally like to have in order to provide insight with regards to (1) demand for your chosen enterprise’s product or service, (2) supply factors that would affect the competitive landscape, or (3) any other key success factor for the enterprise. Prepare and submit a list (one sentence each) of the data sets, indicating for each data set the question you hope to answer by exploring and analyzing that data set.

3) Choose two of the data sets in your list for which you expect that readily-available data does notexist, meaning that you need to create the data set by collecting the data. In no more than half a page for each data set, discuss how you would go about collecting the data, taking into account cost, representativeness and potential biases. You are not expected to collect this data.

4) For two of the data sets in your list, using publicly available data sources, attempt to find data that best/most closely meets your needs. (Clearly, these two data sets cannot be the same as the ones discussed in #3, above.) Provide the data you found in an Excel file with a separate tab for each of the two data sets. In your assignment document, identify the type of data you found and clearly indicate its source. In no more than half a page for each data set, discuss the quality of the data set, making particular reference to any potential biases, and summarize the insights you have gained by exploring the data set. You may wish to apply some basic statistical techniques to help reveal the insights in the data, providing the calculations in your Excel sheet along with the data itself.

Format using Calibri 12 point with 1“ (2.54cm) margins all around.

Any detailed analysis you choose to provide will be in the attached Excel file, but must be documented to allow the reader/grader to easily follow what you are doing without having to open formulas. No VBA is to be used.

Parenthetical refencing is simple and preferred: a. from the textbook (Text, p 399); b. for outside sources (KPMG, p12), where the KPMG document would be listed in a bibliography at the end of the submission on a separate page.