Business Intelligence Project

Sales Order Dashboard

Scroll

The KPI Chart to get overall information.

Image

Visualization for Quantity and Revenue by Date and Principal/Brand Filter

Image

Visualization for Quantity and Revenue Share of Principal and Brand. Also Quantity and Revenue by Month

Image

Visualization for Quantity and Revenue by Principal and by Brand to measure sales performance.

Image

Report of Monthly Average Basket Size by Store. Metric is count transaction, total quantity (paid) and total revenue (paid)

Image
Project Date June 2025 - July 2025
Role BI Dashboard, Pipeline, DAXs.
Client Distribution Company JLTR
Visit Github Repo
Tools Used:
Image
Image
Image
Image
Image

Designed and implemented a data solution that enabled stakeholders to track and manage sales order performance by principal, brand, and item. Sourced data from sales and customer databases, developed APIs from SQL queries, and integrated the results into a Qlik Sense dashboard via REST API. The dashboard monitored sales orders by both volume and revenue, and analyzed average basket size per store each month.

This provided consistent oversight of sales order trends, delivered actionable insights on principal and brand performance by location, and supported data-driven decisions on which principals offered the highest distribution potential.