paraspahwa/comparison-of-region-based-on-sales

Comparison-of-Region-Based-on-Sales

Comparison of Region Based on Sales Course-end Project 2

DESCRIPTION

The director of a leading organization wants to compare the sales between two regions. He has asked each region operators to record the sales data to compare by region. The upper management wants to visualize the sales data using a dashboard to understand the performance between them and suggest the necessary improvements.

Objective: Help the organization by creating a dashboard to visualize the sales comparison between two selected regions.

Datasets: Sample Superstore

Steps to Perform:

Select Sample Superstore as Dataset

Use Sample Superstore Dataset

Select Data

Use Group by from Data Source Table on a Folder to create a folder to segregate the required data for Customer Name and Order ID inorder to organize the data thoroughly.

Create a hierarchy called Location for the variable Country.

Create two parameters: Primary Region and Secondary Region with all regions listed in them. Here, primary and secondary region are the two regions where the sales are being compared.

Create Parameters for Primary Region and Secondary Region

Create a Calculated Field for both Primary Region and Secondary Region

Create a First Order Date

Create a Calculated Field and name it as the First Order Date

Create a dashboard

Align all sheets in the dashboard

Partition the dashboard to display the below details of Primary Region and Secondary Region

First Order Date Total Sales Average Sales per Order No. of Customers No. of Orders No. of Products in Sale