Create a simple data dictionary for the file

Assignment Help Other Subject
Reference no: EM133539169 , Length: word count:1000

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 Instructions

Face-to-Face Students
• Form groups of 4-5 before class

• Each group needs to ensure they bring at least one laptop to the class in Week 10 and have access to a data visualisation software (free student license)

• Your lecturer will email the data set to your groups at the start of class.

Assessment Task

Part A: Data Management (200 words)

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 (800 words)

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.

Reference no: EM133539169

Questions Cloud

What is fake news : What is "fake news?" How do you determine what is true and what is fake? 4. Are websites from sites with .gov .org, and .edu credible websites?
Essay-historic context of america in the 20th century : Choose one of the Essay Questions from "Historic Context of America in the 20th Century" and answer it based on your own opinion.
What checks-and-balances does she mention : You may consider these questions: What checks-and-balances does she mention? What does she think about the role of Congress regarding impeachment?
Discuss about the criminal justice system : Be sure to summarize the book and explain the author's opinion of the criminal justice system in America and the evidence he presents.
Create a simple data dictionary for the file : Create a simple data dictionary for the file which outlines the name (top row) and data type in each of the remaining columns
How might the policy positively affect voter turnout current : Give background such as when and why was it created or other historical context. How this policy positively affect voter turnout currently and/or in the past?
Describe 5 different leadership functions : How can you promote positive outcomes relevant to applying professional leadership as opposed to management behaviors?
Effects of colonization in the americas can you see today : What evidence of the effects of colonization in the Americas can you see today?
Write an essay on the examination of first peoples cultures : The examination of First Peoples cultures and lived experiences through text builds understanding of Canadians' responsibilities in relation to Reconciliation.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd