Order Individual Case Study

Order Individual Case Study
In groups of 4-5 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.
Page 2 Kaplan Business School Assessment Outline
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 New York Times bestseller list 2011 – 2018, what types of books and which titles should be stocked by the owner of a bookstore?
• Data: The data file will be provided by your lecturer at the commencement of the class.
• Software: Your team’s choice of Power BI, Tableau or Tibco Spotfire
• This assessment covers learning outcomes 3 and 4
Assessment Instructions
Order Individual Case Study
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 books data set to your groups at the start of class.
• Complete the assessment task below in groups: o You will have 1 hour to do Part A below (Data Management) as a group after
which you will have one group member upload to the assessment portal via TurnItIn o You will have 1.5 hours to do Part B below (Data Analysis and Recommendation)
as a group after which you will have one group member upload to the assessment portal via TurnItIn
• This task is open book
Online Students
• Form groups of 4-5 before class
• Each group needs to ensure they attend the online workshop in Week 10 and have access to a computer and data visualisation software (free student license)
• Your lecturer will email the books data set to your groups at the start of class.
• Complete the assessment task below in groups: o You will have 1 hour to do Part A below (Data Management) as a group after
which you will have one group member upload to the assessment portal via TurnItIn o You will have 1.5 hours to do Part B below (Data Analysis and Recommendation)
as a group after which you will have one group member upload to the assessment portal via TurnItIn
• This task is open book
Order Individual Case Study
Page 3 Kaplan Business School Assessment Outline
Assessment Task Part A: Data Management (10 marks, 200 words) – 1 hour Instructions:
1. The data file will be provided by your lecturer at the commencement of the class.
2. Pre-cleaning: Open the BI tool and load the file copy, however do not import columns “book_review_link”, “primary_isbn13”, “sunday_review_link” and “first_chapter_link”. Ensure that the format of the columns is correct (i.e. dates should be dates and numbers should be integers or real).
3. Currency conversion:
The price is shown in column G. The currency type for the price is shown in column Q. Before you carry out your analysis, all prices must be converted to a single currency and this value entered into ‘converted_price’ in column R. Undertake this conversion using the vlookup command in Excel. The currency pairs are as follows:
Your lecturer will advise you at the start of class which base currency to convert all prices to.
4. Data Dictionary: Write a simple data dictionary for the file which outlines the name (top row) and data type in each of the remaining columns. Explain how you constructed this dictionary and how it can be applied to data succession management.
5. 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?

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Order your essay today and save 30% with the discount code HAPPY