Advanced Analysis with Power BI

Advanced Analysis with Power BI examines various methods for teasing out insights from data using statistical methodologies and presenting significant findings in visually compelling formats. The lesson starts with basic statistics such as standard deviation and then progresses to AI and machine learning analysis where Power BI does all the heavy lighting allowing the user to investigate and dynamically explore significant findings.

Learning Objectives

• How to use Z-scores to display outliers and use the Outlier Detection visualization from Microsoft
• How to use Power BI's Anomaly Detection and Fluctuation Analysis functionality
• Use time-series forecasting to predict future data points with varying degrees of certainty
• Use groups to classify categorical data and bins to categorize continuous data
• Learn about Key Influencers
• Use the Decomposition tree to drill down into a metric manually using known factors or let AI functionality determine which factors are the major contributors
• Use the power of Azure's AI and machine learning to analyze text for positive and negative sentiment, keywords and phrases, and image tagging

Intended Audience

This lesson is intended for anyone who wants to discover insights hidden in their data.

Prerequisites

• Have a basic understanding of statistics, like knowing the difference between a mean and median, a normal distribution, and conceptually how standard deviation is related to that
• Know how to connect a data source, load data, and generally use the Power BI Desktop and Power Query Editor environments
• AI Insights demonstration requires a PowerBi.com premium account