Profitability Analysis for Godswill Enterprise
Embedded Files
Project Description:
As a Data Analyst for Godswill Enterprise, I was tasked with utilizing the provided Sales Dataset to construct an interactive Excel dashboard. The primary objective was to answer critical business questions related to profit, seasonal trends, age group contributions, yearly performance, weekly patterns, gender impact, and top-selling sub-product categories.
Project Objectives:
Project Objectives:
Seasonal Profit Analysis:
Identify which of the seasons (Spring, Summer, Fall, and Winter) has the highest profit.
Age Group Contribution:
Determine which age group contributed the most to the business in terms of profit, categorized as Youth, Young Adult, Adults, and Seniors.
Profit Over the Years:
Analyze how profit is performing over the years.
Day-of-the-Week Profitability:
Identify which day of the week the company made the highest profit.
Gender Impact on Profitability:
Determine which gender contributed the most to the profitability of the company.
Top 10 Best-Selling Sub-Product Categories:
Identify the top 10 best-selling sub-product categories based on profit.
Project Tasks:
Project Tasks:
Seasonal Profit Analysis:
Analyzed profit data for each season to identify the season with the highest profit.
Age Group Contribution:
Grouped the age column into categories: Youth, Young Adult, Adults, and Seniors.
Calculated and visualized the profit contribution of each age group.
Profit Over the Years:
Tracked and visualized profit trends over the years to assess performance.
Day-of-the-Week Profitability:
Analyzed profit data by day of the week to identify the most profitable day.
Gender Impact on Profitability:
Analyzed profit data based on gender to determine the gender contributing the most to profitability.
Top 10 Best-Selling Sub-Product Categories:
Identified and presented the top 10 best-selling sub-product categories based on profit.
My Achievements:
My Achievements:
Informed Seasonal Strategy:
Provided insights into the most profitable season, guiding seasonal marketing and inventory strategies.
Age Group Profit Contributions:
Categorized age groups and identified the age group contributing the most to business profit.
Yearly Profit Performance Insight:
Tracked and visualized profit performance over the years, offering insights for strategic planning.
Optimal Day-of-the-Week Strategy:
Identified the most profitable day of the week, enabling targeted marketing efforts.
Gender-Specific Profitability Analysis:
Determined the gender contributing the most to profitability, informing targeted marketing approaches.
Focused Marketing on Top-Selling Sub-Product Categories:
Identified and presented the top 10 best-selling sub-product categories based on profit, guiding marketing and inventory management.
Recommendations to Management:
Seasonal Marketing Strategies:
Focus marketing efforts and inventory management on the season identified with the highest profit.
Targeted Age Group Campaigns:
Design marketing campaigns tailored to the age group contributing the most to business profit.
Yearly Performance Focus:
Continuously monitor and strategize based on yearly profit performance trends.
Strategic Day-of-the-Week Promotions:
Implement targeted promotions on the most profitable day of the week.
Gender-Specific Marketing Approaches:
Tailor marketing approaches based on gender contributing the most to profitability.
Promotions for Top-Selling Sub-Product Categories:
Design promotions or campaigns around the top 10 best-selling sub-product categories to maximize profitability.
Page updated
Google Sites
Report abuse