SAP and Microsoft BI Interop White Paper (Plus Some Color Commentary)

Last week (week of July 22 2013), Microsoft held its TechReady conference for internal employees.  I didn’t get to go this time around, but I was able to audit the classes remotely (a very cool experience). One of the sessions was focused on wiring up Microsoft BI to SAP – an ever-interesting topic.  During the…

1

Soooooo…you now have two approaches to hosting BI in the cloud (Power BI vs. Azure VM Role for BI Deployment)

With the announcement of Power BI at the WPC last week, Microsoft now has *two* ways it can host your BI application in a public-cloud setting.  Power BI delivers self-service BI modeling, transformation, reporting, and geospatial via Office 365. Of course, you can run both the traditional (SQL/SSAS/SSRS/SSIS) and self-service (Power Pivot/Power View) by provisioning…


How can I check out Power BI?

If you want to check out the entire Office 365-hosted incarnation of Power BI, you can register to get in the queue for the preview now at http://office.com/powerbi.  Microsoft will start churning through the queue in about four weeks.  In the meantime, you are more than welcome to install the components you’ll need on your machine…


Power Query – Pulling in Foursquare Data into Power BI

As a follow-up to my previous post, I wanted to do a quick demo of how to pull in JSON-structured data into Power BI.  Going directly into Power Pivot isn’t an option; we need to use Power Query to help pluck the data we need out of the API call.   In my example, I…


Power BI – Why would you ever need Power Query when I already have Power Pivot?

I’ve been mulling this question over since the first incarnation of the former Data Explorer technology.  At first, I wondered if this was developed in some secret back-room in Redmond – completely outside the watching eyes of any of the “mainstream” developers. Now, I get it. The easiest way to think about Power Query vs….

5

I have finally started blogging!

Hi folks – it’s taken a looooooonnnnnggg time to get to this point, but I figured now would be a good time to start. If you know me already, I’m grateful that you followed me over here.  If not, here’s the quick story on my background: At Microsoft, I am a Principal Specialist for Business…

2