Data Analytics with Generative AI Workshop-40 Hours

Data Analytics with Generative AI Workshop- 40 Hours
Duration: 40 Hours

Target Audience

This workshop is suitable for:

• BCA, B.Sc., B.Com., BBA, BE, and B.Tech students
• MCA, MBA, M.Sc., M.Com., and M.Tech students
• Freshers looking to start a career in Data Analytics
• Aspiring Data Analysts and Business Analysts
• Students who want to learn Excel, SQL, Power BI, and Generative AI tools

Prerequisites

Participants should have:

• Basic computer knowledge
• Familiarity with Microsoft Excel is preferred but not mandatory
• No programming experience is required
• A laptop or desktop system with a minimum of 8 GB RAM is compulsory for practical sessions

Workshop Approach

The workshop follows a practical and interactive learning approach:

• 20% Theory: Data Analytics concepts, business problem-solving, Generative AI, prompt engineering, and analytics lifecycle
• 80% Hands-on Practical: Excel, SQL, Power BI, AI tools, dashboards, automation, reports, and projects
• Practice using real-world datasets and industry-based business scenarios
• AI-assisted learning using Generative AI tools such as ChatGPT, Gemini, and Copilot
• Guidance for dashboard creation, data modeling, report generation, automation, and insight presentation

Syllabus

Module 1: Data Analytics Fundamentals — 3 Hours
Introduction to Data Analytics, types of analytics, data sources, data quality, key analytics concepts, and industry applications.
Module 2: Business Problem Solving and Analytics Lifecycle — 2 Hours
Understanding business problems, defining objectives, identifying KPIs, analytics lifecycle, data-driven decision-making, and real-world case studies.
Module 3: Generative AI and Prompt Engineering — 3 Hours
Introduction to Generative AI, AI tools such as ChatGPT, Gemini, and Copilot, effective prompt engineering, responsible AI, and using AI for analytics tasks.
Module 4: Excel for Data Analytics — 10 Hours
Excel basics to advanced concepts including data cleaning, sorting, filtering, conditional formatting, formulas, functions, lookup functions, logical functions, Pivot Tables, Pivot Charts, dashboards, and report creation.
Module 5: SQL for Data Analytics — 8 Hours
SQL fundamentals including database concepts, DDL, DML, SELECT queries, WHERE, ORDER BY, GROUP BY, aggregate functions, JOINS, subqueries, views, and business-based SQL queries.
Module 6: Power BI — 8 Hours
Power BI introduction, importing data, Power Query, data cleaning and transformation, data modeling, relationships, DAX basics, measures, calculated columns, visualizations, dashboard design, interactive reports, and publishing dashboards.
Module 7: AI-Powered Data Analysis and Automation — 3 Hours
Using Generative AI tools for data analysis, generating Excel formulas and SQL queries, creating report summaries, automating insights, preparing business reports, and improving analyst productivity.
Module 8: End-to-End Capstone Project — 3 Hours
Students will complete an end-to-end capstone project using Excel, SQL, Power BI, and Generative AI tools. They will analyze a real-world dataset, create dashboards, generate reports, and present actionable business insights.

Pricing Structure

The total workshop duration is 40 Hours.

• In-House Workshop: Rs 2,500 per candidate
• Onsite Workshop: Rs 1,500 per candidate

For a batch of 40 students:

• Onsite Workshop: 40 × Rs 1,500 = Rs 60,000
• In-House Workshop: 40 × Rs 2,500 = Rs 1,00,000

The batch size should be a minimum of 40 students and a maximum of 60 students. If the batch size is below 40 students, charges will be calculated on an hourly basis.

Practical Distribution

Students will receive practical training through:

• Excel Dashboard Creation
• SQL Query Practice
• Power BI Dashboard Development
• AI-Generated Reports and Automated Insights
• End-to-End Capstone Project
• Project Presentation

Learning Outcomes

After completing this workshop, students will be able to:

• Understand Data Analytics fundamentals and the complete analytics lifecycle
• Identify business problems, KPIs, and data-driven solutions
• Clean, analyze, and visualize data using Excel
• Write SQL queries to retrieve, analyze, and report business data
• Build interactive Power BI dashboards using Power Query, data modeling, and DAX
• Publish and share Power BI reports and dashboards
• Use Generative AI tools for faster data analysis, automation, and report generation
• Complete an end-to-end analytics project and confidently present insights
• Build job-ready skills for Data Analyst, Business Analyst, MIS Executive, Reporting Analyst, and Junior Power BI Developer roles