All articles in 'Power Pivot' Category

Top 5 with above average – Power Pivot Trick

Published on Aug 13, 2018 in Power Pivot
Top 5 with above average – Power Pivot Trick

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In this installment, learn how to get top 5 list with a twist.

Let’s say you are analyzing sales data and you want to know who are your top 5 sales persons?

Of course, this is simple, you just create a pivot to see total sales by person and then sort the pivot. First five rows have the answer you need. You can even apply a value filter > top 5 to show only their data.

Continue »

Nest Egg Calculator using Power BI

Published on Aug 6, 2018 in Power BI, Power Pivot, Power Query

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In the first installment, let’s take a look at something we all can related to – Money. 

We all know that Power BI is good for creating awesome visual experiences. Today let me share another fun way to use Power BI – to build a calculator. Learn how to create nest egg calculator in this Power BI parameter example tutorial.

Continue »

How to get percentage of something calculations in Excel Pivot Tables

Published on Aug 1, 2018 in Pivot Tables & Charts, Power Pivot
How to get percentage of something calculations in Excel Pivot Tables

Ever wondered how to get percentage of another value in Excel pivot tables, like this: In this tip, learn how to create such calculations using Excel pivot tables. Note: this tip is not compatible with older versions of Excel. If you are using Excel 2007 / 2010 / 2013, then please install free Power Pivot […]

Continue »

Best Excel Books & Power BI Books – 2018

Published on Jun 11, 2018 in Learn Excel, Power BI, Power Pivot, Power Query
Best Excel Books & Power BI Books – 2018

So you have decided to up your game with Excel and / or Power BI this year and now ravenously looking for books to read. You have come to the right place. Here is my list of recommended best Excel books, and books on Power BI, visualization, dashboards, VBA, Macros and analytics.

Use below links to navigate the relevant section of this page:

Continue »

How your country did in Commonwealth Games – Power BI Viz and Tutorial

Published on Apr 17, 2018 in Power BI, Power Pivot, Power Query
How your country did in Commonwealth Games – Power BI Viz and Tutorial

Commonwealth games 2018 have ended in the weekend. Let’s take a look at the games data thru Power BI to understand how various countries performed.

Here is my viz online or you can see a snapshot above.

Looks good, isn’t it? Well, read on to know how it is put together.

Continue »

D’oh – Visualizing Homer’s favorite sayings in Power BI

Published on Sep 29, 2017 in Power BI, Power Pivot, Power Query
D’oh – Visualizing Homer’s favorite sayings in Power BI

Before we begin:

Today is the last day for enrolling in our Power BI Play Date. Don’t miss out on this amazing opportunity to learn, use and benefit from Power BI at your work. Check out my online class and sign up before the doors close at midnight. Click here.

Let’s get our Simpsons on then.

D’oh, How often Homer says his favorite things?

Here is the visualization to explore Homer’s (and other character’s) favorite sayings in 27 years worth of Simpsons episode. Click on the image to play.

Continue »

Analyzing 300,000 calls for help [case study]

Published on Aug 24, 2016 in Analytics, Learn Excel, Pivot Tables & Charts, Power Pivot
Analyzing 300,000 calls for help [case study]

Over the weekend, I got an email from Mr. E, one of my students. Mr. E works at a police department in California and as part of his work, he was looking at calls received by police. Whenever police get a call for help, multiple teams can respond to the call and go to the location. All of these dispatches are recorded. So a single call can have several such dispatches. And Mr. E wanted to findout which team responded the first. The problem?

Finding the first responded team is tricky.

Today let’s take up this problem as a case study and understand various methods to solve it.  We are going to learn about writing better lookups, pivot tables, power pivot and optimization. Put on your helmets, cause this is going to be mind blowingly awesome.

Continue »

A slicer that doesn’t slice [Pivot Table Tricks]

Published on Mar 30, 2016 in Pivot Tables & Charts, Power Pivot
A slicer that doesn’t slice [Pivot Table Tricks]

Mary Ellen, one of our readers, has an interesting conundrum,

I have some data that goes to Pivot table then to pivot chart. There is a slicer to filter the data. But when I slice, my pivot chart gets messed up. How to have the slicer, but still see the insights in the chart?!?

See above demo to understand:

This is because when you slice by a school, the pivot table gets filtered and hence % row total for that school becomes 100% (as there are no other schools).

How to fix the problem? The easy answer is to remove the slicers. But we want to have our slicers and eat a slice of them too. So we crank up the Excel awesomeness valve and get to work. There are two ways to achieve what we want.

  • Old school method: Two pivot tables, some formulas & a line chart
  • New Excel method: Power Pivot and a line chart

Read the rest of this article to know more.

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 »

Last day to join Advanced Power Pivot class & Bundles – Enroll to become awesome

Published on Feb 21, 2014 in Power Pivot
Last day to join Advanced Power Pivot class & Bundles – Enroll to become awesome

Hi folks,

I have a quick announcement for you.

Only few hours left to join Power Pivot course…

As you may know, I have opened enrollments for our 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 advanced Power Pivot & Bundled options at midnight, today – 11:59 PM, Pacific time, Friday, 21st of February.

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

Continue »

Heads up! Our Join Power Pivot class

Published on Feb 19, 2014 in Power Pivot

Hi folks,

Let me interrupt the flow of awesome Excel stuff to share about our ongoing Power Pivot class enrollments.

We opened the class last Monday (10th of February) and every day lots of people are joining the army of awesome Power Pivot analysts.

Click here to know more and join us.

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 »

Power Pivot course is now open, Please join to become awesome

Published on Feb 10, 2014 in Power Pivot, products
Power Pivot course is now open, Please join to become awesome

Hi friends & readers of Chandoo.org,

I am happy to tell you that my latest online course – Power Pivot class is now open for your consideration. Please take a few minutes to read about this course and how it can help you. If you are ready to join, please click here.

Continue »

Details about upcoming Power Pivot course

Published on Feb 6, 2014 in Power Pivot
Details about upcoming Power Pivot course

As we are getting ready to open enrollments for my upcoming Power Pivot online class, I am having a very busy and exciting time. Today, let me share few more details about our course.

First about the Power Pivot

Power Pivot adds world-class Business Intelligence (BI), Reporting and analysis capabilities to plain old Excel. It lets you connect, analyze and visualize massive amounts of data with ease.

While this technology is hugely empowering it is also has a steep learning curve for many of us. So in 2013 I started an online class to teach Power Pivot. So far I have trained more than 800 people on Power Pivot. Most people (and businesses) have transformed the way they analyze data and present results once they discovered what Power Pivot can do.

And now, I am very glad to tell you that my Power Pivot course along with Rob Collie’s Advanced Power Pivot course (aka Power Pivot University) is open for new session.

We are opening these courses for enrollment on 10th of February (Next Monday) for your consideration.

Continue »

5 reasons why you should learn Power Pivot

Published on Jan 29, 2014 in Power Pivot
5 reasons why you should learn Power Pivot

Power Pivot for Excel has come a long way since it was introduced in late 2009. In the last 4 years not only has the technology matured, but also became a standard reporting platform in many businesses. As a smart analyst (or manager), you will gain a lot of mileage by adding this vital skill to your resume.

Today, let me show 5 reasons why you should learn Power Pivot this year.

Continue »