Wow! eBook
Artificial Intelligence with Power BI: Take your data analytics skills to the next level by leveraging the AI capabilities in Power BI
Author(s): Mary-Jo Diepeveen (Author)
- Publisher: Packt Publishing
- Publication Date: 29 April 2022
- Language: English
- Print length: 348 pages
- ISBN-10: 1801814635
- ISBN-13: 9781801814638
Book Description
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.
Table of Contents
- Introducing AI in Power BI
- Exploring Data in Power BI
- Data Preparation
- Forecasting Time-Series Data
- Detecting Anomalies in Your Data Using Power BI
- Using Natural Language to Explore Data with the Q&A Visual
- Using Cognitive Services
- Integrating Natural Language Understanding with Power BI
- Integrating an Interactive Question and Answering App into Power BI
- Getting Insights from Images with Computer Vision
- Using Automated Machine Learning with Azure and Power BI
- Training a Model with Azure Machine Learning
- Responsible AI
Editorial Reviews
Review
“Artificial Intelligence is the hottest topic in decision-making today. Many are excited about the opportunities it provides and the insight it can unlock; however, most are not sure how and where to start. This is where this book comes in. By starting with the basics of what AI and related technologies are, it shows you how to apply AI in your own decision-making process using Power BI. The best thing about this book is the fact that it is so well written that it feels like the author is taking you by the hand and guiding you from using easy-to-use but generic out-of-the-box Power BI solutions all the way to building and using custom solution tailored to your specific business needs. With the added emphasis on what to use when and responsible AI, this is a balanced and practical guidebook that will surely help you reap the benefits of AI in your business, while educating you on the important principles and challenges in the application of AI.”
Jeroen ter Heerdt, Senior Program Manager, Microsoft
“This book explains complex AI models in a very simple manner using Azure Cognitive services and Power BI. The author has given valuable insights into the ML algorithms behind Cognitive tools using real-world examples. It is very interesting to see how Power BI is capable of solving various problems in our daily lives using forecasting, natural language processing, and computer vision models. I thoroughly enjoyed reading this book.”
Vijay Suda, Senior Solution Architect, Azure Cloud, Data & AI, Microsoft, USA
“This book enables you to understand how to use artificial intelligence within Power BI to solve key business problems. Taking a steady pace, the book ensures that the reader goes from easy-to-use solutions to a deeper understanding of how to implement more advanced solutions”
Leon Gordon, Microsoft Data Platform MVP and Director of Analytics at Onyx Data
“The book is written in a very clear and straightforward manner. It is specifically suited for analysts who are very new to the world of AI. For this reason, the first part of the book presents an excellent introduction to the basic concepts of AI, data exploration, and data preparation. In addition, only Power BI’s “no code” functions are used to interface with Microsoft’s artificial intelligence platforms on Azure, precisely so as to not overburden the novice analyst’s learning with the use of R or Python code.
In the end, I would definitely recommend this book to those who need to take the very first steps in integrating Power BI with the world of artificial intelligence using out-of-the-box Power BI AI features, Azure machine learning, and Azure cognitive services.”
Luca Zavarella, Head of Data & AI at iCubed, Microsoft MVP for AI
About the Author
Mary-Jo Diepeveen is an AI expert at Microsoft who focuses primarily on creating educational content around data and AI. Mary-Jo’s passion for AI stems from her experience in neuroscience, where collecting and analyzing brain data to understand unconscious behavioral patterns led to an interest in machine learning and AI. This interest has continued to grow during her years at Microsoft, and she is often invited to talk and inspire others to get involved in tech.
