157216 Management, Analytics and Decision Making

As abusiness analytics specialist, your job is to use Qlik Senseproduct to create a visual dashboard for HBHL, analyse existing data, and write a report for HBHLmanagement providing them with your analysis on sales data.Download HBHLdataset (HBHLDatasetVersion 2.xlsx)fromStream(under Assessment pageon Stream).It is a Zip file containing six Exceltables holding theInternet sales information of HBHLbetween 2011 to 2014. Then use what you learntinlectures and Qlik Senseworkshops to createauseful, informative, insightful and rich dashboard for HBHLmanagement to use. Think about whatdiagrams/visualisationswould be useful for the managers of HBHL (so should be on the dashboard). Then use your dashboard to analyse the HBHLsales dataand write your reportfor HBHL top management.The intention of the report is to provide a good and informative summary of data to HBHC management and bring the important and interesting highlights to theirattention. Think about it this way: How would you write the report if you were reallyastaffof HBHL and were asked to analyse the sales data and write a report for the top management?Bring in your judgment, imaginationand creativity. Creativity is the spice in real-world projects!What to includeand discuss in your report (and your dashboard) is ultimatelyyour choice.But as a guideline, your report, at least, should address the following points:1-Screenshot (or screenshots) of the dashboard (or dashboards) that you have producedwith Qlik Senseplatformfor HBHL management.At least 8 visualisations (graphs) by Qlik Senseplatformare required. 2-Analysis of status of sales from the perspective of product categories and sub-categories, location of sales, timing of sales, customers, and similar(both in dashboard and the report)3-Discuss some of the most interesting graphsthat you have created. What do they inform?

34-Identify and discuss any interesting insight you can find in the salesinformation that you would like to bring to the attention of the managers,e.g., any interesting pattern