Power BI Pro Tip: Show Top x results with RANKX() function
One of the more frequent scenarios is listing the top X results, such as most profitable products, biggest customers, top 10 best selling stores, etc. Also doing a top X selection helps reduce clutter in charts: a…
Office 365 roadmap site
If you want to keep track of what is happening on Office 365 and what updates are rolling out and coming down the line check this site: http://office.microsoft.com/en-us/products/office-365-roadmap-FX104343353.aspx Trust me, a lot is happening on Office 365!
Power BI Pro Tip: DIVIDE() function
If you ever used Power Pivot to calculate things such as sales amount per capita or averages of some sort you will have run into the situation that the denominator (the column you want to divide by)…
OneDrive launched!
Today we (re)launched SkyDrive OneDrive, our solution for storing, sharing and editing documents in the cloud. OneDrive is cross platform (Android, iOS, Windows Phone, Windows) and syncs files automatically. It even enables you to edit Office files…
Setup and register a Data Management Gateway for Power BI
In this post we will have a look at how to install, setup and register a Data Management Gateway for Power BI. It involves installing software on a server which will function as the gateway as well…
Five years at Microsoft
I was hired as FTE at Microsoft in November 2008 so recently celebrated five years at Microsoft! Still going strong and enjoying every day J Below is the glass award I received:
Speaking at SharePoint Connections Amsterdam 2013
Just a quick post: I will be speaking at SharePoint Connections Amsterdam 2013 (19th-20th November 2013) on Power BI for Office 365. More info on: www.nccomms.com/sharepoint_connections. I can get you a 10% discount, just reach out to me.
Installing Master Data Services add-in for Excel 2013
I recently picked up my new laptop, which of course runs Office 2013 and Windows 8. When you try to install the Master Data Services add-in for SQL 2012 you may run into a warning that says…