WALMART SALES DASHBOARD

This dataset was cleaned with Power Query and visualized with Power BI. Before visualization, new measures were created using the necessary DAX functions and formulas. Data types were adjusted, and missing values were handled accordingly.

Problem Statements

What was the total sales amount in 2014, and how did it compare to the previous year's sales performance?

How did the key performance indicators such as total quantity, profit, orders, and average order value change in 2014 compared to the previous year?

Monthly Sales Performance:

Which month in 2014 recorded the lowest sales, and what was the sales figure for that month?

During which month in 2014 were the highest sales recorded, and what factors contributed to this peak?

Shipping Analysis:

What percentage of the total orders were shipped early(within 48 hours)and how does this compare to the percentage of late shipments?

Regional Sales Comparison:

Among the top five regions, which one recorded the highest sales, and what was the total sales amount?

Which region had the lowest sales among the top five, and how significant was the difference compared to the highest?

Product Category Performance:

Which product type had the highest sales in 2014, and what was the total sales amount for that category?

Which product category had the lowest sales, and how did it compare to the category with the highest sales?

Day of the Week Sales Patterns:

On which days of the week were the highest and lowest sales consistently recorded, and what trends were observed?

Answers

In 2014, total sales were $111,000, which represents an increase of 22% compared to the same period last year. Total quantity grew by 38%, total profit grew by 98.23%, total orders grew by 22%, while the average order value dropped by 5.26%.

Moreover, the lowest sales month was April, with a sales figure of $3,439, while the highest sales for the year were recorded in December. Of all the total orders, only 23.6% were shipped early, while the remaining 76.4% were shipped late.

California had the highest number of sales at $72,000 among the top 5, while Oregon had the least among the Top 5

Of all the product types, accessories had the highest sales of $13,000, while fasteners had the lowest sales for the year 2014.

Lastly, Fridays consistently have the highest number of sales, followed by Thursdays, while Sundays consistently have the least amount of sales.