Reference no: EM132423452
BUS105 - Business Information systems - Kaplan Business School
Assessment - Data Management Project: Winter Olympics 1992 - 2014
Business Scenario: You have been hired by a committee to perform data management of a subset of Winter Olympics data from 1992 to 2014.
Project Data: Download file "Data_for_BUS105_Assessment3.xlsx"
Instructions:
Task 1: General Data management
A. Refer to Workshop 3.
B. Write a simple data dictionary for this data file. Explain the benefit of data dictionaries and documentation in your own words.
C. Under the file menu, chose info and note the metadata (file size, date saved, author, etc.)
D. Write a few lines on the type of database this is, the type of query language you could use to search the data and where you could store the data.
E. Refer to workshop 4. What sort of analyst could you get to help you with the analysis of this data?
Task 2: Analysis & Interpretation
A. Recall the work you did in week 7.
B. Find the maximum and minimum age of all of the athletes listed in the database.
C. Put a filter on the country of origin.
COMMONWEALTH OF AUSTRALIA Copyright Regulations 1969
This material has been reproduced and communicated to you by or on behalf of Kaplan Business School pursuant to Part VB of the Copyright Act 1968 (‘Act'). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Kaplan Business School is a part of Kaplan Inc., a leading global provider of educational services. Kaplan Business School Pty Ltd ABN 86 098 181 947 is a registered higher education provider CRICOS Provider Code 02426B.
Assessment Information
D. Illustrate some of the events in which Canada won Gold medals by
a. Filter out countries so you are left with Canada,
b. Cut and paste the data to another spreadsheet,
c. Then place a filter on Medal Rank and filter out the rankings so that you are left with 1s.
d. Write an extensive paragraph on the sports involved, e.g. Ice hockey, etc., events and age of the athletes involved.
E. Repeat the exercise in Part D for Austria.
Task 3: Transforming Data
A. Recall workshop 8
B. Consider the first three lines of the data set "Data_for_BUS105_Assessment3.xlsx"
C. Rewrite the first three line in column-oriented format
Task 4: Unstructured data
A. Describe the challenges and benefits of unstructured data.
B. Suppose that you are required to collect unstructured data about the athletes.
C. Provide three different examples of the data that would be collected. For example, an mp4 file of the German slalom team chatting.
Task 5: Generation and recommendations
A. Provide practical recommendations regarding other structured data which could be collected, i.e. time sports event started and ended.
Attachment:- Business Information systems.rar