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 P3 Adaptive journey: 800 Blog Posts and 2000+ YouTube Subscribers! Get a list of our hottest blog posts below.

P3 Adaptive 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!


Datazen = Beautiful Mobile Dashboards to Make Power Pivot Shine


Power BI, YouTube for Workbooks: More Affordable!


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


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


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


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


The Only “Requirements Doc” You Will Ever Need


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


VLOOKUP better than Relationships? Hell must have frozen over


Our Road Ahead


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


The Diabolical Genius of “SWITCH TRUE”


Create a Custom Calendar in Power Query


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


Power Pivot to SSAS Tabular in less than 30 minutes


Some Good Power Pivot / Power BI Computers


Is Your DAX/PowerPivot/Power BI Computer FAST?


“Beta Test” the New Reference Card?


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


Power Query Super Charges the Internet


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


Dynamic Age Calculation Using Measures


Power Pivot to SSAS Tabular: Automatically Publish Excel Workbooks


Power BI as Google Docs Antidote