Advanced Power BI (1st Ed.)

Overview

In this course, you’ll learn advanced techniques for Power BI that will help you create sleek and professional dashboards from start to finish, applying each technique directly to several retail data sets. You’ll begin by enhancing a set of existing dashboards with better visuals and an improved user experience, then dive into Power Query to build an advanced combine-files-from-folder solution from a blank query. From there, you’ll explore dynamic, user-controlled elements in visuals such as legends, colors, axes, and levels of hierarchy. You’ll also work with a financial statement Power BI report, which you’ll enhance with artificial intelligence to get deeper insights from the data more quickly, and finish by exploring three ways to integrate Python into Power BI to extend its capabilities. By the end of this course, you’ll be comfortable executing complex tasks in Power BI and building world-class dashboards more efficiently and with greater flexibility.

Highlights

• Advanced visuals, including custom tooltips and custom visuals
• Advanced user experience with drillthrough, buttons, and bookmarks
• Advanced Power Query, including custom functions and combining files
• Advanced data modeling and DAX with dynamic, user-controlled elements
• Enhancing reports with artificial intelligence
• Integrating Python into Power BI

Prerequisites

None are required, but Power BI Fundamentals and DAX skills are recommended.

Objectives

• Produce advanced visuals that better communicate a message
• Develop a sleek, modern user experience around visuals
• Create advanced queries using custom functions, list functions, and complex columns
• Add dynamic elements to report visuals that are user-controlled
• Enhance reports with artificial intelligence functionality
• Extend Power BI functionality with Python

Preparation

None