At AI Variant, I completed a project-based Data Analyst internship focused on interactive business dashboards using real-world datasets. I worked on sales analytics and manufacturing operations.
For the AdventureWorks Sales Analysis project, I built an Excel dashboard to analyze sales trends, product performance, and revenue patterns, and developed a Power BI dashboard for regional sales and business metrics.
I also wrote SQL queries to analyze sales data and identify revenue trends, product performance insights, top revenue-generating categories, and seasonal demand peaks.
For the Manufacturing Analytics Dashboard (Axon Labels), I built an Excel dashboard tracking produced quantity, rejected quantity, and wastage percentage, and developed a Tableau dashboard for machine- and employee-level production performance. I consolidated fragmented production data into a structured dashboard and wrote SQL queries to analyze rejection and wastage trends.
