Generative AI for Data Analytics

The course aims to enhance data science abilities in making informed decisions for both senior data scientists and managers. Transforming vast amount of data into actionable insights can be trivial. In the era of AI, this power can be harnessed by senior management and data scientists in order to transform data into actionable insights. This course is a journey for managers and data scientists from AI-assisted learning to elevate your understanding of machine learning, business analytics, and statistics. This course is carefully designed to provide with the knowledge and practical skills needed to stay ahead in the rapidly evolving world of data science.

• Identify and discuss practical use cases of AI in modern data analysis and business intelligence contexts.
• Summarize and interpret unstructured data using ChatGPT for efficient insight generation.
• Perform data analysis and exploration tasks with the assistance of ChatGPT.
• Communicate complex findings clearly and effectively using ChatGPT’s natural language processing capabilities.
• Apply prompt engineering techniques to optimize ChatGPT’s analytical and reporting outputs.
• Query and interact with data models in Power BI using Microsoft Copilot.
• Create and refine reports through natural language prompts to enhance visualization and storytelling.
• Leverage Copilot to develop visual narratives from business data for improved strategic communication.
• Use Copilot to generate calculated columns and measures, accelerating analytical workflows.

Introduction to Deep Learning

• Deep learning
• DL and language models
• ChatGPT
• DeepSeek
• Accessing ChatGPT
• Accessing DeepSeek

Understand Text Data with Generative AI

• Summarizing unstructured text
• Mining food choices data
• World population discussion on Wikipedia
• Ask questions to a medical research article (and get answers!)

AI and Data Science

• What is data science?
• What AI can and cannot do
• Three ChatGPT uses in data science

Data analysis with ChatGPT

• How an analysis works
• Practical examples: From Data to Summarizations
• Guide to color-coding in google-sheets
• Brainstorming for analyses
• Inspiration for learning soft skills
• Prompt engineering (usage tips)
• From Analysis to Report Crafting
• Crafting Reports – Puttin it in writing
• Data summaries, visualizations and insights
• Points to text, text to points
• Language translations and Writing emails with ChatGPT
• Usage tips

Microsoft Copilot: Transforming the way Business Intelligence Tools are used

• Overview of Power BI
• What is Copilot and why it matters
• Understanding the prerequisites: licenses, capacities, workspace setup
• How AI is transforming business intelligence
• Demo: Exploring the Copilot interface in Power BI Desktop

Introduction to Copilot

• Accessing Copilot: logging in and selecting the right workspace
• Ensuring your workspace is Copilot-ready (Power BI Premium or Fabric)
• Enabling and managing Copilot in your organization (admin settings)
• Hands-on: Creating a Copilot-enabled workspace and dataset
• Natural Language Queries & Report Generation
• Using Copilot to ask questions and explore your data
• Generating report pages from prompts
• Understanding how Copilot interprets data
• Hands-on: Create a report using natural language prompts

Enhancing Reports with Copilot

• Adding and explaining visualizations with Copilot
• Customizing visual elements based on Copilot suggestions
• Storytelling with data: how to prompt Copilot for summaries and narratives
• Hands-on: Use Copilot to create visual stories from business data

Using Copilot for DAX and Measures

• Introduction to DAX (for beginners)
• How Copilot helps generate and explain DAX measures
• Validating and optimizing DAX queries
• Hands-on: Ask Copilot to create calculated columns and measures

Troubleshooting and AI Best Practices

• Recognizing limitations of Copilot
• When to trust vs. verify AI outputs
• Best prompting practices for clear, useful results
• Ethics & data governance with AI
• Group activity: Spot and fix AI-generated issues in dashboards

Reflection on AI potential of uses

• Course Evaluation

Senior Management, Senior Data Scientists and Senior Data Analysts