Scribd Logo
Upload

Welcome to Scribd!

  • 236 views

    Abintio Beginner 1

    Uploaded by

    manjula mishra
    This document contains sales figures for a retail store in 2013 including customer ID, name, store ID, transaction amount, and date. It also includes a table mapping store IDs to regions. It lists 5 questions/tasks: 1) Find the highest spending customer overall, 2) Find the lowest spending customers by region, 3) Create files of customers grouped by the region of stores they shopped at, 4) Generate rankings of customers from most to least spending, 5) Filter for customers whose names start with "V".

    Copyright:

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

    Abintio Beginner 1

    Uploaded by

    manjula mishra
    236 views2 pages
    This document contains sales figures for a retail store in 2013 including customer ID, name, store ID, transaction amount, and date. It also includes a table mapping store IDs to regions. It lists 5 questions/tasks: 1) Find the highest spending customer overall, 2) Find the lowest spending customers by region, 3) Create files of customers grouped by the region of stores they shopped at, 4) Generate rankings of customers from most to least spending, 5) Filter for customers whose names start with "V".

    Original Description:

    Assignments

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains sales figures for a retail store in 2013 including customer ID, name, store ID, transaction amount, and date. It also includes a table mapping store IDs to regions. It lists 5 questions/tasks: 1) Find the highest spending customer overall, 2) Find the lowest spending customers by region, 3) Create files of customers grouped by the region of stores they shopped at, 4) Generate rankings of customers from most to least spending, 5) Filter for customers whose names start with "V".

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    236 views2 pages

    Abintio Beginner 1

    Uploaded by

    manjula mishra
    This document contains sales figures for a retail store in 2013 including customer ID, name, store ID, transaction amount, and date. It also includes a table mapping store IDs to regions. It lists 5 questions/tasks: 1) Find the highest spending customer overall, 2) Find the lowest spending customers by region, 3) Create files of customers grouped by the region of stores they shopped at, 4) Generate rankings of customers from most to least spending, 5) Filter for customers whose names start with "V".

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Short Assignment 1

    For a retail store we have sale figures for 2013 as

    Cust_id Cust_name Store_id Transaction Transaction date


    Amount
    123 Abhishek 101 25696 01/01/2014
    156 Vivek 108 25888 02/01/2014
    756 Shobhit 107 24756 08/01/2014
    369 Manish 105 47565 05/01/2014
    258 Jitin 103 25874 07/01/2014
    369 Manish 112 35466 12/01/2014
    125 Vishal 104 100000 02/01/2014
    136 Advait 110 45635 03/01/2014

    Region Store id
    North 100
    East 101
    North 102
    South 103
    West 105
    North 106
    North 107
    East 108
    South 109
    West 110
    West 111
    East 112

    Create graphs for below questions (Q46-Q50) :

    1. Find the customer who has spent the highest amount overall

    2. Find the customers who have spent least amount per region. File should have Cust_id, Cust_name,
    Transaction_amount and Region.

    3. Create 4 files for 4 regions having details of customers who have done shopping in a region
    For example for East region the file should have the details of customers who have done shopping in stores

    1|Page
    belonging to eastern region.

    4. Generate the rankings of customers according to their spending from most stingy to most extravagant.
    5. Filter all the customer names starting from ‘V’.

    2|Page

    You might also like