Instructor-Led Online Training

MODULE 1 – Introduction to Generative AI & AI Fundamentals 

Duration: 2 Hours 

Topics Covered 

• What is AI?  

• Difference:  

• AI vs ML vs Deep Learning vs GenAI  

• What is Generative AI?  

• Evolution of AI  

• Popular AI tools overview:  

• ChatGPT  

• Microsoft Copilot  

• Google Gemini  

• Claude  

• Perplexity  

• How GenAI is transforming analytics industry  

• AI use cases in corporate environments  

Practical Activities 

• AI-assisted content generation 

• AI Q&A exercises 

• Understanding prompts 

MODULE 2 – Prompt Engineering for Data Analytics 

Duration: 2 Hours 

Topics Covered 

• What is Prompt Engineering?  

• Types of prompts:  

• Basic prompts  

• Structured prompts  

• Role-based prompts  

• Analytical prompts  

• Prompt frameworks:  

• Persona-based prompting  

• Chain prompting  

• Contextual prompting  

• Writing effective prompts for:  

• Analytics  

• Reporting  

• Insights  

• Dashboards  

Hands-on 

• Creating prompts for: 

• KPI analysis  

• Business Summaries  

• Chart Suggestions  

• Report Automation  

• Stakeholder Communication  

MODULE 3 – GenAI with Excel 

Duration: 2 Hours 

Topics Covered 

• AI features in Excel  

• Analyze Data Functionality  

• Formula Generation using AI  

• AI-Assisted:  

• Data cleaning  

• Formatting  

• Summarization  

• Pattern Identification  

• Using ChatGPT for Excel formulas  

• Generating:  

• VLOOKUP  

• XLOOKUP  

• IF  

• SUMIFS  

• Dynamic array formulas  

• AI for dashboard suggestions  

Hands-on 

• Formula generation using AI 

• Excel automation prompts 

• Data cleaning using AI support 

MODULE 4 – GenAI with SQL 

Duration: 2 Hours 

Topics Covered 

• Using AI for SQL Query Generation  

• Converting Business Questions into SQL  

• AI-assisted:  

• Joins  

• Subqueries  

• CTEs  

• Window Functions  

• Query optimization using AI  

• Explaining SQL queries with AI  

Practical Activities 

• Generate SQL queries from business scenarios 

• Debugging SQL using ChatGPT 

• Query explanation exercises 

MODULE 5 – GenAI with Power BI 

Duration: 2 Hours 

Topics Covered 

• AI visuals in Power BI  

• Q&A feature  

• Smart Narratives  

• AI-assisted DAX generation  

• Using AI for:  

• KPI suggestions  

• dashboard storytelling  

• business insights  

• Copilot in Power BI overview  

• AI-driven dashboard optimization  

Hands-on 

• DAX generation prompts 

• Dashboard enhancement ideas 

• AI insight generation 

MODULE 6 – GenAI with Tableau 

Duration: 2 Hours 

Topics Covered 

• AI in Tableau ecosystem  

• Tableau Pulse overview  

• AI-assisted calculated fields  

• AI-generated visualization suggestions  

• Dashboard storytelling using AI  

• Explain Data feature  

Practical Activities 

• AI-generated chart recommendations 

• Visualization storytelling 

• Business summary generation 

MODULE 7 – Python + GenAI for Analytics 

Duration: 2 Hours 

Topics Covered 

• Using AI to write Python code  

• AI-assisted:  

• Pandas Operations  

• Data Cleaning  

• EDA  

• Visualization  

• Generating charts using AI  

• Debugging Python errors with AI  

• AI-generated comments/documentation  

Hands-on 

• AI-generated Python scripts 

• Cleaning datasets using AI support 

• Visualization code generation 

MODULE 8 – AI Productivity, Ethics & Real Corporate Use Cases 

Duration: 2 Hours 

Topics Covered 

• AI productivity hacks for analysts  

• Automating repetitive tasks  

• AI for:  

• Email Drafting  

• Presentation Summaries  

• Report Narration  

• Stakeholder Communication  

• Responsible AI Usage  

• AI Limitations & Hallucinations  

• Data Privacy & Compliance  

• Future of AI in Analytics  

Corporate Case Studies 

• Sales dashboard automation  

• HR analytics  

• Financial reporting  

• Operations reporting  

• Marketing analytics  

Final Activity 

End-to-end AI-assisted analytics workflow demo 

Suggested Tools 

• ChatGPT  

• Microsoft Copilot  

• Excel  

• Power BI  

• Tableau  

• SQL/MySQL  

• Python  

• Google Gemini  

Deliverables 

• Participants will receive: 

• Training Notes 

•  Practice Exercises 

•  Prompt Library 

• Sample Datasets 

• Hands-on Assignments 

• Completion Certificate 

Target Audience 

• Data Analysts  

• MIS Executives  

• Business Analysts  

• Reporting Professionals  

• Excel Users  

• Power BI/Tableau Users  

• Managers & Team Leads  

• Non-technical professionals exploring AI  

Learning Outcomes 

By the end of the program, learners will be able to: 

• Use GenAI tools confidently 

• Automate reporting tasks 

• Generate formulas, SQL & DAX using AI 

• Build smarter dashboards 

• Improve productivity significantly 

• Create business insights faster 

• Use AI responsibly in analytics workflows