Scribd Logo
Upload

Welcome to Scribd!

  • 30 views

    CTS Final Project

    Uploaded by

    nithya Anand
    This document describes a project analyzing sales data from European supermarkets. It contains information about the software used (Tableau), the scope of analyzing sales and finding ways to increase profits, and includes three dashboards visualizing different aspects of the data like sales by category, country, and manufacturer. The dashboards use various chart types like bar charts, scatter plots, and tree maps to visualize relationships in the data and identify trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    CTS Final Project

    Uploaded by

    nithya Anand
    30 views27 pages
    This document describes a project analyzing sales data from European supermarkets. It contains information about the software used (Tableau), the scope of analyzing sales and finding ways to increase profits, and includes three dashboards visualizing different aspects of the data like sales by category, country, and manufacturer. The dashboards use various chart types like bar charts, scatter plots, and tree maps to visualize relationships in the data and identify trends.

    Original Title

    CTS Final Project PPT (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes a project analyzing sales data from European supermarkets. It contains information about the software used (Tableau), the scope of analyzing sales and finding ways to increase profits, and includes three dashboards visualizing different aspects of the data like sales by category, country, and manufacturer. The dashboards use various chart types like bar charts, scatter plots, and tree maps to visualize relationships in the data and identify trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    30 views27 pages

    CTS Final Project

    Uploaded by

    nithya Anand
    This document describes a project analyzing sales data from European supermarkets. It contains information about the software used (Tableau), the scope of analyzing sales and finding ways to increase profits, and includes three dashboards visualizing different aspects of the data like sales by category, country, and manufacturer. The dashboards use various chart types like bar charts, scatter plots, and tree maps to visualize relationships in the data and identify trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 27

    Cognizant

    Project – EUROPEAN SUPERMARKET SALES


    Data Mentor:
    Batch-INTCDB22DW144 Ganesh Kumar

    Submitted By:
     Sofia Panda 2252335  Rishikeshan B J 2159019
     Nithya A 2148671
     Rishi R 2165830  S Tanvi 2165454
     Jhaideep Thodupunuri 2164603  Sandhya R 2125142
     Premsai Thanuku 2152212
     Jalaj Agarwal 2164409
    CONTENTS
     Introduction
     About the Software
     Scope of Project
     Dataset
     Dashboard 1
     Dashboard 2
     Dashboard 3
    INTRODUCTION
    PURPOSE & SCOPE OF THE DOCUMENT
     The purpose of the project is to analyze European market sales and it’s profits.
     This project helps us to visualize the sales data of different products and its
    subcategories at different regions.
     This project will help to save time , to visualize and understand the data
    thoroughly.
    ABOUT THE SOFTWARE

     Tableau is a fastly growing and powerful data visualization tool. Tableau is a business
    intelligence tool which helps us to analyze the raw data in the form of the visual
    manner; it may be a graph, report, etc.
     It is a self service bi tool, it can connect to 50 different data sources.
     Tableau provides a drag-n-drop facility to quickly let the users interact with the data.
    You can check some of the templates created using tableau in the tableau gallery.
     With Tableau’s gallery of templates, you can choose your option and customize it. With
    data visualization features, you can easily embed tons of information in the form of
    infographics that appeals to the audience.
     It can run on all operating systems.
    SCOPE OF THE PROJECT
     Themain objective of carrying out this analysis is to
    find out the reasons behind performance of
    supermarkets and ways through which super market
    managers can increase their sales through effective
    marketing strategy.
    DATASET
    DATA MODEL
    DATA MODEL
    DASHBOARD 1
    Sales and Profit per Order Date Year

    This is a dynamic bar chart where measure can be changed from profit to sales and
    vice versa. Each color and size of each bar represents the measure. Each bar
    represents the dimension.
    Sales Per Customer and Sales Forecast By Ship Date Year

    This charts compares two different measures, the blue bars are sales
    forecast and the orange area represents the sales per customer.
    Dimension is Year of the Ship Date.
    Sales By Order Quarter

    The color and slices of the pie chart represents the dimension Quarter of
    Order Date and the size of the each slices represents the sales.
    Sales By Order Month

    This line chart represents the sales of each year over the months.
    DASHBOARD 2
    Sales and Profit By Categories

    This Scatter plot represents the relationship Sales and Profit, where
    size of the bubble represents the number of units
    Sales for Top 5 Country By Quarter

    Stacked Bar chart shows the sales of top 5 countries in respective


    quarters and the size of each stack represents the sales.
    Profit By Top 10 Product and Sub-Category

    This Tree map explains the profit of Top 10 product as per product
    hierarchy. Size and color of each rectangle represents profit.
    Sales Per Customer by Region

    This chart shows values across multiple stages. The size of each
    segment represents sales in each region.
    DASHBOARD 3
    Top Ten Manufacture with High Profit

    This packed bubble chart represents top ten manufactures with high
    profits. The color and size of circles represents the profit.
    Profit By Country

    This chart represents profit in each country. The color in each


    country represents profit.
    Profit By Ship mode

    The color and segment of the donut chart represents the dimension ship
    mode and the size of the each segment represents the profit.
    Estimated Unit Sales For Top 5 Sub-Category

    Gantt chart represents the distribution of estimated units of sub


    category shipped over the years through different modes over the
    years.
    Thank Have a
    great day

    you!
    ahead.

    You might also like