Artificial Intelligence with Power BI

Learn how to create your own AI model and consume it in your Power BI reports to gain better insights from your data

Key Features

• Learn how to gain better insights from your data by applying different AI techniques within Power BI
• Save time by creating machine learning models independently and integrating them within your BI reports
• Understand how to combine Cognitive Services and Azure Machine Learning together with Power BI

Book Description

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.

What you will learn

• Apply techniques to mitigate bias and handle outliers in your data
• Prepare time series data for forecasting in Power BI
• Prepare and shape your data for anomaly detection
• Use text analytics in Power Query Editor
• Integrate QnA Maker with PowerApps and create an app
• Train your own models and identify the best one with AutoML
• Integrate an Azure ML workspace with Power BI and use endpoints to generate predictions

Who this book is for

This artificial intelligence BI book is for data analysts and BI developers who want to explore advanced analytics or artificial intelligence possibilities with their data. Prior knowledge of Power BI will help you get the most out of this book.