Portfolio - Pritam Dan

Excel Project

Excel-Sales-Analytics

Domain/Function: FMCG

Analyzed ~800K FMCG sales records across 23 markets, 298 products, and 189 customers using Excel. Cleaned data with Power Query and built an interactive dashboard with Pivot Tables and slicers to track revenue trends, customer contribution, and market performance for better decision-making.

View Project
Engagement

View Project
on GitHUB

View Project
on

Other Tools

Power Query

Pivot Table

Slicers

Built an Excel dashboard to analyze market performance vs targets for AtliQ Hardwares. Used Pivot Tables, Power Query, and conditional formatting to track revenue trends, identify underperforming markets, and support data-driven decisions.

Built an Excel P&L dashboard to analyze financial performance across fiscal years. Evaluated net sales, COGS, and gross margin trends, highlighting growth and margin changes, and enabling clear insights for data-driven decision-making.

Project Details

Transformed 800K+ FMCG sales transactions into actionable insights by developing an interactive Sales Analytics Dashboard in Microsoft Excel. Utilized advanced tools such as Power Query, Pivot Tables, slicers, and KPI tracking to manage and analyze data across 23 markets, 298 products, and 189 customers.

Performed detailed analysis to uncover revenue trends, identify growth opportunities, and evaluate market performance against targets, highlighting underperforming regions. Assessed customer net sales to identify high-value contributors and analyzed product performance to determine top revenue-generating products.

Designed a user-friendly and visually intuitive dashboard, enabling stakeholders to explore data through interactive filters. The solution improved performance tracking, enhanced visibility into key business metrics, and supported data-driven decision-making for sales strategy and optimization.

Project video

PowerBI Project

Business-Insights-360-PowerBI

Domain/Function: FMCG

Built an end-to-end Power BI solution analyzing 1.8M+ records across Finance, Sales, Marketing, and Supply Chain. Created 5 interactive dashboards using Power Query, DAX, and star schema modeling for KPI tracking, profitability analysis, and executive insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

Power Query

DAX

SQL

Excel

Designed a Power BI dashboard for Business Insights 360 to track KPIs like net sales, gross margin, and forecast accuracy. Enabled trend analysis, market comparison, and interactive navigation for Finance, Sales, Marketing, and Supply Chain insights.

Power BI data model with a complex star-schema, linking multiple fact and dimension tables including Date, Customer, Product, Market, and Cost. Enables advanced analysis, reporting, forecasting, and calculation of key business measures efficiently.

Project Details

Built an enterprise-level Business Intelligence solution in Power BI to analyze 1.8M+ transactional records for AtliQ Hardware, replacing scattered Excel reports with a unified, scalable analytics platform. The solution enabled cross-functional analysis for Finance, Sales, Marketing, Supply Chain, and Executive teams. Designed a robust star-schema data model by integrating multiple datasets, applying Power Query for extraction, cleaning, and transformation. Developed advanced DAX measures to calculate key KPIs and metrics. Created 5 interactive dashboards covering Finance, Sales, Marketing, Supply Chain, and Executive insights to monitor revenue, gross margin, net profit, customer performance, and regional trends. This solution provided real-time performance tracking, improved visibility, and helped stakeholders identify top products, underperforming markets, and operational gaps, enabling data-driven strategic decisions.

Project video

Live Interactive Dashboard

SQL Project

sales-supply-chain-sql-analysis

Domain/Function: Sales & Supply Chain Analytics

Designed and analyzed a 7M+ record SQL project using star schema architecture, a custom forecast vs actual fact table, and advanced querying techniques including joins, CTEs, and window functions to drive business insights in sales and supply chain analytics.

View Project
Engagement

View Project
on GitHUB

View Project
on Github

Other Tools

MySQL

Data Modeling (Star Schema)

Excel (for validation)

Created a SQL-based supply chain analysis to evaluate forecast accuracy, net error, and customer-level sales performance across global markets. Identified planning gaps and business insights using advanced SQL queries on large-scale structured data.

Built a SQL query to measure forecast accuracy by comparing forecasted vs actual sales at the customer level. Used aggregations and error metrics to uncover planning gaps, evaluate demand performance, and support smarter supply chain decisions.

Project Details

Built an end-to-end SQL business analysis project on a large-scale dataset containing **7M+ records** to uncover actionable insights across **sales, customers, products, and supply chain performance**. The project involved **data cleaning, schema understanding, multi-table joins, aggregations, CTEs, subqueries, views, stored procedures, and window functions** to solve real-world business problems. Designed queries to analyze **top-performing products, customer trends, forecast accuracy, market performance, and operational efficiency**. Also worked with a **custom fact table** to compare forecast vs actual data and support decision-making. This project strengthened my ability to translate raw structured data into **business-driven insights**, while applying SQL in a practical, analytics-focused environment similar to real industry use cases.

Hello, I am

Pritam Dan

1

1

1

About

Key

My

Excel-Sales-Analytics

Business-Insights-360-PowerBI

sales-supply-chain-sql-analysis

My

Awards

Contact Me

Email

Github

Linkedin

Call

Pritam Dan

Download Resume