Description
DATA ANALYTICS WITH GENERATIVE AI – 2026
Platform: Marathi Coding Shala
Course Level: Beginner to Advanced
Duration: Approximately 6 Months
Course Description
Master Data Analytics with Generative AI from beginner to advanced level.
Learn Python Programming, SQL, PostgreSQL, Advanced Excel, Power BI, Data Visualization and Generative AI tools through structured classes, practical assignments and real-world projects.
Understand how to use AI tools to automate data analysis, generate SQL queries, write Python code, clean datasets, create reports, build dashboards and generate meaningful business insights.
Build 9 industry-oriented projects and develop a professional GitHub portfolio.
Complete Course Syllabus
Phase 1 – Python Programming Fundamentals
-
Python Basics, Variables and Data Types
-
Operators, Conditions and Loops
-
Lists, Tuples, Sets and Dictionaries
-
Functions and Lambda
-
File Handling and Exception Handling
Phase 2 – SQL & PostgreSQL
-
Database Fundamentals
-
PostgreSQL and pgAdmin
-
DDL, DML and Constraints
-
Joins and Subqueries
-
Views, CTEs and Window Functions
-
Python + PostgreSQL Connectivity
Phase 3 – Core Python Data Analytics
-
CSV Data Handling
-
Data Cleaning and Validation
-
Missing and Duplicate Values
-
Data Transformation
-
Summary Statistics and Aggregation
Phase 4 – Data Analytics Libraries
-
NumPy
-
Pandas
-
Matplotlib
-
Seaborn
-
Exploratory Data Analysis
-
Data Visualization
Phase 5 – Web Scraping & APIs
-
HTML Fundamentals
-
Requests and BeautifulSoup
-
Web Scraping
-
JSON APIs
-
Data Collection and Extraction
Phase 6 – Streamlit Development
-
Streamlit Fundamentals
-
Interactive Dashboards
-
Data Upload and Visualization
-
Analytics Applications
-
Deployment
Phase 7 – Git & GitHub
-
Git Fundamentals
-
Git Commands
-
GitHub Repository
-
Version Control
-
Project Documentation
Phase 8 – Advanced Excel with Generative AI
-
Excel Formulas
-
VLOOKUP, XLOOKUP and INDEX-MATCH
-
Pivot Tables and Charts
-
Power Query
-
Data Cleaning
-
AI-Based Formula Generation
-
ChatGPT and Copilot for Excel
-
AI-Assisted Reporting
Phase 9 – Power BI & Business Intelligence
-
Power BI Desktop
-
Power Query
-
Data Modelling
-
Star Schema
-
DAX Functions
-
Interactive Dashboards
-
Business Intelligence Reports
Phase 10 – Generative AI & End-to-End Capstone
-
Introduction to Generative AI
-
Large Language Models (LLMs)
-
Prompt Engineering
-
ChatGPT for Data Analytics
-
AI-Assisted SQL Query Generation
-
AI-Assisted Python Coding and Debugging
-
AI-Based Data Cleaning Assistance
-
AI-Powered Data Insights
-
AI-Assisted Report Generation
-
Responsible AI Usage and Output Validation
-
End-to-End E-Commerce Analytics & BI Capstone
9 Practical Projects
-
Student Management System
-
E-Commerce Sales Analysis
-
E-Commerce EDA & Visualization
-
Product Data Collection & Analysis
-
Interactive Sales Analytics Dashboard
-
Excel Sales Analytics Dashboard
-
Integrated SQL + Python + Excel Reporting System
-
Power BI Sales Performance Dashboard
-
End-to-End E-Commerce Analytics System
Course Benefits
-
Structured Learning
-
Practical Assignments
-
9 Industry-Oriented Projects
-
Real-World Dataset Practice
-
Generative AI Tools Training
-
GitHub Portfolio Development
-
Technical Interview Preparation
-
Resume & LinkedIn Guidance
Certification & Internship
-
Course Completion Certificate after successful completion of course requirements.
-
Internship Completion Letter after successful completion of applicable internship requirements.
Career Opportunities
-
Data Analyst
-
Junior Data Analyst
-
Business Intelligence Analyst
-
Reporting Analyst
-
MIS Analyst
-
Power BI Developer
-
Junior Business Analyst
Admission & Enquiry: 8767438912
MARATHI CODING SHALA
Learn in Marathi. Build Real Projects. Grow with AI.