Data Analyst
Welcome to my project showcase! Each project reflects my journey in data analytics—solving real-world problems through data cleaning, analysis, and visualization. From building dashboards to uncovering insights with SQL and Excel, these projects highlight my technical skills and analytical thinking.
PROJECTS
📊 Tableau Dashboard: Sales & Customer Insights
I built an interactive dashboard suite in Tableau Public to visualize key metrics across sales performance and customer behavior.
🔍 Key Features:
-
KPI tracking for sales, profit, and quantity
-
Product subcategory analysis to spot top and low performers
-
Customer segmentation by order frequency
-
Profit contribution by top customers
💡 Outcomes:
-
Identified sales growth and customer acquisition trends
-
Uncovered margin gaps in product lines
-
Highlighted retention and loyalty opportunities
Tools Used: Tableau Desktop Public Edition (KPI tiles, trend lines, bar charts, segmentation tables)
Scalable | Time-Agnostic | Actionable.
📊 Data Warehouse & Analytics Pipeline
Tech Stack: SQL | ETL | Data Modeling
🔹 Project Overview
I designed and implemented a data warehouse that integrated multiple datasets (sales, customer, and product) into a unified source of truth for analysis. The project focused on building scalable pipelines, efficient data models, and optimized queries for faster reporting.
🔹 Key Contributions
-
ETL Development: Built SQL-based pipelines to clean, transform, and load raw data into a star schema.
-
Data Modeling: Designed fact and dimension tables to support advanced analytical queries.
-
Performance Optimization: Improved query efficiency by 40%, ensuring faster data retrieval and reporting.
🔹 Impact
This project demonstrated my ability to design scalable data systems and transform raw data into structured insights, enabling data-driven decision-making.
Coffee Sales Dashboard
📊 A comprehensive dashboard project analyzing global coffee sales from 2019 to 2022. It features interactive filters for roast type, size, and loyalty card usage. Key insights include:
-
Top-selling countries: United States leads with $35K+ in sales.
-
Popular coffee types: Arabica and Liberica show consistent demand.
-
Customer analysis: Highlights top 5 high-value customers.
-
Trends over time: Identifies seasonal spikes and sales patterns.
The dashboard empowers business teams to make data-driven decisions on marketing, inventory, and customer engagement strategies.
