ONLINE RETAIL DASHBOARD USING PIVOT TABLE

Dashboard

Dashboards often provide at-a-glance views of KPIs (key performance indicators) relevant to a particular objective or business process. In the other, “dashboard” has another name for “progress report” or “report”.

In this article step by step will cover how to create dashboard using pivot tables.

Overview of the Data Set

In this sales dashboard we have used dummy retail dataset, which is keeping a track of product info, sales, customer info, and geographic info.

This dashboard contains four sections

• Segment-wise Sales Analysis
• Category-wise Sales Analysis
• No. of days vs No. of orders delivered comparison
• Monthly Sales Analysis

Let’s start step by step and close all four sections

Segment-wise Sales Analysis

To create segment-wise section, we have created segment-wise sales% pivot table and then we have created doughnut pivot chart using the same pivot table.

Segment-wise Pivot Table:

Segment-wise Pivot Chart:

Category-wise Sales Analysis:

To create category-wise section, we have created category-wise sales% pivot table and then we have created doughnut pivot chart using the same pivot table

Category-wise Pivot Table:

Category-wise Pivot Chart:No.of Days:No-of-Days_CHART:Sales_Pivot:Sales_chart:

November 22, 2018

0 responses on "ONLINE RETAIL DASHBOARD USING PIVOT TABLE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Tableau Training in Delhi  

    2012 - 2018

    LOKESH@EXCELCRAZY[DOT]COM

    Excel Crazy Analytics Services. All rights reserved.

    NM 23, OLD DLF COLONY, SECTOR 14, GURUGRAM (DELHI - NCR) 8826547882

    Drop us a Query

    Call Us: +91 8826547882

    Drop us a Query