Enable the Power BI developer tools

if you want more control over the visualisation you can create in PowerBI take a look at the new developer tools.

You enable these by signing into your PowerBI environment and appending:

?devToolsEnabled=true

to the end of the URL.

The browser should refresh.

image

That will reveal a new menu option under the COG called Dev Tools.

image

A new tab will open and you’ll see the developer environment.

Take a look at the above video to see what’s involved in getting started with this environment.

A bit geeky I know and not for everyone but it should reinforce the point how important software (i.e. coding) skills are fast becoming. It should also highlight the opportunities that abound in this new environment and how easy it is to get started.

Power BI achievement unlocked

clip_image002

I find that the best way to learn ‘stuff’ is to have an end goal in mind. Design a specific project, with specific outcomes rather than trying to ‘learn’ generically. Solving a problem using technology, I find, generally produces faster and better results because it provide focus.

Case in point. One of my ‘learning’ projects has been to get a report on the storage utilisation from a machine and then be able to display that in a dashboard tool that allows ad hoc querying and reporting on that information.

Luckily, Power BI has come to the rescue at the presentation end, the issue I had been struggling with was developing something to collect all the data. I had written a PowerShell script and imported the results it into Excel but hadn’t got much further.

Recently I came across the new:

Office IT Pro Deployment Script project

in there was a Check-DiskSpace project that basically used the new Excel 2016 graph types like TreeMap and Sunburst to graphically display data collected from the hard disk.

Inside the project was everything i needed, a PowerShell script to collect the raw data, an Excel spreadsheet to automatically pull the raw data into an Excel pivot table. All I needed to do now was save that data to a new clean spreadsheet and upload into Power BI.

Once the upload into Power BI was complete I was then able to not only view my data graphically but also use nature language querying to analyse it, all thanks Power BI.

The result is what you see in the screen show above. Sure it is simple but it has progressed me a long way along the path of turning this into an impressive integrated demonstration that I can show prospects. That is going to give them a much better idea of what Power BI can do for their business and potentially win me more consulting opportunities.

Sure there are easier ways to display hard usage BUT the aim of this was to firstly improve my knowledge of Power BI by solving a problem (CHECK) and at the same time come up with an end to end demonstration of how Power BI can produce valuable information from raw data (CHECK).

Thus, achievement unlocked and now I’m onto the next level.

New Power BI available July 24

Along with Delve I think Power BI is going to be one of the most influential applications in Office 365. The good news is that Microsoft just announced the new Power BI, which has been in preview for a while now, will become generally available on July 24th 2015. You can read more about the release here:

http://blogs.microsoft.com/blog/2015/07/10/over-500000-unique-users-from-45000-companies-across-185-countries-helped-shape-the-new-power-bi/

The above video gives a quick overview of what Power BI can do and how it can be used in a business. Best of all, the basic version of Power BI is free!

The next piece of the puzzle after this will be the Office 365 content packs that allow you to surface all sorts of Office 365 analytics directly into Power BI and create amazing dashboards. Can’t wait!

Switching on to PowerBI

One of the most powerful applications just about every business has at their fingertips is Excel. What this product can do is truly amazing when you explore it fully. The downside is that most people use less than ten percentage of the product capabilities.

Some of the more advanced features of Excel are Pivot tables. In essence, these allow you to create basic data cubes to easily slice and dice your raw data to create information that has value and provide insight. Sadly again, few people even know what Pivot tables are, let alone even used them.

The growing demand in our increasing data driven world is having a method of producing meaningful information from a vast array of raw data input sources. Microsoft is providing such a solution in the form of PowerBI.

The latest version of PowerBI from Microsoft is now available in preview for free. You can sign up at:

http://www.powerbi.com

When you do you’ll be presented with some sample Retail Analysis data that look like this:

image

As interesting as that is it is a little abstract. Where you begin to appreciate the role that PowerBI can play for you is when you select the option to Get Data.

image

Here you’ll now see a variety of sources that PowerBi can report on. One of the options you’ll see from the above screen shot is Google Analytics web data.

image

When you connect up your Google Analytics you’ll get a new dashboard, as you see above, with all of the information about your web site. In this case, I’m look at data from my www.anzacsinfrance.com web site.

image

At the top of the dashboard you’ll see a box into which you can type a free form query. So if I type “total hits” the dashboard automatically shows me the result as you see above.

image

If I now extend that query to “total hits last month” the result is immediately updated and displayed as shown above.

image

If I extend that further to “total hits last month in turkey” I see a result of 6 website views from Turkey in the last month.

image

If I extend that once more to “total hits last month in turkey compared to france” i now get a graph as shown above.

Hopefully, you can see the possibilities and the depth of reporting that is possible. And of course you can pin these queries to your dashboard so they display upon your return.

image

Apart from the adhoc dashboard you can create multi page reports. The above is an example from my web site data. Again, you can customise these easily in the web browser or download the PowerBI Designer for your desktop.

As you saw earlier, one of the data sources I can use is a plain old Excel file, uploaded from your desktop or saved in OneDrive consumer or OneDrive for Business.

image

Once the spreadsheet is available to PowerBI, now you can start creating reports based on the Excel Pivot tables I alluded to earlier. You do this by simply dragging and dropping the desired column heading into the appropriate locations (axis, vales, etc). The difference here is that I am doing this in a browser in a way that I can pin the result to a dashboard and report.

image

I can also now quickly and easily change the style of graph that is display, change the data I report on, create more results on the page or create additional pages effortlessly.

image

I can also easily share my dashboards with others when they are complete.

Microsoft is announcing more and more options for data sources with PowerBI. One of the upcoming options will be analytics from Office 365 with the soon to be released Office 365 content pack for PowerBI.

Whats new in Office 365 Administration from Microsoft Ignite 2

Which should allow you to produce report from Office 365 like you see in the above screen shot taken from the announcement blog post.

At the core of PowerBi is the concept of data sets. Raw data sets are ordered by Excel style Pivot tables with the results being surfaced through PowerBI. Thus, to get meaningful results you need to understand Excel Pivot tables. If you don’t now might be the time to fire up that version of Excel and start learning!

Hopefully, giving you this small inkling of what is possible with PowerBI will inspire you to dive into the product and learn what it can offer. I know I am and am amazed everyday with what is possible and will be detailing more in upcoming posts. Given that it is also in preview and free to access is an even better reason not to hesitate but to dive in now and power up with PowerBI.