Skip to Content
Data Visualization with Microsoft Power BI
book

Data Visualization with Microsoft Power BI

by Alex Kolokolov, Maxim Zelensky
August 2024
Beginner to intermediate
416 pages
9h 31m
English
O'Reilly Media, Inc.
Content preview from Data Visualization with Microsoft Power BI

Chapter 17. Sankey Chart

For the practice in this chapter, use this practice dataset.

The Sankey chart is probably the most impressive visualization. It might seem like only a skilled designer could create something like this, and this level of creativity cannot be templated! Nevertheless, even such a chart can be constructed in just a few clicks if you have the data prepared in the correct format (indeed, this is the most subtle and challenging part).

While some may misinterpret it as “sun key” in the name, it has no relation to sun rays or keys. It is actually named after the 19th-century Irish engineer, Matthew Sankey, who utilized this method to illustrate the functioning of a flow engine. In the 21st century, it is being employed to showcase how money works.

The Sankey chart in Figure 17-1 provides a clear and accessible explanation of financial operations, especially for managers who are not familiar with them. We can see that the company’s revenue is composed of three main flows: the majority comes from the sale of goods, around 30% from services provided, and a smaller (insignificant) portion from other sources of income. Subsequently, these funds are allocated to two budgets: operational (Opex) and capital (Capex). Moreover, you can see how expenses are distributed within these budgets and, most notably, where they intersect. For example, the salary mainly belongs to Capex, but a portion of it is also included in Opex.

Figure 17-1. Profit and loss (P&L) statement shown ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Data Analysis with Microsoft Power BI

Data Analysis with Microsoft Power BI

Brian Larson
Data Modeling with Microsoft Power BI

Data Modeling with Microsoft Power BI

Markus Ehrenmueller-Jensen

Publisher Resources

ISBN: 9781098152772Errata Page