BI & PowerBI News
Really didn’t know about few facts in BI world. I saw a lot of articles about some great improvement inside Microsoft BI technologies, so I would like to provide some basic overview to all of you, who are same enthusiasts in Microsoft BI stuff.
The first one is that you are able to integrate PowerBI in standard Microsoft Office Documents, all you need is to download add-on inside Office App. This app is called PowerBI Tiles
What is not so surprising is fact, that DevScope as an developer of this app is providing the same app for SharePoint Server via app store. Great that I am now available to insert PowerBI parts to SharePoint Online environment. Hopefully on day this should be available for hybrid or on-premise scenarios. Great! And not only from hybrid point of view. I like it on Office 365 most.
Another Great feature is that Microsoft releases gallery of let’s say add-ons or templates for PowerBI – gallery, which is available for free uploads for anyone. So if you want something new in your dashboard let’s take a look, you will definitely found something similar to whatever you need.
Take a look to this address: https://app.powerbi.com/visuals
Power Map and your own region
If you are using Power Map to analyze from a geographical point of view, it’s a definitely nice feature to use regional coloring. It is necessary to define zip codes in dataset, but what if you want to specify your own region for coloring regarding to your data? About custom regions visit THIS post from office blog series or download THIS GREAT GREAT demo files.
Microsoft Dynamics NAV vs. PowerBI
Regarding to BLOG post from Microsoft, new out of box connector was released for Dynamics NAV/content pack. Each report includes a set of visuals with different insights. For additional information you can hover over any of the items, or select a particular value to cross filter other visuals on the page. The Sales report provides insights such as the sales amount by customer group and product. On this report you can select a specific salesperson from the salesperson name slicer to filter the data for that person.
Interesting resources about BI
Great session about Demystifying Kerberos in SP2013 and SQL 2012 for business intelligence and about System Center Reporting through the Microsoft BI Stack.