Skip to content

πŸ” Tata Group Data Visualization Virtual Internship (Forage) Completed a real-world business intelligence simulation focused on cleaning, analyzing, and visualizing sales data to support executive decision-making.

Notifications You must be signed in to change notification settings

Ajayace03/tata-data-visualization

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

10 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“Š Data Visualization: Empowering Business with Effective Insights

Tata Group Virtual Internship – Job Simulation (Forage)


🏒 About the Program

This virtual internship, hosted by Tata Group through Forage, offers a practical, hands-on experience focused on data visualization and business intelligence. It simulates real-world tasks that are critical for interpreting and presenting data to empower decision-makers with effective insights.

⚑ A self-paced experience designed to prepare aspiring data professionals with skills relevant to industry-level projects.


🎯 Objectives

  • Understand the role of data visualization in business strategy
  • Learn how to clean, analyze, and visualize data for impactful communication
  • Develop interactive dashboards and compelling visual reports
  • Gain exposure to the tools and techniques used by Tata Group professionals

🧠 Skills Practiced

  • Visualisation
  • Data Analysis
  • Data Interpretation
  • Data Visualisation
  • Charts & Graphs
  • Visual Basics
  • Dashboard Creation
  • Data Cleanup
  • Analysis & Presentation
  • Effective Communication
  • Analytics & Insights

βœ… Task Summary

🧠 Task 1: Understanding the Business Context

Objective: Draft strategic questions the CEO and CMO would ask to assess business performance.

  • πŸ§‘β€πŸ’Ό CEO Questions: Focused on product performance, competitor analysis, profitability, and planning for seasonal sales.
  • πŸ“ˆ CMO Questions: Targeted marketing effectiveness, product-region mapping, demographic insights, and campaign ROI.

πŸ“Š Task 2: Choosing the Right Visuals

Objective: Select the most appropriate visualizations to answer specific business questions.

  • πŸ”Ή Line Chart for monthly revenue trends (seasonal forecasting)
  • πŸ”Ή Stacked Bar Chart for country-wise revenue with product breakdown
  • πŸ”Ή Boxplot to visualize revenue distribution per country
  • πŸ”Ή Column Chart for top 10 customers by revenue
  • πŸ”Ή Map Chart to show demand by country for expansion planning

πŸ› οΈ Task 3: Creating Effective Visuals

Objective: Clean the dataset and create four interactive Tableau dashboards.

  • βœ… Cleaned data by filtering rows where Quantity < 1 or UnitPrice < 0
  • πŸ“Œ Visual Q1: Monthly revenue trend for 2011 (Line chart)
  • πŸ“Œ Visual Q2: Top 10 countries by revenue, excluding UK, with product-level view (Stacked bar chart)
  • πŸ“Œ Visual Q3: Top 10 customers sorted by revenue (Bar chart)
  • πŸ“Œ Visual Q4: Country-wise product demand, excluding UK (Bar chart)
    Each visual was saved on separate Tableau worksheets named Q1, Q2, Q3, and Q4.

πŸŽ₯ Task 4: Communicating Insights and Analysis

Objective: Present findings clearly to CEO and CMO via a 5-minute script or video.

  • Walked through the entire process from data cleaning to dashboard design
  • Provided business context behind each visual, not just what the data shows but why it matters
  • Final takeaway:

    β€œThe data reveals clear seasonal trends, key customer segments, and strong international demand β€” all of which can inform smarter marketing, retention, and expansion strategies.”


πŸ™Œ Acknowledgements

This project is part of the Tata Group x Forage Data Visualisation Virtual Internship.
All tasks, datasets, and use cases were provided by Tata Group through the Forage platform for educational purposes.


πŸ› οΈ Tools Used

  • Tableau
  • Excel
  • Python (for optional preprocessing)
  • Git & GitHub for version control

πŸ™‹β€β™‚οΈ About Me

I’m an AI & Data Science Enthusiast passionate about building smart systems and solving real-world problems through intelligent technologies.


About

πŸ” Tata Group Data Visualization Virtual Internship (Forage) Completed a real-world business intelligence simulation focused on cleaning, analyzing, and visualizing sales data to support executive decision-making.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages