[SOLVED] ISE328 Technology and Applications of Electronic Business Systems SQL

ISE328 Technology and Applications of Electronic Business Systems

Department of Industrial & Systems Engineering

Laboratory Assignment – Data Visualisation on Qlik Sense (20%)

Case Background:

Imagine that you are going to launch your own retail business in Hong Kong, but you have no idea about the current situation of the retail market. Thus, you are going to analyse the data published on the public sector information portal (DATA.GOV.HK) for getting some insights and business directions. The collected data are managed on Qlik Sense, and you have to build your own dashboard for effective data visualization. Subsequently, you can have a clear picture on the current retail market in Hong Kong, and select the suitable type of retail business. Through this laboratory exercise, you can

•    Know how to collect the data from DATA.GOV.HK

•    Understand how to conduct data visualization by using Qlik Sense, and data presentation in the storytelling mode.

Instructions of Building the Presentation:

1.   At the top of the first page of your assignment, write your full Englishname, student ID, and laboratory group.

2.   Insert your visualisation dashboard in your stories.

3.   Download a story as a PDF, using the data storytelling features in Qlik Sense.

4.   Answer all the questions listed in Parts A and B.

5.   Combine multiple pdf files (if any) into one single pdf file for submission.

6.   Upload a PDF file of your data storytelling to Blackboard.

Submit your answer about the below tasks in ONE single file (.pdf). Please name the file with your student ID, e.g. 12345678d.pdf.

Submission Deadline: 23:59 on 17th November, 2024

• It is an individual assignment.

• PolyU views plagiarism as a serious disciplinary offence.

• The report submission should be done via Learn@PolyU

Tasks-to-Do:

Datasets retrieved from https://data.gov.hk/en/

1.   Table 620-67001: Total Retail Sales [English]

2.   Report on Monthly Survey of Retail Sales [English]

*Hints: You can search the keywords to download these two datasets. You may need to do data pre-processing and cleaning before building data visualizations in Qlik, e.g. data sorting by specific year

Part A (10%): Overview of the Retail Sales

(i)        Create your data visualisation dashboard for the trend of total retail sales from

2005 until the present, by making use of at least FIVE types of data visualisation methods.

Discuss the following questions in the storytelling mode:

(ii)       Elaborate your observations of the changes of Hong Kong retail market in your story

(iii)      Analyse the variation of retail sales from  1st  January, 2019 until the present in your story

Part B (10%): Decision Support on the Retail Business

Assuming that you are going to launch your own retail business in HongKong, you are going to explore some insights from the ‘Repot on Monthly Survey of Retail Sales ’.

(i)        Create your data visualisation dashboard to answer the following questions, by making use of at least THREE types of data visualisation methods

Discuss the following questions in the storytelling mode:

(ii)       Is non-store retailing a good choice in the current retail market? Why?

(iii)      Which retail outlet would you consider for your coming retail business? Why?