Aritra Mondal

Analyzed bike sales dataset in Microsoft Excel to uncover customer demographics, income patterns, and factors influencing purchase decisions.

Cleaned and transformed raw data using Excel functions (IF, VLOOKUP/XLOOKUP, TEXT, data validation) to ensure accuracy and consistency.

Created Pivot Tables and Pivot Charts to evaluate sales trends by age group, gender, region, and commute distance.

Built an interactive dashboard with slicers and KPIs to visualize bike purchase behavior and key sales insights.

Generated actionable insights to support marketing targeting and product positioning strategies.

Analyzed product sales dataset in Microsoft Excel to evaluate revenue trends, product performance, and regional sales distribution.

Cleaned and structured raw sales data using Excel functions (IF, XLOOKUP/VLOOKUP, TEXT, conditional formatting) to ensure data accuracy.

Built Pivot Tables and Pivot Charts to compare category-wise sales, monthly revenue trends, and top-selling products.

Developed an interactive Excel dashboard with slicers and KPI metrics (total sales, profit, growth %) for business insights.

Derived actionable insights to support inventory planning, pricing strategy, and sales optimization.

Analyzed retail sales dataset using SQL to extract insights on product performance, customer purchasing behavior, and regional sales trends.

Designed and executed complex SQL queries (JOIN, GROUP BY, window functions) to compute KPIs such as revenue, average order value, and category-wise sales contribution.

Identified top-selling products and high-value customers through aggregation and ranking techniques, enabling data-driven business insights.

Performed data cleaning and transformation in SQL to handle missing values and ensure accurate reporting.

Developed summary tables and reports to support decision-making for inventory planning and marketing strategy.