Details about upcoming Power Pivot course (and a bonus tip on dashboards)
Hello friends..,
I have 2 things for you:
- Details about our upcoming Power Pivot courses
- A short video about designing better dashboards.
Are you interested in learning Power Pivot?
Hi there,
I have a question and an announcement for you.
Question: Are you interested in learning Power Pivot? Do you want to connect, analyze and visualize lots of data using Excel?
IF(Your_answer="YES", "Read Announcement", "Read Announcement anyway!")
Announcement: 2nd Batch of Power Pivot coming on August 1st.
Learn Top 10 Excel Features
Last week, we had a lovely poll on what are your favorite features of Excel? More than 120 people responded to it with various answers. So I did what any data analyst worth his salt would do,
I analyzed the data and here are the top 10 features in Excel according to you.
Read on to learn more.
10 things that wowed me in Excel 2013
As you may new, the newest version of Excel is out for a while. I have been using it since last 6 months and enjoying it. Today, lets understand 10 things in 2013 that wowed me (and probably you too).
Finding Conversion ratio using Pivot Table Calculated Items
Today, lets understand how to use Calculated items feature in Pivot tables. We will use a practical problem many of us face to learn this feature – ie calculating conversion ratio from a list of sales calls.
Last day for enrollments – Join our Power Pivot course & become awesome analyst
Hi folks,
I have a quick announcement & an awesome Power Pivot technique 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 inaugural 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.
We will be closing the doors of this program at midnight, today (11:59 PM, Pacific time, Friday, 15th of February).
If you want to join us, click here and enroll now.
How many people have joined the class?
At the time of writing this, we have 195 students enrolled in Power Pivot class. We are eager to share Power Pivot knowledge & techniques to as many more of you as possible. So go ahead and join us because you want to be awesome in Excel & Power Pivot.
Distinct Count & Blanks – Power Pivot Real Life Example
When it comes to analyzing business data, managers are always asking, “so how many distinct x each y is doing?”
And that sends us, data analysts & reporting professionals running from pillar to post figuring out the best way to do it.
- We can use variations of SUMPRODUCT, COUNTIFS etc, but the methods are not flexible..
- We can use VBA, but it would become slow as you add more data.
- We can use Pivot tables, but it only gives half of what we want ie each y part, but not distinct count of x.
- We might as well shave our head with a shovel before manually counting values.
And that brings us to 2 distinctly simple solutions:
- Using Power Pivot & Excel 2010
- Using regular pivot tables in Excel 2013
Today, lets talk about these 2 approaches & see why they are so better than anything else for distinct count situations.