Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    A1522242063 - 15604 - 14 - 2020 - Asg 1 MKT504 Q1939

    Uploaded by

    Jyoti Arvind Pathak
    Students will analyze the sales, profitability, and liquidity of an assigned company over the past 10 years compared to two major competitors using Tableau. They will submit a Tableau workbook and world file. The assignment will be evaluated based on data collection and analysis (10 marks), graphical presentation of company performance compared to competitors (15 marks), and interpretation and reporting of results (5 marks).

    Copyright:

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

    A1522242063 - 15604 - 14 - 2020 - Asg 1 MKT504 Q1939

    Uploaded by

    Jyoti Arvind Pathak
    32 views4 pages
    Students will analyze the sales, profitability, and liquidity of an assigned company over the past 10 years compared to two major competitors using Tableau. They will submit a Tableau workbook and world file. The assignment will be evaluated based on data collection and analysis (10 marks), graphical presentation of company performance compared to competitors (15 marks), and interpretation and reporting of results (5 marks).

    Original Title

    A1522242063_15604_14_2020_Asg 1 MKT504 Q1939

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Students will analyze the sales, profitability, and liquidity of an assigned company over the past 10 years compared to two major competitors using Tableau. They will submit a Tableau workbook and world file. The assignment will be evaluated based on data collection and analysis (10 marks), graphical presentation of company performance compared to competitors (15 marks), and interpretation and reporting of results (5 marks).

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    32 views4 pages

    A1522242063 - 15604 - 14 - 2020 - Asg 1 MKT504 Q1939

    Uploaded by

    Jyoti Arvind Pathak
    Students will analyze the sales, profitability, and liquidity of an assigned company over the past 10 years compared to two major competitors using Tableau. They will submit a Tableau workbook and world file. The assignment will be evaluated based on data collection and analysis (10 marks), graphical presentation of company performance compared to competitors (15 marks), and interpretation and reporting of results (5 marks).

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 4

    Assignment 1 – MKT504

    BUSINESS INTELLIGENCE AND VISUALIZATION

    Topics: Students will do the performance analysis of assigned company (As per the template
    given in this assignment). Student will assess and analysis the sales, profitability and liquidity of
    the assigned company viz-a-viz two major competitors through Tableau. Student will be required
    to submit a world file as well as tableau packaged workbook.

    Section: Q1939

    Class Teacher: Dr. Harpreet Bedi (15604)

    Date of Submission: 30th March 2019

    Submission Mode: Online

    Evaluation parameters: Data collection and analysis-10 marks, Graphical presentation of


    company performance viz-a-viz competitors-15 marks. Interpretation and reporting of results -5
    marks

    Company Allocation

    Serial Registeratio
    No n Number Name Roll Number Company
    1 11900303 Hamid Hameed RQ1939A01 ACC
    2 11900367 Monika Sharma RQ1939A02 Aditya Birla Fashion
    3 11900442 Muhammed Minhaj RQ1939A03 Amara Raja Battery
    4 11900712 Upasana Katoch RQ1939A04 Ambuja Cement
    5 11906176 Subhadip Bhattacharya RQ1939A05 Asian Paints
    6 11906560 Aaliya Ashraf RQ1939A06 Bajaj Consumer
    7 11906902 Esaie Vasavi RQ1939A07 Bandhan Bank
    8 11907442 Nikita Agrawal RQ1939A08 Berger Paints
    9 11908414 Pragya Singh Chahar RQ1939A09 Bharti Airtel
    10 11908634 Isha aggarwal RQ1939A10 Britannia
    11 11908853 Nilakantha Mandal RQ1939A11 Cadila
    12 11909192 Harshit Rautela RQ1939A12 Canara Bank
    13 11909221 Uttam Dutta RQ1939A13 Castrol
    14 11909477 Akhil Haridas RQ1939A14 Century Plywood
    15 11909622 Naman Pare RQ1939A15 Cipla
    16 11909629 Narravula Deepa RQ1939A16 Coal India
    17 11909685 N S Shalini RQ1939A17 Dabur
    18 11909697 B Sai Mahesh RQ1939A18 Doller India
    19 11910040 Radhika Rani Kashyap RQ1939A19 Drup and Company
    20 11910215 Rajesh Nitharwal RQ1939A20 Eclerx Financial Services
    21 11910643 Swati Mishra RQ1939A21 Elgi Equipments
    22 11911515 Paramjeet Singh RQ1939A22 Exide
    23 11911608 Siyad Muhammed RQ1939A23 Federal Bank
    24 11913796 Ritu Pandey RQ1939A24 GAIL
    25 11913927 Sajid Ahmed Tariq RQ1939A25 Godraj Consumer
    26 11915300 Kirti Bansal RQ1939A26 Greaves Cotton
    27 11915890 Ritika RQ1939B27 Grrenply
    28 11918597 Lutfullah Eshraq RQ1939B28 Havells
    29 11918845 Debasmita Das RQ1939B29 HDFC Life Insurance
    30 11918877 Mufid Siddique RQ1939B30 Heromotorcorp
    31 11912724 Deepanshu Kumar RQ1939B32 IDFC First Bank
    32 11911697 Arun Kumar RQ1939B34 Infoedge
    33 11911730 Ankit Kumar Singh RQ1939B35 Infosys
    34 11911531 Sahib Jyot Singh Gill RQ1939B36 Johnson Control Hittechi
    Gidda Bhaskara Satya
    35 11909989 Prakash RQ1939B37 JTEKT India
    36 11910648 Ravi Kumar RQ1939B38 Jyothy Labs
    37 11910316 Deepanshu Raj RQ1939B39 Kajaria
    38 11910438 Prashant Thainua RQ1939B40 Kansai Nerolac
    39 11910540 Jyoti Pathak RQ1939B41 Khadim India
    40 11910111 Pushpendra Singh Chauhan RQ1939B42 Kitex Garments
    41 11909124 Shivani Sharma RQ1939B43 Liberty Shoes
    42 11909531 Aditya Sharma RQ1939B44 Mahindra and Mahindra
    43 11909287 Laiphrakpam Bijeta Devi RQ1939B45 Mahindra Holiday
    44 11909363 Siddharth Tomar RQ1939B46 NHPC
    45 11908436 Paras Mehta RQ1939B47 NRB Bearing
    46 11907569 Mohd Haris RQ1939B48 NTPC
    47 11907031 Amit Kumar Sahu RQ1939B49 ONGC
    48 11908205 Angel Garg RQ1939B50 Oracle Financial Services
    Sunkavalli Phani Sai
    49 11908250 Chandu RQ1939B51 Petronet LNG
    50 11906871 Simran Wadhwa RQ1939B52 Pidilite Industry
    51 11906899 Charde Ashwini Ravindra RQ1939B53 Raymonds
    52 11903051 Rishabh Dwivedi RQ1939B55 Safari
    53 11901305 Gul Ahmad Esmati RQ1939B56 Somany Ceramic
    54 11900598 Zaid Khan RQ1939B57 Tata Motors
    55 11919505 Mohammad Eklil Samadi RQ1939B58 Tata Power

    Template:
    Performance Analysis of ITC

    1. About ITC: Half Page


    2. Performance Analysis and Indicators: Half Page to one Page

    2.1 Sale Analysis: The revenue of the company has been assessed

    a. By looking at the absolute revenue of ITC of last 10 year


    b. By looking at the growth in sales of ITC of last 10 years
    c. By looking at the comparative sales of ITC viz-a-viz <Name of Competitors>
    d. By looking at the comparative growth in sales of ITC viz-a-viz <Name of Competitors>

    2.2 Profitability Analysis:

    The profitability of the company has been assessed

    a. By looking at the ROCE of ITC of last 10 year


    b. By looking at the EPS of ITC of last 10 years
    c. By looking at the comparative ROCE of ITC viz-a-viz <Name of Competitors>
    d. By looking at the comparative EPS of ITC viz-a-viz <Name of Competitors>

    2.3 Liquidity Analysis:

    The liquidity of the company has been assessed

    a. By looking at the CR of ITC of last 10 year


    b. By looking at the cash flows of ITC of last 10 years
    c. By looking at the comparative CR of ITC viz-a-viz <Name of Competitors>
    d. By looking at the comparative cashflows of ITC viz-a-viz <Name of Competitors>

    3. Data Analysis

    3.1 Sales Analysis

    One or two introductory Lines

    Required Charts/ Tables

    Interpretation
    3.2 Liquidity Analysis

    One or two introductory Lines

    Required Charts/ Tables

    Interpretation

    3.3. Profitability Analysis

    One or two introductory Lines

    Required Charts/ Tables

    Interpretation

    4. Conclusion: Half Page to one Page

    You might also like