Tata Data Visualisation: Empowering Business with Effective Insights Job Simulation on Forage - April 2025

• Completed a simulation involving creating data visualizations for Tata Consultancy Services
• Prepared questions for a meeting with client senior leadership
• Created visuals for data analysis to help executives with effective decision making  

Task 1: Framing the Business Scenario

Framing the questions

Task 2: Choosing the Right Visuals

Choosing the right visuals for the given questions

Task 3: Creating Effective Visuals

-DATA CLEANUP

• Removing the rows where the quantity was less than 1

• Removing the rows where the value of unit price was less than $

  -DATA IMPUTATION

• Creating a new column named 'Revenue' using the formula Revenue = quantity * unit price

Question 1

The CEO of the retail store is interested to view the time series of the revenue data for the year 2011 only. He would like to view granular data by looking into revenue for each month. 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.

• Line chart is used to see the time series of the revenue data for the year 2011

Question 2

The CMO is interested in viewing the top 10 countries which are generating the highest revenue. Additionally, the CMO is also interested in viewing the quantity sold along with the revenue generated. The CMO does not want to have the United Kingdom in this visual.

• side by side bar chart is used
• Add the filter to only show the top 10 countries by revenue and filter UK in the visual

Question 3

The CMO of the online retail store wants to view the information on the top 10 customers by revenue. He is 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.

• Column bar chart is used
• Add a filter to only display the top 10 customers.
• Customers who do not have any customer IDs are excluded from the visual.
• sort the customers in descending order based on the total revenue generated.

Question 4

The CEO is looking to gain insights on the demand for their products. He wants 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, he 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. There is no need to show data for the United Kingdom as the CEO is more interested in viewing the countries that have expansion opportunities.

• Map chart is used
• To precisely see the countries, use a text chart along with the map chart.

Task 4: Communicating Insights and Analysis

• Presenting the insights to the CEO and CMO

Certification Link :

https://forage-uploads-prod.s3.amazonaws.com/completion-certificates/ifobHAoMjQs9s6bKS/MyXvBcppsW2FkNYCX_ifobHAoMjQs9s6bKS_5aWp5YuKt6cuqC2Yx_1744821400384_completion_certificate.pdf