Aastha Kansal's Work | ContraWork by Aastha KansalAastha Kansal
Data Analyst | SQL, Power BI, Excel & Python
E-Commerce Sales Dashboard Development Built an interactive sales dashboard using Microsoft Excel to analyze revenue, customer footfall, and product performance.
📊 Key Highlights:
• Total Sales: $698K+
• Peak Hours: 8–10 AM
• Coffee contributes 39% of revenue
• Friday has highest orders
đź› Tools Used:
â—ŹPivot Tables
â—ŹKPI Cards
â—Ź Slicers
â—ŹData Visualization Developed an interactive HR Analytics & Attrition Dashboard in Power BI to analyze employee attrition and workforce trends. Analyzed 1,470 employee records across age groups, salary levels, and departments, using KPI cards, charts, filters, and DAX to deliver actionable workforce insights. Built an AI-powered Business Intelligence Assistant that converts natural language questions into SQL queries using Google Gemini API. Integrated MySQL to execute queries and retrieve business data, then generated automated insights and visualized results using Matplotlib.