INTERNSHIP REPORT

ON

Vrinda Stores Dashboard Report

Yeshwantrao Chavhan College of Engineering

Bachelor of Technology
in
Computer Science & Engineering

Session 2024-25

Submitted by:

Ayush Shende
IV Semester CSE-A-34

Supervised by:

Prof. Milind.C.Tote

Edunet Foundation
16th June - 16th July, 2025

Nagar Yuwak ShikshanSanstha’s

YESHWANTRAO CHAVAN COLLEGE OF ENGINEERING,

(An Autonomous Institution Affiliated to Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur)

NAGPUR – 441 110

2024-25

1
 CERTIFICATE OF COMPLITION

Certified that the Internship project entitled “Vrinda Stores Dashboard Report” has
been successfully completed by Aryan Ilamkar during session 2024-25

Faculty Supervisor

Signature : ______________________________
Name : _________________________________
Designation:______________________________

2
 ACKNOWLEDGEMENT

I, Ayush Shende would like to convey my gratitude to Yeshwantrao Chavan College

of Engineering for emphasizing on the Semester Internship Program and giving me

the platform to interact with industry professionals.

I would also like to thank Prof. Milind C.Tote and Dr. Lalit Damahe for giving me the

opportunity to work on the prestigious Internship.

I extend my warm gratitude and regards to everyone who helped me during my

internship

3
 TABLE OF CONTENTS

Sr.No Title Page No

1 Cover Page 1

2 Certificate of Completion 2

3 Acknowledgement 3

4 Internship Overview 5-8

5 Training Component 9-11

6 Project Component 12-14

7 Weekly Work Log (Mandatory for Audit 15

Compliance)
8 Challenges & Solutions 16-17

9 Skills Acquired 18

10 Conclusion & Future Scope 19

11 References (if any) 20

12 Annexures 21-22

4
Internship Overview

Introduction

The purpose of this report is to provide a complete overview of my internship experience at

Edunet, a technology training company. This report will cover the company details, my
learning experience, the project work I completed, and the overall impact of this internship on
my professional development. The report aims to document my journey as a student intern
and highlight the valuable skills and knowledge gained during this period.

Company Background

About Edunet Foundation

A social enterprise founded in 2015, working across India to bridge the academia–industry
gap, enhance student employability, and foster an entrepreneurial ecosystem using emerging
technologies. It holds a Special Consultative Status with the United Nations ECOSOC since
2020.
 NextGen Employability Program: Hands-on training to make youth industry-ready,
with notable placements and internships.
 Skills4Future Program: Developed in collaboration with Shell India to impart green
and AI-driven skills to students
 CodeUnnati Program: Equipping underserved youth and educators across multiple
states with industry-relevant tech skills and certifications.

Company Mission and Vision

 Vision: To create an ecosystem where every learner in India has access to future-ready
skills and equal opportunities for employability.

 Mission: To empower students, educators, and youth through skill-building, vocational

training, and technology-driven initiatives, with a goal to equip 5 million future workers by
2030.

Company Culture

Edunet Foundation maintains a friendly and supportive work environment where students
feel comfortable asking questions and exploring new ideas. The trainers and staff are
experienced professionals who understand the challenges students face when learning new
technologies.

Company Services and Training Programs

5
1. Services Offered

Edunet Foundation provides services across multiple domains aimed at skilling,

employability, and community empowerment:

A. Digital Skilling & Employability Training

o Hands-on training in AI, Cloud, Cybersecurity, Data Analytics, Web
Development, and Productivity Tools.
o Soft skills development (communication, teamwork, leadership, interview
readiness).
B. Vocational Training
o Advanced diploma and certificate-level vocational programs recognized by
National Skills Qualifications Framework (NSQF).
o Industry-linked internships and employability pathways.
C. Faculty Development
o Training of teachers and faculty in digital tools, modern pedagogy, and
emerging technologies.
o Establishment of Centres of Excellence for faculty capacity-building.
D. Community Development
o Education support for underprivileged children (schools, homes, digital
literacy centers).
o Technology access and internet connectivity in remote/rural areas.
E. Women Empowerment Programs
o Targeted initiatives to skill and mentor women in technology fields.
o Hackathons and innovation challenges to increase female participation in
STEM.
F. Green & Sustainable Skills
o Programs focusing on green jobs, renewable energy, and electric vehicle (EV)
skills.
o Promoting climate-conscious digital innovation.

2. Training Programs

A. IBM SkillsBuild Program

 Free, self-paced online learning in AI, Cybersecurity, Cloud, Data Science, and Soft
Skills.
 Virtual internships in collaboration with AICTE.
 Global certification and career mentoring.

B. SkillSaksham (with Microsoft & DGT)

 Training in MS Office productivity tools, AI fundamentals, Cybersecurity, Power BI,

and employability skills.
 Reached 8,000+ students across India.

C. TechSaksham (with Microsoft & SAP)

6
  Focused on AI, Cloud Computing, and Web Development.
 Delivered via bootcamps, hackathons, faculty training workshops.
 Special emphasis on women students in tier-2 & tier-3 colleges.

D. Code Unnati (with SAP Labs India)

 Establishment of SAP Centres of Excellence in colleges.

 Faculty training, industry projects, and student innovation challenges.
 Impact: 2500+ students and 500+ faculty across 45+ colleges.

E. Vocational Skilling Programs

 Advanced Diploma in IT (NSQF Level 6) at National Skill Training Institutes

(NSTIs).
 Includes classroom teaching + industry bootcamps + internships.
 Over 750 students trained.

F. Skills4Future (with Shell India)

 Training in Green Skills + AI skills for sustainable jobs.

 Partnership with Gujarat Knowledge Society to train 10,000+ students annually in
digital and EV-related skills.

G. Certificate Program for Class 10 Dropouts (with LTI Mindtree Foundation & IIIT
Dharwad)

 IT and employability training for youth who dropped out after Class 10.
 High placement success (70–82% employed).

H. Community Education Programs

 Rourkela School (Odisha): Education, mid-day meals, and health support.

 Turtuk Valley (Ladakh): Digital classrooms and internet access.
 Shalom Children Home (Bangalore): IT infrastructure for 50+ children.

Relevance of Edunet Foundation in Industry

Edunet Foundation plays a highly relevant role in the industry by bridging the gap between
academic learning and industry requirements. One of the major challenges faced by
employers is the lack of job-ready skills among graduates, and Edunet addresses this through
specialized training in Industry 4.0 technologies such as Artificial Intelligence, Cloud
Computing, Cybersecurity, Data Analytics, and Green Skills.

By collaborating with global corporates like IBM, Microsoft, SAP, Shell, and LTI Mindtree,
Edunet ensures that students gain industry-recognized certifications, practical exposure, and
project-based learning experiences. This not only reduces the cost and time industries spend
on employee training but also provides them with a skilled and innovation-ready workforce.
Through hackathons, internships, and capstone projects, Edunet fosters innovation and
entrepreneurship, helping industries access fresh ideas and talent.

7
Additionally, its focus on vocational training, women empowerment, and tier-2 and tier-3 city
students ensures the creation of a diverse and inclusive workforce, supporting corporate CSR
and DEI goals. With initiatives like Skills4Future, the foundation also prepares youth for
emerging green jobs, helping industries transition towards sustainability and achieve ESG
targets. Recognized by the United Nations with ECOSOC consultative status, Edunet stands
as a trusted partner for industries seeking workforce development, innovation, and
sustainable growth.

Training Component

8
Mode of Training

My training at Alexler Technologies was primarily conducted on weekends through Zoom

Meet sessions. These virtual classes were interactive and allowed us to engage with the
mentor in real-time. The sessions were structured around specific modules that covered both
the fundamentals and advanced aspects of data visualization using Microsoft Excel.

For addressing queries outside the scheduled classes, we had multiple communication
channels available. Most doubts and clarifications were resolved through WhatsApp and
Telegram, where the mentor was actively available to guide us. Additionally, students could
visit the internship office in person if required. This flexible arrangement made it easier to
balance learning with personal schedules while ensuring consistent progress throughout the
internship.

We were encouraged to practice regularly during the weekdays so that the concepts discussed
in the weekend sessions could be applied effectively. This self-practice approach helped us to
reinforce the learning and explore Excel’s features in greater detail.

Training Modules Covered

The internship program is designed to integrate Green Skills with Artificial Intelligence
(AI) technologies, preparing students for sustainable, future-ready careers. The following
training modules are covered:

A. Foundational Modules
 Introduction to Artificial Intelligence and Machine Learning
 Basics of Python Programming for AI applications
 Fundamentals of Cloud Computing and AI toolkits

B. Green Skills & Sustainability

 Climate Change and Environmental Challenges
 Renewable Energy Systems (Solar, Wind, EV ecosystem)
 Sustainable Development Goals (SDGs) and Industry Relevance
 Green Economy and Future Job Opportunities

C. AI Applications for Green Solutions
 Data Analytics for Environmental Monitoring
 AI in Renewable Energy Optimization (smart grids, energy efficiency)
 AI-based Waste Management and Water Conservation
 AI for Carbon Footprint Analysis and Reduction

D. Employability & Soft Skills

 Problem-Solving and Critical Thinking
 Communication and Collaboration Skills
 Innovation & Design Thinking for Sustainability
 Workplace Readiness and Career Guidance

E. Capstone Projects & Hackathons

 Team-based projects on real-world sustainability challenges

9
  AI-driven solutions for climate action and green energy
 Presentation of outcomes to industry mentors and faculty

Each module was followed by assignments and practice tasks, ensuring that we not only
understood the theory but also applied it in practice.

Theoretical Knowledge Gained

During the internship on Green Skills using AI technologies, students acquired

comprehensive theoretical knowledge in both emerging technologies and sustainability
practices. The following key areas of learning were emphasized:

1. Artificial Intelligence & Machine Learning

o Understanding AI fundamentals, types of AI, and its applications in real-world
problem-solving.
o Basics of Machine Learning algorithms, supervised vs. unsupervised learning,
and model training concepts.
2. Data Analytics & Cloud Computing
o Concepts of data collection, preprocessing, and visualization for
environmental monitoring.
o Introduction to cloud platforms and AI toolkits for scalable data analysis.
3. Green Skills & Sustainability
o Principles of climate change, environmental challenges, and the need for green
technologies.
o Fundamentals of renewable energy systems such as solar, wind, and electric
vehicles (EVs).
o Understanding Sustainable Development Goals (SDGs) and their industrial
applications.
4. AI for Environmental Solutions
o Theoretical frameworks on how AI can optimize energy efficiency, reduce
carbon footprints, and enable smart resource management.
o AI applications in waste management, water conservation, and pollution
monitoring.
5. Employability & Innovation Mindset
o Theoretical concepts of design thinking, problem-solving approaches, and
innovation for sustainability.
o Awareness of workplace readiness skills, teamwork, and leadership in the
context of green industries.

Roles and Objectives During the Internship

10
1. Roles of the Interns

During the internship, students were expected to take on the following roles:

 Learner & Researcher: Gaining theoretical knowledge of Artificial Intelligence,

Machine Learning, and Green Skills concepts.
 Data Analyst: Understanding and analyzing datasets related to sustainability,
environment, and energy efficiency.
 Problem-Solver: Applying AI tools to design innovative solutions for real-world
environmental and green technology challenges.
 Team Collaborator: Working in groups to complete projects, share ideas, and
present solutions collaboratively.
 Innovator & Presenter: Developing project prototypes and presenting findings in
hackathons or capstone project reviews.

2. Objectives of the Internship

The internship aimed to achieve the following learning and industry-relevant goals:

1. To provide theoretical understanding of AI, Machine Learning, and Green Skills,

and their applications in industry.
2. To develop technical proficiency in Python, data analytics, and cloud-based AI
tools.
3. To create awareness about climate change, renewable energy, and sustainability
challenges.
4. To encourage innovation by applying AI for solving environmental problems such
as waste management, water conservation, and carbon footprint reduction.
5. To build employability skills including communication, teamwork, critical thinking,
and design thinking for sustainable industries.
6. To deliver hands-on experience through capstone projects and hackathons that
simulate industry scenarios.

Project Component

11
Title of the Project

The project I worked on during my internship was titled “Carbon Emission Prediction.” The
primary aim of this project was to analyze climate-related datasets and develop a predictive
model that could estimate future carbon emission trends. This work provided me with the
opportunity to apply the concepts and skills I had learned during my training, particularly in
the fields of data preprocessing, machine learning, and data visualization using Python.

Problem Statement

The rapid increase in carbon emissions caused by industrial growth, urbanization, and energy
consumption has become a major global concern. These emissions are a key driver of climate
change, leading to rising temperatures, extreme weather events, and environmental
degradation. Traditional methods of monitoring and analyzing carbon emissions are often
limited and fail to provide timely insights for effective planning.

To address this issue, there is a need for AI-powered predictive models that can analyze
large datasets and forecast future emission trends. Such models can help governments,
industries, and organizations take proactive measures towards sustainability, policy-making,
and reducing environmental impact. This project focuses on building such a predictive
framework to support greener solutions.

Data Collection

The dataset used in this project contained historical records related to carbon emissions and
their influencing factors. It included details such as year, country, total CO₂ emissions,
per capita emissions, population, GDP, energy consumption by source (coal, oil, gas,
renewables), and temperature anomalies. This dataset formed the foundation of the
analysis and was provided as part of the internship assignment.

Data Cleaning

Since raw data often contains inconsistencies, errors, or missing values, the first step was to
prepare the dataset for analysis. Using Microsoft Excel, I carried out multiple cleaning
operations such as:

 Removing duplicate entries that could distort analysis.

 Standardizing formats for dates, numbers, and text fields.
 Handling missing or incomplete records by either imputing values or removing them
where necessary.
 Organizing the raw dataset into structured tables for better readability and processing.

This stage ensured that the dataset was accurate, consistent, and ready for further analysis

Data Analysis

12
The collected dataset was analyzed to identify key trends, correlations, and patterns in carbon
emissions. Exploratory Data Analysis (EDA) was performed using Python (pandas, mat-
plotlib, seaborn) to visualize emission levels over time and compare them across different
countries and sectors. Statistical summaries were generated to understand the distribution of
variables such as GDP, population, energy consumption, and CO₂ emissions.

Correlation analysis revealed strong relationships between fossil fuel-based energy usage
and emission levels, as well as a positive association between GDP growth and carbon out-
put. On the other hand, increasing the share of renewable energy sources showed a potential
reduction in emissions. The analysis also highlighted rising per-capita emissions in develop-
ing countries due to industrial growth and urbanization. These insights provided the founda-
tion for building a predictive model to forecast future carbon emission trends.

Detailed Explanation of the Project

The project “Carbon Emission Prediction” was undertaken as part of the AI for Green Skills
Internship by Edunet Foundation in collaboration with AICTE and Shell. The primary aim of
this project was to design a data-driven solution that could analyze historical environmental
and socio-economic data to predict future carbon emissions and thereby contribute towards
building strategies for sustainable development.

The first step involved data collection from credible sources such as the World Bank, Our
World in Data, and the Global Carbon Project. The dataset included key attributes like year,
country, total CO₂ emissions, per capita emissions, population, GDP, energy consumption
mix (coal, oil, gas, renewables), and temperature anomalies. These variables were chosen
since they are strongly linked to industrial growth, energy usage, and climate change. After
collecting the raw data, preprocessing steps were carried out including handling missing
values, standardizing units, detecting outliers, and creating derived features such as emission
intensity (tCO₂/GDP) and per capita energy use.

Once the dataset was cleaned, exploratory data analysis (EDA) was conducted using Python
libraries such as pandas, matplotlib, and seaborn. Visualizations like line graphs, bar charts,
and heatmaps helped identify trends in emissions across years and regions, as well as
correlations between economic growth, energy usage, and emission levels. The EDA revealed
that fossil fuel consumption, especially coal and oil, had the strongest correlation with rising
CO₂ emissions, while renewable energy adoption showed potential in reducing emission
levels.

For the prediction phase, machine learning models were applied to forecast future carbon
emissions. Models such as Linear Regression, Random Forest, and Time-Series Forecasting
(ARIMA/Prophet) were tested to analyze historical data and project emission trends.
Performance of these models was evaluated using metrics like Mean Squared Error (MSE)
and R² Score to ensure accuracy. Among them, Random Forest performed well in capturing
complex, non-linear relationships, while time-series models provided better trend-based
predictions.

Finally, the results were visualized in the form of interactive dashboards and charts, which
highlighted projected emissions under different scenarios (e.g., high fossil fuel usage vs.
renewable adoption). This provided a clear and actionable view of how policy decisions and
energy choices could shape future emission outcomes.

13
Overall, this project combined theoretical knowledge of AI and data science with practical
application in sustainability. It not only enhanced skills in data collection, cleaning,
visualization, and machine learning but also emphasized the importance of AI for
environmental protection and green skill development.

Weekly Work Log

14
The internship was conducted over a period of five weeks, and each week had specific
agendas and deliverables. The detailed weekly log is as follows:

Week 0

 Agenda: Orientation of Internship, Project Allocation

 Student Deliverables: Selection of Projects through LMS

Week 1

 Agenda: Mentoring session on Project Planning, Importing, Preprocessing, Data

Visualization & Data Modelling, and Ask Me Anything sessions
 Student Deliverables: Commence Project Related Tasks, Complete the Weekly
Milestone and feedback form

Week 2

 Agenda: Mentoring session on Model Selection & Building, Mentorship sessions,

and Ask Me Anything sessions
 Student Deliverables: Project related tasks, Complete the Weekly Milestone and
feedback form

Week 3

 Agenda: Mentoring session on Model Evaluation and Optimization, Mentorship

sessions, and Ask Me Anything sessions
 Student Deliverables: Project related tasks, Complete the Weekly Milestone and
feedback form

Week 4

 Agenda: Mock project presentations, Final Project Presentations (PPT), Presentation

of Project in front of Subject Matter Experts, Incorporate changes in the project
mentioned by Mentors, Final Presentation of Project before Industry Experts
 Student Deliverables: Final Submission of Project with PPT

Challenges and Solutions

15
Every internship experience brings with it a set of challenges that test both technical ability
and adaptability. My internship at Edunet Foundation was no different. While I gained
invaluable skills in AI with green skill, I also faced multiple challenges that initially seemed
overwhelming. However, with consistent practice, guidance from mentors, and a willingness
to learn, I was able to overcome these hurdles successfully. The following section describes
the major challenges I encountered during the internship and the solutions that helped me
resolve them.

Challenge 1: Data Availability and Quality

One of the major challenges was finding reliable and comprehensive datasets related to
carbon emissions. Many publicly available datasets had missing values, inconsistencies, or
lacked uniformity in measurement units.

Solution:
To address this, data cleaning and preprocessing techniques were applied, including handling
missing values, standardizing units, and normalizing data ranges. This ensured the dataset
was consistent and ready for analysis and modeling.

Challenge 2: Feature Selection and Correlation

Carbon emissions are influenced by multiple factors such as energy consumption, industrial
output, population, and transportation. Identifying the most significant features from a large
dataset was a challenge.

Solution:
Feature engineering and correlation analysis were performed to identify key variables that
had the highest impact on emissions. This helped in building a more accurate and efficient
prediction model.

Challenge 3: Model Selection and Optimization

Choosing the right machine learning model for prediction was another challenge. Some
models overfitted the data while others underperformed in terms of accuracy.

Solution:
Multiple models such as Linear Regression, Random Forest, and Gradient Boosting were
tested and evaluated using performance metrics like RMSE, MAE, and R² score.
Hyperparameter tuning was done to optimize the best-performing model for better prediction
accuracy.

Challenge 4: Computational Limitations

Large datasets and complex models required significant computational power, which was
sometimes limited during the internship.

Solution:
To overcome this, optimized code implementation, data sampling, and cloud-based
computational tools were utilized when necessary to handle large-scale processing efficiently.

16
Reflections on Challenges

Looking back, these challenges played a crucial role in shaping my learning experience. If the
internship had been too easy, I would not have gained the depth of understanding that I now
have. Each challenge taught me a specific lesson: managing large datasets taught me patience
and optimization, designing complex visualizations taught me creativity and technical skill,
making the dashboard user-friendly taught me empathy for the end-user, and navigating
online communication taught me self-discipline and clarity.

By overcoming these hurdles, I not only completed the Vrinda Stores Dashboard Report
successfully but also became more confident in my ability to tackle new problems in the
future. These experiences strengthened both my technical and professional skills, leaving me
better prepared for future academic projects and industry roles.

Skills Acquired

17
The internship at was not only an opportunity to work on a real-world project but also a
platform to acquire a wide range of technical and professional skills. Over the four weeks, I
progressed from being a beginner in advanced Excel to being able to design a complete,
interactive business dashboard. The skills I gained during this period can be broadly
classified into technical skills, which enhanced my ability to handle data and create
visualizations, and professional skills, which contributed to my personal growth and
workplace readiness.

Technical Skills

A. Data Collection & Preprocessing

 Learned how to gather, clean, and preprocess large datasets.

 Applied techniques such as handling missing values, normalization, and feature
engineering.

B. Data Visualization

 Gained expertise in representing data through meaningful charts and graphs.

 Used tools like Microsoft Excel, Python (Matplotlib, Seaborn, Pandas) for trend
analysis.

C. Machine Learning & Prediction Models

 Acquired hands-on experience in building and evaluating models such as Linear

Regression, Random Forest, and Gradient Boosting.
 Learned how to compare models using performance metrics (RMSE, MAE, R²
Score).

D. Problem-Solving & Analytical Thinking

 Developed the ability to analyze complex environmental problems and translate them
into predictive models.
 Strengthened logical reasoning and decision-making skills.

E. Technical Tools & Programming Skills

 Improved proficiency in Python, Jupyter Notebook, Excel, and data science libraries.
 Enhanced understanding of model optimization and parameter tuning.

F. Professional & Soft Skills

 Improved skills in report writing, project documentation, and presentation.

 Learned effective time management, teamwork, and communication during mentoring
sessions and project reviews.

Conclusion & Future Scope

18
Conclusion

The project on Carbon Emission Prediction provided an opportunity to explore how Artificial
Intelligence and Machine Learning can be applied to address real-world environmental
challenges. By working with historical datasets on CO₂ emissions, population, GDP, and
energy consumption, the project helped in identifying patterns and relationships between
human activities and their environmental impact.

Through the stages of data preprocessing, visualization, model building, and evaluation, the
project highlighted the importance of clean and well-structured data in building accurate
predictive systems. The use of regression and forecasting models not only helped in
predicting future emission trends but also gave a deeper understanding of how various socio-
economic factors contribute to rising carbon levels.

This internship experience also reinforced the value of interdisciplinary learning, combining
technical knowledge in AI with awareness of global sustainability issues. Overall, the project
was a step toward applying modern technology to create meaningful solutions for climate
change challenges.

Future Scope

In the future, the scope of this project can be broadened by integrating real-time datasets
from IoT devices, government reports, and satellite imagery. This would enhance the
accuracy and relevance of predictions by ensuring that the model adapts to changing
conditions.

More advanced algorithms, including deep learning models and ensemble techniques, can
be implemented to achieve higher accuracy and robustness. Additionally, the model can be
extended to predict emissions at regional, national, and global levels, enabling targeted
climate action plans.

Another important future direction is the integration of this system into decision-making
dashboards for policymakers, industries, and environmental organizations. Such a system
could support evidence-based policymaking by providing clear forecasts and insights into the
impact of different energy and economic policies.

Finally, with the growing importance of sustainability, this project can evolve into a
comprehensive climate intelligence platform, combining carbon prediction with renewable
energy adoption trends, pollution control measures, and environmental risk assessments. This
would make the system not only a prediction tool but also a guiding framework for a greener
future.

References

19
1. Microsoft Support – Overview of Excel for Windows

https://support.microsoft.com/en-us/excel

2. Microsoft Learn – Create and format Excel tables

https://learn.microsoft.com/en-us/office/troubleshoot/excel/create-format-tables

3. Microsoft Learn – PivotTable and PivotChart Reports

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-
a9a84538-bfe9-40a9-a8e9-f99134456576

4. GeeksforGeeks – Data Visualization in Excel

https://www.geeksforgeeks.org/data-visualization-in-ms-excel/

5. TutorialsPoint – Excel Dashboards

https://www.tutorialspoint.com/excel_dashboard/index.htm

6. Excel Easy – Excel Tutorials

https://www.excel-easy.com/

7. Investopedia – The Importance of Data Visualization

https://www.investopedia.com/terms/d/data-visualization.asp

8. Towards Data Science (Medium) – Why Data Visualization is Important

https://towardsdatascience.com/why-data-visualization-is-so-important-88a2c6b1b51b

Annexure 1: Internship Offer Letter

20
Annexure 2: Internship Completion Certificate

21
22