Reference no: EM133531950
Business Analytics
Learning outcome 1: be able to identify and analyse business requirements for the identification of patterns and trends in data sets.
Learning outcome 2: be able to appraise the different approaches and categories of BA problems.
Learning outcome 3: be able to explore and critically analyse data sets
Learning outcome 4: be able to identify and evaluate the security, privacy and ethical implications in BA
Introduction
This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is designed to improve student analytic skills and to give students experience in problem solving in business analytics.
Task 1: Pivot table exercise
Collect the "Online Retail" dataset from UCI Machine Learning Repository. Carefully observe the dataset and apply analytics to find answers for the below queries:
I. List the top 5 countries where the greatest number of invoices were generated from and their corresponding number of invoices.
II. Produce a list of customers (CustomerIDs) that placed at least 1000 invoices and include their corresponding number of invoices for customer loyalty program.
III. Generate a pivot table and a suitable chart showing Monthly Invoice counts for the year of 2011.
IV. Identify the months with the highest and lowest number of invoices and comment on the visible sales patterns in the chart.
Task 2: Data Exploration
Collect the "Irish Flower" dataset from any public data source, e.g., the UCI Machine Learning Repository. Then perform the following tasks:
I. Clearly mention the source where you have collected the dataset. Include a screenshot and URL of the source.
II. Specify the basic details of the dataset, including the number of attributes, names of the attributes, number and names of the classes and the mean and standard deviation of the attribute variables.
III. Convert the dataset into a .csv file with the attribute column headers as Sepal_length, Sepal_Width, Petal_Length, Petal_Width and the 5th column as "Class".
IV. Use an analytics tool of your choice (e.g., MS Excel) to compute the class-wise mean and standard deviation of the attributes and present your answer as the table shown below.
|
Class-wise mean ± standard deviation
|
|
Sepal_Lengh
|
Sepal_Width
|
Petal_Length
|
Petal_Width
|
Iris-setosa
|
|
|
|
|
Iris-versicolor
|
|
|
|
|
Iris-virginica
|
|
|
|
|
Use an analytics tool of your choice to generate a suitable graph taking only the class-wise mean values of the attributes and comment on how the classes show separability in this dataset. Justify your answer with screenshots and briefly discuss the graph in terms of a pattern.
Task 4: Written Exercise
Topic: Security, Privacy and Ethics in Business Analytics.
In this task, you are required to write a short report based on the topic of security, privacy and ethics
in Business Analytics. You must
I. identify the major security, privacy, and ethical implications in Business Analytics
II. briefly describe the significance of these implications in business sector
III. support your response with appropriate examples and references