Introducing Power Update!

Post by Rob Collie

***Update:  check out Scott Senkeresty’s review of Power Update over on Tiny Lizard.

***Update #2:  a Free Version of Power Update is now available.  More info here.

***Update #3:  There is now a forum for Power Update questions, located here.

Power Update: Refresh any Power Pivot / Power BI Workbook, from Any Data Souce, and Publish to Any Location (SharePoint or Otherwise)

A brand-new software utility designed from the ground up as
a “Companion” to  Power Pivot, Power Query, and the entire Power BI stack.

Definitely Click on the Image for Larger Version – Surprises Lurk Therein

Do Any of These Sound Familiar?

Common Problems with Power Pivot and Power BI Scheduled Refresh

Power Update Helps With ALL of These (And a Few More, Too)

“What IS It?”

OK, a few things:

Read the Rest

Europe Underestimated: Why Power View Hates Bob Phillips, and a User Group Update

 
Lots more interest still flowing in through the registration page.  Updated status (changes in CAPS)…

Places that are ready:  NEW YORK, DALLAS, INDIANAPOLIS, KANSAS CITY, LONDON, NORTHERN ENGLAND, Portland, Detroit, Washington DC, Vancouver BC, Boston, Cincy/Dayton, Milwaukee/Madison, Seattle, Atlanta.

Places that are getting close:  CHARLOTTE, NASHVILLE, BIRMINGHAM (Alabama), GENEVA, COPEHNAGEN, OSLO, STOCKHOLM, Minneapolis/St. Paul,  Chicago, Buenos Aires, Cape Town, Perth, Melbourne, Sydney.

Places that just need an organizer:  NorCal and Denver still slacking in this regard Smile

But there’s an actual Power View technique/fix to be reported here, one that paints a much nicer picture of Europe especially…

image

Europe Has a Lot More Bubbles than Originally Thought Smile

I got a comment/question from Bob Phillips yesterday:

image

Read the Rest

PowerPivot vs. Power View: What’s the Difference?

 
I’ve been getting this question a lot lately:  How does Power View relate to PowerPivot?  Is PV a replacement for PP?   (And why does PV have a space in it while PP does not?)

(For more information on the various “Power *” offerings from Microsoft, see also the newer posts What is Power BI? and The Three Big Lies of Data).

First:  Understand that PowerPivot is Kinda Two Things

Let’s rewind all the way back to Office 2010, a world in which PV does not exist.  (For most of you, we call this time Today.  And for those stuck on 2007 or 2003, you may refer to this as Tomorrow.  Or maybe even the Day After Tomorrow).

In that world, which is where this blog largely lives, it’s helpful to reflect that PowerPivot has two parts:  the PowerPivot window, and the Excel window.  They have the following relationship:

PowerPivot's Relationship to Excel

 

Read the Rest

Guest Post: GeoFlow using Panama’s Census Data

imageIntro from Rob

Very busy week for me.  Fortunately Miguel is at the ready with another guest post.

It occurs to me that we’ve now had guest posts from the US, the UK, Holland, Canada, and Panama.  That’s pretty cool. 

Miguel told me that I was going to LOVE the first picture in this post.  And I do.  But I must say that, once I saw the title, I expected something along the lines of the picture at the right.  The picture below is better.

OK, over to Miguel…

image001

Figure shows the population distribution for Panama in 2010
Made Entirely in Excel!

If you read my latest guest post at Powerpivotpro’s blog, you’ll know that I’m working on a personal project trying to get a more visual aproach of the latest census Data for the country of Panama (where I’m from and I currently live in).

Read the Rest