π 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
### π 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
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