Data Analytics with Generative AI Workshop-24Hours

Data Analytics with Generative AI Workshop

Duration: 24 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: Core concepts of Data Analytics, Generative AI, Responsible AI, and business problem-solving
• 80% Hands-on Practical: Excel, SQL, Power BI, AI tools, dashboards, 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, business reporting, data modeling, and insight generation

Syllabus

Module 1: Introduction to Data Analytics and Industry Applications — 2 Hours
Introduction to Data Analytics, Types of Analytics, Analytics Lifecycle, business problems, and real-world industry applications of data analytics.
Module 2: Generative AI, Prompt Engineering, and Responsible AI — 2 Hours
Introduction to Generative AI, effective prompt engineering, AI tools such as ChatGPT, Gemini, and Copilot, along with responsible and ethical use of AI.
Module 3: Excel Data Analytics — 6 Hours
Advanced Excel functions, data cleaning, sorting, filtering, conditional formatting, Pivot Tables, Pivot Charts, dashboards, and report creation.
Module 4: SQL for Data Analytics — 5 Hours
SQL basics including DDL, DML, SELECT queries, WHERE, ORDER BY, GROUP BY, aggregate functions, JOINS, subqueries, and business-based SQL queries.
Module 5: Power BI — 5 Hours
Power BI introduction, importing data, Power Query, data cleaning, data modeling, relationships, DAX basics, visualizations, dashboard design, and interactive reports.
Module 6: AI-Assisted Data Analysis and Automated Reporting — 2 Hours
Using Generative AI tools to analyze data, generate SQL queries, create Excel formulas, summarize reports, automate insights, and prepare business reports.
Module 7: End-to-End Analytics Project and Presentation — 2 Hours
Students will complete an end-to-end data analytics mini project using Excel, SQL, Power BI, and AI tools. They will present their dashboards, reports, findings, and business insights.

Pricing Structure

The total workshop duration is 24 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 Mini Project
• Project Presentation

Learning Outcomes

After completing this workshop, students will be able to:

• Understand the Data Analytics lifecycle and real-world business applications
• Clean, organize, analyze, and visualize data using Advanced Excel
• Write SQL queries for database analysis and business reporting
• Build interactive dashboards and reports using Power BI
• Understand basic data modeling and DAX concepts in Power BI
• Use Generative AI tools to create formulas, SQL queries, reports, summaries, and business insights
• Complete and present an end-to-end data analytics project
• Build a foundation for roles such as Data Analyst, Business Analyst, MIS Executive, Reporting Analyst, and Junior Power BI Developer