TechMart Electronics — 3 Sheet

TechMart Electronics — 3 Sheet Merge, Pivot & Automated Dashboard A US electronics retail store came to me with 3 completely disconnected sheets — sales transactions, product details, and customer records — and no way to see how their business was actually performing across 4 states.

The raw data had duplicate transactions, Inconsistent entries throughout, missing revenue on 14 rows and no connection between any of the sheets.

I cleaned all 3 sheets independently, merged everything into one master sales table, calculated all missing revenue and profit figures automatically and built a pivot view comparing performance across all 4 states per product category.

Final delivery included an input sheet with dropdown validation so new data is always entered correctly, and a summary dashboard with total revenue, total profit, top sales rep, best performing state and two dynamic charts — All updating automatically updated with one click.