Advanced Certification in Data Analytics
In Association with :
- Advanced Certification from E&ICT Academy, IIT Guwahati.
- 6-Months technical training program with hybrid classes.
- Suitable for college student, graduate, post graduate, career gap, Early professionals.
- Start from scratch – no prior experience needed, all pre-requisite will be covered.
- Next-Gen curriculum for the age of ChatGPT and Generative AI.
Our Presence in Pune
- Wakad
- Baner
- Kharadi
- Hinejwadi
Next Batch
22nd May, 2025
Program duration
6 Months
Learning format
Classroom/Hybrid
Ethan's x E&ICT, IIT Guwahati
E&ICT Academy, IIT Guwahati, a leading Indian Institute of Technology, excels in education, research, and innovation. Our partnership with E&ICT Academy at IIT Guwahati aims to advance global education standards. Leveraging the Institute’s esteemed reputation, we offer world-class educational opportunities and foster a global academic community.
Mentors & Instructors
Our team is made up of industry experts, seasoned professionals, and passionate trainers who work together as a close-knit family. We believe in not just teaching, but mentoring, inspiring, and growing together — creating a learning environment that feels like home and performs like the best in the business.
Gurjeet Sir
IIT Kharagpur - Alumnus
Vinit Sir
IIT Bombay - Alumnus
Raman Sir
Ex-Data Analyst, Mu Sigma
Jatin Sir
Ex-VP Credit Suisse, Pune
Siddhant Sir
R&D Scientist, IIIT Allahabad
Himanshu Sir
Ex-Data Scientist, PwC
Most Advanced Curriculum in Industry
Python Basics: Learn, Code, Create
- Introduction to Python Programming:
- Basic Data Types in Python
- Variables and Naming Conventions
- Data Types in Python:
- Data Structure
- Python String Object
- Python List and Tuple Objects
- Python Dictionary Object
- Python Set Object
- Indexing & Slicing:
- Importance of indexing in Python
- Introduction to Slicing
- Indexing and Slicing in Strings
- Indexing and Slicing in Lists and Tuples
- Operators in Python:
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Assignment Operators
- Membership Operators
- In-Built Functions & Methods:
- Exploring Built-in Functions
- Use Built-in Functions with data types
- Introducing Built-in Methods for specific data types
- Introduction to Python Programming:
Python Control Flow Simplified
- Statements, Indentation and Conditionals:
- Statements and Indentation
- Introduction to Conditional Statements
- Combining Multiple Conditions
- Loops & Iterations:
- Conditional Loops (While Loop)
- Conditional Loops (For Loop)
- Master ‘for’ loops, Learn ‘while’ loops
- Comprehend loop control statements
- Explore nested loops
- Statements, Indentation and Conditionals:
Building Smarter Programs
- Custom Functions in Python:
- Introduction to Custom Functions
- Defining and Calling Custom Functions in Python
- Working with Arguments and Return Values
- Advanced Looping Concepts:
- List Comprehension
- Set Comprehension
- Dictionary Comprehension
- Lambda Functions
- OOPs in Python:
- Introduction to Object-Oriented Programming (OOPs)
- Creating and Working with Classes
- Understanding Objects and Instances
- Working with Attributes
- Utilizing Methods in Classes
- Embracing Polymorphism
- Leveraging Inheritance
- Exception Handling & Logging:
- Introduction to Exception Handling
- Try-Except Block: Catching Exceptions
- Handling Specific Exceptions
- Finally Block: Cleaning Up After Exceptions
- Raising Exceptions: Taking Control
- Handling Multiple Exceptions: The Exceptional Mastery
- Custom Functions in Python:
Python Data Structures and Algorithms
- Data Structures Fundamentals:
- Introduction to Data Structures
- Arrays
- Efficient String Operations:
- Introduction to Strings
- Combining strings using concatenation (+)
- Searching and Finding
- Introduction to regex
- Recursion Fundamentals:
- Understanding Recursion: Introduction and Basics
- Recursive Function Design
- Implementing Recursion in Algorithms
- Analyzing Recursive Calls
- Mastering Recursion Concept:
- Time and space complexity
- Algorithm Fundamentals:
- Introduction to Algorithms
- Big O Notation
- Sorting Algorithms
- Searching Algorithms
- Data Structures Fundamentals:
Python Data Wrangling
- Getting Started with Pandas & Numpy:
- Introduction to Pandas & Numpy
- Mastering Data Wrangling:
- Series and dataframes
- Indexing and slicing
- Manipulating data
- Advanced Data Wrangling Concepts:
- Introduction to Data Wrangling
- Handling Missing Data
- Merging and Joining Data
- Grouping and Aggregation
- Reshaping Data
- Filtering Data
- Data Wrangling – Code Optimisation:
- Techniques for Code Optimization
- Strategies for Parallel and Distributed Data Wrangling
- Best Practices for Efficient Data Wrangling
- Data Wrangling on Different Data Formats:
- Data Wrangling on Different Data Formats
- Data Management Libraries:
- File Management Libraries
- Data Manipulation Libraries
- Data Visualization Libraries
- Web Scraping
- Regular Expression Libraries
- Date and Time Libraries
- Web Scraping using Python:
- Introduction to Web Scraping
- Getting Started with Pandas & Numpy:
Python Visualization Libraries in Action
- Data Visualization with Matplotlib & Seaborn:
- Introduction to Matplotlib and Seaborn Plots
Introduction to SQL: Learn the Lang. of Data
- SQL Basics for Data Analysis:
- Introduction to SQL
- Setting up the SQL environment
- Basic SQL Commands
- Creating and Deleting Databases and Tables
- Importing and Exporting Data from CSV Files
- Fundamentals of SQL Query:
- Anatomy of SQL Query
- SQL Data Types and Operators
- Filtering and Sorting Data in SQL
- Aggregate functions in SQL
- Dealing With Multiple Tables:
- Grouping Data – GROUP BY
- HAVING
- Subqueries
- Joining tables using INNER JOIN, LEFT JOIN, RIGHT JOIN & FULL OUTER JOIN
- Alias in SQL queries
- Working with Multiple Tables Using Subqueries
- Using Set Operators
- Aggregating Data from Multiple Tables using GROUP BY and HAVING.
- Advanced SQL Joins:
- Advanced Join Techniques
- Joining multiple tables
- Handling duplicate records and eliminating duplicates
- Using UNION and UNION ALL to combine data from multiple tables
- SQL Basics for Data Analysis:
SQL In-Built Functions
- Type Casting & Math Functions:
- Mathematical Functions
- Type Conversion Functions
- Using CASE Statements to Perform Conditional Operations
- DateTime & String Functions:
- Working with date/time data in SQL
- Date/time functions
- Formatting date/time data
- String manipulation functions (e.g. UPPER, LOWER, LEFT, RIGHT, etc.)
- Regular expressions in SQL for string operations
- Using CONCAT_WS to concatenate strings with a separator
- Window Functions:
- Syntax of Windows Function
- Ranking functions (e.g. ROW_NUMBER, RANK, DENSE_RANK, etc.)
- Aggregate functions using windows (e.g. SUM, AVG, MAX, MIN, etc.)
- Partitioning data for window functions
- Understanding the difference between row-based and aggregate-based window functions
- Type Casting & Math Functions:
SQL for Data Preparation
- Complex queries using CTE & Pivoting:
- Common Table Expressions(CTE)
- Recursive CTEs for Hierarchical Data
- Combining CTEs with Window Functions and Subqueries
- Understanding the Performance Implications of CTEs
- Database Management & Schema Design:
- Understanding The Relational Model and Database Schema Design
- Normalization and Denormalization of Database Tables
- Database Administration Tasks
- Implementing Indexes and Constraints for Data Integrity
- Designing Efficient Database Queries for Performance Optimization
- Complex queries using CTE & Pivoting:
Data Analysis using Excel
- Fundamentals of Excel:
- Introduction to Excel
- Reading Data into Excel
- Basic Data Manipulation in Excel
- Arithmetic Manipulation in Excel
- Basic Functions in Excel
- Function Using Absolute and Relative Reference in Excel
- Additional Useful Function in Excel
- Conditional Statements in Excel
- Data Exploration with In-Built Functions:
- Data Filtering in Excel
- Data Validation in Excel
- Use of Pivot Tables in Excel
- Pivot Table Operations & Applications
- Introduction to Charts in Excel
- Excel Shortcuts
- Storytelling with Excel:
- Introduction to storytelling with data
- The importance of data visualization in storytelling
- Choosing the right chart type for different data scenarios
- Understanding the principles of good data visualization
- How to use Excel to create compelling data visualizations
- Advanced Dashboarding Concepts:
- Introduction to dashboards
- The purpose and benefits of dashboards
- Choosing the right chart types for different dashboard scenarios
- Techniques for creating interactive dashboards in Excel
- Creating dashboard templates for reuse
- Sharing dashboards with stakeholders
- Fundamentals of Excel:
Tableau for Professionals
- Getting Started with Tableau Ecosystem:
- Introduction to Tableau
- Use of tableau for the company’s KPI
- What are business KPIs?
- Choosing the Right Chart:
- What Is a Chart and Types of Charts?
- Line Chart
- Bar Chart and Column Chart
- Pie Chart
- Area Chart
- Dashboarding & Storytelling with Tableau:
- Best Practices for Dashboard Design
- Define your goal: Start by identifying the key insights or metrics that you want to communicate through your dashboard
- Use appropriate visualizations: Choose the right charts and graphs to best represent your data
- Make it interactive: Use filters and other interactive elements to allow users to explore the data
- Keep it simple: Avoid using too many elements that may confuse or distract the viewer
- Getting Started with Tableau Ecosystem:
Data-Driven Business Analysis with Power BI
- Dashboarding with Power Bl:
- Introduction to creating and formatting table visualization
- Formatting Our First visualization
- Creating Different Visualizations: Matrices and Charts
- Adding More Control to Your Visualizations
- Introduction to Mapping
- Measure Performance by Using Kpis, Gauges, and Cards
- Advanced Dashboarding Concepts with PowerBl:
- Introduction to Get and Transform Data
- Introduction for Get Data – Home
- Getting multiple files
- Transform menu
- Customer & Web Analytics:
- Introduction
- Understanding customer behavior and preferences through website data
- Key performance indicators (KPIs) for website analytics
- Analyzing website traffic and user engagement using tools like Google Analytics
- A/B testing and experimental design for website optimization
- Creating user personas and segments for targeted marketing -Cro techniques
- Identifying opportunities for upselling and cross-selling through website data
- Advanced Charts:
- Introduction
- Visualization best practices and chart selection for different data types and analysis goals
- Advanced chart types and techniques, such as heatmaps, sankey diagrams, and sparklines
- Tools for creating advanced charts, such as D3.js, Plotly, and Tableau
- Dashboard design principles and user experience considerations
- Creating interactive charts and dashboards for exploratory data analysis
- Dashboarding with Business KPIs – Ecommerce:
- Key Performance Indicators (KPIs) for Ecommerce Businesses
- Defining Business Goals and Objectives for E-commerce Dashboards
- Selecting and Designing Appropriate Charts and Visualizations for E-commerce KPIs
- Identifying Trends and Patterns in E-commerce Data Using Exploratory Analysis Techniques
- Creating Data-Driven Recommendations for Improving Ecommerce Performance
- Measuring the Impact of Marketing Campaigns and Other Initiatives on Ecommerce Metrics
- Integrating Data from Multiple Sources into E-commerce Dashboards
- Dashboarding with Power Bl:
Best Tech Tools
Industry Projects
Data Analytics - Program Highlights
- 18+ POCs & Projects – Work on proof-of-concepts and projects to build practical expertise.
- Internship Integrated Program in Data Science & Analytics — a unique blend of training and real time.
- Core concepts like Python and analytics, designed to meet real-world demands.
- Tied-Up with 500+ Companies – Get access to top recruiters for exciting job opportunities.
- We help you get hired. With our 100% Career Support, you gain access to POD unique hiring platform.
- Learn to build compelling dashboards and visualizations using Power BI, Tableau, and Excel.
- Job Readiness Program – Master industry skills, resume building, and interview preparation for career success.
- Recognized certification and dedicated placement support designed to launch your career in Data Science & Analytics
- Receive industry-recognized certification and 100% placement support, including resume building, mock interviews.
Up-Skills with 3-in-1 Certifications
Gain a competitive edge in the job market with our exclusive 3-in-1 certification bundle designed to validate your skills and elevate your resume:
🎓 E&ICT, IIT Guwahati Certification 💼 NexGen Internship Letter✅ Wipro DICE ID Certification
Gain a competitive edge in the job market with our exclusive 3-in-1 certification bundle designed to validate your skills and elevate your resume:
🎓 E&ICT, IIT Guwahati Certification
💼 NexGen Internship Letter
✅ Wipro DICE ID Certification
Ethan’s x E&ICT, IIT Guwahati Certificate
Ethans x Wipro DICE ID Certificate
NexGen Internship Certificate
Master 12+ In-demand Skills
- Python Foundation
- Python Advanced
- Python for Analytics
- Exploratory Data Analysis
- Descriptive Statistics
- Inferential Statistics
- Microsoft Excel
- Microsoft PowerBI
- Tableau
- Database - SQL
- Machine Learning
- Artificial Intelligence
Why to Join this Program:
E&ICT Academy, IIT Guwahati
Earn a prestigious certification recognized across industries for career advancement
Guest Lectures by IIT professors
Learn directly from top IIT faculty through hands-on, real-time sessions
Ethan’s Tech Career Track
Flexible timelines to complete your course and projects at your own pace
IIT Approved Mentors
Get personalized guidance and career insights from experienced professionals
Advance Curriculum
Master concepts from basic to expert level through structured, applied learning
Immersion programme at IIT campus
Experience life at an IIT with on-campus sessions, networking, and mentorship
Next Batch Starts on 22nd May, 2025
Join 1% Elite Cohort
4.7
4.6
4.5
4.7
4.6
4.5
Join the 1% Elite Club.
Step into the IIT learning environment and embrace the pride of excellence.
- Take part in a comprehensive job orientation program conducted by E&ICT IIT Guwahati.
- Learn through a cutting-edge curriculum, thoughtfully designed in collaboration with IIT faculty.
- Gain exclusive exposure to guest lectures delivered by experienced professors from E&ICT Academy, IIT Guwahati.
- Receive your official admission letter, student ID card, branded T-shirt, completion certificate symbolizing your association with the institution.
What Other Learners are Saying:
Placed - StackMentalist Ventures
When I started the AWS & DevOps course, I wasn’t sure where it would take me. But the way everything was taught – especially the practical, real-time projects – made all the difference. It wasn’t just about learning tools, it was about understanding how to use them in real-world scenarios. With the knowledge and support I got, I was able to land a role as a DevOps Engineer at StackMentalist Ventures. Honestly, it’s been a big step forward in my career, and I’m really grateful for the journey.
Placed - Sapience Analytics
I completed the AWS & DevOps course from Ethan's Tech, and it provided me with more than just theoretical knowledge. It equipped me with the practical skills and confidence I needed to kickstart my career in cloud computing. The hands-on approach and continuous mentor support made the learning process both easy and effective. Today, I’m proud to be working as a Cloud Engineer at Sapience Analytics, and I’m incredibly grateful for the journey that led me here.
Placed - Lentra.Ai
Enrolling in the DevOps course at Ethan's Tech was one of the best decisions I made for my career. The course didn’t just focus on theory; it provided real-world, hands-on experience that helped me understand how to apply everything I learned. The mentors were incredibly supportive, guiding me every step of the way, which really boosted my confidence. Today, as an Automation Tester at Lentra.AI, I’m truly grateful for the skills and opportunities this course has given me.
Placed - Exacuer
I took the Data Analytics course at Ethan's Tech, and it was good experience for me. The trainers were extremely knowledgeable, and their real-world insights made all the difference in how I approached data analysis. Their constant support and ability to explain things from various perspectives helped me build a solid foundation. Now, as a Data Analyst at Exacuer, I can confidently apply everything I learned to make meaningful contributions to my team
Placed - Sav Analytics
I completed the Python + AWS + DevOps course at Ethan's Tech, and it really helped me build a strong foundation in these key technologies. The course covered everything I needed to know, from Python to AWS and DevOps, in a clear and structured way. The trainers were incredibly knowledgeable and always available to guide me through any challenges. Now, as a Python DevOps Engineer at Sav.com, I feel confident in applying everything which I learnt from Ethan's Tech.
Ethan's Offices Tour
Ethans Tech is a leading professional training institute founded with the mission to bridge the gap between academic learning and real-world skills. With a strong presence in Pune and expanding across India, Ethans Tech has trained thousands of students and working professionals, helping them upgrade their careers in the most in-demand technologies.
The name “Ethans” represents a commitment to “education with excellence”. It’s not just a name; it’s a culture — built by passionate industry experts who believe in practical, hands-on learning rather than rote education. Every trainer at Ethan’s is a seasoned professional with real industry exposure, making the learning experience highly relevant, practical, and impactful.
At Ethans, it’s not just about completing a course — it’s about building a career.
Learners Profile
Our diverse and dynamic batch brings together individuals from various academic and professional backgrounds, creating a rich learning environment driven by collaboration and growth.
- 📘 11% – College Graduates (Non-technical backgrounds)
- 🛠️ 23% – B.Tech & M.Tech Graduates (CS, IT, ME, CIVIL)
- 💻 27% – BCA, B.Sc (IT/CS/Maths/Stats) Graduates
- 💼 23% – Early Career Professionals (1–6 years of experience)
- 🔄 16% – Career Comeback Learners (with a gap in education or employment)
This blend of learners adds immense value to the learning experience — offering unique perspectives, fresh ideas, and real-world context to every session
Learner Profiles & Trusted Companies
Batch Profile
Our diverse and dynamic batch brings together individuals from various academic and professional backgrounds, creating a rich learning environment driven by collaboration and growth.
- 📘 11% – College Graduates (Non-technical backgrounds)
- 🛠️ 23% – B.Tech & M.Tech Graduates (CS, IT, ME, CIVIL)
- 💻 27% – BCA, B.Sc (IT/CS/Maths/Stats) Graduates
- 💼 23% – Early Career Professionals (1–6 years of experience)
- 🔄 16% – Career Comeback Learners (with a gap in education or employment)
This blend of learners adds immense value to the learning experience — offering unique perspectives, fresh ideas, and real-world context to every session
Learner Profiles & Trusted Companies
Trusted By 155+ Top IT Companies For Upskilling
Data Analytics Certification Training FAQs
Who is this program meant for?
This program is ideal for college students, graduates (BCA, B.Sc, B.Tech, M.Tech), early professionals, and career-switchers who want to build a strong foundation in data science and analytics and launch a career in this high-demand field.
How are the classes scheduled?
Classes are held from Tuesday to Friday, combining live instructor-led sessions with hands-on, lab-based practice. Learners are expected to dedicate 4–5 hours per day to fully engage with the program content. Flexible scheduling options may be provided depending on the batch structure and availability.
Do I need any prior coding knowledge?
No prior coding or technical background is required to join this program. It is specifically designed to be beginner-friendly, starting with the fundamentals of Python programming, SQL for data handling, and essential statistical concepts. Whether you’re from a non-technical background or completely new to data science, the structured learning path ensures you build a strong foundation before moving into advanced topics like machine learning, data visualization, and AI.
Are there real-world projects included?
Absolutely. In addition to the 8 core academic modules, the program also includes multiple industry-relevant projects and a capstone project. These real-world assignments are designed to provide hands-on experience, reinforce your learning, and help you build a strong, job-ready portfolio that showcases your skills to potential employers.
What are the IIT Guest Lectures?
Guest lectures are delivered by esteemed faculty from E&ICT, IIT Guwahati, focusing on advanced concepts, emerging research trends, and industry insights in Data Science, AI, and Analytics. These sessions are conducted either online or offline, depending on the schedule, and are typically held on weekends to ensure maximum participation and engagement.
What is the NexGen Internship and when does it start?
The NexGen Internship is an integral part of the program that offers learners the opportunity to gain real-world industry exposure through project-based learning. It allows you to apply the skills you've acquired in a simulated work environment, enhancing both your confidence and your resume.
The internship typically starts after the completion of the core academic modules (3 months from the start), once learners have built a solid foundation in data science and analytics. Detailed schedules and project assignments are shared with students well in advance.
Can I repeat the classes if I miss or need a revision?
Yes! During the program, learners have access to session recordings and class repetition options, allowing you to revise or re-attend sessions as needed for better understanding.
However, if a learner wishes to repeat the entire batch after the 6-month program period, a batch repetition fee of ₹5,000 will be applicable.
Will I receive any certification?
Upon successful completion, you’ll receive a joint certification from E&ICT, IIT Guwahati, an internship letter from NexGen, and a Wipro DICE ID certification.
Is there a placement support system?
Yes, we offer 100% career support as part of the program. This includes mock interviews, resume-building workshops, career counseling, and job referrals through our extensive placement network.
Interaction with our dedicated placement team begins 15 days after the batch start date, ensuring you're well-prepared early on.
As a complimentary benefit, learners also receive one month of Personality Development training (worth ₹12,000) to boost communication skills, confidence, and interview readiness.
Are there real-world projects included?
Absolutely. The program includes multiple industry-aligned projects and a capstone project, giving you practical exposure and a strong portfolio.
Contact Us
- Wakad
- Kharadi
- Baner
- Hinjewadi