Huski KPI Dashboard
Description
Huski Mountain Delivery
2020
A set of KPI dashboards showing live sales data which is automatically updated from different systems. Created in Google Data Studio it connects sales, finance and CRM data.
Includes:
- Users can select dynamic data such as order date range, product types, delivery location etc. to analyse trends and export reports.
- Automated PHP cron script to collect sales data from the Dear Inventory ERP system API and store for analysis in a MySQL database.
- Breakdown of sales per order date, delivery date, and source.
- Breakdown of products by sales performance.