TATA VIRTUAL EXPERIENCE PROGRAM SOLUTIONS

The Tata Group is a global company operating in over 100 countries across six continents, whose mission is 'to improve the lives of the communities we serve around the world, through long-term independent creation enter the value based on Trusted Leaders' 128 billion by 2021 -22 With revenues of $9.6 billion, these companies collectively employ more than 935,000 people. There are 29 publicly listed Tata companies – many are market leaders in their respective industries.

This virtual experience program is available at one of our companies, Tata Insights and Quants or Tata iQ. You will gain insight into how our passionate multidisciplinary experts solve some of the most complex business problems using data visualization solutions, such as Tableau and Power BI and create amazing stories with the data they generate the foothills of the mountains.

The program will show you the problems that are solved on a daily basis at Tata Insights & Quants and will try to simulate the challenges that you will face.

To get in touch with the Tata team for more information, please email [email protected].

TASK 2

Choosing the Right Visuals

Learn which visuals are most effective in a given scenario.

Q1/5: The CEO of the retail store is interested to view the time series of the revenue data for the entire year. The CEO is interested in viewing the seasonal trends and wants to dig deeper into why these trends occur. This analysis will be helpful for the CEO to forecast for the next year.

Which visual would most likely help the CEO analyze the data?

ANS : Line Chart

Q2/5: The CMO is interested in viewing the top 10 countries which are generating the highest revenue. Additionally, as a subcomponent, they would also like to see which products are contributing to the total revenue being generated by each country.

Which visual would enable the CMO to view the revenue for each country and the breakdown by products on a single chart?

ANS : Stacked Bar Chart

Q3/5: The CEO of the online retail store wants to see how much average revenue is generated by each country. They are interested in viewing the following metrics on the visual:

Minimum value

First quartile value

Median value

Third quartile value

Maximum value

Which chart would you create to show the above metrics for the average revenue generated by each country?

ANS : Boxplot

Q4/5: The CMO of the online retail store wants to view the information on the top 10 customers by revenue. They are interested in a visual that shows the greatest revenue-generating customer at the start and gradually declines to the lower revenue-generating customers. The CMO wants to target the higher revenue-generating customers and ensure that they remain satisfied with their products.

Which visual would help the CMO understand the data on revenue generated by the top 10 customers?

ANS : Column chart

Q5/5: The CEO is looking to gain insights on the demand for their products. They want to look at all countries and see which regions have the greatest demand for their products. Once the CEO gets an idea of the regions that have high demand, they will initiate an expansion strategy which will allow the company to target these areas and generate more business from these regions.

He wants to view the entire data on a single view without the need to scroll or hover over the data points to identify the demand.

Which chart would be most useful to provide the CEO information on the demand in each region?

ANS : Map Chart

View the Task 1 solutions here :

TASK 1 SOLUTIONS -> https://vocal.media/education/tata-virtual-experience-program-solutions

MORE ABOUT THE VIRTUAL EXPERIENCE PROGRAM

WHAT WILL YOU LEARN?

Framing the Business Scenario

* Learn how to anticipate the questions your business leaders will need answers to

* Practical skills you will gain from working on this task:

* Visualization

* Data Analysis

* Data Interpretation

Choosing the Right Visuals

* Learn which visuals are most effective in a given scenario

* Data Visualization Charts & Graphs Visual Basics

Creating Effective Visuals

* Apply your under and create visuals based on business scenarios

* Data Visualization

* Dashboard

* Data Cleanup

Communicating Insights and Analysis

* Effectively communicate your findings and explain how it relates to each scenario

* Analysis & Presentation

* Effective Communication Analytics & Insights

This program is self-paced. It takes 3.5-4.5 hours to complete this virtual experience program.

TATA VIRTUAL EXPERIENCE PROGRAM LINK : https://www.theforage.com/virtual-internships/prototype/MyXvBcppsW2FkNYCX/Data-Visualisation-Empowering-Business-with-Effective-Insights?ref=ZDpWiY9Dv6fWoRRTF