What is the Microsoft Power BI connector for SAP?

I have been getting some questions about it recently so I decided to write a few lines in addition to what's now available on the Power BI site. Here is a list of some key points about the tool: No middle-ware components are necessary to provide the connectivity between Excel and the Business Objects server. … Continue reading What is the Microsoft Power BI connector for SAP?

How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot

In this post I will walk you through all the steps necessary to expose your on premise enterprise data to your Power BI users of Power Query in Excel and also will demonstrate how to source that data into a Power Pivot workbook. I am not going to give you too much theory, rather, I … Continue reading How to configure on premise access in Power BI and use Power Query to load on premise data into Power Pivot

Modeling financial scenarios tutorial available from Microsoft

Kasper de Jonge has recently posted a PowerPivot model, Access database with some financial data and a white paper that provides what I think is the absolutely best way to jump start a BI initiative focused on implementing financial metrics and KPIs. Please find the overview and the download link here. This is an absolute … Continue reading Modeling financial scenarios tutorial available from Microsoft

SAP vs. Microsoft, Information Assets vs. End User Experience positioning

If your company runs SAP, chances are the picture below represents your environment pretty well The black colors represent the existing investments/business processes and the size of the bubbles represents the effort/investment $$$. Your company has made a very large investment in the SAP back-end (ERP, BW, etc.) which is represented by a large black circle … Continue reading SAP vs. Microsoft, Information Assets vs. End User Experience positioning