Jen Stirrup,
Thomas Weinandy
Artificial Intelligence with Microsoft Power BI
Simpler AI for the Enterprise
Paperback Engels 2024 1e druk 9781098112752Levertijd ± 16 werkdagen
Gratis verzonden
Samenvatting
Advance your Power BI skills by adding AI to your repertoire at a practice level. With this practical book, business-oriented software engineers and developers will learn the terminologies, practices, and strategy necessary to successfully incorporate AI into your business intelligence estate. Jen Stirrup, CEO of AI and BI leadership consultancy Data Relish, and Thomas Weinandy, research economist at Upside, show you how to use data already available to your organization.
Springboarding from the skills that you already possess, this book adds AI to your organization's technical capability and expertise with Microsoft Power BI. By using your conceptual knowledge of BI, you'll learn how to choose the right model for your AI work and identify its value and validity.
- Use Power BI to build a good data model for AI
- Demystify the AI terminology that you need to know
- Identify AI project roles, responsibilities, and teams for AI
- Use AI models, including supervised machine learning techniques
- Develop and train models in Azure ML for consumption in Power BI
- Improve your business AI maturity level with Power BI
- Use the AI feedback loop to help you get started with the next project
Specificaties
ISBN13:9781098112752
Taal:Engels
Bindwijze:paperback
Aantal pagina's:350
Uitgever:O'Reilly
Druk:1
Verschijningsdatum:30-4-2024
Hoofdrubriek:IT-management / ICT
Lezersrecensies
Wees de eerste die een lezersrecensie schrijft!
Inhoudsopgave
Preface
What Is the Current State of AI Technology in Businesses?
The Structure of This Book
Why Did We Write This Book?
Who Is This Book For?
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments
1. Getting Started with AI in the Enterprise: Your Data
Overview of Power BI Data Ingestion Methods
Workflows in Power BI That Use AI
How Are Dataflows Created?
Things to Note Before Creating Workflows
Streaming Dataflows and Automatic Aggregations
Getting Your Data Ready First
Getting Data Ready for Dataflows
Where Should the Data Be Cleaned and Prepared?
Real-Time Data Ingestion Versus Batch Processing
Real-Time Datasets in Power BI
Batch Processing Data Using Power BI
Importing Batch Data with Power Query in Dataflows
The Dataflow Calculation Engine
Dataflow Options
DirectQuery in Power BI
Import Versus Direct Query: Practical Recommendations
Premium, Pro, and Free Power BI
Summary
2. A Great Foundation: AI and Data Modeling
What Is a Data Model?
What Is a Fact Table?
Why Is Data Modeling Important?
Why Are Data Models Important in Power BI?
Why Do We Need a Data Model for AI?
Advice for Setting Up a Data Model for AI
Analytics Center of Excellence
Earning Trust Through Data Transactions
Agile Data Warehousing: The BEAM Framework
Data Modeling Disciplines to Support AI
Data Modeling Versus AI Models
Data Modeling in Power BI
What Do Relationships Mean for AI?
Flat File Structure Versus Dimensional Model Structure in Power BI
Summary
3. Blueprint for AI in the Enterprise
What Is a Data Strategy?
Artificial Intelligence in Power BI Data Visualization
Insights Using AI
Automated Machine Learning (AutoML) in Power BI
Cognitive Services
Data Modeling
Real-World Problem Solving with Data
Binary Prediction
Classification
Regression
Practical Demonstration of Binary Prediction to Predict Income Levels
What Is the Current State of AI Technology in Businesses?
The Structure of This Book
Why Did We Write This Book?
Who Is This Book For?
Conventions Used in This Book
Using Code Examples
O’Reilly Online Learning
How to Contact Us
Acknowledgments
1. Getting Started with AI in the Enterprise: Your Data
Overview of Power BI Data Ingestion Methods
Workflows in Power BI That Use AI
How Are Dataflows Created?
Things to Note Before Creating Workflows
Streaming Dataflows and Automatic Aggregations
Getting Your Data Ready First
Getting Data Ready for Dataflows
Where Should the Data Be Cleaned and Prepared?
Real-Time Data Ingestion Versus Batch Processing
Real-Time Datasets in Power BI
Batch Processing Data Using Power BI
Importing Batch Data with Power Query in Dataflows
The Dataflow Calculation Engine
Dataflow Options
DirectQuery in Power BI
Import Versus Direct Query: Practical Recommendations
Premium, Pro, and Free Power BI
Summary
2. A Great Foundation: AI and Data Modeling
What Is a Data Model?
What Is a Fact Table?
Why Is Data Modeling Important?
Why Are Data Models Important in Power BI?
Why Do We Need a Data Model for AI?
Advice for Setting Up a Data Model for AI
Analytics Center of Excellence
Earning Trust Through Data Transactions
Agile Data Warehousing: The BEAM Framework
Data Modeling Disciplines to Support AI
Data Modeling Versus AI Models
Data Modeling in Power BI
What Do Relationships Mean for AI?
Flat File Structure Versus Dimensional Model Structure in Power BI
Summary
3. Blueprint for AI in the Enterprise
What Is a Data Strategy?
Artificial Intelligence in Power BI Data Visualization
Insights Using AI
Automated Machine Learning (AutoML) in Power BI
Cognitive Services
Data Modeling
Real-World Problem Solving with Data
Binary Prediction
Classification
Regression
Practical Demonstration of Binary Prediction to Predict Income Levels
Gather the Data
Create a Workspace
Create a Dataflow
Model Evaluation Reports in Power BI
Summary
4. Automating Data Exploration and Editing
The Transformational Power of Automation
Surviving (and Thriving with) Automation
AI Automation in Power BI
AI in Power Query
Get Data from Web by Example
Demo 4-1: Get Data from Web by Example
Add Column from Examples
Demo 4-2: Add Column from Examples
Data Profiling
Demo 4-3: Data Profiling
Table Generation
Demo 4-4: Table Generation
Fuzzy Matching
Demo 4-5: Fuzzy Matching
Intelligent Data Exploration
Quick Insights
Demo 4-6: Quick Insights
Report Creation
Demo 4-7: Report Creation
Smart Narrative
Summary
5. Working with Time Series Data
More Than Just Timestamps
The Components of a Time Series
Changes to a Time Series
How Trend Lines Work in Power BI
Limitations of Trend Lines
Demo 5-1: Exploring Taxi Trip Data
Forecasting
Forecasting for Business
How Forecasting Works
Limitations of Forecasting
Demo 5-2: Forecasting Taxi Trip Data
Anomaly Detection
Anomaly Detection for Business
How Anomaly Detection Works
Limitations of Anomaly Detection
Demo 5-3: Anomaly Detection with Taxi Trip Data
Summary
6. Cluster Analysis and Segmentation
Cluster Analysis for Business
Segmentation Meets Data Science
Preprocessing Data for Cluster Analysis
How Cluster Analysis Works in Power BI
Limitations of Cluster Analysis
Demo 6-1: Cluster Analysis with AirBnB Data
Summary
7. Diving Deeper: Using Azure AI Services
Supporting Data-Driven Decisions with a Data Dictionary
What Is Azure AI Services?
Accessing Azure AI Services in Power BI
Creating an Azure AI Services Resource
Creating a Power BI Report
OpenAI ChatGPT and Power BI
What Is the Purpose of the Exercise?
Exercise Prerequisites
Azure OpenAI and Power BI Example
Generating a Secret Key and Code from the OpenAI Website
Creating a Streaming Power BI Dataset
Dashboard Didn’t Work?
Summary
8. Text Analytics
Custom Models Versus Pretrained Models
Text as Data
Limitations of Text Analytics
Demo 8-1: Ingest AirBnB Data
Language Detection
How It Works
Performance and Limitations
Demo 8-2: Language Detection
Key Phrase Extraction
How It Works
Performance and Limitations
Demo 8-3: Key Phrase Extraction
Sentiment Analysis
How It Works
Recommendations and Limitations
Demo 8-4: Sentiment Analysis
Demo 8-5: Exploring a Report with Text Analytics
Summary
9. Image Tagging
Images as Data
Deep Learning
A Simple Neural Network
Image Tagging for Business
How It Works
Limitations of Vision
Demo 9-1: Ingest AirBnB Data
Demo 9-2: Image Tagging
Demo 9-3: Exploring a Report with Vision
Summary
10. Custom Machine Learning Models
AI Business Strategy
Organizational Learning with AI
Successful Organizational Behaviors
Custom Machine Learning
Machine Learning Versus Typical Programming
Narrow AI Versus General AI
Azure Machine Learning
Azure Subscription and Free Trial
Azure Machine Learning Studio
Demo 10-1: Forecasting Vending Machine Sales
Summary
11. Data Science Languages: Python and R in Power BI
Python Versus R
Limitations
Setup
Setting Up Python
Setting Up R
Ingestion
Ingesting Data with Python
Ingesting Data with R
Transformation
Transforming Data with Python
Transforming Data with R
Visualization
Visualizing Data with Python
Visualizing Data with R
Machine Learning
Using a Pretrained Model with Python on Transform
Training a Model with R on Ingest
Summary
12. Making Your AI Production-Ready with Power BI
Strategies to Help Evaluate Models
Scenario Without Heteroscedasticity
Scenario with Heteroscedasticity
How Does Heteroscedasticity Affect AI Models?
What Can Be Done If Heteroscedasticity Is Suspected?
Making Your AI Model Ready for the Real World
Assessing the Costs and Benefits to the Business
Example ROI Calculation
Can the Business Teams Have Confidence in the AI Model?
Is the Model Result Just a Fluke?
Assuring Ongoing Model Performance
Making Your AI Production-Ready in Power BI
Data Lineage for the AI Model
Using the Scored Output from the Model in a Power BI Report
Summary
13. The AI Feedback Loop
How Do You Start the Next Project?
How Does Feedback Affect the Training and Development of AI Models?
AI and Edge Cases in Feedback
How Can Feedback Help Fix Errors in an AI Model?
AI, Bias, and Fairness
Explainable AI and Feedback
How Can Members of Organizations Address Ethics and AI?
Transfer Learning in Model Training
How Are Other Organizations Using the AI Feedback Loop?
How Can the AI Feedback Loop Help You?
AI and Power BI—Over to You!
Index
About the Authors
Create a Workspace
Create a Dataflow
Model Evaluation Reports in Power BI
Summary
4. Automating Data Exploration and Editing
The Transformational Power of Automation
Surviving (and Thriving with) Automation
AI Automation in Power BI
AI in Power Query
Get Data from Web by Example
Demo 4-1: Get Data from Web by Example
Add Column from Examples
Demo 4-2: Add Column from Examples
Data Profiling
Demo 4-3: Data Profiling
Table Generation
Demo 4-4: Table Generation
Fuzzy Matching
Demo 4-5: Fuzzy Matching
Intelligent Data Exploration
Quick Insights
Demo 4-6: Quick Insights
Report Creation
Demo 4-7: Report Creation
Smart Narrative
Summary
5. Working with Time Series Data
More Than Just Timestamps
The Components of a Time Series
Changes to a Time Series
How Trend Lines Work in Power BI
Limitations of Trend Lines
Demo 5-1: Exploring Taxi Trip Data
Forecasting
Forecasting for Business
How Forecasting Works
Limitations of Forecasting
Demo 5-2: Forecasting Taxi Trip Data
Anomaly Detection
Anomaly Detection for Business
How Anomaly Detection Works
Limitations of Anomaly Detection
Demo 5-3: Anomaly Detection with Taxi Trip Data
Summary
6. Cluster Analysis and Segmentation
Cluster Analysis for Business
Segmentation Meets Data Science
Preprocessing Data for Cluster Analysis
How Cluster Analysis Works in Power BI
Limitations of Cluster Analysis
Demo 6-1: Cluster Analysis with AirBnB Data
Summary
7. Diving Deeper: Using Azure AI Services
Supporting Data-Driven Decisions with a Data Dictionary
What Is Azure AI Services?
Accessing Azure AI Services in Power BI
Creating an Azure AI Services Resource
Creating a Power BI Report
OpenAI ChatGPT and Power BI
What Is the Purpose of the Exercise?
Exercise Prerequisites
Azure OpenAI and Power BI Example
Generating a Secret Key and Code from the OpenAI Website
Creating a Streaming Power BI Dataset
Dashboard Didn’t Work?
Summary
8. Text Analytics
Custom Models Versus Pretrained Models
Text as Data
Limitations of Text Analytics
Demo 8-1: Ingest AirBnB Data
Language Detection
How It Works
Performance and Limitations
Demo 8-2: Language Detection
Key Phrase Extraction
How It Works
Performance and Limitations
Demo 8-3: Key Phrase Extraction
Sentiment Analysis
How It Works
Recommendations and Limitations
Demo 8-4: Sentiment Analysis
Demo 8-5: Exploring a Report with Text Analytics
Summary
9. Image Tagging
Images as Data
Deep Learning
A Simple Neural Network
Image Tagging for Business
How It Works
Limitations of Vision
Demo 9-1: Ingest AirBnB Data
Demo 9-2: Image Tagging
Demo 9-3: Exploring a Report with Vision
Summary
10. Custom Machine Learning Models
AI Business Strategy
Organizational Learning with AI
Successful Organizational Behaviors
Custom Machine Learning
Machine Learning Versus Typical Programming
Narrow AI Versus General AI
Azure Machine Learning
Azure Subscription and Free Trial
Azure Machine Learning Studio
Demo 10-1: Forecasting Vending Machine Sales
Summary
11. Data Science Languages: Python and R in Power BI
Python Versus R
Limitations
Setup
Setting Up Python
Setting Up R
Ingestion
Ingesting Data with Python
Ingesting Data with R
Transformation
Transforming Data with Python
Transforming Data with R
Visualization
Visualizing Data with Python
Visualizing Data with R
Machine Learning
Using a Pretrained Model with Python on Transform
Training a Model with R on Ingest
Summary
12. Making Your AI Production-Ready with Power BI
Strategies to Help Evaluate Models
Scenario Without Heteroscedasticity
Scenario with Heteroscedasticity
How Does Heteroscedasticity Affect AI Models?
What Can Be Done If Heteroscedasticity Is Suspected?
Making Your AI Model Ready for the Real World
Assessing the Costs and Benefits to the Business
Example ROI Calculation
Can the Business Teams Have Confidence in the AI Model?
Is the Model Result Just a Fluke?
Assuring Ongoing Model Performance
Making Your AI Production-Ready in Power BI
Data Lineage for the AI Model
Using the Scored Output from the Model in a Power BI Report
Summary
13. The AI Feedback Loop
How Do You Start the Next Project?
How Does Feedback Affect the Training and Development of AI Models?
AI and Edge Cases in Feedback
How Can Feedback Help Fix Errors in an AI Model?
AI, Bias, and Fairness
Explainable AI and Feedback
How Can Members of Organizations Address Ethics and AI?
Transfer Learning in Model Training
How Are Other Organizations Using the AI Feedback Loop?
How Can the AI Feedback Loop Help You?
AI and Power BI—Over to You!
Index
About the Authors
Afgekapt op 60 regels
Anderen kochten ook
Leon Tindemans€ 29,50
Elisa Farri€ 22,99
Victor de Graaff€ 130,80
Ramesh Sharda€ 100,09
Mariya Yao€ 26,73
Markus Enhrenmueller-Jensen€ 80,27
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan