Detail-oriented Data Analyst with hands-on experience in data cleaning, ETL, exploratory data analysis, statistical analysis, KPI tracking, and business intelligence dashboard development using Excel, Power BI, SQL, and Python.
Bachelor of Management Studies (BMS), Marketing
May 2024
CGPA: 8.23 / 10
Built an interactive Power BI dashboard analyzing 279K+ listings, 182K+ hosts, and 5.3M+ reviews using DAX and data modeling. Conducted exploratory data analysis, identified the top three cities contributing 50% of listings and 48% of reviews, analyzed pricing trends and customer ratings, and generated business insights and reports for stakeholder decision-making.
Performed ETL using Excel, Power Query, and DAX on 15.69K+ transactions. Developed a Power BI dashboard analyzing $1.25B+ in revenue and tracking KPIs across products and regions. Identified a 29.72% cancellation rate causing $525M+ in revenue loss and provided data-driven recommendations.
Designed an Excel dashboard analyzing $2.26M+ in sales, 4.9K+ orders, and 793 customers using pivot tables and formulas. Conducted trend analysis and forecasting for 2015–2018 and identified key revenue drivers and high-performing categories.