Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    Devang SIP

    Uploaded by

    Pooja R Aakulwad
    The document analyzes retail sales data from India to make recommendations. It finds that office supplies have the highest demand. Furniture generates the least profit. Consumer sales are highest while home office sales are lowest. Some states and regions have much lower sales than others. The analysis recommends focusing on increasing sales of furniture, home office segments, and underperforming states and regions. Discounts should be kept below 25% to maintain profit margins.

    Copyright:

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

    Devang SIP

    Uploaded by

    Pooja R Aakulwad
    32 views12 pages
    The document analyzes retail sales data from India to make recommendations. It finds that office supplies have the highest demand. Furniture generates the least profit. Consumer sales are highest while home office sales are lowest. Some states and regions have much lower sales than others. The analysis recommends focusing on increasing sales of furniture, home office segments, and underperforming states and regions. Discounts should be kept below 25% to maintain profit margins.

    Original Title

    Devang SIP PPT

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document analyzes retail sales data from India to make recommendations. It finds that office supplies have the highest demand. Furniture generates the least profit. Consumer sales are highest while home office sales are lowest. Some states and regions have much lower sales than others. The analysis recommends focusing on increasing sales of furniture, home office segments, and underperforming states and regions. Discounts should be kept below 25% to maintain profit margins.

    Copyright:

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

    Devang SIP

    Uploaded by

    Pooja R Aakulwad
    The document analyzes retail sales data from India to make recommendations. It finds that office supplies have the highest demand. Furniture generates the least profit. Consumer sales are highest while home office sales are lowest. Some states and regions have much lower sales than others. The analysis recommends focusing on increasing sales of furniture, home office segments, and underperforming states and regions. Discounts should be kept below 25% to maintain profit margins.

    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 12

    Title

    Exploratory Data Analysis on


    Retail Data Using Python
    Company Profile

    ABOUT
    Industry: NGOs, Trust, Charitable Institutions
    Services: Education Management, Student
    Scholarship Program, Student Mentorship
    Program, Student SOS Program, Student
    Externships Program.
    Contact: +65-8402-8590,
    info@thesparksfoundation.sg
    Location: The hangar, NUS enterprise 21 Heng
    Mui Keng Terrace, Singapore, 119613
    7/14/20XX
    PITCH DECK TITLE
    OBJECTIVES SCOPE

    • To analyze the demand of different The analysis is performed on ‘Superstore


    product categories of retail superstore. Dataset’ which is of India and consist of 26
    states, also products are divided in three
    • To study the distribution and sales of categories as Office Supplies, Furniture and
    different product categories in the region. Technology which contains different sub
    categories, Also the customers are from three
    • To research about the segment wise segments i.e., Consumers, Home office and
    purchase and to get insights about which Corporate. And shipment is done in four
    category is sold highest among which different modes as Standard mode, First
    segment. Class, Second class and same day. And the
    language used to perform analysis is python.
    • To research about the mode of shipments
    category wise and region wise.
    • To analyse about the highest discount
    which retailer can give to keep profit
    margin.
    Research Methodology

    • Size of data: rows:9994 columns:12 Ship


    Mode, Segment, Country, State, Postal Code,
    Region, Category, Sub-Category, Sales,
    Quantity, Discount, Profit.
    • The ‘superstore-data’ is secondary data
    which is stored on database of ‘Superstore’.
    • Methods and technique used: exploratory
    data analysis by using python

    7/14/20XX
    Data Interpretation

    As per the data analysis Office supplies have


    Highest demand among all three categories
    As per data analysis profit generated through
    which are sold by superstore.
    sale of furniture is least among three categories
    As per research among all 26 states Karnataka has highest sales whereas Mizoram, Assam, Odisha has
    least sale we have to focus on these states to increase our sale SALE IN EACH REGION OF DIFFERENT
    CATEGORY
    • As per data analysis North and Northeast India are
    generating less profit as compared to central and
    south India.
    According to research sale in east region are highest but
    • Western and East India are generating highest profit.
    In northeast region sales are minimum
    • To analyse profit over region
    As per the research, to keep the profit margin the percentage discount should be less than 25%
    Findings
    • As per the data analysis Office supplies have Highest demand among all three
    categories which are sold by superstore.
    • As per data analysis profit generated through sale of furniture is least among three
    categories
    • As per data analysis highest purchases are in consumer segment whereas home
    office has least purchases in every category We need to focus on corporate and
    home office segment to increase our sale.
    • As per research there are three weak areas. As retailer is facing loss on Tables,
    Supplies(office supplies) and Bookcases.
    • As per research among all 26 states Karnataka has highest sales whereas
    Mizoram, Assam, Odisha has least sale we have to focus on these states to
    increase our sale.
    • As per research there are three weak areas. As retailer is facing loss on
    Tables, Supplies(office supplies) and Bookcases.
    • As per research among all 26 states Karnataka has highest sales whereas
    Mizoram, Assam, Odisha has least sale we have to focus on these states to
    increase our sale.
    • As per data analysis Office supplies is highest selling product in each region
    • As per data analysis standard class is most preferred mode of shipment in
    every region and same day is least preferred in each state. • According to
    research sale in east region are highest but In northeast region sales are
    minimum.
    • As per data analysis North and Northeast India are generating less profit as
    compared to central and south India.
    • Western and East India are generating highest profit.
    • As per the research, to keep the profit margin the percentage discount should
    be less than 25%
    7/14/20XX
    PITCH DECK TITLE
    Conclusion and Suggestion

    • AS OFFICE SUPPLIES IS HAVING HIGHEST DEMAND RETAILER SHOULD SALE OFFICE


    SUPPLIES AS MAJOR PART OF HIS SALE.
    • AS FURNITURE GENERATES VERY LESS PROFIT RETAILER SHOULD MINIMIZE SALE
    OF FURNITURE.
    • THE HIGHEST SALE IS DUE TO CONSUMER SEGMENT AND SALES FOR HOME OFFICE
    We based our research on
    CONSUMER ARE LEAST IN EVERY CATEGORY. HENCE RETAILER CAN ARRANGE
    market trends and stock market
    CAMPAIGNS FOR HOME OFFICE
    historical performance data
    • AS RETAILER IS FACING LOSS IN THREE SUB CATEGORIES AS TABLE, SUPPLIES AND
    BOOK CASES SO TO PREVENT MORE LOSS RETAILER SHOULD ARRANGE SOME
    MARKETING SKIMS TO INCREASE SALE.
    • SALES IN NORTH AND NORTHEAST REGION ARE LESS SO RETAILER SHOULD FOCUS
    ON THESE REGIONS TO INCREASE SALE OR SHOULD ARRANGE SOME DISCOUNT
    OFFERS.
    • AS STANDARD CLASS IS MOST PREFERRED MODE OF DELIVERY RETAILER CAN
    GIVE FREE SHIPPING.
    THANK
    YOU

    7/14/20XX
    PITCH DECK TITLE

    You might also like