For the practice, please download a special dataset.
The funnel chart is extremely popular in business reports. For years it was unavailable in Excel, so having it in a report could mean that you were using advanced business intelligence tools. Today it is available in the latest versions of Microsoft Office, and we can publicly use it, but Power BI has more options for creating brilliant reports with it.
The funnel chart displays sequential processes, where at every step the quantity is reduced. In Figure 11-1, you’ll see a good example of how the sales process progresses from initial contact with the client to presentations and negotiations prior to the deal, and finally to signing a contract.
Figure 11-1. Sales process displayed on the funnel chart
You can see that out of 134 clients on the list, our sales department has signed contracts with 20 of them; in other words, the conversion rate is around 15%. For such a simple chart, we can manage without Power BI. However, Power BI provides a more interactive way for us to look deeper into this data.
In Figure 11-2, you’ll see a section of the dashboard where we have a column chart with the number of contracts by salespersons, with the funnel underneath it. If we click on a certain salesperson’s column, the funnel will be filtered by their data.
Figure 11-2. Cross-filtration between column chart and funnel ...
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.
O’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
I 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
I’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
I'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.
O’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.
