After studying the Huskie Motor Corporation (HMC) case study (attached), please write a report containing critical analysis of the key issues, challenges, and
opportunities related to the organisation’s endeavour to capitalise on Data Analytics.
The following items are expected to be part of the report (this is an extract from the HMC Case):
1. Overall performance analytics:
How is HMC performing globally?
How are various HMC brands performing?
How are the various sales channels performing?
What are the most and least profitable models?
2. Financial analytics:
What is the current contribution margin (CM) per model?
What is the average variable cost per model, and how has that changed over time?
Which model has the most variability in variable costs?
What is the current CM per channel?
3. Operations analytics:
What model options are the top and bottom sellers?
How many days are the various models on the lot prior to sale?
Sales Volume –Four quarters in advance (Hint: use Forecast option in Tableau).
Contribution Margin –Four quarters in advance (Hint: use Forecast option in Tableau).
Once you have prepared the analysis, prepare an interactive dashboard for each of the four areas described earlier. The client uses Tableau for data
visualisation and would like you to create the dashboards using that software. You have been given some guidelines for preparing the business report (see
“HMC Guide attached). There are two additional requests:
You have to provide an infographic containing key findings of interest in your analysis of the HMC data. It is highly desirable that the infographic be created
using Adobe Spark (but you can use another tool such as Canva).
Client has been informed there may potentially be an issue with the HMC data. Hence, you are specifically asked to prepare a table with a list of issues (i.e.,
data discrepancies, missing values, data integrity issues) you encountered when reviewing the quality of the HMC dataset and what you have done with the
issues prior to analysing the data.
In your analysis of the case, please make sure you incorporate some of the following key issues, challenges, and opportunities:
The competitive landscape and the strategic positioning of the organisation in the competitive landscape of its industry (appropriate to the context of the
The key challenges/barriers, opportunities and values for growth, further developments of products and services through/associated with the use of data
(corporate and/or big data).
The key challenges/barriers, opportunities, and further developments of strategy and management practices in the attempt to effectively capitalise on data
(corporate and/or big data).
Potential of strategic alliances in data acquisition, management, and use of data (corporate and/or big data).
The strategic impacts on the organisation’s endeavour and intent on analytics and the use of Big Data to its customers, partners, staff, business processes
and/or activities, strategy, management processes/style, as well as its other constituents.
Issues pertaining data quality, ethical issues, privacy, security, and data ownership.
This is not about rewriting parts of the case study.
As part of a case study analysis, critical thinking, synthesis, analysis, and your professional views are critical to the task. These need to be informed and
supported by the appropriate literature (i.e., in-text references).
A minimum of 8 scholarly references (i.e., journal papers, conference papers) is required. It is important that you employ only resources which are accepted
as being scholarly and academically reliable (i.e., journal papers, conference papers). Wikipedia or to the individual opinions expressed in some Blogs and
Web articles are nice to read and may contain valuable information, but these are not regarded as “scholarly references”. The Swinburne University library