Aspiring Data Analyst | Data Cleaning • Google Sheets • SQL
In this project, I designed and built an interactive sales dashboard in Google Sheets to analyze revenue performance across products, customers, and locations. The objective was to transform raw transactional data into clear, visual insights that support data-driven decision-making.
Cleaned and structured sales and customer datasets for analysis
Combined datasets using VLOOKUP to enrich transactional data
Created a Total Revenue KPI to summarize overall performance
Built pivot tables to aggregate revenue by product, city, and customer
Developed a dashboard with charts and slicers for interactive data exploration
Data Cleaning and Preparation
Data Joining (VLOOKUP)
Data Analysis (Pivot Tables)
Dashboard Design and Data Visualization
Interactive Filtering (Slicers)
Business Insight Generation
Los Angeles is the top-performing city, contributing the highest share of revenue
Jane Smith is the highest-value customer
Salad and Pizza are the leading revenue-generating products
These insights highlight key drivers of performance and help identify areas for strategic focus.
This project demonstrates the ability to build an end-to-end analytical workflow—from raw data to an interactive dashboard—delivering clear, actionable insights for business decision-making.