Book Image

Artificial Intelligence with Power BI

By : Mary-Jo Diepeveen
Book Image

Artificial Intelligence with Power BI

By: Mary-Jo Diepeveen

Overview of this book

The artificial intelligence (AI) capabilities in Power BI enable organizations to quickly and easily gain more intelligent insights from unstructured and structured data. This book will teach you how to make use of the many AI features available today in Power BI to quickly and easily enrich your data and gain better insights into patterns that can be found in your data. You’ll begin by understanding the benefits of AI and how it can be used in Power BI. Next, you’ll focus on exploring and preparing your data for building AI projects and then progress to using prominent AI features already available in Power BI, such as forecasting, anomaly detection, and Q&A. Later chapters will show you how to apply text analytics and computer vision within Power BI reports. This will help you create your own Q&A functionality in Power BI, which allows you to ask FAQs from another knowledge base and then integrate it with PowerApps. Toward the concluding chapters, you’ll be able to create and deploy AutoML models trained in Azure ML and consume them in Power Query Editor. After your models have been trained, you’ll work through principles such as privacy, fairness, and transparency to use AI responsibly. By the end of this book, you’ll have learned when and how to enrich your data with AI using the out-of-the-box AI capabilities in Power BI.
Table of Contents (18 chapters)
Part 1: AI Fundamentals
Part 2: Out-of-the-Box AI Features
Part 3: Create Your Own Models

Chapter 2: Exploring Data in Power BI

Once you get your hands on the data, it is time to do an initial exploration, also referred to as exploratory data analysis (EDA). The goal is not only to get to know your data from top to bottom, to find outliers and missing data to fix during our data preparation, and to find correlations between features, but also to simply understand what the data looks like. By knowing your data, the model you will train is more likely to be accurate.

In this chapter, we will learn how we can use different techniques to explore our data before we use any of the artificial intelligence (AI) features in Power BI. By using the tools in Power BI that are covered in this chapter, we know what to do when preparing our data, and by understanding and cleaning up your data, you will ensure that you have good input for your model. Therefore, we will cover the following topics in this chapter:

  • What to look for in your data
  • Using data profiling tools
  • ...