This project conducts an in-depth analysis of 5 years worth of sales data for various accounts, including wholesale distributors, online retailers, small businesses, and medium businesses. The dataset encompasses sales figures categorized by marketing channels such as social media, coupons, catalogues, posters, and more.
- Computes the 5-year compound annual growth rate (CAGR) for each account based on marketing channels.
- Determines the average CAGR by city, highlighting cities with the highest and lowest sales growth.
- Visualizes year-over-year sales figures and CAGR for each account through visually appealing charts and graphs.
- Analyzed 5 years of account sales data spanning multiple business segments.
- Calculated CAGR by marketing channel to pinpoint growth drivers and opportunities.
- Presented year-over-year sales and growth trends visually through Excel charts.
- Generated insights to enhance account performance and expedite sales growth.
The insights obtained aid in identifying the accounts, cities, and marketing channels propelling the most growth, as well as areas where improvements can be made.
In addition to the Excel files, I created a 5-slide PowerPoint presentation to showcase the key findings and recommendations from the analysis:
• Summary of accounts, period and data analyzed. • Charts showing CAGR by marketing channel and by city. • Tables with year-over-year sales and growth for high-performing and underperforming accounts. • Recommendations to improve performance for underperforming accounts and marketing channels. • Overall conclusions and next steps
Let me know if this updated project description works for your purposes or if you have any other changes/additions in mind. I'm happy to refine it further.