Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analytics with Gen AI Tools
Rating: 4.4 out of 5(6 ratings)
38 students

Data Analytics with Gen AI Tools

Master data analysis using ChatGPT, Gemini, Copilot, and other Gen AI tools to accelerate real-world analytics workflows
Created bySkills Marathon
Last updated 7/2025
English
English [Auto],

What you'll learn

  • Apply Generative AI tools like ChatGPT, Gemini, and Copilot to automate data analytics workflows
  • Generate and optimize SQL queries using AI for real-world business datasets
  • Create dashboards and reports in Excel, Power BI, and Google Sheets with AI integration
  • Use LLMs to summarize insights, automate reports, and enhance data storytelling

Course content

2 sections • 19 lectures • 4h 7m total length

  • Introduction5:24

    Explore an Excel project with multiple sheets, data validations, and transaction tracking that integrates income, expenses, categories, and subcategories via dropdowns.

  • video26:09

    Explore how to configure data validation for income and expense categories, set sources and subcategories, adjust currency, and generate analytics reports with charts and visualizations.

  • video36:33

    Analyze personal finances with gen AI tools by separating income sources such as investments and salaries, using percentile analysis and conditional formatting to visualize expenses by category.

  • video44:45

    Explore how to create and customize reporting charts that visualize income, expenses, and percentages, with data labels and color-coded ranges to enhance client-focused insights.

  • video53:34

    Create a concise income and expense summary report, highlighting balances and transactions with conditional formatting, while applying exploratory data analysis for clear bank account insights.

  • video68:25

    Learn to analyze IMDb data sets with SQLite and SQL queries in Xcode or Colab, reading CSV, Excel, or DB files, and extracting movie reviews, directors, and genres.

  • video79:29

    Demonstrate advanced database querying on a movie dataset, employing nested queries, joins, set operations, and grouping to analyze directors, actors by year, and female film counts.

  • video811:30

    Explore data analytics with gen AI tools using SQL-like queries, handle nulls, group by year, MIT, compute percentile of movies with female actors, and examine decade trends and cast size.

  • video96:05
  • video105:05

    Learn to compute a Shahrukh Khan number by modeling the acting graph and implementing nested SQL queries that join persons, movies, and casting to find the shortest path.

Requirements

  • No prior programming experience is required — beginners are welcome
  • Basic familiarity with Excel or spreadsheets is helpful
  • A stable internet connection and a laptop/PC to try out tools
  • Curiosity to explore AI-driven data solutions is a plus

Description

Welcome to Data Analytics with Gen AI Tools, a hands-on, beginner-friendly course crafted to empower aspiring analysts, business professionals, and tech enthusiasts with the latest advancements in Generative AI.

In this course, you’ll learn how to apply tools like ChatGPT, Gemini, GitHub Copilot, Bard, and AI-powered Excel/PBI assistants in your data analytics projects. We’ll explore real-world use cases to automate tasks such as data cleaning, SQL generation, report creation, dashboard design, and even predictive modeling — all through the power of Gen AI.Building simple visualizations and summaries using AI promptsUsing LLMs for storytelling and data interpretation.Ethical considerations and limitations of Gen AI in analytics

You’ll gain experience with:

  • Integrating Gen AI into Excel, Power BI, and Google Sheets

  • Writing AI-assisted SQL queries

  • Automating analytics reports and dashboards

  • Building simple visualizations and summaries using AI prompts

  • Using LLMs for storytelling and data interpretation

  • Ethical considerations and limitations of Gen AI in analytics

This course is project-based, packed with examples and tools that are immediately applicable to your work or portfolio. By the end, you’ll not only save time but also elevate the quality and insight of your data work with Gen AI assistance.

Whether you're a student, data analyst, business analyst, or upskilling professional, this course will give you a major productivity edge.

Who this course is for:

  • Aspiring data analysts and business analysts who want to boost productivity using Gen AI
  • Students and freshers looking to enhance their job-readiness with practical AI tools
  • Working professionals seeking to automate and speed up analytics tasks
  • Entrepreneurs, managers, or educators wanting to leverage AI for faster data decisions

Report abuse