BI-NSIGHT Power BI Sweet IQ , Summer Release – SSIS Feature Pack for Azure – Excel 2016 New Chart Options (Treemap, Sunburst, Histogram, Box & Whisker, Waterfall)

Well this week there were some updates and fortunately not too many so where we go!

Power BI – Sweet IQ

This week, there was yet another release of a content pack for Power BI, this time it was relating to a company called Sweet IQ.

They position themselves as provider that can leverage your local search and increase your visibility on the web. Whilst looking at the blog post, I have to say that this is once again a great way for customers to get quick and easy access to their data. And enable the customers to interact and see how it is performing.

You can read about the post from Microsoft here: Analyze and Monitor your SweetIQ Data with Power BI

Summer Release of Power BI

I am not going to go into too much detail around this, because all the information that I could find was on the blog post from Microsoft. But it does bode well for the next release of the Power BI Designer.

And for me I think this is where I would start at looking the Power BI Designer over say using Excel as a source or using the web based version to author reports.

As you can see from the above screenshot, it appears that there is going to be a whole host of things that you can customize within the Power BI Designer. And this will make their existing reports, which look really good, go from good, to be a standout. Especially since from what I can see above, I have not seen this in other products of similar nature.

You can read the blog post from Microsoft here: We’re on for a great Designer Summer…

SSIS Feature Pack for Azure

As you can see from the above screenshot, these are the items that are available in the SSIS Feature pack for Azure.

I personally think that this is great, as in the past, it has been a bit of trickery to get data from On Premise into Azure. Personally I know of a few people who have had some struggles. As well as a lot of people who do know and understand SSIS, really well. So this would fit in with their existing skills.

I also did see that the Varigence have created a webinar for this here: Moving ETL Loads to Azure Part1 Webinar Content

I have personally not tested it yet, but I am sure that it will be a lot easier to get data into Azure!

You can read up all about it on MSDN here: Azure Feature Pack

As well as downloading the SSIS Feature Pack here: Microsoft SQL Server 2014 Integration Services Feature Pack for Azure | Microsoft SQL Server 2012 Integration Services Feature Pack for Azure

Excel 2016 – New Charting Options (Treemap, Sunburst, Histogram, Box & Whisker, Waterfall)

Every week or so, I check to see if there are any Office 2016 updates, and this week there was!

So one of the things that I have been looking for since watching the Ignite video’s is for the new chart types. And finally this week, we have the new chart types in Excel 2016!

The one of the things that I can currently note, and I do hope that this will not be the case once the final product is released, is that it says that it cannot be used with a Pivot Table. I might not totally understand the dynamics behind how the chart is created. But how awesome would it be if we could use it with our data from Power Pivot, or our SSAS Cubes!

I have also noticed that they have changed the multi select button on your slicer to look a little more attractive as shown below.

There might be a few other changes, but currently I have not seen them or found them out!

That is it for this week!

BI-NSIGHT – Power BI Updates (comScore, appFigures, Mail chimp) – Microsoft Social Engagement

I was away on holiday so here is this week’s BI-NSIGHT..

Power BI Updates


comScore and Microsoft Partner to Provide Big Data Mining and Visualization Solution

comScore, is a Digital Media analytics company. And their relationship with Microsoft which has been ongoing for quite some years seems to be able to add additional values for their clients.

Using the real-time functionality within Power BI, it will enable their clients and customers to be able to see in real-time their analytics. Which for comScore’s existing customers, this could mean a leap frog on their competition.

You can read about their press release here: comScore and Microsoft Partner to Provide Big Data Mining and Visualization Solution

appFigures content back

Here is another content pack from Power BI, this time for appFigures. And I think that this is great for people who create apps. I am sure that currently it might not be such a simple process to be able to track their apps. Now with the developer being able to connect and subscribe to appFigures, they then get all of the additional reporting and analysis into their app data within Power BI.

I am sure that with having this useful information, it can allow the developer to then potentially view issues or alternatively be able to see when they released an update, and how it affected their app.

You can read more about it here: Explore and Analyze your appFigures data with Power BI

Mail chimp in Power BI

Just when I thought I had got all the updates for the past two weeks, I have a look on Twitter and see that there is another content pack for Power BI. And it is for Mail Chimp.

This is yet another tool, where you can monitor and evaluate your email marketing campaigns. And once again, another really great and interactive way to see how your email marketing campaigns are doing. As well as seeing how successful they are.

You can read more about it here: Use Power BI to Monitor and Visualize Your MailChimp Data

Subtle changes within the Power BI Interface

I logged into Power BI, to have a look at the new content packs and I noticed that they have changed or added the icons for the Dashboards, Reports and Datasets.

I know that this is a small change, but I find that people enjoy change. And even something so subtle, also shows that they are continually working on Power BI, and making changes. Which in my mind means that they are improving and working on Power BI.

Microsoft Social Engagement

This is something that is not directly related to BI, but I found it interesting in the way in which this product from Microsoft is positioned in my view.

From the way that I see it, it allows users and or companies to be able to gain access across the different social media platforms. And then from there be able to have some analysis in terms of what people are saying about their products on the multiple social media platforms.

I did also see, that there is the potential to do some sentiment analysis. And this is quite a hot topic at the moment, and I think that it will be so for a while. Especially when a company is already dealing with the public, and also have a strong social media offering which they manage. This will enable them to track and view over time, what people are thinking and saying about a brand or multiple brands.

It also appears that they have made it a lot easier and feature rich to use. A lot of what I saw in the demo, reminds me of Power BI. And I would not be surprised to pentially see a content pack in Power BI for Microsoft Social Engagement in the near future.

You can read more about it here: Turning social sentiment into opportunity

And here are more details about Microsoft Social Engagement: Microsoft CRM – Social