Projects using Photopea in MakatiProjects using Photopea in Makati
Cover image for πŸ“Š Turning Data into Insights
πŸ“Š Turning Data into Insights with Excel! πŸ“Š I recently built this dynamic "Wastage Recovery Tracker" dashboard to help teams easily monitor costs, analyze categories, and track performance in real-time. Good data analysis isn't just about the numbersβ€”it's about making them clear, actionable, and visually engaging. πŸ“© Need a custom dashboard or data analysis design like this for your business? PM me directly, and let’s discuss how we can bring your data to life! #DataAnalysis (https://www.linkedin.com/search/results/all/?keywords=%23dataanalysis&origin=HASH_TAG_FROM_FEED) #ExcelDashboard (https://www.linkedin.com/search/results/all/?keywords=%23exceldashboard&origin=HASH_TAG_FROM_FEED) #DataVisualization (https://www.linkedin.com/search/results/all/?keywords=%23datavisualization&origin=HASH_TAG_FROM_FEED) #ExcelTips (https://www.linkedin.com/search/results/all/?keywords=%23exceltips&origin=HASH_TAG_FROM_FEED) #BusinessIntelligence (https://www.linkedin.com/search/results/all/?keywords=%23businessintelligence&origin=HASH_TAG_FROM_FEED) #FreelanceDataAnalyst (https://www.linkedin.com/search/results/all/?keywords=%23freelancedataanalyst&origin=HASH_TAG_FROM_FEED)
0
75
Cover image for πŸš€ Project Spotlight: Upgrading Excel
πŸš€ Project Spotlight: Upgrading Excel to an Executive Web-App UI πŸ“Šβœ¨ Most corporate reporting falls into two traps: it is either a dense, unreadable wall of numbers, or a pretty graphic that has to be manually redrawn every single week. I built this CL FY'2026 Market Performance Tracker to prove that you can achieve automated, heavy-duty backend engineering AND an immersive, software-like user experience entirely within native systems. Here is the exact 3-tier workflow behind this build: βš™οΈ Tier 1: The Automated Pipeline (Power Query) No manual data entry. No copy-pasting. Raw transactional data is fed directly into Power Query, which acts as the automated data-cleaning engine. With a single click, the query automatically shapes, cleans, and runs ETL processes on thousands of rolling rows, refreshing the dashboard in seconds. πŸ“Š Tier 2: The Core Logic Matrix (Dynamic Pivot Table & 3D Chart) β€’ The Grid: The transformed data consolidates seamlessly into a multi-period Pivot Table, mapping 15 distinct regional markets across an active 12-month calendar. It handles everything effortlessly, highlighting Market 5 as our heavy hitter with 2,936,685 in total volume. β€’ The Volumetric Display: The lower chart panel isn't a stagnant graphicβ€”it is a live, native 3D Pivot Chart configured into cylinder metrics. As new numbers hit the backend table, the liquid fill-levels automatically rise or drop in real time to show progress against a 6,299,300 Grand Total. 🎨 Tier 3: The Premium UI Skin (Photopea Enhancement) To lift the dashboard completely out of the standard "spreadsheet look," I engineered a high-fidelity background framework inside Photopea. Dropping the functional, live Excel components into this polished visual skin provides an immersive app environment, clean visual hierarchy, and polished title framing without compromising a single cell of live functionality. The Takeaway: Spreadsheets don't have to be boring to be powerful. By treating data architecture like a product, you give clients and executive teams instant clarity at a single glance. πŸ› οΈ Built with: Microsoft Excel (Power Query, Pivot Tables, 3D Charting) & Photopea (UI Layout Design).
0
88
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
107
Cover image for An interactive Power BI dashboard
An interactive Power BI dashboard designed to monitor pineapple production and packing performance from 2019 to the present year. The dashboard provides graphical insights into: Total Pineapple Boxes Packed – overall production/packing volume Daily, Weekly, Monthly, and Yearly KPIs – performance monitoring across different time periods Packing Trends – identifies production trends and changes over time Brand Distribution – boxes packed by brand Tag Distribution – analysis of packing tags Variant Distribution – comparison of different pineapple variants Pack Size Distribution – analysis of boxes packed by pack size Time-Based Analysis – allows users to drill into daily, weekly, monthly, and yearly performance The dashboard helps management quickly understand packing volume, production trends, and product mix, while identifying changes in brand, tag, variant, and pack-size distribution. Key value: Production data β†’ KPI analysis β†’ Trend analysis β†’ Product mix β†’ Graphical insights β†’ Better operational decisions
0
81
Cover image for An interactive Power BI dashboard
An interactive Power BI dashboard designed to provide clear graphical insights into coffee sales performance and customer purchasing patterns. The dashboard analyzes: Total Sales – overall coffee sales performance Total Cups Sold – total number of cups sold Monthly Sales KPI – tracks sales performance by month Sales by Month – identifies monthly sales trends Sales by Time of Day – compares morning, afternoon, and evening/night sales Sales by Product – identifies which coffee products generate the highest sales Product Performance by Time of Day – shows which coffee products perform best during morning, afternoon, or night The interactive visuals make it easy to identify top-selling coffee products, peak sales periods, and monthly performance trends, helping management understand customer purchasing behavior and make better sales decisions. Key value: Sales data β†’ KPI analysis β†’ Interactive visualization β†’ Customer insights β†’ Better sales decisions
0
90
Cover image for An interactive Power BI dashboard
An interactive Power BI dashboard designed to monitor and analyze carton wastage and its cost impact against the Annual Operating Plan (AOP). The dashboard provides daily, weekly, monthly, and yearly analysis of: Carton wastage and quantity trends Wastage cost impact vs. AOP Causes of damage and their contribution to total wastage Team performance, including the team with the highest damage Daily, weekly, monthly, and yearly trends Interactive buttons for easy navigation between different time periods Power BI Q&A page for users to ask questions and explore the data interactively The dashboard transforms raw operational data into clear graphical insights, helping management identify major wastage drivers, monitor trends, compare actual performance against AOP, and determine areas that require corrective action. Key value: From wastage data β†’ KPI analysis β†’ graphical visualization β†’ business insights β†’ actionable decisions.
0
88