About
Aspiring Data Analyst pursuing a B.Com (Hons.) with hands-on experience in Excel, SQL, and Power BI. Skilled in data cleaning, dashboard development, and turning raw data into actionable business insights.
Education
-
B.Com (Hons.)Acharya Jagdish Chandra Bose CollegeCommerce · Jun 2023 – Jun 2026
Skills
Projects
-
Excel
Built an interactive HR dashboard to analyze employee performance, attrition, demographics, and job satisfaction. Used Pivot Tables, Pivot Charts, KPIs, and Slicers for dynamic analysis. Analyzed attrition, department distribution, gender diversity, and job satisfaction trends.
-
Excel
Developed an interactive Excel dashboard to analyze sales performance and key business metrics. Used Pivot Tables, Pivot Charts, KPIs, and Slicers to create dynamic visualizations. Cleaned and analyzed sales data by region, product, and category.
-
SQL
Analyzed 21,350 orders and $817,860.05 in revenue using MySQL. Identified top-performing pizzas, categories, sizes, and ordering patterns. Used SQL aggregations, joins, subqueries, and window functions to generate business insights.
-
Power BI
Built an interactive dashboard analyzing $2.30M sales, $286.40K profit, and 5,009 orders. Used Power Query and DAX to create KPIs and analyze sales trends, categories, regions, products, and customer segments. Added interactive Region, Category, and Date slicers for dynamic analysis.
Courses & certifications
- Data Analytics ↗ · TuteDude · 2026