Contents
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 course 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 course 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
Hi, and welcome to this Advanced Analysis with Power BI course. In this course, we will be looking at some of the built-in features that enable you to easily and quickly analyze your data, teasing out insights and presenting them in a visually compelling format. You don't have to be a data scientist or statistical expert to take this course, as Power BI will be doing all the heavy lifting. It would help if you had 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.
This course does cover a lot of ground and will be focusing on the core topic. It's assumed you know how to connect a data source, load data, and generally use the Power BI Desktop and Power Query Editor environments. The AI insights demonstration uses a Power BI.com premium account, so if you don't already have one, you can sign up for a generous trial period if you want to follow along.
My name is Hallam Webber, and I'll be your instructor for this course. We welcome all comments and feedback, so please feel free to reach out and get in touch with us at support@cloudacademy.com with any feedback, positive or negative.
Hallam is a software architect with over 20 years experience across a wide range of industries. He began his software career as a Delphi/Interbase disciple but changed his allegiance to Microsoft with its deep and broad ecosystem. While Hallam has designed and crafted custom software utilizing web, mobile and desktop technologies, good quality reliable data is the key to a successful solution. The challenge of quickly turning data into useful information for digestion by humans and machines has led Hallam to specialize in database design and process automation. Showing customers how leverage new technology to change and improve their business processes is one of the key drivers keeping Hallam coming back to the keyboard.