From job market trends to sales performance dashboards, these projects highlight my ability to turn data into results that inform decisions and drive efficiency.
SQL Project – Data Job Analysis
Overview
Analyzed job market trends for data-related roles using a structured SQL workflow. The project involved cleaning raw data, filtering for specific job titles (like Business Analyst, Data Analyst, and Data Scientist), and identifying hiring patterns across regions and skills.
Key Contributions
Wrote complex SQL queries to extract, join, and aggregate data from multiple tables.
Analyzed top cities, common job titles, and required skills.
Gained insight into which locations and skills are in high demand for data jobs.
Designed an interactive Excel dashboard to track and visualize key sales performance indicators, such as monthly revenue, product category breakdowns, and regional sales trends.
Key Contributions
Built dynamic dashboards using pivot tables, charts, and slicers.
Automated data updates for quicker monthly reporting.
Improved clarity and decision-making for non-technical stakeholders.
Tools Used
Microsoft Excel (Pivot Tables, Charts, Slicers, Conditional Formatting)
Created a Power BI dashboard to identify customer churn trends and visualize key churn drivers. This project supports business teams in proactively addressing retention issues.
Key Contributions
Built data model and DAX measures to track churn rate, customer tenure, and usage behavior.
Added interactive filters by geography, customer type, and plan.
Highlighted insights to reduce churn through data storytelling.
Conducted a sales performance analysis for Adidas products in the US using Excel. This project involved cleaning and analyzing transaction-level data to uncover sales trends by product category, location, and period.
Key Contributions
Built an interactive dashboard to track revenue, total units sold, and top-performing products.
Used pivot tables and charts to compare performance across regions and store types.
Delivered actionable insights to help identify growth opportunities and underperforming areas.
