Data Science & Gen-AI
In collaboration with:
- Become a Top 1% Data Expert: Learn Sheets, Power BI, Python, SQL, and Machine Learning.
- Curriculum designed and delivered by experts from Google, Microsoft and Amazon
- Build projects like Google Drive, LinkedIn and E-commerce
Tuition Fee- ₹1,24,999/- + 18% GST (EMI options available)
For Enquiries call: +91 7827927539
Students Placed
0
+
Average CTC
0
LPA
Job Offer
0
LPA
Hiring Partners
0
+
Get Your Brochure
Why Choose This Programme? ✨
Build your skills step-by-step with our momentum-driven approach.
Prestigious Certification
- Earn a certification that stands out in the industry, showcasing your advanced skills and expertise.
IIT-Curated Curriculum
- Study a cutting-edge curriculum crafted by IIT Guwahati experts, ensuring you learn the latest and most relevant content.
Immersive Campus Experience
- Spend two days on campus at one of India’s top institutes, blending intensive learning with a vibrant campus environment.
Insightful Guest Lectures
- Gain unique perspectives from leading academics, enhancing your knowledge with their expert insights.
Our Hiring & Partner Network
CURRICULUM
Data Science & Gen-AI
Course Content
- Become a Top 1% Data Expert: Learn Sheets, Power BI, Python, SQL, and Machine Learning.
- Designed by professionals from Google, Microsoft, and Amazon.
- Work on 100+ real projects like Stock Price Prediction, Song Recommendation, Speech Recognition, and more.
- Get certified from E&ICT Academy, IIT Guwahati
1. Introduction to Google Spreadsheets & Power BI
AI-Powered Analytics in Google Sheets & Power BI I 1.5 month
- Introduction to Google Sheets
- Explore UI and Basic Features
- Mastering Core Formulas
- Arithmetic, Logical, and Autofill Functions
- Advanced Data Manipulation
- Clean, Format, and Freeze Data
- Text Function Handling
- Manipulate Text with Various Functions
- Excel and Google Sheets Integration
- Integrate and Transform Data with Excel
- Utilizing Lookup Functions
- Employ VLOOKUP, HLOOKUP, INDEX/MATCH
- Special Functions Usage
- Explore IFERROR, XLOOKUP, SUMPRODUCT
- Dashboard Creation Techniques
- Design and Build Effective Dashboards
- Data Visualization Skills
- Implement Charts and Pivot Tools
- Case Study Analysis
- Apply Skills in Real-life Scenarios
- Introduction to Power BI
- Charts and Dashboard Creation
- Core Data Transformation Techniques
- Advanced Data Handling
- Data Modeling Foundations
- Fundamentals of Data Analysis Using DAX
- Advanced DAX Techniques
- Interactive and Enhanced Report Making
- Power BI Services and Dashboard Management
- Project Application: UN Volunteers Data Analysis
- Amazon Sales Data Analysis
- Myntra Sales Dashboard
- Analyzing the BusinessFeasibility
- Walmart Retail Data Analysis
- Swiggy Food Price Analysis
- YouTube Content Performance
2. Databases and SQL
AI-Enabled Query Optimization I 1 month
- Introduction to Database Concepts
- Overview of Database Management Systems
- SQL Installation and Environment Setup
- Basic SQL Syntax and Commands
- Creating and Managing Tables
- Techniques for Filtering Numeric and Text Data
- Sorting Data and Using DISTINCT
- Employing Aggregate Functions like SUM, MIN, and MAX
- Crafting Advanced Queries with Subqueries
- Grouping Data with GROUP BY and Filtering with HAVING
- Advanced String and Date Functions
- Implementing Different Types of Joins (INNER, OUTER, CROSS, SELF)
- Utilizing UNION and UNION ALL for Data Merging
- Applying Conditional Logic with CASE Expressions
- Data Type Conversion with CAST and CONVERT
- Detailed Table Operations and Schema Modifications
- Using Constraints for Data Integrity
- Managing Data with Views and Common Table Expressions (CTEs)
- Analyzing Data with Window Functions like RANK and DENSE_RANK
- Creating and Using Stored Procedures for Repeated Operations
- IPL Data Insights
- Advanced Fraud Detection Analytics
- Merchant’s Credit Card Discount Campaign
- Online Betting Game Analysis
3. Data Structure In Python
AI Algorithm and Libraries in Python I 1.5 month
- Introduction to Programming Language
- Introduction to Variables and Operators
- Conditional Statements (if-else, Nested if-else)
- Practice with if-else and Understanding Switch-Case (Using Dictionaries as Python Lacks a Switch Statement)
- Introduction to Character Data Types and Built-in Char Functions
- Introduction and Manipulation of String Data Types
- Introduction and Implementation of For Loop (Basic Examples)
- Advanced Usage of For Loop (Working with Complex Data Structures)
- Basic While Loop Usage
- Advanced Scenarios with While Loops
- Lists and Tuples
- Functions and Exception Handling
- Sets and Dictionaries
- Modules and Working with Files
- Understanding and Creating Simple Functions
- Advanced Functions and Digit Traversal Techniques
- List: Introduction and Manipulation of Lists
- Tuple: Basic Introduction to Tuples and Their Immutability
- Dictionary: Introduction, Usage, and Manipulation of Dictionaries
- Set: Basic Introduction and Operations on Sets
- Project: Implementing a Rock, Paper, Scissors Game Using OOP Concepts
- Exploring Python Through Various Small Projects
- Python for Automation Tasks
- Introduction to Text-to-Image Generation Using Python Libraries
- Eye Mouse-Cursor Tracking
- Personal AI Assistance
- Game – Ping Pong
- Rock-Paper-Scissors
- Text-to-Image Generation
4. Exploratory Data Analytics
AI-Powered Job Preparation and Hunting I 1.5 month
- Git
- GitHub
- Introduction to PIP and Modules
- Data Scraping using BeautifulSoup and Selenium
- NumPy Arrays
- Pandas DataFrame
- Data Loading, Storage & File Formats
- Data Cleaning & Preparation
- Data Wrangling: Join, Combine & Reshape
- Data Aggregation & Group Operations
- Descriptive Statistics
- Statistical Inference
- Population vs Sample
- Frequency Distributions
- Descriptive Measures
- Central Tendency
- Data Distributions
- Data Pre-processing
- Data Visualization with Matplotlib
- Advanced Data Visualization with Seaborn
- Customizing Charts with Plotly and Bokeh
- Building Data Dashboards
- Indian Startups Market Analysis
- Stock Market Financial Crisis Analysis
- Airbnb Data Analysis
5. Machine Learning & NLP
Building your own GPT using API I 1.5 month
- What is Machine Learning?
- Data vs Information
- ML Applications
- Types of Machine Learning
- Linear Regression
- Optimizing Linear Regression
- Polynomial Regression
- Bias-Variance Tradeoff
- Logistic Regression
- Decision Tree
- Ensemble Techniques
- Random Forest
- Feature Engineering Techniques
- PCA
- Text Preprocessing: Tokenization, Lemmatization, Stopword Removal
- Word Frequency Analysis & Visualization
- Regular Expressions for Pattern Matching
- Sentiment Analysis
- Named Entity Recognition (NER) using SpaCy
- Feature Extraction using Bag-of-words & TF-IDF
- Natural Language Processing
- 5+ real-world Projects
- Personal AI voice Assistant
- Practical Experience with Data Analysis
6. Deep Learning & Gen-AI
Advanced Pattern Recognition I 1 month
- Introduction to Neural Networks
- Activation Function
- Feed Forward Neural Networks
- Back Propagation
- Regression using TensorFlow and Keras
- Introduction to Cloud Computing and AWS
- IAM Roles
- Exploring S3, VPC
- Data Warehousing using Redshift
- Data Visualization using Quicksight
- 5+ Real World Projects
- Build Your own LLM
- AWS
800+ Companies
have hired CertiPHYD Learners
Highest Salary
0
LPA
Average Salary
0
LPA
Hiring Partners
0
+
100+ hours of Personalised
Career Prep for Accelerated Job Success 🧑🏻💻
Sprint 1
1:1 Expert Counseling
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Sprint 2
Industry Mentor
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Sprint 3
AI-Powered Portfolio Upgrade
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Sprint 4
Real-World Coding Challenges
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Your Dream Job
Sprint 7
Placement Drive Success
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Sprint 6
HR Readiness
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
Sprint 5
Mock Technical Interviews
Analyze your strengths, weaknesses, and current market trends to pinpoint areas for rapid skill development.
New Advanced IIT Certification
E&ICT IIT Guwahati for Strengthening Your Skills
IIT Guwahati
is the 6th member of the IIT fraternity, the Indian Institute of Technology Guwahati, was founded in 1994, and its academic programme began in 1995. The institute ranked 7th best institute in India.
Prestigious Certification
is the 6th member of the IIT fraternity, the Indian Institute of Technology Guwahati, was founded in 1994, and its academic programme began in 1995. The institute ranked 7th best institute in India.
IIT-Curated Curriculum
is the 6th member of the IIT fraternity, the Indian Institute of Technology Guwahati, was founded in 1994, and its academic programme began in 1995. The institute ranked 7th best institute in India.
Transformative Campus Experience
is the 6th member of the IIT fraternity, the Indian Institute of Technology Guwahati, was founded in 1994, and its academic programme began in 1995. The institute ranked 7th best institute in India.
Inspirational Guest Lectures
is the 6th member of the IIT fraternity, the Indian Institute of Technology Guwahati, was founded in 1994, and its academic programme began in 1995. The institute ranked 7th best institute in India.