Project: Sales Analytics Dashboard
Tools: Excel, Python, SQL, Power BI
- Performed data validation and cleaning to ensure accuracy, consistency, and reliability of datasets used for reporting.
- Extracted and transformed sales data from relational databases using optimized SQL queries for efficient analysis.
- Analyzed large datasets (millions of records) to identify trends in customer behavior, product performance, and regional sales.
- Optimized SQL queries to improve data retrieval speed and reporting efficiency.
- Developed interactive Power BI dashboards to track key business KPIs, including revenue, sales growth, and product performance.
- Conducted regional sales analysis to identify high-performing markets and underperforming areas.
- Automated reporting workflows using Python (Pandas) and Excel, reducing manual effort by 30%.