Skip to content

This project analyzes 5 years of sales data for various accounts, including wholesale distributors, online retailers, small businesses and medium businesses. The data includes sales figures by marketing channel, such as social media, coupons, catalogs, posters and more.

License

Notifications You must be signed in to change notification settings

DataVisualizationExpert/Sales-growth-analysis-using-Excel-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

Project: Sales Growth Analysis using MS Excel

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.

Developed utilizing Excel formulas, pivot tables, charts, and graphs.

Key Features:

  • 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.

Dashboard Created:

Sales Account Data

Key Highlights:

  • 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

Slides :

Slide1 Slide2 Slide3 Slide4 Slide5

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.

About

This project analyzes 5 years of sales data for various accounts, including wholesale distributors, online retailers, small businesses and medium businesses. The data includes sales figures by marketing channel, such as social media, coupons, catalogs, posters and more.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published