All articles with 'dashboards' Tag

Come join me at Excelapalooza conference in Dallas or Masterclass at Houston this September

Published on Jul 9, 2014 in Excel Workshops, Training Programs

Excelapalooza - Annual Excel User Conference - Chandoo will be speaking on making awesome dashboards

If you listen carefully, you can hear my screams of joy. I have 2 very happy news to share with you.

  1. I am speaking at Excelapalooza Excel conference, happening at Dallas (Texas) between September 21 to 24.
  2. I will be conducting an Advanced Excel, Dashboards & Power Pivot masterclass at Houston (Texas) between September 15 to 18.
Continue »

Winners of state migration dashboard contest

Published on Jul 7, 2014 in Charts and Graphs, Excel Challenges
Winners of state migration dashboard contest

Finally the wait is over. Here are the winners of our 2014 dashboard contest. Check them out.

Continue »

Top 10 things we struggle to do in Excel & awesome remedies for them

Top 10 things we struggle to do in Excel & awesome remedies for them

Recently we asked you, what do you struggle doing in Excel? 170 people responded to this survey and shared their struggles. In this post, lets examine the top 10 struggles according to you and awesome remedies for them.

Continue »

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.

49 Dashboards to visualize State to State Migration - Chandoo.orgExcel Dashboard Examples - Visualizing state to state migration trends - Chandoo.org

Click on the image to see the entries.

Continue »

Excel Links – Delay in State migration visualization results edition

Published on May 20, 2014 in excel links

Hello friends,

First a quick update about state migration visualization contest.

We got more than 50 wonderful entries for this contest. I have compiled 50% of the entries. Due to personal reasons (its annual vacation time at our household), I had to delay the rest and resume it after first week of June. So the results will be announced in 2nd week of June. Thanks for understanding and your patience. Watch this space for mind-boggling dashboards in 3 more weeks.

Click “Read more” to get a sneak-peek at 3 random entries & 4 useful Excel links.

Continue »

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

Published on Apr 24, 2014 in Chandoo.org Podcast Sessions
CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

In the 6th session of Chandoo.org podcast, we focus on making you a better analyst and propose a road map for getting better at data analysis & improving your career prospects.

In this podcast you will learn,

  • Why become a better analyst?
  • The road map for becoming a better analyst – BETTER framework
  • B for Business Knowledge
  • E for Examining user needs
  • T for Thinking about analysis
  • T for Tools of Trade ie Excel
  • E for Expression
  • R for Refining yourself
  • Conclusions
Continue »

Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]

Published on Apr 9, 2014 in Excel Challenges
Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]

Time for another dashboard contest. Sit straight, set aside your appointments and get number-crunching.

Analyze state to state migration data between 2012 & 2010 and present your results in a dashboard (or charts) and you could walk away with glory, fame & and an iPad.

If all of this sounds tempting, read on.

The contest

  1. Download dataset for the contest [mirror]
  2. Analyze the data and create a dashboard or set of charts (see rules below)
  3. Submit your workbook by 20th of April (Sunday), 2014.
  4. If readers at chandoo.org and our panel of judges love your work, you get one of the cool prizes.
Continue »

CP003: Business Intelligence for Masses – Interview with Mike Alexander

Published on Mar 27, 2014 in Chandoo.org Podcast Sessions
CP003: Business Intelligence for Masses – Interview with Mike Alexander

In the third session of Chandoo.org podcast, we are going to get BI curious. 😉

Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members. In this session, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.

You will learn,

  • Introduction, what Mike is up to these days?
  • What is BI, what does it mean to an average Excel analyst?
  • What BI capabilities Excel has – brief intro to each of them
    • Power Pivot & what it does
    • Power Query & why it is important
    • Power View & how it works (and where it sucks)
    • Power Maps
  • How to learn about these new technologies
    • Recommended Books
    • Websites
    • Courses
    • Live classes
  • Special gift for our listeners
Continue »

Learn how to create these 11 amazing dashboards

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…

Continue »

What is your favorite Excel book? [open thread]

Published on Feb 7, 2014 in Learn Excel
What is your favorite Excel book? [open thread]

Today lets talk about Excel books. The question is simple.

What is your favorite Excel book? Please share your answers using comments.

My favorite books are..,

Continue »

Top 10 things I learned using Excel for a decade

Published on Jan 6, 2014 in Charts and Graphs, Learn Excel
Top 10 things I learned using Excel for a decade

Sometime during the 2nd half of 2013, I finished 10 years of Excel usage. In the last 10 years, I completed my studies, got my first job, married, had kids, visited 15 different countries, quit my job to start a business, bought first car, first house, made dozens of new friends, read 100s of books, wrote a book and learned 1000s of new things. And all along, Excel stayed a true companion. Right from MBA entrance exam preparation in 2003 to making my summer internship project reports in 2005 to planning my wedding expenses in 2007 to getting a promotion in 2009 to planning my kids feeding schedule in 2010 to running a successful business in 2014, Excel helped me in every step.

So today, I want to tell you the top 10 things I learned using Excel in last decade. Grab a hot cup of coffee, buckle your belts and get ready for time travel.

Continue »

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)

Sachin Tendular 200 Tests - Visualized in an Excel Dashboard

Continue »

Closing gaps in this Gender Equality Gap chart…

Published on Nov 5, 2013 in Charts and Graphs
Closing gaps in this Gender Equality Gap chart…

Today lets close some gaps.

Recently I saw this interesting chart on Economist Daily Charts page. This chart is based on World Economic Forum’s survey on how women compare to men in terms of various development parameters. First take a look at the chart prepared by Economist team.

So what are the gaps in this chart?

This chart fails to communicate because,

  • All country charts look same, thus making it difficult to spot any deviations.
  • We cannot quickly compare one country with another on any particular indicator.
  • It does not provide a better context (for eg. how did these countries perform last year?)

But criticizing someone’s work is not awesome. Fixing it and making an even better chart, that has awesome written all over it. So that is what we are going to do. You can see the improved chart above. Click on it to learn how you can create it.

Continue »

Last day for enrollments – Join our Power Pivot class & become awesome analyst

Published on Aug 16, 2013 in Power Pivot

Hurry up, Enrollments for Power Pivot online classes closing in few hours - Join nowHi folks,

I have a quick announcement & a creative dashboard to share with you. First the announcement.

Only few hours left to join our Power Pivot course…

As you may know, I have opened enrollments for our 2nd batch of Power Pivot course few days ago. The aim of this course is to make you awesome in Excel, Advanced Excel, Dashboards, Power Pivot & Advanced Power Pivot.

We will be closing the doors of this program at midnight, today (11:59 PM, Pacific time, Friday, 16th of August).

If you want to join us, click here and enroll now.

Continue »

Excel Links for you – Busy busy edition

Published on Jul 30, 2013 in excel links
Excel Links for you – Busy busy edition

As the launch date for our 2nd batch of Power Pivot class nears, my plate looks fuller than ever. Fine tuning the course details, preparing our online classroom for new batch of students and coordinating with Rob for video recording etc.

But I wanted to take a few mins today and share with you some really useful Excel tricks, ideas and examples from web. I found these really useful and inspiring. I am sure you will learn from these links as much as I learned.

Continue »