Sales Performance Analysis for Philip Morris and Fortune Tobacco

As an Area Planning Assistant at Philip Morris and Fortune Tobacco Corporation, I was responsible for managing customer databases, preparing sales reports, and analyzing sales data to identify trends and insights. This project demonstrates my ability to transform raw data into valuable insights, driving strategic decision-making and revenue growth.

Data Management: Successfully managed and updated customer databases using SAS.

Sales Reporting: Prepared and consolidated sales reports, ensuring accuracy and consistency.

Data Analysis: Identified patterns and trends in sales data to support strategic decisions.

Collaboration: Coordinated with HQ SIA Supervisor and Document Controller to ensure report accuracy.

1. Data Collection and Preparation

Collected and cleaned sales data from internal databases, ensuring data accuracy and consistency for analysis.

2. Sales Trend Analysis

Analyzed sales trends over four years, identifying seasonal peaks and growth patterns using Power BI.

3. Customer Segmentation

Segmented customers based on purchase behavior and demographics, revealing key customer groups and insights.

4. Market Share Analysis

Assessed market share to understand competitive positioning and identify growth opportunities.

5. Interactive Dashboards

Developed interactive dashboards with Power BI to visualize sales performance, customer segmentation, and market trends.

6. Sample Sales Reports

Prepared detailed sales reports, summarizing key findings and actionable insights.

Increased Sales: Identified a 10% increase in sales during Q2 through trend analysis.

Customer Retention: Found that Segment A had a higher retention rate, enabling targeted strategies.

Market Growth: Helped increase market share by 5% in the last year through data-driven insights.

Conclusion

This project highlights my ability to manage, analyze, and visualize sales data, providing valuable insights that drive business performance. My contributions have led to increased sales, improved customer retention, and market growth for Philip Morris and Fortune Tobacco Corporation.