Global Store Sales Analysis-II

Return Products table consisted of 2220 rows which was available in Excel and was loaded in PowerBi for data cleaning and visualization.

The main table(Global sales) was left joined with return table to analyse the data as per the given categories.

A Page navigator was used in the second dashboard as well to ease the navigation process between both the reports.

The following areas were analyzed during the report creation for 2220 returned items.

1. Quarter wise return rate-It was found that Quarter 4 has seen a tremendous return rate from year 2014-2015
2. Region wise distribution- It was found that Asia-Pacific has observed the majority of returns.
3. Category wise- It was observed that Office supplies faced the max return even though they are the major profit sharing supply.
4. Segment wise- Consumer segment observed the max rate of return as compared to Corporate and Home-Office.