Monthly Archives

4 Articles

Big InfoPath News

The word is out! On January 31, we published a post on the official Office blog¬†where we layed out the future of InfoPath. I have been thinking about this for a while and am glad that the decision is there: “there will not be another version of the InfoPath desktop client or InfoPath Forms Services” (source: the Office blog post, see above).

I feel the functionalitity that InfoPath provided will find its way into other parts of the Office suite and SharePoint. Take Access for example: Access is much less a database program than it was before. If you now start a new database, the first question you get is to specify in which SQL Server the database should be created. The forms Access creates can now be published to SharePoint to facilitate easy data entry and editing into databases. InfoPath provided other features and challenges, and I am curious as to where the features will go. I am certain we will get rid of some of the challenges InfoPath has (XML forms anyone?).

So, bottom line: yes, “Partir cest mourir un peu”. It hurts to get rid of a product, but I think it is for the best; we get a better, clearer proposition and a rationalized product line up. All in all, less confusion, same or better functionality. What do you think?

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 right there in the browser. Even better: it’s free!

Check it out:


CEO Announcement Twitter Analysis

Last week Satya Nadella was announced as the new CEO of Microsoft (see This was met with a lot of reaction in the world and also on the social networks. I decided to analyze the tweets on Twitter using my favourite tool Excel and a special Twitter Analysis add-in that we have made available through . I opened the twitter analytics sheet and did a new query. Here’s what I searched on:

#ceo #nadella #microsoft #satyanadelle @satyanadella

There is really a lot of info that you can get from the Excel sheet. I cannot cover all of it, but I’ll share some screenshots:


What I found interesting is the hashtags and mentions. Of course #microsoft, #ceo and #satyanadella are the top three hashtags but #Manual is on fourth place. #cybersecurity and #hacking take sixth and seventh place respectively. Looking at the mentions I noticed @satyanadella, @billgates and @Microsoft, but also @bill_nizzle. Not sure what he is doing there J

In the top screenshot some slicers are shown that enable you to filter the data at will to slice and dice to more insight.

One thing I especially like is the tone map that displays whether a tweet was positive or negative. It also has a map so you can see where the tweet came from and allows you to play back the number of tweets over time:

Only a small amount of the tweets were negative and when I selected negative tweets only I saw the following:

It seems like in Europe we have not been tweeting negatively on this subject (at least in the timeframe I recorded). The US is most negative and also there were some negative reactions from Nadella’s home country India, from Australia and Egypt.

This is a very easy way to do any kind of on the spot Twitter analysis using Excel. The Excel sheet used is freely available via the link above. Enjoy!

Using Featured Questions in Power BI Q&A

Those of you who have tried Power BI may have noticed the Featured Questions tiles:

(Those of you who have not yet tried Power BI: go to and build you own demo environments in minutes for free!)

The featured questions function as a sort of shortcut / favorite to an answer in Q&A. What is cool is that you can actually add your own.

To do this start Q&A and come up with the question you would like to feature. I used “medal count by country in europe for swimming vs athletics”.

Now, copy that question (or remember it) and click on the fly-out on the right and then choose “featured questions”. Next click on “add featured question”.

In the next window type or paste your question and wait for Q&A to validate it.

Be sure to enable ‘show on the Power BI site home page’ if you want your question to show up on the home page and continue setting up your tile. I used these settings (I used an image from Wikipedia to function as background. Not the prettiest but it works):

Next click ‘save’. Next go back to the Power BI home page and there it is:

Pretty cool huh?


%d bloggers like this: