Lets Connect

Go to my LinkedIn 🌐

Go to My Dashboard

Developed Walmart Retail Data Dashboard which tracks the Profit, Sales and Discount in different categories. It's a Business ready Dashboard that allows employees to make data-driven decisions by evaluating each Metric. It is a dynamic dashboard.

The Walmart Retail data has 26 fields (city, customer name, order date, etc.) and 8399 rows.

1. Show the distribution of avg profit by states.
2. Analyze which state is generating more average profit and which is going in loss.
3. In which age range company is getting maximum profit
4. Show the average sales
5. Show the average profit
6. Show the average discount
7. Regional quarterly profit

1. South Dakota has the highest average profit $706 and Montana has the least profit -$186.

2. The age group 85 years have showed maximum average profit while age group 90-95 year have shown losses.

3. Average sales is $1,775.88

4. Average Profit is $181.18

5. Average discount is $0.05

6. In 2012 Q4 with $510 was the highest quarterly average profit from East region. In 2013 Q3 with $321 was the highest quarterly average profit from Central region. In 2014 Q4 with$383 was the highest quarterly average profit from Central region. In 2015 Q1 with $284 was the highest quarterly average profit from East region.

I have uploaded all the files, datasets, workbook, icons above. Feel free to use this Project's resourses for your next Project. If you like this Project and Dashboard give it a Star or just tell me. It'll make me feel Good :)

Go to my LinkedIn 🌐

• ATLIQ Sales Insight 💻

• Financial Consumer Complaints Data Analysis 📜

• KPI Dashboard of Car Sales Opportunities 🛰️

• Github Profile 🧮

• Linkedin 🤝