AI for Data Analytics & BI Training

The AI for Data Analytics & BI Training demonstrates how artificial intelligence can significantly enhance the capabilities of data analytics and business intelligence. You will learn how to integrate AI features into Microsoft Power BI to deliver deeper insights and advanced reporting.

Key topics include:

• Introduction to AI in data analytics and business intelligence
• Overview of AI capabilities within Microsoft Power BI
• Applying AI functions such as sentiment analysis, predictive modeling, and clustering
• Integrating Azure Cognitive Services and Azure Machine Learning into Power BI
• Using AI visuals like Key Influencers and Decomposition Tree
• Automating data analysis with AI-driven workflows
• Practical use cases and hands-on exercises for BI reporting
• Best practices for combining AI and BI to support decision-making
• Data ethics and responsible use of AI in analytics

This training is particularly relevant for Power BI users, especially those who have already completed the Microsoft PL-300 and want to extend their expertise with AI applications.

This LearningKit with more than 25 hours of learning is divided into three tracks:

Demo AI for Data Analytics & BI Training

Course content

An Introduction to Generative AI

Course: 1 Hour, 41 Minutes

• Course Overview
• What Is Generative AI?
• Content Generation Using Generative Models
• Prompt Engineering
• Evolution of Generative AI
• Recent Advances in Generative AI
• Applications of Generative AI
• Generative AI Risks
• Ethical Considerations in Working with Generative AI
• Deepfake AI
• Course Summary

An Introduction to GPT Models

Course: 1 Hour, 53 Minutes

• Course Overview
• What Is GPT?
• Foundation Models and the GPT-n Series
• Attention Is All You Need
• Understanding the Transformer Architecture – I
• Understanding the Transformer Architecture – II
• Understanding the GPT Model
• Understanding Foundation Models
• Model Alignment – Supervised Fine-tuning (SFT)
• Model Alignment – Reinforcement Learning from Human Feedback (RLHF)
• Prompt Engineering and Prompt Tuning
• Course Summary

Artificial Intelligence and Machine Learning

Course: 1 Hour, 37 Minutes

• Course Overview
• What is Artificial Intelligence (AI) and Machine Learning (ML)
• Understanding Machine Learning
• A Brief History of Machine Learning
• Supervised and Unsupervised Learning
• Regression
• Classification
• Clustering
• Linear Regression, Logistic Regression, and Decision Trees
• Ensemble Learning
• Course Summary

AI Landscape: Deep Learning and Neural Networks

Course: 1 Hour, 20 Minutes

• Course Overview
• Understanding Deep Learning
• Understanding Neurons
• Training a Neural Network
• Convolutional Neural Networks (CNNs)
• Recurrent Neural Networks (RNNs)
• Natural Language Processing (NLP)
• Attention-based Models and Transformers
• Generative Adversarial Networks (GANs)
• Reinforcement Learning
• Course Summary

Introduction to Prompt Engineering: Getting Started with Prompt Engineering

Course: 2 Hours, 1 Minutes

• Course Overview
• Introducing Prompt Engineering
• Prompt Engineering and the Open AI Playground
• Understanding Generative AI and LLMs
• Prompt Engineering Use Cases
• Creating an Account on ChatGPT and Exploring ChatGPT's Interface
• Conducting a Natural Language Conversation Using Prompts with ChatGPT
• Exploring Bard for Conversational AI
• Conducting a Natural Language Conversation with Google Bard
• Working with Bing for Conversational AI8
• Conducting a Natural Language Conversation with Bing Chat
• Using the Precise Mode and Creative Mode on Bing Chat
• Exploring Perplexity AI for Natural Language Searches
• Working with Perplexity AI Focus Modes and Features
• Course Summary

Introduction to Prompt Engineering: Exploring Prompt Engineering Techniques

Course: 1 Hour, 55 Minutes

• Course Overview
• Prompt Crafting
• Exploring Elements of a Prompt
• Exploring Prompt Categories
• Seeking Facts and Explanations
• Summarizing Text Using Prompts
• Classifying Text Using Prompts
• Extracting Information Using Prompts
• Answering Questions with Prompts
• Using Prompts for Writing, Grammar, and Tone
• Exploring Ideation and Roleplay Prompts
• Using Mathematical Logical and Predictive Reasoning Prompts
• Course Summary

Introduction to Prompt Engineering: Case Studies in Prompt Engineering

Course: 1 Hour, 20 Minutes

• Course Overview
• Generating Data Using Prompts
• Generating Code Using Descriptive and Comment Prompts
• Starter Code Prompts and Generating SQL Queries
• Utilizing Code Conversion and Code Explanations
• Debugging Code and Generating Code Using Documentation
• Working with Zero-shot and Few-shot Prompts
• Working with Chain-of-Thought Prompts
• Working with Augmented Knowledge Prompts
• Course Summary

Leveraging AI Insights & Text Analytics in Power BI

Course: 2 Hours, 14 Minutes

• Course Overview
• Leveraging Artificial Intelligence (AI) in Power BI
• Generating AI Insights on Datasets
• Importance of Data in Generating Insights
• Optimizing Data for Better Insights
• Extracting Insights from Reports
• Analyzing Insights from Reports
• Viewing Insights from Dashboard Tiles
• Explaining Fluctuations in Visuals
• Discovering Where Distributions Vary
• Performing Language Detection Using Text Analytics
• Performing Key Phrase Extraction Using Text Analytics
• Performing Sentiment Scoring with Text Analytics
• Executing Image Tagging Using Vision Analytics
• Course Summary

Training Machine Learning Models in Power BI

Course: 1 Hour, 43 Minutes

• Course Overview
• Creating a Dataflow and Exploring Data for Binary Classification
• Training a Binary Classification Model
• Analyzing the Training Report, Top Influencers, and Probability Thresholds
• Performing Cost Benefit Analysis and Assessing Model Performance
• Exploring Data Loading and Exploratory Data Analysis for Regression
• Configuring and Training a Regression Model
• Evaluating and Interpreting the Training Report
• Loading Data and Exploring Multi-class Classification
• Viewing Training Metrics for Multi-class Classification
• Retraining the Model with New Data
• Course Summary

AI-powered Visuals in Power BI

Course: 1 Hour, 25 Minutes

• Course Overview
• Performing Anomaly Detection with Insights and Forecasting
• Detecting and Explaining Anomalies
• Drilling Down into Measures Using the Decomposition Tree
• Using AI Splits to Build the Decomposition Tree
• Locking and Unlocking Levels
• Interpreting Key Influencer Visuals
• Viewing Multiple Key Influencers and Top Segments
• Configuring Key Influencer Visuals
• Creating Key Influencers for Continuous Numeric Metrics
• Course Summary

Smart Narratives, Q&A Visuals, & Copilot in Power BI

Course: 1 Hour, 18 Minutes

• Course Overview
• Generating Smart Narratives for Visuals
• Creating and Configuring Dynamic Values in Smart Narratives
• Generating Smart Narratives with Filters, Clusters, and for Reports
• Asking Natural Language Questions Using Q&A Visuals
• Teaching Q&A New Terms Used in Queries
• Configuring Synonyms and Suggested Questions for Q&A
• Using Copilot to Write DAX Formulas for Quick Measures
• Generating More Complex DAX Formulas with Copilot
• Course Summary

Prompt Engineering for Data: Leveraging Prompts When Working with Data

Course: 1 Hour, 38 Minutes

• Course Overview
• Prompt Engineering for Data Analysis
• Introducing Prompt Engineering
• Getting Set Up for Data Analysis and Visualization
• Creating pandas Series Objects
• Using ChatGPT to Understand Index Labels for pandas Series
• Indexing and Filtering Series Using .loc and .iloc
• Performing Operations on pandas Series
• Creating pandas DataFrame Objects
• Viewing DataFrame Properties with Generative AI's Help
• Performing DataFrame Indexing Using .loc and .iloc
• Course Summary

Prompt Engineering for Data: Basic Data Manipulation Using Generative AI

Course: 1 Hour, 36 Minutes

• Course Overview
• Exploring, Debugging, and Reading CSV Files with Bard
• Reading Data from Multiple Sources
• Writing Data Using Multiple Formats
• Column Dropping and Selection Using Generative AI Tools
• Performing Basic Data Frame Operations
• Using ChatGPT to Iterate over and Sort DataFrames
• Debugging Sorting Issues with Generative AI Help
• Computing New Columns Using Existing Data
• Learning to Use the Apply Function
• Using Chain-of-Thought Prompting for a Sequence of Operations
• Course Summary

Prompt Engineering for Data: Leveraging Prompts for Filtering & Grouping Data

Course: 1 Hour, 49 Minutes

• Course Overview
• Filtering by Column Headers and Row Labels
• Performing Filtering and Querying on Data
• Executing Complex Queries
• Filtering Using Dates and Strings
• Performing Simple Aggregations
• Performing Grouped Aggregations with ChatGPT's Help
• Performing Multi-column Grouping and Split-Apply-Combine
• Using Prompts to Identify and Remove Duplicates
• Cleaning Categorical Data
• Using Prompt Engineering to Deal with Missing Values
• Working with Pivots and Pivot Tables
• Reshaping and Aggregating Data Using Pivot Tables
• Course Summary

Prompt Engineering for Data: Combining & Visualizing Data Using Generative AI

Course: 1 Hour, 45 Minutes

• Course Overview
• Combining DataFrames
• Using Debugging and Explanation Prompts to Combine Data
• Merging Data Using Inner Joins
• Exploring Other Join Types with Google Bard's Help
• Merging on Multiple Columns and Validating Relationships
• Visualizing Time Series Data
• Grouping and Aggregating Time Series Data with Generative AI
• Exploring Univariate Visualizations with Prompt Engineering
• Using ChatGPT's Recommendations for Bivariate Visualizations
• Creating Interactive Time Series Visualizations with Plotly
• Creating Interactive Scatter Plots and seaborn Heatmaps
• Course Summary

Boost your data skills with AI! ✅ Enroll today in our award-winning e-learning program featuring real-world projects, official practice exams, and expert mentor support.