Hermawan Prabowo
Automated Google Sheets & KPI Dashboard Expert
- 1
- Followers
this is dashboard interactive database member jago bangunan made with looker studio
0
49
Project Name: Custom Data Pipeline & Dashboard Automation
Project Scope: > Built a robust automated system using Google Apps Script to manage large-scale data flows. This project involved writing custom scripts to automate data cleaning, aggregation, and reporting schedules. The result is a high-performance dashboard that updates automatically, reducing administrative overhead by 50% and ensuring data accuracy across all business units.
0
40
Project Name: Executive-Level KPI Visualization & Reporting
Project Scope: > Designed a clean, professional BI interface tailored for executive review. This dashboard focuses on high-level metrics such as Total Volume, Transaction Trends, and Sales Efficiency. By implementing a user-friendly UI/UX within Google Sheets, I enabled stakeholders to perform deep-dive analysis on regional performance without needing technical data skills.
0
38
Project Name: Automated Sales Performance & KPI Monitoring System
Project Scope: > Developed a centralized Google Sheets dashboard that consolidates complex sales data from multiple channels. The system tracks real-time KPI achievements, project visits, and switching volumes. By utilizing advanced QUERY functions and custom script logic, I eliminated manual data entry, providing the management team with a "single source of truth" for strategic decision-making.
0
42