BI-RoundUp – Power BI (August Desktop Release – Timeline Story Custom Visual – Help Shape the Future of Power BI – Text Analysis Solution Template using Bing – Azure Activity Log Solution Template – Survey for Mobile Apps – Developer Update for August)

While the week before had nothing to really talk about that is new, this week there is a whole host of updates and great new things to play with so here are the latest details.

Power BI – Power BI August Desktop Release

Whilst this picture above may not look like much it is incredible with this new “What If” can do for your data and your users.

There are some great new features in the August release of Power BI desktop which I will cover below.

Reporting

The great thing that they have done with the reporting is how many updates they have made with Matrix and now you can easily put your measures on rows. This is fantastic and in the past I had to create a whole stack of measures to get this done.

You can now also use Conditional Formatting on the Font Colour, so if your data is low or high you can then put in some conditional formatting. This is again a great feature and on the way to allowing to show KPIs in the Matrix

There has also been updates and improvements for line charts, as you can see below to have custom settings for each of the line charts, as well as line marker options which means that you can customize it as to your requirements.


There has also been some new Custom Visuals added which are the Dot Plot, Power KPI, Funnel Plot and Beyond Soft Calendar which can show you ways to gain deeper insights into your data with some great ways to show what is happening within your data.




Analytics

As with the first picture one of the great new features is the What If parameter. I think that this is a killer feature as it is something business users have been asking for. As well as the implementation is relatively simple which makes it easy to integrate as well as leverage in existing Power BI Datasets.

Next is updates to the scatter chart where you can now use the Symmetry shading which will show you which has a higher value based on the X-Axis measure compared to the Y-Axis measure or vice versa

Along with this there is now also the ratio line, which is used to define the ratio of the subtotals to the x-axis and y-axis measures. Which allows you to quickly see based on either axis what your data is telling you.

There is also a new Quick measure called Weighted Average, this is where this measure calculates a weighted average of the base value for each category. This can be really handy when comparing different values.

Data Connectivity

In this month’s release connecting to the Power BI Service dataset is now generally available. As well as now you can connect to Google BigQuery which I am sure people who utilize Google BigQuery will be excited to bring their data into Power BI.

You can find all the details as well as the YouTube video here: Power BI Desktop August Feature Summary

Power BI – Timeline Story Custom Visual

I am really excited to see that the TimeLine Story Custom visual has been released in the Office store for Power BI. This was shown at the Data Insights Summit and it showed how powerful this visualization can be. Now that it is available I cannot wait to use it on my own data to see what it can show to the users.

You can download it from the following location: Office Store – Timeline Storyteller

Power BI – Help Shape the Future of Power BI

As you can see above the Power BI team is looking for people to join the user research channel which will enable you to help shape the future by giving them your real world inputs into how and what you think is required to enable Power BI to just get better.

I have personally completed the required survey and I do hope to be selected. They do request that you complete a survey which I assume is to ensure that they are getting the right type or possibly even a good spread of people to help shape Power BI.

Here is the link to the Survey: Take our quick survey and join our research panel.

You can find more details here: Shape the future of Power BI: Join Our User Research Panel

Power BI – Text Analytics Solution Template using Bing

There is a new solution template which now allows you to use text analytics and sentiment analysis using Bing and other related Microsoft products. The difference with this solution template is that it allows you to enter your own list of words. Which was a highly requested feature. Which I think is fantastic as everyone has different requirements and this allows them to achieve this.

You can find the blog post details here: Bringing more text analytics to the Bing News Solution Template

Power BI – Azure Activity Log Analytics Solution Template

Here is another great solution template which allows you to do analytics on your Azure Logs. This is a great way to leverage all your log data so that you can see what is happening within your organization.

I quickly installed this to see if it will allow me to view my log data for what has been happening inside Power BI, and I can

PIC HERE

You can find more details here: Announcing the Power BI Solution Template for Azure Activity Log Analytics

Power BI – Survey to improve Mobile Apps

If you are interested in helping Power BI with the mobile apps, here is your change to take the Survey which will give valuable information to the Power BI Mobile Apps team.

Here is a link to the Survey: Take the Survey

And here is a link to their blog post: Help improve the Power BI mobile apps

Power BI – Developer Update for August

For the first time there is a Power BI Developer update which details all the updates and changes with regards to the Power BI Development experience relating mostly to Power BI Embedded.

There is some great content in here if you are a Power BI Developer around the Embedded content. As well as some additional details around Power BI Premium as well as how you can find code samples and even test a working version to see how it works.

You can find all the details here: Power BI Developer community August update

BI-RoundUp – Power BI (Data Insights Summit Analytics Challenge Winners – Non-Profits Program)

It has been a quieter week, so here is the BI-RoundUp

Power BI – Data Insights Summit Analytics Challenge Winners

A big congratulations to the people that won the Analytics challenge for the categories “Complex Data Preparation”, “Advanced Analytics” and “Just for Fun”

It is great to see so many people who submitted their entries. Hopefully next year I can dedicate some time to entering the competition.

You can find the blog post here: Congratulations to the Data Insights Summit Analytics Challenge winners!

Power BI – Non-Profits Program

I was unaware that there is special pricing for Non-Profit organizations. This is great to see as very often these companies provide selfless work and really help out people and communities.

If you want to find out more details here is the link: Power BI – Non-Profit Organizations

BI-RoundUp – Power BI (June Desktop Update – Data Insights Summit Details – Power BI Embedded Pricing & Details – Power BI Premium Generally Available – Power BI Report Server Generally Available)

I was fairly certain that there were going to be a whole host of updates and additions to Power BI, and I can say that I am not disappointed. There is a whole host of information below, where I will endeavour to try and get it all to you, so this might be a bit long to read, but it will be worth it.

(more…)

BI-RoundUp – Power BI (Usage Metrics – Mobile Apps May 2017- Stream Data Insights Summit – Processing Suggestion Idea’s for Power BI)

Here is this week’s BI-RoundUp with some great content below.

Power BI – Usage Metrics

You now have the capability to be able to view the usage metrics for your dashboards and reports in Power BI. This is a great feature, because it now gives the organization the capability to see how well the dashboards and reports are being used, shared or viewed.

In order to be able to view the metrics you need to have a Pro license, as well as at least have Edit access to the Dashboard or report to be able to view the Usage metrics.

There is also the option to disable the usage metrics for the Organization in the Admin Portal.

And finally you can also build your own Usage Report, by clicking File, Save As, and from there you are then able to modify the existing report so that it can suit your requirements.

You can find that and more details here: Usage metrics for dashboards and reports

(more…)

BI-RoundUp – Power BI (Office 365 Adoption Content Pack – Embedded Accelerator) – Excel (Get & Transform Updates May 2017)

This will no doubt be a quieter week, leading up towards the end of May and into June when there will be the next wave of updates from the Microsoft Power BI Team

You might also notice that I have changed the name from BI-NSIGHT to BI-Roundup, as there was another blogger who has his blog URL as BiInsights, so rather than make it confusing I thought to change the weekly update name.

(more…)