Business Analytics Case Study

Weight

Criterion

Details

1 mark

Company Information

For conducting this assignment you need to have access to some data set. You either get your data from a corporate website or you get some open source (free) data from different websites, for example government website. The aim of this section is to familiarize the reader with the context of your report.

If you get your data from a corporate website present a detailed background information of the company including size, business type, areas of operations, competitors etc.

If you have collected the data from the websites and you don’t know the company information, you can discuss about the potential company or entity. For example, if you have access to some accident data Australian Department of Health can be the company or if you have access to unemployment data Australian people can be considered as an entity. So you can discuss how Australian Department of Health or Australian people are related to your data set and can benefit from your investigations.

A valid dataset should have at least 4 columns, 100 rows and at least 1 numerical data.

1 mark

Identify the problem

You should investigate the data set and identify a problem in the data set. In this section you should consider the following issues:

Start this section by presenting your problem statement. It is suggested to present the problem statement with bold font (just to make it easier to be found and distinguished from rest of the text). Problem statement should be clear and comprehensive.

In the following paragraphs the problem statement should be supported by appropriate level of detail which can include: how did you come up with this problem, significance of the problem, and similar issues.

It should be clear how your problem statement is originated from the data set.

The relevance of your problem statement with business analytics methods should be addressed.

You should clarify how did you come up with the problem statement. For example, you can present an argument explaining the procedure of creating different visualization methods which lead to recognizing the problem spot.

5 marks

Literature review

Here you have to investigate different sources such as scientific articles and conference proceedings to see how other people used business analytic methods to address similar problems. For example, if you are looking at predicting the number of passengers for an airline, you can search in published articles to see how others used analytical methods for doing prediction of number of passengers, how they did the variable selection, whether they used descriptive or predictive or a combination of of analytical methods.

The relationship between different studies in this literature review section should be clear.

It should be clear how literature of business analytics helped you to design your report.

We do not want to re-create the wheel. It should be identified how your study supplements previews investigations.

At least 4-5 articles are needed

1 mark

Data Collection

You are required to collect real data for the chosen topic. You should use different resources for collecting data: internet, company reports, etc. You should explain the process of your data collection. This could include but not limited to:

The websites that you used for collecting the data.

If you merged several small data sets to build a data set with appropriate size, explain the details.

If you lunched an application to get access to the data, the details of your application should be here.

How did you deal with missing values in the data set?

22 marks

Analysis and Discussion

Show all analysis based on the collected data. Here make sure you use the techniques and principles that you learned in our course correctly. You may discuss if your analysis is not used in decision making what would be the consequence (therefore, here you need to show the impact of your analysis). You can apply one or multiple techniques that we had in business analytics course.

It should be clear how your analysis solves the problem.

Appropriate decision-making pertaining selection of Business Analytic methods is of significant importance. For example, if creating a histogram is appropriate method for dealing with part of the problem usage of other methods such as bar chart will not be accepted.

You have to decide how you want to combine different business analytic techniques to present your analysis and discussion. This means you can use descriptive analytics, predictive analytics or a combination of them. However, this usage should be justified.

It is mentioned that only analysis in Excel is accepted, meaning, you can only use Excel and its functions to analyze the dataset, not other platforms. And later with the analysis, written it in word in the report.

2 marks

Recommendations

Here you need to provide some recommendations based on your analyses and explain how your analyses can improve the decision making and performance.

Recommendations should originate from your analysis and discussion. The relationship between analyses, discussion and recommendations should be crystal clear.

It should be clear how recommendations can solve the problem.

Recommendations should be feasible and applicable. There should be enough details explaining how your recommendations are feasible and applicable.

3 marks

Overall presentation of the assignment

Clarity of presentation and the sequence of the topics, including:

Correct referencing (not including in word count limitations). Note: referencing is mainly associated with literature review section.

Executive summary and its clarity

Quality of writing and explnation

Table of contents (not including in word count limitations)

List of figures/tables (not including in word count limitations)

Page numbering

Cover sheet (not including in word count limitations

Present a detailed background information of the company information

The company is introduced with a clear and concise overview of its industry, size, and relevance to the analysis. Data or evidence is provided to support the claim

2.86 pts

Identify the problem

The section begins with a clear and concise problem statement in bold font. There are well-developed arguments with a high level of detail to support the problem significance. Arguments are supported by strong, relevant, and credible data.

2.86 pts

Literature review

his argument should show how similar past problems were solved using business analytics. You should demonstrate how the previous work helped you in solving your problem. Arguments should be supported with credible references.

14.29 pts

Data collection

The source of data is clearly identified and highly relevant to the research question. The procedure for data collection is meticulously explained

2.86 pts

Analysis based on data. Digitally Adept:

Analyses data and constructs a collaborative environment to draw insight and conclusion.

62.85 pts

Provide recommendations based on analyses

Recommendations are clear, feasible, and practical, demonstrating a strong understanding of real-world constraints. Recommendations directly originate from the analysis and discussion of the data collected. The explanation clearly demonstrates how the proposed solutions can contribute to effectively solving the problem.

5.71 pts

Overall presentation

All of these factors are considered.

8.57 pts