Bharathi Education Trust®
G. MADEGOWDA INSTITUTE OF TECHNOLOGY (GMIT)
(Affiliated to VTU, Recognized by Government of Karnataka, Approved by AICTE,
New Delhi)
A Report on Technical Training
PROGRAMMING ADVANCED
DATA ANALYTICS
Organised by
Department of Computer Science and Engineering as an
initiative by IQAC
From
23TH DECEMBER 2023 to 16th MARCH 2024
Event Coordinator:
Prof. Padmavati K
Assistant Professor, Dept. of CSE
IQAC Coordinator HoD Principal
Bharathinagara (K.M.Doddi), Maddur Taluk, Mandya – 571422
Advanced Data Analytics Session at G. Madegowda Institute of
Technology
Session Title: Advanced Data Analytics
Institution: G. Madegowda Institute of Technology, Mandya
Topics Covered: Python, Statistics, Tableau, SQL, Excel, Projects on Data
Analytics
Start Date of Session: [23/12/23]
End Date of Session: [Insert Date]
Duration: [12 WEEKS]
Introduction:
The session on Advanced Data Analytics conducted at G. Madegowda Institute
of Technology, Mandya, marked a pivotal step in equipping students and
professionals with essential skills and knowledge in the dynamic field of data
analytics. This comprehensive training program aimed to bridge the gap
between theoretical concepts and practical application, empowering
participants to excel in data-driven decision-making processes and thrive in the
ever-evolving landscape of data analytics.
DATA ANALYSIS Training Session By Mr Arpith Yadav
Through a carefully curated curriculum encompassing Python programming,
statistical analysis, data visualization using Tableau, SQL for data querying,
advanced Excel techniques, and hands-on projects, the session provided a
holistic learning experience. Participants were immersed in a blend of
theoretical insights and practical exercises, enabling them to gain proficiency in
key tools and techniques essential for success in data analytics roles across
industries.
The importance of this training extends beyond acquiring technical skills; it
fosters a mindset of continuous learning, critical thinking, and problem-solving.
By exploring real-world datasets, engaging in data analysis projects, and
mastering industry-relevant tools, participants were empowered to unlock
Training Sessions handled by Mr Arprith Yadav and team
insights, drive informed decisions, and contribute meaningfully to their
organizations' success in a data-centric era.
This introduction sets the stage for understanding the significance of the
Advanced Data Analytics session at G. Madegowda Institute of Technology,
Mandya, in empowering individuals with the knowledge and skills to navigate
the complexities of data analytics and make impactful contributions to the
digital economy.
Topics Covered:
1. Python
2. Statistics
3. Tableau
4. SQL
5. Excel
6. Projects on Data Analytics
Learning Outcomes:
Python: Students learned how to use Python for data analysis, including data
manipulation, visualization, and statistical analysis. They gained hands-on
experience with libraries like Pandas, NumPy, and Matplotlib.
Introduction to Python programming language
Data manipulation and analysis using Pandas and NumPy libraries
Data visualization with Matplotlib
Application of Python in data analytics projects
Statistics: The session provided an understanding of statistical concepts such
as descriptive statistics, probability distributions, hypothesis testing, and
regression analysis. Students learned how to apply statistical techniques to
analyze and interpret data.
Basics of statistical analysis
Descriptive statistics and data visualization techniques
Probability distributions and hypothesis testing
Regression analysis for predictive modeling
Tableau: Students gained proficiency in creating interactive and visually
appealing data visualizations using Tableau. They learned how to connect to
data sources, create dashboards, and tell compelling stories with data.
Introduction to Tableau for data visualization
Connecting to data sources and data preparation
Creating interactive dashboards and visualizations
Storytelling with data using Tableau
SQL: The session covered SQL fundamentals, including database design,
querying databases using SELECT statements, data manipulation with INSERT,
UPDATE, DELETE statements, and basic database management concepts.
Fundamentals of Structured Query Language (SQL)
Database design and management
Data querying, manipulation, and retrieval using SQL
Integration of SQL with data analytics workflows
Excel: Students learned advanced Excel techniques for data analysis, including
data cleaning, transformation, and pivot tables. They also learned how to use
Excel functions and formulas for statistical analysis and reporting.
Advanced data analysis techniques in Excel
Data cleaning, transformation, and pivot tables
Statistical functions and formulas in Excel
Excel as a tool for data visualization and reporting
Projects on Data Analytics: The session included practical projects where
students applied their knowledge of Python, Statistics, Tableau, SQL, and Excel
to solve real-world data analytics challenges. This hands-on experience
enhanced their problem-solving skills and prepared them for data analytics
roles in industry.
Hands-on projects to apply learned concepts
Real-world data analysis scenarios
Problem-solving and critical thinking in data analytics projects
Presentation of project findings and insights
Outcomes:
Enhanced understanding of data analytics tools and techniques
Improved proficiency in Python programming for data analysis
Ability to perform statistical analysis and hypothesis testing
Competence in creating interactive data visualizations using Tableau
Proficiency in SQL for data querying and manipulation
Advanced data analysis skills in Excel, including pivot tables and
functions
Practical experience through projects, fostering problem-solving and
analytical skills
INTRODUCTION TO MACHINE LEARING AND DATA ANALYTICS
Importance of Training:
Industry Relevance: The training provided participants with skills and
knowledge aligned with industry standards, making them proficient in
using tools and techniques widely used in data analytics roles.
Hands-On Experience: The practical approach of the training, including
projects, allowed participants to gain hands-on experience and apply
theoretical concepts to real-world scenarios.
Career Advancement: The training enhanced participants'
employability by equipping them with in-demand skills in data analytics,
preparing them for roles such as data analysts, data scientists, business
analysts, and data engineers.
Decision-Making Skills: The session focused on developing
participants' ability to make data-driven decisions by analyzing and
interpreting data effectively, leading to better business outcomes.
Continuous Learning: The training encouraged a culture of continuous
learning and skill development, empowering participants to stay updated
with the latest trends and advancements in data analytics.
Overall, the Advanced Data Analytics session at G. Madegowda Institute of
Technology provided students with a comprehensive understanding of data
analytics tools and techniques, empowering them to analyze data effectively
and derive actionable insights for decision-making.
PROGRAMMING IN SQL Concept DATA ANALYTICS
PROGRAMMING data Analysis Python Training session
Install Tableau Software Training Session
I
.
