BUS105 Business Information systems Assignment

Assignment Help Supply Chain Management

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

Reference no: EM132423452

Questions Cloud

Is there anything in the code that did not make sense : What are some of the values that employees are expected to have? Does the company provide a communication plan that ensures that employees adhere to the plan?

What is the principle of sangers sequencing technique : What is the principle of sangers sequencing technique? Use a labeled diagram to briefly describe the technique.

What laboratory tests could confirm diagnosis : Based on the man's symptoms, what diagnosis can be made? What laboratory tests could confirm a diagnosis in this case?

Find article about handwashing in online health magazine : Find an article about handwashing in an online health magazine or website such as Prevention, Men's Health, or WebMD.

BUS105 Business Information systems Assignment : BUS105 Business Information systems Assignment Help and Solution, Kaplan Business School - Assessment Writing Service - Data Management Project

Mortality rate of the disease : The CDC contains information on diseases including epidemiological data such as prevalence, incidence, and mortality rate of the disease.

How does the human body respond to invading pathogens : How does the human body respond to invading pathogens? How does the biology of the 1918 flu, given this information: The 1918 flu was particularly dangerous

Explain how it relates to another subfield of biology : For each concept explain how it relates to another subfield of biology (such as genetics, ecology, evolution etc.)

Discuss cancer on a cellular and molecular level : Discuss cancer on a cellular and molecular level. Discuss traditional treatment for cancer and innovative "non-traditional" treatments that are currently

User Account

All Pages