ICT601 Business Analytics

Semester 2, 2019
This is an Individual Assignment. Students are reminded of their obligations with regard to academic integrity. If you are not clear as to what this involves, please see the link below.
The Assignment has two parts.
Part A involves you performing a set of analyses on a given dataset in order to answer a number of questions relevant to that dataset. You will present these analyses in a written document as well as creating and submitting a Tableau file to demonstrate the analyses.
Part B is a report on a business intelligence and analytics platform.
It is your responsibility to keep a copy of any work handed in for assessment purposes. It is recommended that you keep both a hard copy (if applicable) and an electronic copy.
Assessments that are not received by the due date will not be accepted and result in a Fail grade being recorded for the unit. Applications for extensions should be made as soon as a problem is experienced, and any supporting documentation should be attached.
This unit uses software called Urkund when viewing work that you submit. Urkund is a pattern-matching system designed to compare work submitted by students with other sources from the internet, journals/periodicals, and previous submissions. Its primary purpose is to detect any submitted work that is not original and provides a thorough comparison between the submitted document and the original sources.

Part A

You used the Global Superstore data set for several of the homework exercises in the unit. This assignment will require you to use that dataset, suggest some other datasets that might be used to answer the questions, and to perform a number of analyses. You will present these analyses in a written document as well as creating and submitting a Tableau dashboard to demonstrate the analyses.

There are four tasks listed below. For each of the tasks you need to:

1. Explain what data you will be using in order to determine the answer to the question that has been asked
2. Include a screen shot of the visualisation or visualisations you have used to answer the question
3. Provide a one paragraph explanation of your visualisation(s) and how it (they) have answered the question
4. Provide a list of any other data you would use in order to explain the result at which you arrived for the task.

When you have completed the four tasks, you need to create a single dashboard that includes the visualisations you used for each of the tasks.

TASK 01:

2014. Determine whether any of the Australian States or Territories had a negative profit (loss) in 2014.
2015. Provide a possible explanation as to why this might be the case.

TASK 02:

2014. Determine which Australian State or Territory had the highest Sales in the period 2011-2014.
2015. Provide a possible explanation as to why this might be the case.

TASK 03:

1. Describe which Product Category has the highest total sales (in dollars).
2. Explain how this is related to the Profit for that Product Category.
3. Provide a possible explanation as to why this might be the case.

TASK 04:

2014. Describe how the Sales and Profits for Western Australia and Victoria have changed over the period 2011-2014.
2015. Provide a possible explanation as to why this might be the case

Part B

Select one Analytics and Business Intelligence Platform (not Tableau, AND NOT THE PLATFORM ABOUT WHICH YOU WROTE IN ASSIGNMENT 01) from the list at:

Prepare a report on its capabilities. You should use sources external to the vendor as much as possible (and, of course, include the references for all sources to which you refer).

The report should be 1000 words in length (not including references) and should, at a minimum, include detail about what platform you investigated, what you found out about it, scenarios in which the platform is seen to perform well, and those where it might not be an appropriate choice.

If you would prefer to use a different style, please discuss it with the unit coordinator.