Category: Office

Microsoft Announces IT Pro and Developer Preview for Office 2016

New BI features include the following: Power Query is integrated into the Ribbon Three new Excel functions have been added to support forecasting Support for Slicer multi select using touch Time grouping for model based pivot tables Power View against multidimensional cubes Improved automatic relationship detection Ability to rename Power pivot measures and columns in

Continue reading

Support of Power BI across various versions of Microsoft Office

In this post I wanted to address several general confusions about Power BI and Microsoft Office. Sometimes I wonder if these confusions have been engineered by design or whether they occurred serendipitously… The most important point to understand is that Power BI is intended to be bundled with the Office 365 Pro version of the

Continue reading

Getting back in the game…

I have not been posting much on the site in the last few months. This lack of activity was attributed to predominantly two things: A) My summer got really busy with my primary revenue generating activities and B) There was really not whole lot going on in the MS BI space that I felt I

Continue reading

Unpivot data using Microsoft Data Explorer

I have been really impressed with Microsoft Data Explorer the minute I had a chance to play with it as I was able to turn formatted Excel reports into legitimate data sources available for analysis. Fairly recently, an update to the tool delivered an uber critical feature that makes a huge impact on the world

Continue reading

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

Apps for Office, specifically Office 2013

Those who have been looking for new features in Microsoft Office 2013 have probably found the new Insert->Apps for Office button on the Ribbon. I have played around with these a little bit and have a few things to report. To get an idea of what Apps for Office are available, please check out this

Continue reading

Microsoft makes big announcements at SQL PASS

I will have a more detailed write-up of everything later but still wanted to give a quick summary of the new announcements: Updateable Column store – Project Hekaton will be released in the next major release of SQL Server and will allow us create updateable clustered column store indexes. This is huge, 20-50 performance increases

Continue reading

No material differences with respect to BI found between the RTM and Preview versions of Microsoft Office 2013

Having gone through the RTM version of Microsoft Office 2013 RTM I cannot find any material differences from the Preview version. The two major (although not really feature related) differences are speed and stability (both revised significantly upwards).