Explain how you will back up the data and keep it secure

Reference no: EM133523917

Introduction to Business Analytics

Assessment - Data Management, Analysis and Visualisation Project

Your Task

In groups of 4 to 5 class members (no more than 5 members) you are to perform a number of data management, analysis and visualisation tasks using your BI (Business Intelligence) tool of choice.

Consider the business question and data set below and complete Parts A and B below in a group in Week 10 class time.

EVERY MEMBER of the group will need to have access to a laptop or a desktop computer in order to contribute to this task. Student will need to have downloaded and installed a BI tool of their choice. Online students will complete this task over online workshop and should have access to a BI tool on their machines.

Assessment Description

Your group will be asked to address the business question below with reference to the data provided and software of your choice.

• Business Question: Based on the data set provided, which breakfast cereal is best for diabetics and those on special diets?

• Data: The data files (data and fields) will be provided by your lecturer at the commencement of the class.

• Software: Your team's choice of Power BI or Tableau. If you wish to use another software package, please let your facilitator know.

Assessment Task

Part A: Data Management

Instructions:

1. The data file and fields file will be provided by your lecturer at the commencement of the class. The data relates to nutrition of breakfast cereal. Suppose that you are an Analytics team for a sport and dieting company. You have been given data on the nutritional components (e.g. sugar, fat, protein,...) of common breakfast cereals and a rating. You wish to determine which cereals are best for diabetics and those on special diets.

2. Upload the data into Excel for an initial check. The file is a csv (txt) file. Check for missing data and errors.
a. You will notice some negative values which can be modified by looking up the components on the internet. If you can't find any information, use an approximate based on a similar product.
b. Sort the ratings from largest to smallest to get an idea of general customer approval of the cereals.
c. Save the file as an excel file for uploading into Power BI or Tableau.

3. Data Dictionary: Open the fields file that you have been given. From the information given, create a simple data dictionary for the file which outlines the name (top row) and data type in each of the remaining columns. Explain how the results can be applied to data succession management.

4. Data Security: Explain how you will back up the data and keep it secure throughout the data management process. What challenges are associated with this?

Part B: Data Analysis and Recommendation

0. Upload your data file into Power BI or Tableau

1. Forming questions and visualising: Create four sub-questions and visualisations for each of them to show different nutrition-based aspects of the products. For example, which manufacturer produces products which contain the least amount of sugar? What would suit those on a high protein diet? Explain which visualization you think is the most effective in addressing the business question above? Why?

2. Filtering: With reference to two visuals, filter out some products at the extreme end. For example, cereals with at least 4 gm of protein or those with less than 3 grams of sugar or more than 3 grams of fat.

3. Summary statistics: Find the average vitamin (percentage of daily recommended dose) per manufacturer and summary stats (by switching from sum to average or median) for two other variables.

4. Sorting: Having sorted the ratings, arrive at a conclusion about what customers prefer to eat.

5. Summary and Recommendation: Summarise all of your findings and recommend which products should be promoted as being the least harmful for diabetics and others with special needs. Justify your answers with reference to the data analysis you have performed in the previous sections.

• You must submit your Power BI or Tableau file and a Microsoft Word file via MyKBS at the end of class.

Attachment:- Business Analytics.rar

Reference no: EM133523917

Questions Cloud

Are nurses involved in evaluating the systems : What training is provided when a new information system is implemented in your organization? Are nurses involved in evaluating the systems?

Write a bash script to check whether the given certificate : CSC8520 Securing Networks, University of Southern Queensland - Write a bash script to check whether the given certificate (sample cert.cer) is on the Certificat

What specifically will you address in your proposed health : Using data and statistics, support your claim that issue you selected is a problem. What specifically will you address in your proposed health promotion program

Describe ethical considerations in relation to recruitment : Describe any ethical considerations in relation to recruitment of the participants and your plans to address them.

Explain how you will back up the data and keep it secure : Explain how you will back up the data and keep it secure throughout the data management process. What challenges are associated with this

Discuss key people involve and how your research will affect : Why is your research need and how will it affect social change or change within organization? Discuss key people involved and how your research will affect them

What electronic communication strategies are used : What electronic communication strategies are used at your organization to communicate with patients? How is patient privacy and confidentiality protected?

What are the benefits of this style on team psychology : What are the benefits of this style on team psychology, and how might this style impact the team in managing conflict?

How your work environment prepares and responds to emergency : How your work environment prepares and responds to emergency preparedness (you may choose natural or man-made emergencies)?

User Account

All Pages