QlikSense Dashboard

Done by: Ng Chuen Siong, Nelson

Objective

Build a dashboard to track a company’s product sales, profitability, and quantity ordered.

Procedure

Datasets
The main dataset is sourced from Kaggle¹, supplemented by additional self-generated datasets to demonstrate drill-down and rollup functions on QlikSense.

Refer to csv files within input_data.

Data Engineering
First, design the star schema for the project (see Data Model - Star Schema.pdf). Next, divide the main dataset into fact and dimension tables. Then, enrich the respective dimension tables with the self-generated datasets. Refer to ‘Data Engineering.ipynb’ for the data engineering work done.

Refer to csv files within star_schema_data.

Dashboard Design
Perform wireframing for the dashboard to visualize the layout and components on a piece of paper.

Build QlikSense Dashboard
Load the fact and dimension tables into QlikSense, and join them using associative joins to form the data model. Develop the dashboard based on the wireframe as a reference. Conduct data quality checks to ensure accuracy.

Operate QlikSense Dashboard

Upload the csv files within star_schema_data and Sales Performance Dashboard.qvf to QlikSense.

Refer to Sales Performance Dashboard - pg 1.pdf and Sales Performance Dashboard - pg 2.pdf for QlikSense Dashboard design.