Sharing the first task of my internship at The Sparks Foundation internship program. TASK : Exploratory Data Analysis- Retail In this dashboard, I've analyzed the sales performance and profitability across different regions, categories, segments and shipping modes to uncover key insights for driving business growth. Here's a breakdown of the key features: Data Cleaning and Analysis: Ensured data accuracy and reliability by checking for duplicates, null values and data types. KPIs: Monitored the business performance with important metrics including Total Sales, Total Profit, Total Quantity, Profit Margin, and Discount Rate. Regional Analysis: Used a slicer for region-wise analysis for a deeper understanding of business performance. Visual Insights: Profit by Category: Identified top-performing product categories using a bar chart. Profit by Shipping Mode: Visualized shipping preferences with a pie chart, understanding how different modes impact profitability. Profit by Segment: Explored customer segments with a donut chart. Profit vs Discount: Noted the relationship between profit and discount with a line graph. Total Sales by Category and Subcategory: Utilized a treemap to visualize sales distribution across product categories and subcategories. Average Sales of States: Mapped out average sales by state. Results : Total Sales: $2.3M Total Profit:$286.4K Total Products Quantity: 37.9K Profit Margin : 12.5% Discount Rate: 15.6% Highest Sales: West Region $725.5K Lowest Sales: South Region $391.7K Highest Profit Margin: West Region 14.9% Lowest Profit Margin: Central Region 7.9% Most Profitable Product by Category: Technology Most Profitable Segment : Consumer Most Profitable Shipping Mode: Standard Class YouTube Link: https://lnkd.in/da6rvN29 GitHub Repository : https://lnkd.in/dMmhJzqS Dataset: https://bit.ly/3i4rbWl Batch : #gripfebruary24 #dataanalysis #internship #TSFGRIP #gripfeb24
Arfa Ahsan
10mo
Congratulations on successfully completing the task 3 of the program. The sales dashboard is visually engaging, user-friendly, and provides valuable insights at a glance. Well done on delivering a top-notch Dashboard.Your work really stands out .Keep up the good work
Onaiza Reaz
10mo
Congratulations🌟, on showcasing your remarkable skills in data analytics during your internship.Your in-depth exploration of the Sample Superstore dataset using PowerBI is both impressive and insightful. Keep up the excellent work, and I look forward to seeing more from you!
Manahil Siddiqui
10mo
Amazing share!
Jyothi Mudisetty
9mo
Congratulations on completing this task. These insights are very clear and easy to understand .
Certified Data Analyst | Google Data Analytics | Power BI | Tableau | SQL | Python | Advanced Excel | DAX | ETL | Data Modeling | Expert in Delivering Actionable Insights
10moGreat job on completing task! Your Retail sales dashboard is visually striking, intuitive, and instantly informative. Excellent work on a standout Dashboard. Your data analytics talent during the internship, especially your detailed work with the Sample Superstore dataset using PowerBI, is impressive. Keep up the strong work, looking forward to more!