Polycarbonate Segment Data Analysis

Client: Deepak Advanced Materials Limited
Duration: 2 Months
Role: Business Data Analyst (Intern, Freelance-style)

Project Title: Customer Behaviour & Data Analysis in Polycarbonate Segment.

Analyzed production, sales, and customer data for polycarbonate and PC-ABS alloys.

Created interactive dashboards to track performance KPIs, sales trends, and inquiry-to-order conversion rates using Power BI and Excel.

Designed Microsoft Forms to digitize processes like inquiry capture, price listing, and customer feedback collection.

Built automated tools for forecasting demand, tracking follow-ups, and monitoring sales pipelines.

Integrated import-export data to assist in decision-making regarding international trade and pricing strategies.

Helped streamline reporting and performance monitoring, improving visibility for leadership and sales teams.


Tools Used: Excel (Power Query, Pivot Tables), Power BI, Microsoft Forms

Impact: Improved decision-making speed, enhanced visibility into sales pipeline, and optimized customer feedback collection process.