Skip to content

SaranS2311/Tata-data-visualisation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📊 Tata Data Visualisation: Empowering Business with Effective Insights

Forage Virtual Experience Programme — Completed March 2026

Certificate Tool Data


🧾 Overview

This repository contains my completed work for the Tata Group Data Visualisation job simulation hosted on Forage. The programme simulates a real-world data analyst role at Tata Consultancy Services (TCS), where I analysed an online retail dataset and created data visualisations to support executive decision-making.


✅ Tasks Completed

Task 1 — Framing the Business Scenario

Reviewed the dataset and drafted key questions that the CEO and CMO would want answered before a strategic meeting. This involved thinking from a business leadership perspective — identifying revenue trends, customer behaviour patterns, and regional performance gaps.

Task 2 — Choosing the Right Visuals

Selected the most appropriate chart types for each business question, justifying why certain visuals (e.g. line charts for trends, maps for geographic demand) communicate insights more effectively than others.

Task 3 — Creating Effective Visuals

Built interactive dashboards in Power BI using the Online Retail dataset. Visuals include:

  • Monthly revenue trends (2010–2011)
  • Top 10 countries by revenue (excluding UK)
  • Top 10 customers by revenue
  • Product demand by country (geographic map, excluding UK)

Task 4 — Communicating Insights and Analysis

Prepared a structured presentation of findings for the CEO and CMO, highlighting actionable insights such as seasonal revenue peaks, high-value customer segments, and international expansion opportunities.


📁 Repository Structure

tata-data-visualisation/
├── README.md
├── data/
│   └── Online_Retail.xlsx          # Raw retail transaction dataset
├── powerbi/
│   └── Saran_4_question_answers.pbix  # Power BI dashboard file
├── reports/
│   └── Saran_powerbi_answers.pdf   # Exported dashboard screenshots & analysis
└── certificate/
    └── completion_certificate.pdf  # Forage certificate of completion

🛠️ Tools & Technologies

Tool Purpose
Power BI Dashboard creation and data visualisation
Microsoft Excel Data exploration and cleaning
Forage Platform Virtual job simulation environment

💡 Key Insights

  • Revenue peaks in November, suggesting strong seasonal demand — ideal for inventory and marketing planning.
  • Netherlands, Ireland, Germany, and France are the top international markets by revenue, outside the UK.
  • A small group of high-value customers contributes disproportionately to total revenue — a key retention target.
  • Europe dominates international demand, with limited presence in Asia and the Americas, presenting expansion opportunities.

🏆 Certificate

Issued by Forage in partnership with Tata Group on March 11, 2026.

Completed practical tasks in:

  • Framing the Business Scenario
  • Choosing the Right Visuals
  • Creating Effective Visuals
  • Communicating Insights and Analysis

📄 View Certificate


This project was completed as part of a Forage virtual experience programme and is intended for portfolio and learning purposes.

About

Tata Group Data Visualisation job simulation – Power BI dashboards & insights

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors