Aspiring Data Analyst | Data Cleaning • Google Sheets • SQL
In this project, I combined and analyzed sales and customer data using Google Sheets to uncover key business insights. The goal was to enrich raw transactional data and evaluate performance across customers and locations.
Joined datasets using VLOOKUP based on Customer_ID to enrich the data with customer details
Created a Total Revenue metric by calculating quantity and price per transaction
Built pivot tables to analyze revenue by customer and by city
Organized the data to support clear and efficient analysis
Jane Smith generated the highest total revenue among customers
Los Angeles was the top-performing city
Revenue patterns varied across customers and locations, highlighting key contributors to overall performance
Data Cleaning and Preparation
Data Joining (VLOOKUP)
Data Analysis (Pivot Tables)
Revenue Calculation and Business Insight Generation
This project demonstrates the ability to combine multiple datasets and transform raw data into meaningful insights that can support data-driven decision-making.