Improve insights and decision-making with interactive visualizations and advanced BI tools that make the most of your data.
Dashboards and Visualizations
At the core of Power BI is the ability to create compelling visuals and assemble them into dashboards. These courses will show you how.
1. Building Your First Dashboard
This course introduces Power BI and its capabilities to new users. You’ll learn how to create a dashboard, import data and create a report in Power BI Desktop. You will then upload the report to Power BI to create the dashboard.
2. Introduction to Visualizations in Power BI
This course introduces many of the most common visualization types in Power BI, such as bar charts, line charts and scatter charts. It will also introduce some of the most common tools for formatting visuals.
3. Developing Effective Visualizations
In this course, we’ll look at the remaining visual types in Power BI, like treemaps, matrices and waterfall charts. We’ll also see how to add custom visuals, and we’ll look at features like hierarchies, quick measures and groups.
4. Designing Effective Dashboards
Creating proper visualizations is only useful if you can also arrange them into dashboards that communicate your messages effectively. This course will teach you how to do this.
5. Tackle delivery delays with real-time dashboards
Help a furniture chain store that's frustrating customers by delivering products with severe delays. You'll help them identify where the delays occur by building dashboards that deliver real-time insights and indicators. This will help the company react quickly and fix its problems.
6. Identify taxpayer cohorts by exploring data
Help a regional government assess the impact of a controversial property tax that's calculated based on a range of variables. You'll show them how to arrange and explore population data to demonstrate the impact of proposed measures, and identify potential problems with the tax structure.
The Query Editor and DAX
Learn the more technical side of Power BI. The Query Editor lets you transform and load data, while DAX lets you add functions and formulas to your data models.
1. The Query Editor
The Query Editor is used in Power BI Desktop to load and transform data before analyzing it. In this course, we’ll import files from a folder, combine them into one query, and transform the data using the Query Editor.
2. Introduction to DAX
Power BI’s formula language is called Data Analysis Expressions or DAX. This course introduces DAX, demonstrating how to use DAX to create columns and measures in your dataset, and introduces some of the most common DAX functions.
3. Advanced DAX Functions and Concepts
This course continues the analysis of DAX. It demonstrates some aspects of the language that are commonly used, but also potentially difficult, such as time intelligence. It also explains the concepts that distinguish DAX from formula languages such as Excel’s, such as row and filter contexts.
4. Practical Applications of DAX
Having established a knowledge of the main concepts of the DAX language, this course will demonstrate various common business applications of DAX in Power BI. You will see how to perform various common calculations and use them to produce compelling visualizations.
5. Reduce an internet provider's customer complaints
Help an internet service provider get to grips with its poor customer service experience. You'll clean customer data, create a solid data model, and use it to derive insights about the issues people are experiencing, providing guidance for the company to improve its customer relations.
Power BI Case Study
See how the visualization and DAX capabilities of Power BI can be applied to a practical example.
1. Power BI Case Study
In this course, we’ll apply the techniques we’ve seen up to this point to a practical case study featuring Interslice, a Software as a Service company using Power BI to obtain insights into their customer numbers and revenues.
Online Service and Data Connections
These courses will teach you about the capabilities of the online service and the data connection capabilities of Power BI. Some functionality covered requires access to a Power BI Pro license for usage and application.
1. The Power BI Online Service
This course introduces Power BI's online service, which provides a platform for users to upload their reports from Power BI Desktop, or create reports directly. Some functionality covered requires access to a Power BI Pro license for usage and application. This course explains the features of this service, how to create interactive dashboards from these reports and the various methods of sharing content with other users.
2. Advanced Data Connections
This course provides an overview of the more advanced data connection options available in Power BI, including Power BI Pro. Some functionality covered requires access to a Power BI Pro license for usage and application. We will see how to connect to data from a database, and use it in Power BI Desktop. We will look at options for directly connecting Excel to the Power BI service, including the latter’s Analyze in Excel feature.