A dashboard to visualize this FIFA worldcup [guest post]
This is a guest post by Krishna, a football lover & one of our readers.
The wait for lifting the most valued priced in football for Germans was finally over. For a football fan, world cup is best time that is scheduled every four years and that if your favorite team lifting the trophy is like your crush is going on a date with you. 🙂
A sneak-peek at the final dashboard
Here is the final dashboard (it has more functionality than depicted). Click on it to enlarge.
Story of my first ever 200KM bike ride (plus an Excel dashboard with ride stats)
Ok people. Let me tell you that this post is almost not about Excel. It is about how one Excel blogger’s (yours truly) dream of long distance cycling came true. So sit back, grab your favorite drink and read between sips.
So what is this all about?
Last Sunday (27th July) & Monday (28th), I finished my first ever 200KM bicycle ride. I rode for a little more than 12 hours, burned 5,179 calories & rode 206 kilometers.
It is definitely one of the most memorable, tiresome & uplifting experiences in my life. So naturally, I want to share the story with you.
Excel Dashboards – 49 dashboards to visualize US State to State migration trends
Hello everyone. Stop reading further and go fetch your helmet. Because what lies ahead is mind-blowingly awesome.
About a month and half ago, we held our annual dashboard contest. This time the theme is to visualize state to state migration in USA. You can find the contest data-set & details here.
We received 49 outstanding entries for this. Most of the entries are truly inspiring. They are loaded with powerful analysis, stunning visualizations, amazing display of Excel skill and design finesse. It took me almost 2 weeks to process the results and present them here.
Click on the image to see the entries.
Learn how to create these 11 amazing dashboards
Today lets talk about how to build world-class dashboards.
What is a dashboard?
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. A dashboard is usually a one page report that contains critical information for decision support.
How to make dashboards?
Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. But creating a dashboard takes a lot of skill & practice. That is where a resource like Chandoo.org comes handy. In this site you can find more than 200 different dashboard examples, tutorials, samples and downloads – all designed to make you awesome.
Read on to learn more…
Combine pie and xy scatter charts – World Polls chart revisited
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.
I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.
Over to FrankensTeam.
Did Jeff just chart?
How do you segment customers by revenue easily in Excel, so that you can see which customer groups to focus on. Find out, and download this handy template.
In this charting example, Jeff, our guest author, occasional charter and Excel wizard shows us how to segment customers based on revenue and depict the result using Excel charts.
Thank you Sachin [a small tribute]
Lets talk about people who inspire us. People who show us that anything is possible. People who prove that commitment, hard work and perseverance are true ingredients of a genius.
I am talking about Sachin Tendulkar. Those of you who never heard his name, he is the most prolific cricketer in the world. He is the leading scorer in both tests (15,921 runs) and one day matches (18,426 runs). Read more about him here.
Tendulkar has been an inspiration for me (and millions of others around the world) since I was a kid. The amount of dedication & excellence he has shown constantly motivates me. It is a pity that the great man is retiring from test cricket. He is playing his last test match (200th, most by any person) as I am writing this.
So as a small tribute, I have decided do something for him. Of course, I have never been a cricketer in my life. Once in college I was reluctantly asked to be a stand-by player in a game with seniors. I did not get a chance to pad up though. That is the closest I have been to a cricketer. So I did what I do best. Create an Excel workbook celebrating Sachin’s test career.
Thank you Sachin – his test career in a dashboard
Here is a dashboard I made visualizing his test cricket statistics. It is dynamic, fun & awesome (just like Sachin).
(click on the image to enlarge)
