Data Science and Analytics with AI (Cohort-03)

Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Introductory Class

  • Data Science and AI (Batch-03) Introductory Class
    02:07:07

Power BI – Introduction of Power BI – Power Query

Power BI – Text Tools | Number Tools | Reference Queries | Column Quality | Date Tools

Power BI – Conditional Columns | Column from Examples | Date Tools | Group By | Filtering & Sorting | Parameters

Power BI – Append Queries | Select from Folder | Data Normalization | Data Modelling

Power BI – Data Modelling | Star & Snowflake Schema | Data Formatting | DAX Calculated Columns (Text & Date Functions)

Power BI – Text Functions | Date Functions | Logical Operators | Logical Functions

Power BI – Logical Functions

Power BI – Measures | Implicit vs Explicit Measures | Filter Context & Flow | Aggregation Functions

Power BI – CALCULATE | ALL & FILTER Functions | Variables & Commenting

Power BI – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions

Power BI – Handling Errors | Data Visualization (Navigation, Images, Cards, Formatting)

Power BI – Data Visualization (Charts, Forecasting, Reference Lines)

Power BI – Data Visualization (Filters, Tables, Matrix, Cards, Slicers, Area Chart)

Power BI – Gauge Chart | Drilling | Bookmarks & Page Navigation | Custom Tooltips | Conditional Formatting

SQL – Introduction to Databases | Clauses (SELECT, FROM, WHERE, GROUP BY) | TOP N & TOP N PERCENT

SQL – Clauses (HAVING, ORDER BY) | Order of Operations | Aggregation Functions | Numerical, Date & String Functions

SQL – Comparison & Conditional Operators | IS / IS NOT | ISNULL Function

SQL – JOINS | Data Modeling (ER Diagrams, Relationships) | Fact vs Dimension | UNION

SQL – LIKE Function | Views | Subqueries

SQL – Subqueries | Window Functions

SQL – Data Cleaning in MySQL

Class 01 – Python Fundamentals: Data Types – Integers & Floats for numerical operations | Strings & Formatted Strings for text handling and output formatting

Class 02 – Python Fundamentals: Collections & Conditionals – Lists, Tuples, Dictionaries, and Sets for data handling | Booleans and if-elif-else statements for logic control

Class 03 – Python Fundamentals – Loops & Functions | For and While Loops for Iteration | User-Defined Functions for Reusability | Lambda Functions for Concise Operations

Class 04 – Python Fundamentals: Advanced Programming | Mini Projects | UDF, Loops & Conditionals | Introduction to Python Libraries | NumPy Deep Dive:Funtions and Arrays (1D/2D/3D), Slicing & Indexing

Class 05 – Python Libraries: Data Visualization & Analysis | Matplotlib for Advanced Visualizations | Pandas Deep Dive with Built-in Functions | Exploratory Data Analysis Project Implementation

Class 06 – Python Real-World Applications | QR Code Generator App | Dynamic Email Sender for Multiple Recipients | PDF Text & Image Extraction | Audio Transcription & Translation using Whisper & Google Translator | Freelancing Opportunities Discussion

Class 07 – Library Functions Practice | NumPy: Advanced Array Creation Functions & I/O Operations | Pandas: Series & DataFrames Deep Dive | Data Selection, Manipulation & Aggregation | Combining DataFrames & Data Cleansing | HTML Data Import

Class 08 – Library Functions Practice | Matplotlib: Bar, Line, Scatter Plots, Histograms, Box & Violin Plots | Seaborn: Categorical, Relational & Distributional Plots | Advanced Plotting Techniques

Class 09 –

Class 10 –

Class 11 – Python Project – 365 Men’s Clothing

Class 12 – Course roadmap | Structured learning approach | VS Code setup | Virtual environments | Troubleshooting, and personalized guidance.

Class 13 – Detailed practice session on Python conditionals | loops | Operators | Functions with examples and query resolution.

Class 14 – Learned from Scratch (Streamlit) | Created Multiple Widgets on it | Machine Learning Classification Project on Streamlit | Learned How to Run project on Local | Learned How to Deploy project on Live Environment

Class 15 – Learned Object-Oriented Programming (OOP) Concepts | Understood Classes, Objects, and Instance Members | Practiced Polymorphism, Encapsulation & Abstraction | Explored Magic Methods & Operator Overloading | Strengthened Code Reusability and Flexibility

Class 16 – Learned ANN Architecture and Working | Understood Sequential & Dense Layers, Weights, Biases, and Activations (ReLU, Sigmoid) | Implemented Forward Propagation | Began Churn Modeling Prediction Project (Data Collection & Preprocessing)

Class 17 – Learned ANN Architecture (Sequential, Dense Layers) | Activation Functions (ReLU, Sigmoid) | Forward Propagation | Optimizer (Adam) & Learning Rate | Model Training (fit, epochs) | Early Stopping | TensorBoard | Model Saving & Predictions

Class 18 – Learned Gen AI & LLM Basics | Explored LangChain Ecosystem | Built Chatbot with Conversation Memory, Context Handling & Streaming in Streamlit

Class 19 – Learned LSTM and GRU Architectures & Training Process | Built End-to-End “Next Word Prediction” Project covering Data Prep, Model Building, Evaluation & Deployment

Class 20 – Search Engine AI Agents | Tool Creation & Custom Tools | Agent Prep & AgentExecutor | LLM + Tool Integration | Streamlit UI & Groq Key | Dynamic Tool Selection & Real-time Reasoning

Class 21 – Built a ReAct Agent in Streamlit using Groq LLM with Web, Wiki, and Research Tools | implemented Reasoning Loops and Chat UI | Began RAG Q&A Project with PDF Upload | Metadata Setup, and Text Chunking.

Class 22 – Streamlit Chat UI | Groq API Key Load | Multi-PDF Upload | Text Extraction & Chunking | MiniLM Embeddings + Persisted Chroma | History-Aware Query Rewriting | Relevant Chunk Retrieval | Final QA with Groq LLM | Session Chat History + Retrieved Context

Class 23 – SQLite DB Setup | Streamlit UI + Sidebar Upload | Tempfile DB Handling | SQLAlchemy Engine & Table Inspection | Cached DB Wrapper | GROQ_API_KEY Config | ChatGroq LLM for SQL Generation

Class 24 – Python Library Imports | sqlite3 DB Connection | Cursor & SQL Execution | Table Creation & Record Insertion | Query Execution & DB Workflow (execute/commit/close) | Streamlit Data Display | Groq LLM AI Agent | Prompt Engineering | Schema-to-Text Conversion | Safe SQL Generation | AI Reasoning & Follow-Up Suggestions | Natural-Language SQL Explanation | Data-to-AI Product Pipeline

Class 25 – FastAPI App Setup | LangChain–FastAPI Integration | Secure API Key Management (.env) | Reusable Prompt Templates | GPT-4o-mini LLM Integration | LangServe Endpoints (/essay & /poem) | Streamlit Frontend UI | API Requests & JSON Payloads | Custom CSS Styling | Full-Stack AI Workflow (Backend → LLM → Frontend)

Class 26 – CrewAI Multi-Agent Workflow | Researcher & Writer Agents | Custom LLM Token Preset | YouTube Channel URL Validation | Smart Channel Search Tool | Query Expansion Logic | yt_dlp Fallback Scanner | Transcript Clip Extraction | Research Brief Generation | Structured Blog Writing Task | Markdown Output Saving | Streamlit UI Controls | Sequential Task Orchestration | One-Click YouTube-to-Blog Pipeline

Class 27 – Multi-Agent Design (Web Search + Finance Tools) | Live Internet & Market Data Retrieval | Role-Based Agent Behavior | Unified Multi-Agent Output | Markdown-Structured Financial Reports | Groq-Powered Fast Reasoning | Phidata + FastAPI Backend | Agent Playground UI | Complete End-to-End Financial Assistant System

Class 28 – Multi-source Summarization App (Web, YouTube, PDFs) | Smart Content Detection | Text Cleaning & Chunking | Map-Reduce + Simple Summaries | Dynamic Prompting (Style, Tone, Length) | Fast Groq LLM Integration | Robust Error Handling | Helper Utilities (Validation, Transcripts, Temp PDFs) | Source Previews | Downloadable Outputs | Clean Streamlit UI Components

Class 29 – Machine Learning Foundations & Supervised Learning | Types of Machine Learning | The ML Workflow | Regression Concepts | Hands-on: Linear Regression | Introduction to Classification | Logistic Regression

Class 30 – Overfitting & Underfitting | Decision Trees | Random Forests | Unsupervised Learning | Dimensionality Reduction (Conceptual) | Introduction to Neural Networks | Hands-on Neural Network Project