Global Store Sales Analysis.

The data set included 51k rows and had columns namely sales,profits,categories,regions,shipping etc. The data was available in excel format which was loaded in PowerBi and transformed using Power Query. Data cleaning was done using power Query,along with the various DAX functions which were also used in this process. Page Navigator is used for easy navigation between different dashboards. The visualization was done using PowerBi.

The following areas were analyzed and insights were provided.

1. The data was divided between 23 Regions,165 countries,3 categories,17 sub-categories, and 3 segments.
2. It was observed that the max orders were received from the Western Europe region and the least from Central Asia.
3. The office supplies have seen the max sales consistently for all the years and have also been the max profit share holder.
4. All the sub-categories were profitable except Tables(Furniture),it had seen a loss of -8.46% on an average.
5. The top 5 items to be sold included 50% items from the Technology and Furniture section and only 10% items from Office sales.