- Extracted over 500,000 sales transactions using SQL queries. Cleaned and transformed data, addressing approximately 10% missing values, duplicates, and outliers
- Developed an interactive sales performance Dashboard in Power BI with 15 visuals. Integrated sales data with product information for real-time analysis of over 1,000
- Analyzed sales metrics over 24 months, revealing a 12% increase in year-over-year revenue. Identified a 7% improvement in profit margins following targeted sales
- The sales performance Dashboard facilitated data-driven decisions, resulting in improved sales forecasting, optimized inventory management and a 12% year-over-year
- Fostered stakeholder relationships, ensuring alignment with performance management and business analysis needs
- Technologies Used: SQL, Power BI (Data Modelling, Dashboarding, Reporting, DAX), ETL. Data warehouse, airflow, c++, writing, scope, recommendation, collaborate
- 1Stop research http communication