skip to Main Content

By Avi Singh [Twitter]

“Hello Everybody…”

With those words, Rob opened the very first blog post on this site back on Oct 26th, 2009. He spoke about his passion for PowerPivot and for the Excel community. He talked about bringing people together.

Today, I am happy to announce two big milestones in the PowerPivotPro journey: 800 Blog Posts and 2000+ YouTube Subscribers! Get a list of our hottest blog posts below.

PowerPivotPro has touched people across the world, through our blog, our youtube channel, our classes and free webinars. And we hope to do more. We hope to set the world of BI on fire and herald the disruptive new force that is Power BI.

We have not gotten here by ourselves though. And we wouldn’t get to our goal alone either. You have supported us, rallied around us, amplified our message and have given us strength. A BIG Thank You!

As a token of our gratitude, we will send a special offer to our subscribers on Tue July 7th. To receive this offer, all you have to do is make sure you are subscribed to our newsletter:

Subscribe to our Newsletter by July 7th to recieve a special thank you gift

What’s this Newsletter?

So far our blog has been our primary means of communication – for our blog articles, but also for our classes/free webinars/events etc.

You could subscribe to our blog via email, and many of you do. However many of you prefer to consume the blog via other methods – just the website or using an aggregator like feedly (my tool of choice). Also our cadence of two blog posts a week (Tuesday & Thursday) is more email than some folks want to receive.

Finally, we heard from many of you, that you would like to be notified via email of upcoming classes, free webinars and other events.

So now you have a choice, click links below to…

Subscribe to our Blog & Newsletter 2 Informative Blog Posts each week + Newsletter delivered to your email
Subscribe to our Newsletter alone 2-3 Emails max each month
regarding our upcoming classes, free webinars, events AND special offers for our favorite peeps in the world

A Story of 800 Blog Posts

800 Blog posts means that you would find pretty much everything under the sun, just use the search box.


Search Box is your friend! (top right corner)

For e.g. if you search for Cycle Plots, you would not only find my post from June 2015, but also Colin Banfield’s guest post from 2012! Read how we tackled it slightly differently. Similarly you can search for disconnected slicers, cube formulas and more.

Race to 1000 Page Views

Here are the fastest burning blog posts from this year (2015) – as measured by how quickly they reached 1000 views. This analysis is modeled after the Compare Product Performance Since Launch post, check out that post to see how you can run a similar analysis. Look through the top blogs list below and see if you had missed any, or go back and revisit an old favorite. A special thanks to our guest bloggers who appear in the list below. And our partners in crime Matt Allington and Dany Hoter who are regular posters and also appear below.

2015 Blog Post

Days to Reach 1K Views

Introducing Power Update!

2

Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine

2

Power BI, YouTube for Workbooks: More Affordable!

3

No More Apologies: Excel is the World’s Best Data Tool, Period.

3

Power Update Adds Email Notifications, Macro Support, and 100% Free Version

3

Harness Power Query to Gain Competitive Analysis Insights from LinkedIn (Gil Raviv)

7

Power Query for Excel: Combine multiple files of different file types (Miguel Escobar)

7

The Only “Requirements Doc” You Will Ever Need

8

Dear Accountants: PowerPivot is your friend! (Mike Griffin)

10

VLOOKUP better than Relationships? Hell must have frozen over

10

Our Road Ahead

10

Secret Pot Roast Recipe: Power Query vs. VBA Macros (Willem van Dijk)

11

The Diabolical Genius of “SWITCH TRUE”

16

Create a Custom Calendar in Power Query

22

Schrodinger’s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.

22

Power Pivot to SSAS Tabular in less than 30 minutes

25

Some Good Power Pivot / Power BI Computers

28

Is Your DAX/PowerPivot/Power BI Computer FAST?

35

“Beta Test” the New Reference Card?

35

Power Pivot and Basketball Superstars: Many-to-Many and USERELATIONSHIP

38

Power Query Super Charges the Internet

41

How to Compare the Current Row to the Previous Row in Power Pivot

44

Dynamic Age Calculation Using Measures

57

Power Pivot to SSAS Tabular: Automatically Publish Excel Workbooks

90

Power BI as Google Docs Antidote

126

Avi Singh

Avi Singh has personally experienced the transformation and empowerment that Power BI can bring - going from an Excel user to building large scale Power BI solutions. His mission now is to share the knowledge about Power Pivot and Power BI.

This Post Has One Comment

Leave a Comment or Question