AI for Data Analytics & BI

AI for Data Analytics & BI

De AI for Data Analytics & BI Training laat je ontdekken hoe kunstmatige intelligentie geïntegreerd kan worden in data-analyse en business intelligence. Je leert AI-functies toepassen in Microsoft Power BI voor geavanceerde rapportages en inzichten.
👉 Deze training is bijzonder interessant voor Power BI-gebruikers, vooral voor wie al de Microsoft PL-300 heeft gevolgd.

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

Specificaties

Taal: Engels
Kwalificaties van de Instructeur: Gecertificeerd
Cursusformaat en Lengte: Lesvideo's met ondertiteling, interactieve elementen en opdrachten en testen
Lesduur: 25:15 uur
Assesments: De assessment test uw kennis en toepassingsvaardigheden van de onderwerpen uit het leertraject. Deze is 365 dagen beschikbaar na activering.
Online Virtuele labs: Ontvang 12 maanden toegang tot virtuele labs die overeenkomen met de traditionele cursusconfiguratie. Actief voor 365 dagen na activering, beschikbaarheid varieert per Training.
Online mentor: U heeft 24/7 toegang tot een online mentor voor al uw specifieke technische vragen over het studieonderwerp. De online mentor is 365 dagen beschikbaar na activering, afhankelijk van de gekozen Learning Kit.
Voortgangsbewaking: Ja
Toegang tot Materiaal: 365 dagen
Technische Vereisten: Computer of mobiel apparaat, Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox, Safari of Edge.
Support of Ondersteuning: Helpdesk en online kennisbank 24/7
Certificering: Certificaat van deelname in PDF formaat
Prijs en Kosten: Cursusprijs zonder extra kosten
Annuleringsbeleid en Geld-Terug-Garantie: Wij beoordelen dit per situatie
Award Winning E-learning: Ja

Tip! Zorg voor een rustige leeromgeving, tijd en motivatie, audioapparatuur zoals een koptelefoon of luidsprekers voor audio, accountinformatie zoals inloggegevens voor toegang tot het e-learning platform.