Excel and Business Analytics Dashboard
A self-initiated Excel dashboard built on a fictional sales dataset, with automated data cleaning, pivot summaries, and a monthly social media content plan.
Overview
This personal project turns a messy sample sales export into a one-page dashboard that a small business owner can refresh in a few clicks, plus a content calendar that connects sales insights to social posts.
The dataset is fictional and was created for practice. Figures in the preview do not describe any real business.
The challenge
Many small businesses keep data in spreadsheets but spend hours each month reformatting it before they can see what is happening.
The approach
Clean and shape the raw data with Power Query, model it with structured tables and pivots, present key indicators on one sheet, and document the refresh steps.
Key features
- Power Query cleaning and transformation steps
- Structured tables with XLOOKUP and dynamic arrays
- PivotTables, slicers, and charts on a single dashboard
- Monthly and category comparisons
- Social media content calendar template
- Step-by-step refresh documentation
Highlights
Refresh, don’t rebuild
New data flows through the same cleaning steps automatically.
From numbers to posts
Insights feed directly into a practical content calendar.
More projects
- Demo ProjectAutomation
Smart Lead Capture Automation
A Google Apps Script system for a fictional marketing agency: form inquiries are saved to a sheet, repeat submissions are filtered, and the agency and customer are emailed automatically.
- Google Apps Script
- Google Forms
- Google Sheets
Demo ProjectOptimizationSpeedBoost Website Performance Case Study
A demo agency website built with Next.js 16 for a measured Lighthouse study. Four performance problems were added on purpose, then removed, taking the mobile home page score from 56 to 91.
- Next.js
- React
- TypeScript