Tag: Office 2013

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).

Microsoft Surface RT review, sort of in a context of Microsoft BI

First, I have to explain why I am writing this review when so many websites have already covered the product – the only thing that I will cover that others haven’t is what features of Microsoft BI stack run on Surface and what don’t. Let’s get through the bad stuff first. I don’t know if

Continue reading

Slew of important SQL Server announcements is expected at SQL Pass conference in Seattle this year

Microsoft is expected to make a number of very important announcements at the upcoming SQL Pass conference in Seattle… If you are on the fence about attending it this year, I would definitely recommend attending this event.

Excel Services 2013 and SharePoint 2013 – interact with Pivot Tables using Browser

One of the nice new features of Excel Services now available in SharePoint 2013 is ability to interact with pivot tables directly from the browser without having to open the workbook in Excel. Here we have a PivotTable report deployed in SharePoint. Before, if we wanted to change a layout of the pivot table, we had to

Continue reading

How to connect Excel PowerView to Analysis Services cube

There are several UI gotchas related to building PowerView visualizations that I wanted to address with this post. First, PowerView is not available in the Ribbon out of the box, in order to enable it, one needs to go to File->Options->Add-ins. Then find Manage Add-Ins drop down box, select “COM Ad-ins” and click Go. That

Continue reading

More details on new PerformancePoint features in SharePoint 2013

Additional details are coming out on the new features that will be available in PerformancePoint 2013. Here is a list of new stuff: Themes – SharePoint has traditionally been somewhat of a challenge with respect to look and feel configuration and PerformancePoint Services was an even bigger challenge yet. Microsoft has simplified the CSS challenges

Continue reading

PowerView in Excel 2013 – Business Intelligence – Second Impression

Well, the more time passes, the more I like it… Somehow I have figured out, subconsciously, how not to make it crash quite as often and also how to work around things that don’t work very well. So, in no particular order, here are few more observations… Map – like it a lot. There is

Continue reading