How to make a variance chart in Power BI? [Easy & Clean]
Power BI is great for visualizing and interacting with your data. In this article, let me share a technique for creating variance chart in Power BI. Variance charts are perfect for visualizing performance by comparing Plan vs. Actual or Budget vs. Actual data.
How to make an Interactive Chart Slider Thingy
Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with it.
Learn how to create this magical contraption in Excel.
Advanced Pivot Table Tricks for you
Excel Pivot tables make data analysis and visualization easy. With the help of these advanced pivot table skills, you can create powerful data analytics and reports. New to Pivot Tables? If you are new to Pivot Tables, check out this excellent introduction to Pivot Tables page. × Dismiss alert Table of Contents #1 – One Slicer, Two […]
Tour de France – Distance & Pace over time – Radial Charts
This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.
Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.
Create impressive dashboard tiles in Excel
If you want to tell the story of how your business / project / charity / thing is going on, then making a dashboard is the best way to go about it. Dashboards can combine heaps of data, insights and messages in to one concise format that fits on to a desktop or table or mobile screen.
But let’s be honest. Creating them in Excel is a lot of work. Even after spending hours on them, they might still look meh. So, let me share a trick to make your dashboards look snazzy (without compromising on insights per inch).
Create dashboard tiles, something like above.
Joyplot in Excel
Over on Twitter, I came across this beautiful chart, aptly titled – Joyplot. It is the kind of chart that makes you all curious and awed. So I did what any Excel nerd would do. Recreated it in Excel of course. This post takes you thru the process.
Take a look at final outcome above. Read on to learn more.
Designing awesome financial metrics dashboard [tutorial]
In this amazing guest post, the winner of our 2016 dashboard contest – Chandeep – Explains how he constructed the jaw dropping beauty (shown above) using Excel, creativity, love and sweat. Grab a full cup of coffee (or whatever liquid fancies you) and read on. Take lots of notes and play with the ideas in Excel while reading to maximize your learning.
Thanks Chandeep.