ONLINE RETAIL DASHBOARD USING PIVOT TABLE

Share Now


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 data set, 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:

Segment wise Pivot Table

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:

Category wise pivot table
sales and profit in pivot table
Pivot Table monthly sales graph


Share Now
November 14, 2019

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

    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    Address

    NM 23, SECTOR 14, OLD DLF COLONY,
    GURGAON (HARYANA)
    0124- 4601426

    Featured Testimonial

    The experience...Read more

    Karan Jeena (HR Analyst)

    ZS Associates

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED