Projects using Google Sheets in MakatiProjects using Google Sheets in Makati
Cover image for Engineered an automated ingestion pipeline
Engineered an automated ingestion pipeline that captures inbound lead payloads via webhooks. The system instantly normalizes erratic form data using field-editing logic and synchronizes records directly into a master tracking sheet for zero-latency data retention.
0
104
Cover image for ### 🍍 Fruit Sales Data
### 🍍 Fruit Sales Data Analysis – Interactive Power BI Dashboard An interactive Power BI dashboard designed to analyze fruit sales performance and provide clear graphical insights into revenue, sales volume, product, size, and geographic performance. The dashboard includes: Sales Revenue – total revenue generated from fruit sales Total Sales Quantity – total quantity of fruits sold Sales by Fruit Name – compares sales performance across different fruits Sales by Size – analyzes sales across different fruit sizes Sales by City – identifies sales performance by city Sales by Country – compares sales across countries Sales per Month – monitors monthly sales performance Revenue per Month – tracks monthly revenue trends Sales Trend by Fruit – analyzes monthly sales trends by fruit name Geographic Sales Analysis – identifies locations with the highest and lowest sales performance The interactive dashboard allows users to explore product, size, time, and geographic sales patterns, helping identify top-performing fruits and markets while supporting data-driven sales and business decisions. Key value: Sales data β†’ KPI analysis β†’ Product & size analysis β†’ Geographic analysis β†’ Monthly trends β†’ Graphical insights β†’ Business decisions
0
106
Cover image for Implemented and followed structured customer-support
Implemented and followed structured customer-support workflows and SOPs to ensure consistent, efficient, and high-quality case handling. I triaged and prioritized tickets, followed response guidelines, documented interactions, handled escalations, coordinated with other teams, and followed up to ensure cases were properly resolved.
0
40