In this project, I worked on cleaning raw sales data and transforming it into meaningful insights using Microsoft Excel. I applied pivot tables and interactive filters to organize information by city, product, payment method, and customer. The analysis highlighted key performance metrics such as total quantity sold, total revenue, and profit across five major cities.

Mumbai emerged as the top-performing city with the highest revenue and profit, while Chennai showed the lowest figures. The final dashboard included a 3D bar chart for clear visualization, making it easy to compare city-wise performance at a glance.

This project demonstrates my ability to:

Perform data cleaning and structuring

Build pivot tables for multi-dimensional analysis

Apply filters for dynamic exploration

Create professional charts for business insights

Impact: The analysis provided actionable insights into regional sales performance, helping identify strong markets and areas for improvement.

How can I work with clients?

.

Facebook & Instagram Ads Strategy

Client: Holhairs Industry: E-commerce / Beauty & Hair Platform: Meta Ads Services: Paid Social, Conversion Campaigns, Retargeting

Objective

Increase qualified website traffic, generate purchase intent, and drive online sales for Holhairs through Facebook and Instagram advertising.

Challenge

The brand needed a structured Meta Ads strategy that could move potential customers from initial discovery through to purchase while continuously identifying the audiences, creatives, and campaigns delivering the strongest results.

Strategy

I developed and managed a full-funnel Meta Ads strategy covering three key stages:

1. Traffic & Audience Testing

Drove targeted traffic to the website.

Tested different audiences and creative variations.

Used Meta Pixel data to identify high-intent users and build audiences for optimization.

2. Conversion Campaigns

Focused campaigns on website purchases.

Tested audience and creative combinations to identify stronger-performing segments.

Optimized campaigns based on purchase events and performance data.

Refined targeting and delivery to improve conversion efficiency.

3. Retargeting & Remarketing

Re-engaged website visitors and users who had previously interacted with the brand.

Used product-focused creatives and purchase-oriented messaging.

Targeted high-intent audiences who had not yet completed a purchase.

Continuously optimized campaigns based on conversion performance.

Results

Across the campaigns, the strategy generated:

303 website purchases

3,648 link clicks

2,465 link clicks from one traffic campaign

1,183 link clicks from another campaign

Multiple conversion campaigns generating 83, 161, and 59 website purchases

The campaign structure helped the brand build a stronger acquisition funnel, increase purchase intent, and generate measurable online sales through Facebook and Instagram.

Outcome

By combining audience testing, conversion optimization, and remarketing, I created a scalable Meta Ads funnel designed to continuously turn traffic and engagement into qualified customers and online purchases.

Great job