You're reading from Power BI Machine Learning and OpenAI

Product type Book

Published in May 2023

Publisher Packt

ISBN-13 9781837636150

Pages 308 pages

Edition 1st Edition

Languages

Python

Concepts

GPT/LLMs

Author (1):

Greg Beaumont

Table of Contents (21) Chapters

Preface

1. Part 1: Data Exploration and Preparation

2. Chapter 1: Requirements, Data Modeling, and Planning

3. Chapter 2: Preparing and Ingesting Data with Power Query

4. Chapter 3: Exploring Data Using Power BI and Creating a Semantic Model

5. Chapter 4: Model Data for Machine Learning in Power BI

6. Part 2: Artificial Intelligence and Machine Learning Visuals and Publishing to the Power BI Service

7. Chapter 5: Discovering Features Using Analytics and AI Visuals

8. Chapter 6: Discovering New Features Using R and Python Visuals

9. Chapter 7: Deploying Data Ingestion and Transformation Components to the Power BI Cloud Service

10. Part 3: Machine Learning in Power BI

11. Chapter 8: Building Machine Learning Models with Power BI

12. Chapter 9: Evaluating Trained and Tested ML Models

13. Chapter 10: Iterating Power BI ML models

14. Chapter 11: Applying Power BI ML Models

15. Part 4: Integrating OpenAI with Power BI

16. Chapter 12: Use Cases for OpenAI

17. Chapter 13: Using OpenAI and Azure OpenAI in Power BI Dataflows

18. Chapter 14: Project Review and Looking Forward

19. Index

Why subscribe?

20. Other Books You May Enjoy

Creating Power BI dataflows with connections to source data

The Power BI Desktop Power Query work from previous chapters is connected to data sources from your local machine. Power BI dataflows is a very similar tool to Power Query, but connectivity happens from the Power BI cloud service. When creating your dataflows, you will need to consider connectivity to the data sources. Earlier in this book, you determined that the sources of data for the FAA Wildlife Strike database were as follows:

wildlife.accdb: All of the historical FAA Wildlife Strike reports. This file is an Access database that’s been downloaded in ZIP file format from the FAA website.
read_me.xls: Descriptive information about the data in the Database.accdb database file. This file is an Excel file that was downloaded within the same ZIP file as the Access database. The file has been changed to a .xlsx extension in the Packt GitHub repository and is available in the folder at https://github.com/PacktPublishing...