AI for Data Analytics & BI Training

Leer hoe je kunstmatige intelligentie (AI) inzet voor geavanceerde data-analyse en business intelligence. In deze training ontdek je hoe AI-tools en -technieken gebruikt worden om patronen te herkennen, voorspellende modellen te bouwen en datagedreven beslissingen te ondersteunen. Je leert werken met AI-modellen in combinatie met dashboards, datavisualisatie en rapportagesystemen zoals Power BI, Tableau of Python-gebaseerde oplossingen.

Wat je leert:

• Toepassen van AI in data-analyseprocessen
• Automatiseren van BI-rapporten met AI-tools
• Gebruik van machine learning-modellen voor voorspellingen
• Integratie van AI met populaire BI-platforms
• Praktische oefeningen met real-world datasets

Inclusief: interactieve e-learning, oefenexamens, en begeleiding van een online mentor.

De AI for Data Analytics & BI Training is een must voor iedere Power BI-gebruiker die méér uit data wil halen. Tijdens deze training leer je hoe je kunstmatige intelligentie kunt toepassen binnen business intelligence, waardoor je analyses slimmer, sneller en toekomstgericht worden.

Heb je de Microsoft PL-300 Power BI Data Analyst training gevolgd of het examen behaald? Dan sluit deze cursus naadloos aan om jouw kennis uit te breiden met AI-technieken. Je ontdekt hoe je voorspellende modellen, natuurlijke taalqueries en machine learning kunt gebruiken om jouw Power BI-rapportages naar een hoger niveau te tillen.

Wat je krijgt:

• AI-integratie in Power BI en BI-processen
• Hands-on voorbeelden met voorspellende analyses
• Verbeterde dashboards met AI-gedreven inzichten
• De perfecte aanvulling op PL-300 certificering

Deze LearningKit met meer dan 25 leeruren is verdeeld in drie sporen:

Demo AI for Data Analytics & BI Training

Cursusinhoud

AI for Data Analytics & BI: Activate

In this track, you will explore foundation Generative AI concepts and prompt engineering techniques.
Courses (11 hours+):

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

AI for Data Analytics & BI: Accelerate

In this track, you will learn to use Power BI AI features and using prompt engineering for data analysis.
Courses (13 hours+)

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

Versterk je datavaardigheden met AI! ✅ Schrijf je vandaag nog in voor onze bekroonde e-learning met praktijkgerichte content, officiële oefenexamens én persoonlijke mentorbegeleiding.