Aastha Kansal
Data Analyst | SQL, Power BI, Excel & Python
- 3
- Followers
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.
E-Commerce Sales Analysis Dashboard — Excel
