Introduction to Data Analytics Course for Beginners

• Get started with this Data Analytics, GenAI and Adaptive Systems program in partnership with IHFC – TIH of IIT Delhi. 

• Introduction to Business Analytics 
• Excel in Business Analytics
• Conditional Formatting and Essential Functions
• Statistical Data Analysis
• Analysis With Pivot Tables
• Dashboard Creation
• Power BI

• Fundamental SQL Statements 
• Database Restoration and Back-Up
• Filtering With Selection Commands 
• Ordering in Selection Commands
• Understanding Joins
• Execution of Subqueries
• Usage of Views & Indexes

• ETL Fundamentals 
• Data Extraction
• Data Transformation 
• Data Mapping and Conversion
• ETL Tools and Technologies 
• Data Loading
• Batch and Real-Time ETL 
• Error Handling and Logging
• Performance Optimization 
• Automation
• Monitoring and Maintenance

• Introduction to Data Visualization
• Data Organization in Tableau
• Creating Charts and Dashboards
• Working with Filters, Parameters, and Sets
• Heat Maps, Treemaps, and Pareto Charts
• Designing Interactive Dashboards

• Programming Fundamentals 
• Python Data Types and Operators
• Conditional Statements and Loops in Python
• Introduction to Python
• Python Functions

• Python Packages for Data Analytics 
• Categorical Data and Working With Text Data
• Hypothesis Testing Mechanism 
• Statistical Functions
• Explorative Data Analysis (EDA) 
• Data Visualization

• Machine Learning and Generative AI Basics
• Types of Machine Learning: Supervised, Unsupervised and Reinforcement Learning
• Generative AI Algorithms: Neural Networks, GANs, Transformers
• Large Language Models and Chatbots
• Image Generation: GANs, Diffusion Models, VAEs & Hands-on Tools 
• Video Generation: Architectures & Hands-On Tools
• Open-Source AI Model Landscape: Hugging Face and AI Marketplaces
• Prompt Engineering: Chatbot Prompts, OpenAI Playground, Image Generation Prompts

• Overview of Generative AI in Data Analytics 
• Data Augmentation Using Generative AI
• Generative AI for Tailored Data Visualization 
• Generative AI in Data Exploration
• AI-Optimized ETL Processes 
• Generative AI in Data Modeling and Forecasting
• Challenges in Integrating Generative AI 
• Future Directions in Generative AI

• Introduction to Data Ethics
• Legal and Regulatory Frameworks
• Data Privacy and Security Protocols
• Bias in Data and Algorithms
• Ethical Decision-Making in Analytics
• Responsible Data Visualization
• Societal Implications of Data Analytics

• After completing the DA and GenAI courses, you undertake a capstone project to put your new skills into action. With mentor support, you utilize Excel, Python, SQL, Tableau, and other tools to address real-world data challenges. This culminating project represents the pinnacle of your training and offers a chance to demonstrate your expertise to potential employers in a practical context.

• Led by IHFC - TIH of IIT Delhi associated faculty, this masterclass explores how adaptive systems respond to changing environments and uncertainty. Through a mix of theory and hands-on sessions, you’ll learn control strategies, software adaptation, and real-world applications in aerospace, robotics, and industrial systems, equipping you to design and deploy robust, adaptive solutions.

• This masterclass explores agentic AI systems in analytics, focusing on designing autonomous agents that gather, process, and act on data. Learn to automate tasks like data prep, feature selection, anomaly detection, and real-time insights. With hands-on demos and case studies, you'll build ethical agentic solutions for predictive modeling and self-driving analytics, while staying updated on trends in autonomous decision-making.

This course equips you with the skills to perform advanced data analysis and create interactive dashboards using Power BI. You'll learn to address business challenges by building responsive dashboards, leveraging Quick Insights, and utilizing natural language Q&A for actionable visualizations. The program also covers best practices in report design, setting up data alerts, and resolving common issues, enabling you to optimize workflows and deliver impactful, data-driven narratives.

• ChatGPT said: This course introduces R, a key language in data science and analytics. Learn to set up R, RStudio, and essential packages while building skills in programming, data wrangling, and visualization. Master core statistical concepts, hypothesis testing, regression models, and clustering techniques to unlock R’s full potential for actionable insights.