You're reading from Power BI Machine Learning and OpenAI Explore data through business intelligence, predictive analytics, and text generation

Product type Paperback

Published in May 2023

Publisher Packt

ISBN-13 9781837636150

Length 308 pages

Edition 1st Edition

Languages

Python

Tools

Power BI

Concepts

Business Intelligence

Author (1):

Greg Beaumont

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: Data Exploration and Preparation

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

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

Adding measures to your Power BI dataset

As a final activity for this chapter, you will add a few basic measures to the Power BI dataset. Measures are not stored on the tables of data but rather during runtime on reports. These measures will be used to do mathematics such as total number of reports, average damage cost amounts, average height of contact calculations, and more. For now, you choose a few basic measures that will give you a starting point for analysis. In future chapters, you can add more measures as you discover new perspectives within the data.

Measures can be added using the DAX expression language, which is a key skill for Power BI. Most of the formulas will be fairly simple for anyone who is familiar with writing formulas in Excel.

Add the following measures in the Data view of Power BI while the Strike Reports Fact table is highlighted:

Name

DAX formula

Description...