191 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Running results and future plans
Mon, Aug 8th 2016 8
Bill Nye and Ken Ham debate
Thu, Jul 7th 2016 5
Gallery test
Fri, Jul 1st 2016 6
A view on Young Earth Creationism
Wed, Jun 29th 2016 4
Working on implementing a new theme
Tue, Jun 28th 2016 4
FindTime for Outlook
Tue, Feb 16th 2016 3
Plantronics Voyager Focus UC
Wed, Jan 27th 2016 4
Top 10
Running results and future plans
Mon, Aug 8th 2016 8
Power BI app for Windows 8.1
Thu, Feb 27th 2014 7
Power BI for Office 365
Wed, Jun 4th 2014 6
Why Katie Hopkins should shut her mouth
Fri, Apr 24th 2015 6
Gallery test
Fri, Jul 1st 2016 6
Three years at Microsoft
Sat, Jun 28th 2014 5
Bill Nye and Ken Ham debate
Thu, Jul 7th 2016 5
All aboard the Camberley Express
Fri, Feb 28th 2014 4
Fitbit not fatboy
Mon, Sep 8th 2014 4
Fitbit Charge
Thu, Apr 30th 2015 4


Power BI for Office 365
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
Darren    

In two recent posts I discussed the Power BI app for Windows 8.1 and Power Query for Excel 2013. Continuing with this business intelligence (BI) theme, let’s take a look at Power BI for Office 365 (and to make it less of a mouthful, I’m just going to refer to it as Power BI).

The post about the Power BI app described the way that Excel files may have ‘presentable’ BI content, and the same applies here. If you create an Excel spreadsheet containing a Power View dashboard (or dashboards), Power BI will recognise this and focus on it as content to display. It should also be mentioned that the data is not necessarily stored in Excel – it could exist in a database or system, and Excel services on the server are being used to query and present the data.

So what is Power BI? It’s an add-on entitlement for Office 365 that will provide an attractive presentation interface for your dashboards. The Excel files containing the dashboards can live in your OneDrive for Business collection or in SharePoint sites. Power BI can be added to the sites to provide that presentation and navigation capability. It also provides some other capabilities, but we’ll come to those later.

How does it work? As I mentioned, if you have entitlements to Power BI, the capability can be added to your SharePoint site. By navigating to the Power BI section of that site you will see a representation of the folders and Excel files in the site’s document libraries. A file can then be ‘enabled’ and this makes it ready to go into the Power BI gallery (by marking it as a featured report). At this point the file’s visual place-holder will show a snapshot from within the file, and it if contains a Power View dashboard then you’ll see a preview of this. The image below shows a number of Excel files enabled and added as featured reports.

Power BI for Office 365

From here it’s simply a matter of clicking on the report to view it. As with Power View in Excel itself, or the Power BI app, the dashboards can be explored, drilled-down and filtered. Fields can be added and removed, and chart types can be changed. Power BI can display the dashboards via HTML5, and therefore it will work on a variety of modern browsers including those on some of the popular tablet devices.

Power BI dashboard

I mentioned that Power BI provided some other capabilities beyond providing navigational access to reports. One is that it removes the file size limit given to Excel files sitting in SharePoint document libraries and viewed using the Excel web app – this will allow you to view and explore some big ol’ chunks of data.

Another capability of Power BI is the natural language ‘Q&A’ feature. In a nutshell this allows you to use natural language to generate a view of the data. Excel files have to be made ready and optimised for this type of analysis, but it’s a simple one-minute step. You can add ‘phrasings’ – this is useful for allowing people to use words which aren’t in the original data definition but which they are likely to use to query the data (e.g. if you were looking at data about football you may use ‘team’ instead of the original term ‘club’).

Power BI Q&A

Once invoked you can type in a ‘question’ – for example, I obtained some house sales data from the Land Registry site and can ask questions such as:

houses in Camberley greater than 500000 and type is detached
value of houses by type in esher and weybridge and camberley
average value of houses by type and town in borough of Spelthorne

Power BI Q&A

You’ll notice in the first screenshot that there are some featured questions – these can be easily be added to the ‘gallery’ for repeated quick access (and it’s a useful tool to ask a question and then tweak the values).



---------------------
http://www.dadams.co.uk/2014/06/04/power-bi-for-office-365/
Jun 04, 2014
7 hits



Recent Blog Posts
8
Running results and future plans
Mon, Aug 8th 2016 3:24p   Darren Adams
I’m pinning this here as a reminder to myself as to when races are, and as a log of times so far. 10 km 22nd March 2015 – Eton Dorney Lake – 56 minutes 11 seconds 3rd May 2015 – Run Frimley – 54 minutes 34 seconds 17th May 2015 – Royal Berkshire Green Park – 51 minutes 7 seconds 3rd June 2015 – Yateley race 1 – 49 minutes 22 seconds 12th July 2015 – Vitality British London run – 52 minutes 21 seconds 13th September 2015 – Se
5
Bill Nye and Ken Ham debate
Thu, Jul 7th 2016 7:55p   Darren Adams
6
Gallery test
Fri, Jul 1st 2016 6:03a   Darren Adams
This is a gallery test.
4
A view on Young Earth Creationism
Wed, Jun 29th 2016 1:02p   Darren Adams
Allowing the notion that the Earth is 6,000 years old to be promulgated in schools is like teaching kids that the distance across the United States is 17 feet.
4
Working on implementing a new theme
Tue, Jun 28th 2016 8:06p   Darren Adams
Here at dadams.co.uk we’re working on implementing a new theme, so things may look a bit odd for a while.
3
FindTime for Outlook
Tue, Feb 16th 2016 1:52p   Darren Adams
One of my major irritations with the whole calendar and scheduling business is receiving an invitation to a time when I’m already busy. If said invitation is from an internal person this is utterly unforgiveable as my free / busy time (and appointment subjects) is available for all to see… therefore they have just not bothered and have adopted the “well I’m free at that time” mentality. Decline. If the invitation comes from an external it’s a different mat
4
Plantronics Voyager Focus UC
Wed, Jan 27th 2016 4:11p   Darren Adams
When I joined Microsoft nearly five years ago (wow, that’s gone quick) I was presented with a technology survival kit on my first day. A Lenovo laptop, a Windows Phone, and a set of Jabra wired headphones. The headphones were necessary (they still are) because there’s almost no desk phones in Microsoft – your PC is your phone, courtesy of Lync… sorry, Skype for Business. The laptop has been replaced (Dell XPS 12, and a Surface Pro 3), and the original HTC phone has long




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition