fannichsalma / sales_visualiastion_meriskill

MERISKILL-INTERNSHIP-SALES-ANALYTICS

Internship Project Showcase

🔍 Project Overview: Sales Analytics 📈

Objective: Analyzing sales data to uncover trends, identify top-selling products, and assess revenue metrics crucial for strategic decision-making. Summary: This project involved an in-depth analysis of a substantial sales dataset to extract actionable insights. I investigated sales trends over time, pinpointed top-performing products, computed key revenue metrics such as total sales and profit margins, and utilized visualizations to communicate findings effectively. Through this project, I demonstrated proficiency in handling and deriving insights from large datasets, facilitating data-driven recommendations to enhance sales strategies.

📈 Key Findings:

• Profitability Analysis: The overall profit margin is currently at 58.8%. We identified one segment with notably lower profit margins and three segments with significantly higher profit margins.
• Revenue Breakdown: Total global revenue amounts to $3,442,035.97. Revenue generated from MacBook Pro Laptops and other segments surpasses that of other products.
• Sales Volume: The global sales volume currently stands at 209,079 units. Sales volume in San Francisco and other segments outpaces that of other regions.

📊 Visualizations Created:

Sales Trends Over Time (Line Chart) Product Sales Distribution (Tree Map) Top 5 Best-Selling Products (Stacked Bar Chart) Top 5 Sales Regions (Map) Weekly Sales Distribution by Weekday (Column Chart)

🌐 Key Functionality:

Interactive Exploration: Users can interact with the data, zooming in on specific timeframes, products, or regions for detailed analysis. Dynamic Filtering: Implemented dynamic filters for easy customization of the dashboard based on user preferences. Profit Margin Assessment: Identified segments with significantly lower and higher profit margins to inform strategic decision-making. Revenue Comparison: Presented a clear visual comparison of revenue across different product segments to facilitate informed business decisions.

💼 Value Addition:

Enhanced Decision-Making: Empowers stakeholders to make well-informed decisions by visualizing trends, top-selling products, and revenue metrics. Sales Strategy Enhancement: Provides the organization with insights to optimize sales strategies based on identified patterns and trends.

👨‍💻 Technology Stack:

Visualization: Power BI

🙏 Acknowledgments:

I extend sincere gratitude to MeriSKILL for providing the opportunity to contribute to this impactful project! Your invaluable guidance played a pivotal role in bringing this Power BI dashboard to fruition. 🌐