Adobe Analytics Connector in Power BI

In this video we’ll walk through the Adobe Analytics Connector by creating and loading a request, changing the format of the data, building a visualization, and publishing to the online service.

 Transcript

Hi, this is Jeremy King. I’m a Senior Product Manager on the Adobe Analytics Cloud team. I’d like to take some time to introduce you to the new Adobe Analytics Connector and Power BI. This was developed in partnership with Microsoft and allows you to directly load your Adobe Analytics data into the Power BI experience. When you launch the connector, you’ll authenticate using your Adobe ID. You’ll be presented with this Navigator, that’ll show you all the available reports we have access to. When you break down a report suite you’ll be able to select the individual items within that report suite. The dimensions and metrics. Everything you need to create the requests, that you want to use to drive and build out your reporting. Let’s go ahead and build a request.

I’m going to build a request, starting with dimension of Operating System Type and we’ll go ahead and find a Measure of Visitors.

And for my report suite, I’m going to change the Start reporting range, to actually fall in April.

We’ll update the End reporting range as well and Apply that additional option. You could also choose to apply a segment to your request or choose Top items to have it only return so many items back for that dimension. In my example, I’m going to go ahead and update the Top to be six and only pull back the first six items.

Once you’ve built the request the way that you want and you want to save it into your Power BI Project, go ahead and hit Load.

Now we’ve successfully loaded a report from Adobe Analytics into our Power BI Project, but now is where the fun starts. So, I can go over here and find the we RETAIL data set table that just got loaded. I’m going to go ahead and Rename it so I can keep track of which data set this was and let’s go ahead and inspect the items inside. So we’re going to click on Operating Systems for the dimension element and Visitors for the metric or the measure. Notice, that the table that Power BI selected to represent the data, shows the Visitors metric and the Visitors metric isn’t quite the format I was looking for, so why don’t we go ahead and change that. I can select the visitors metric, go to the Modeling tab, we’ll keep the separator and we’ll get rid of the decimal places. You’ll notice that it will update the visualization, as well as the actual dataset that I have inside of the Power BI project. And then in terms of the visualization, maybe I don’t want to represent this as a table. Why don’t we switch it to a pie chart.

Now you may have noticed a few other dataset tables already loaded in the right-hand side. If I switch over to page two of this report, you’ll see a few other visualizations I went ahead and pre-built, just to show you what’s possible. Now this isn’t where you end. You also have the option of Publishing the data sets that you’ve created and formatted, as well as the report that you generate to the Power BI online service.

A service you’ll use to share this reporting out to others across your organization.

So I’m gonna go ahead and Select my workspace and let it Publish to the online service and it’s done. So let’s go ahead and look at that experience.

Now I’ve successfully published my data from Adobe Analytics into the Power BI desktop. Reformatted those datasets to look like, how I want represented for the reporting I needed to create. Created reports and then published both the Datasets and the Reports I created in the desktop application to the online service.

Now I have the option of taking these tiles that are in the reports, pinning them to dashboards and then sharing those dashboards, along with the reports and data set assets with others across my organization.

I hope you look forward to exploring this integration further.

Additional Resources

On this page