Artificial Intelligence with Power BI

Artificial Intelligence with Power BI

by Mary-Jo Diepeveen
Released April 2022
Publisher(s): Packt Publishing
ISBN: 9781801814638

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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

  1. Artificial Intelligence with Power BI
  2. Contributors
  3. About the author
  4. About the reviewers
  5. Preface
    1. Who this book is for
    2. What this book covers
    3. To get the most out of this book
    4. Download the example code files
    5. Download the color images
    6. Conventions used
    7. Get in touch
    8. Share Your Thoughts
  6. Part 1: AI Fundamentals
  7. Chapter 1: Introducing AI in Power BI
    1. What do we expect from a data analyst?
      1. What is a data analyst?
      2. Connecting to data
      3. Visualizing data
    2. What is AI?
      1. Understanding the definition of AI
      2. Understanding machine learning
      3. Understanding deep learning
      4. Understanding supervised and unsupervised learning
      5. Understanding algorithms
      6. What is the data science process?
    3. Why should we use AI in Power BI?
      1. The problems with implementing AI
      2. Why AI in Power BI is the solution
    4. What are our options for AI in Power BI?
      1. Out-of-the-box options
      2. Creating your own models
    5. Summary
  8. Chapter 2: Exploring Data in Power BI
    1. Technical requirements
      1. Using the sample dataset on world happiness
      2. How to interpret this dataset
      3. Importing the world happiness dataset into Power BI
    2. What to look for in your data
      1. Understanding data quantity
      2. Understanding data quality
    3. Using data profiling tools
      1. Column quality
      2. Column distribution
      3. Column profile
    4. Using visuals to explore your data
      1. Line charts
      2. Bar charts
      3. Histograms
      4. Scatter plots
      5. matplotlib
    5. Summary
  9. Chapter 3: Data Preparation
    1. Fixing the structure of your data
      1. Working with structured data
      2. Fixing the structure of semi-structured data
      3. Fixing the structure when working with images
    2. Working with missing data
      1. How do you find missing data?
      2. What do you do with missing data?
    3. Mitigating bias
      1. How to find bias
      2. How to mitigate bias in your dataset
    4. Handling outliers
    5. Summary
  10. Part 2: Out-of-the-Box AI Features
  11. Chapter 4: Forecasting Time-Series Data
    1. Technical requirements
    2. Data requirements for forecasting
      1. Why use forecasting?
      2. Time-series data
      3. Using an example – tourism data
    3. Algorithms used for forecasting
      1. The benefit of using an out-of-the-box feature
      2. Understanding how forecasting is calculated in Power BI
      3. Optimizing forecasting accuracy in Power BI
    4. Using forecasting in Power BI
    5. Summary
    6. Further reading
  12. Chapter 5: Detecting Anomalies in Your Data Using Power BI
    1. Technical requirements
    2. Which data is suitable for anomaly detection?
      1. Why use anomaly detection?
      2. Data requirements for anomaly detection
    3. Understanding the logic behind anomaly detection
      1. The algorithms behind Microsoft's anomaly detection feature
      2. No need to label your data
      3. Fast and powerful analysis
    4. Using anomaly detection in Power BI
      1. Importing the sample dataset into Power BI
      2. Enabling anomaly detection in Power BI
    5. Summary
    6. Further reading
  13. Chapter 6: Using Natural Language to Explore Data with the Q&A Visual
    1. Technical requirements
    2. Understanding natural language processing
      1. Using natural language in programs
      2. Understanding natural language for data exploration
      3. Preparing data for natural language models
    3. Creating a Q&A visual in Power BI
      1. Adding a Q&A visual
      2. Using the Q&A visual
    4. Optimizing your Q&A visual
      1. Exploring the Q&A setup
      2. Improving the Q&A experience
      3. Using feedback to improve the model over time
    5. Summary
    6. Further reading
  14. Chapter 7: Using Cognitive Services
    1. Technical requirements
    2. Understanding Azure's Cognitive Services
      1. Creating a Cognitive Services resource
    3. Using Cognitive Services for LU
      1. Using Azure's Text Analytics
      2. Creating question answering from a knowledge base
    4. Using Cognitive Services for CV
      1. Understanding Azure's Computer Vision
      2. Using Azure's Custom Vision
      3. Using the Face service
    5. Summary
  15. Chapter 8: Integrating Natural Language Understanding with Power BI
    1. Technical requirements
    2. Using Language APIs in Power BI Desktop
      1. Using AI Insights
      2. Using Power Query Editor
    3. Visualizing insights from text in reports
      1. Visualizing text with a Word Cloud
    4. Summary
  16. Chapter 9: Integrating an Interactive Question and Answering App into Power BI
    1. Technical requirements
    2. Creating a question answering service
      1. Understanding the application of question answering
      2. Configuring a question answering service
    3. Creating an FAQ app with Power Apps
      1. Creating a new app with Power Apps
      2. Adding Power Automate to call the question answering service
      3. Connecting Power Automate to Power Apps
    4. Integrating the FAQ app with Power BI
    5. Improving the question answering model
    6. Summary
  17. Chapter 10: Getting Insights from Images with Computer Vision
    1. Technical requirements
    2. Getting insights with Computer Vision using AI Insights
      1. Using the Vision option of AI Insights
    3. Configuring Custom Vision
      1. Preparing the data for Custom Vision
      2. Training the model in Custom Vision
      3. Evaluating classification models
      4. Publishing your Custom Vision model
    4. Integrating Computer Vision or Custom Vision with Power BI
    5. Using visuals to show a reel of images in a report
      1. Storing data and ensuring it is anonymously accessible
      2. Improving the Custom Vision model
    6. Summary
  18. Part 3: Create Your Own Models
  19. Chapter 11: Using Automated Machine Learning with Azure and Power BI
    1. Technical requirements
    2. Understanding AutoML
      1. Understanding the ML process
      2. Improving the performance of an ML model
      3. When to use AutoML
    3. Creating an AutoML experiment in Azure ML
      1. Creating an Azure ML workspace and resources
      2. Configuring an AutoML run
    4. Deploying a model to an endpoint
    5. Integrating the model with Power BI
    6. Summary
  20. Chapter 12: Training a Model with Azure Machine Learning
    1. Technical requirements
    2. Understanding how to train a model
      1. Understanding the machine learning process
    3. Working with Azure ML
      1. Creating Azure ML assets
    4. Training a model with Azure ML Designer
      1. Configuring an Azure ML Designer pipeline
    5. Deploying a model for batch or real-time predictions
      1. Generating batch predictions
      2. Generating real-time predictions
    6. Integrating an endpoint with Power BI to generate predictions
    7. Summary
  21. Chapter 13: Responsible AI
    1. Understanding responsible AI
    2. Protecting privacy when using personal data
      1. Removing personally identifiable information
      2. Using differential privacy on personal data
    3. Creating transparent models
      1. Using algorithms that are transparent by design
      2. Explaining black-box models
    4. Creating fair models
      1. Identifying unfairness in models
      2. Mitigating unfairness in models
    5. Summary
    6. Why subscribe?
  22. Other Books You May Enjoy
    1. Packt is searching for authors like you
    2. Share Your Thoughts

Product information

  • Title: Artificial Intelligence with Power BI
  • Author(s): Mary-Jo Diepeveen
  • Release date: April 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781801814638