Reference no: EM132641487

Data Analytics - Report

Required file:
1. Excel file (analysis), make sure you copy all required information such as tables and plots that you created from Excel file to the word file.
2. Word file (report).

Suggestive Datasets:
There are two scenarios you can choose one: having access to corporate data or using public data.

1- (Company data): You can get access to corporate data by conducting some online search. Alternatively you if have some connections in a company let us say you used to work in that company you can ask the related office to provide you with some data.
2- (Public data): Some useful webpages to access public data are provided below:

Task
Write a report containing the following 6 components: Each component should be a title on the report

1) 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.

2) 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.

3) 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 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.

4) 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?
5) Analysis and Discussion / Linear Regression
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.
6) 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.

Attachment:- Data Analytics.rar