WAHANA STAR ELECTRONIC CASE STUDY
Transforming Raw Data Into Business Decisions
We help companies automate manual processes and turn scattered data into smart dashboards — giving teams clarity, speed, and control.
🧾 Client Profile
Retail Electronics Distributor – Wahana Elektronik (Semarang, Indonesia)
Wahana Star Elektronik distributes computer accessories, mobile devices, and gaming gear to over 30 outlets across Java. With growing scale, their management needed better visibility into sales, inventory, and financial data.
🛠️ Client Challenges
- Daily sales and stock data were collected via manual spreadsheets from each outlet.
- Reports were inconsistent in format, making it hard to consolidate or analyze quickly.
- Management decisions were delayed due to slow data processing (sometimes over 48 hours).
- There was no early-warning system for stock shortages or sales drops.
💡 Zavair Tech’s Solutions
Custom Data Analytics & Reporting Automation
- ETL Automation
Built a pipeline that pulls, cleans, and aggregates daily reports from each outlet’s Google Sheets folder using a scheduled Python script. - Centralized Sales Dashboard
Created a visual dashboard that displays real-time:- Daily and weekly sales by outlet
- Best-selling products
- Low-stock alerts
- Sales performance vs target
- Automated Email Reports
Set up a scheduled email every 6 AM that sends daily summaries to regional managers and finance team. - Forecast Module (Beta)
Implemented a simple predictive model to estimate stock depletion based on current trends, helping them prepare reorder plans in advance.
✅ Results & Impact
- Report availability improved from 2 days delay to real-time access.
- Regional managers now act on daily data before store opening hours.
- Sales meetings became data-driven with clear visualizations.
- Prevented multiple stockouts with the early-warning alert system.
- Manual consolidation work (±10 hours/week) is now automated.
