DSAI 203 Project

Who will use the Dashboard?

Sales department, Company CEO

Data available by the client

Transactional data includes:

• dateSold On which day was the product sold
• item which item was sold
• qty quantity was sold
• price sold at what price
• lat delivary Latitude
• long delivary Longitude
• gender gender of person purcheased the device
• rating rating after using the device
• soldFromBranch from which the device was ordered

Dashboard Questions

1. What is the overall trend in sales over time based on "dateSold"?
2. What is the quantity of each item sold in year?
3. How does the quantity sold vary across different items?
4. Are there geographic patterns in sales based on "lat" and "long"?
5. Which branch has the highest sales?
6. Are there specific items that are more popular among a particular gender?
7. Which branch has the highest sales and which has the lowest?
8. What is the rating of each item for each item branch and year?

Charts

All Charts are visable all the time

1. Data By Product

Figure 1 data by products in dashboard

Shows Total Sales in USD and quantity of sold items an of each product and items ordered descending according to total sales

2. Sales Trend Line Chart

Figure 2 Sales trend

Colors

Auto generated by AmCharts5 for each product

Axies Names

• X axies: Date
• Y Axies: Quantity sold
• Lines: Each line represents the sales of a product

Legend

Containes the line of each item in the chart

Questions Answered

Questions 1,2,3

3.Sales by Gender Stacked Bar

Figure 3 sales by gender

Colors

Auto generated by AmCharts5 for each product

Axies Names

• X Axies: Product Names
• Y Axies: Quantity sold
• Stacked Bars: Each line represents the sales of a product

Legend

Controls Bars of Male and Female bars

Questions Answered

Questions 3,6,7

4. Sales by Region Maps Chart

Figure 4 Demographic Sales

Colors

Auto generated by AmCharts5 for each product

Axies Names

• Dots represents sales in a region

Questions Answered

Questions 4

5. Rating by Gender Bar Chart

Figure 5 Rating by gender

Colors

Auto generated by AmCharts5 for each product

Axies Names

• X Axies: Product Names
• Y Axies: Average Ratings
• Bars: Each bar represents the rating of a product by gender

Questions Answered

Questions 6,8

6. Filter Section

Figure 6 Filter items

Updates all charts dynamically

Questions Answered

All Questions

Discussion

Why are the charts in their positions ?

• Figure 1 On the top for the sales Because the user needs to know sales by numbers
• Figure 2 Left first row After knowing sales by numbers to know the general trend
• Figure 3 Right first row After knowing sales trend and user need to sales by gender and the users read Left-to-right
• Figure 4 Left Second row to know the sales distribution around the globe
• Figure 5 Right Second row to know ratings after the number of sales

Future Work

• Make color themes for the dashboard
• Improve fonts and font sizes
• Reduce clutters in graphs

How to Run

• Run $ py server.py
• Launch in browser https://localhost:5000

Implementation Details

• Data is generated using class DummyDataGenerator
• Data is saved to sqlite database
• Queries are run and results returned in pandas DataFrames
• DataFrames are serialized to JSON string and sent to Front End