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

Data Analytics with Generative AI | Python, SQL, Excel & Power BI