Data Analytics with Gen AI
This cutting-edge program combines traditional Data Analytics skills with the power of Generative AI. Learn advanced Excel, SQL, Power BI, and Tableau alongside AI-powered analytics using ChatGPT, Google Gemini, and custom LLM integrations. Master prompt engineering for data analysis, automated report generation, AI-assisted data cleaning, and building intelligent dashboards that leverage Gen AI for predictive insights.
Program Highlights
Target Audience
Business Analysts, Non-technical graduates, Commerce/Arts students, and working professionals wanting to leverage Gen AI for data-driven decision making.
Prerequisites
Basic computer operations. No prior programming or AI experience required — everything is taught from scratch.
Job Roles & Careers
AI-Powered Data Analyst, Gen AI BI Consultant, Business Intelligence Developer, Analytics Engineer.
Salary Outlook
₹5 LPA - ₹12 LPA
Detailed Course Syllabus
- VLOOKUP, HLOOKUP, INDEX-MATCH, and dynamic array functions
- Pivot Tables, Pivot Charts, Slicers, and conditional formatting
- Using ChatGPT and Copilot for Excel formula generation and debugging
- Automating repetitive tasks with Gen AI-assisted macros
- Introduction to databases (MySQL / PostgreSQL) and relational schemas
- SQL queries: Select, filtering, joins (Inner, Left, Right, Full), Group By
- Subqueries, CTEs, and window functions for advanced analytics
- Using Gen AI tools to generate, optimize, and debug SQL queries
- Connecting data sources and ETL processes using Power Query
- Data Modeling: Star Schema, Snowflake Schema, and Relationships
- DAX formulas: Calculated columns, Measures, and Time Intelligence
- Copilot in Power BI: AI-powered visual creation and natural language Q&A
- Tableau workspace, connection types, and calculated fields
- Creating interactive dashboards, stories, and drill-down reports
- Einstein AI integration in Tableau for predictive analytics
- Publishing, sharing, and scheduling automated reports
- Prompt engineering for data analysis: Summarization, pattern detection, anomaly finding
- Building custom AI-powered reporting tools using Python and LLM APIs
- Automated data cleaning and transformation with Gen AI pipelines
- Portfolio project: End-to-end AI-powered analytics dashboard presentation
Batches & Timings
Weekday Batch
Monday - Friday (10:00 AM - 12:00 PM OR 6:00 PM - 8:00 PM)
Weekend Batch
Saturday & Sunday (10:00 AM - 2:00 PM)
Career Benefits & Outcomes
Learn to use ChatGPT, Gemini, and Copilot for automated data analysis and reporting
Building AI-enhanced interactive dashboards in Power BI and Tableau
Hands-on prompt engineering for SQL query generation and data insights
Creating automated ETL pipelines with Gen AI assistance
1-on-1 resume building, portfolio review, and placement support
Quick Summary
- Duration: 3 Months
- Format: Classroom & Online
- Placement Support: 100% Assistance
- Batch: Weekday / Weekend
- Live Projects: AI-Powered Projects
Quick Enquiry
Have questions? Ask our academic counselors.