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 Microsoft Announces IT Pro and Developer Preview for Office 2016
Category: Office
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 Support of Power BI across various versions of Microsoft Office
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 Getting back in the game…
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 Unpivot data using Microsoft Data Explorer
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
Customizing PowerView in PowerPoint
Although "customizing" may be too strong of a word, there are few things that we can tweak to improve the look and feel of PowerView slides that had just been exported from SharePoint. The first thing to do after the fresh export is to adjust the size of the exported image. For some reason as … Continue reading Customizing PowerView in PowerPoint
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 Apps for Office, specifically Office 2013
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 Microsoft makes big announcements at SQL PASS
A quick note on Surface RT battery life
Just wanted to write a quick note about my first day of using Surface at work.. I used it extensively throughout the whole day, lots of internet browsing, a few Lync meetings, heavy emails. As of right now, the battery is at 58% without me charging it for the entire day. In fact I had … Continue reading A quick note on Surface RT battery life
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).
business intelligist 