203 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
Latest 7 Posts
Amazon Echo
Wed, Mar 29th 2017 2
Running results and future plans
Mon, Aug 8th 2016 4
Bill Nye and Ken Ham debate
Thu, Jul 7th 2016 2
Gallery test
Fri, Jul 1st 2016 7
A view on Young Earth Creationism
Wed, Jun 29th 2016 1
Working on implementing a new theme
Tue, Jun 28th 2016 2
FindTime for Outlook
Tue, Feb 16th 2016 4
Top 10
All aboard the Camberley Express
Fri, Feb 28th 2014 9
Plantronics Voyager Focus UC
Wed, Jan 27th 2016 8
Power BI for Office 365
Wed, Jun 4th 2014 7
Microsoft Office 2016
Tue, Sep 29th 2015 7
Gallery test
Fri, Jul 1st 2016 7
Microsoft Project Siena
Wed, Feb 19th 2014 6
Power BI app for Windows 8.1
Thu, Feb 27th 2014 6
Apps for Excel 2013
Wed, Jun 25th 2014 6
(Half) marathon man
Tue, Aug 25th 2015 6
Dell XPS 2720
Sun, Oct 19th 2014 5

Power BI app for Windows 8.1
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious

In late December I blogged about the Power Query add-in for Excel 2013, and mentioned that Excel is an important part of Microsoft’s strategy for Business Intelligence. BI in general is very much a hot topic in customer conversations. Power BI for Office 365 recently became available, and I’ll cover that in detail another time, but now we’re going to take a look at the Power BI app for Windows 8.1.

Power BI app homeAs I mentioned before, Excel’s Power tools take care of the various stages of BI, and Power View is the tool that allows you to present, view and explore the data. You can view the Power View dashboards is in Excel itself, but Microsoft are delivering other methods. Power BI for Office 365 will allow users to view a Power View dashboard in a browser, and this experience is enhanced with added support for HTML 5.

Power BI dashboard (1)The Power BI app for Windows 8.1 accesses an Excel spreadsheet in a shared place (e.g. a SharePoint document library or OneDrive) and displays the ‘presentable’ BI content – that will be data tables, pivot tables, charts and Power View dashboards. Click on the images to see the larger versions.

So, consider this scenario… the busy executive walks into a meeting with his (or her) Windows 8.1 tablet, loads the Power BI app, views the available reports, selects a dashboard to view, and then explores, filters and drills down into the data. This is made easy by the app’s touch interface. It’s also easy to browse an entire SharePoint library, select an Excel spreadsheet, and mark it as a favourite so that it appears in the app’s home screen.

The two images below show the same Power View dashboard – the panel containing the filters is open on the right, but in each image an aspect of the data is selected to show the impact of that data. In the first example, Q4 is selected in the bottom-right chart, and the data represented by Q4 is shown on the other charts (I love the way the pie chart slices shrink). In the second example, ‘Software’ is selected in the pie chart and again, the other charts show how that revenue category is represented in the other charts.

BI dashboard (2)BI dashboard (3)

The app supports all of the visual elements provided by Power View, with the exception of animated time-based bubble charts (you’ll have to stick to static bubble charts for now).

Power BI is available to download from the Windows app store, and after installing it you’ll see that there are some sample dashboards to try out.

Feb 27, 2014
7 hits

Recent Blog Posts
Amazon Echo
Wed, Mar 29th 2017 8:59p   Darren Adams
Here at dadams.co.uk we’re always quick to bring the news of new tech… oh, hang on, the Amazon Echo has actually been available for more than two years. Okay, well, the Adams household acquired one about a month ago. We don’t have a dog named Alexa, which means the Echo doesn’t have to tell us it doesn’t understand the question when we tell the dog (which isn’t called Alexa) to go out for a number two. If the dog was named Alexa, we could change the Echo

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