Monitoring Your SparkPost Data with Microsoft’s Power BI

Sparky
Dec. 16, 2015 by Sparky

SparkPost is proud to announce a powerful new integration with Power BI. The recently formed partnership with Microsoft’s cloud-based business analytics service is designed to provide customers with a single view of critical business data.

By connecting Power BI to your existing SparkPost account, you’ll be able to use the Power BI SparkPost content pack to monitor, explore, and visualize email metrics. The content pack allows you to easily connect your SparkPost data and begin to discover insights with an out-of-the box dashboard, reports, and curated data sets on Power BI.

The Power BI content pack can help you analyze your SparkPost data next to multiple sources. For additional details on how to get started, please see the SparkPost content pack for Power BI help page.

Power BI and SparkPost

After connecting with your SparkPost credentials, your data will begin loading into Power BI and you will be notified when the dashboard is ready. In addition to the dashboard, there are three reports that you can drill into by selecting one of the tiles on the dashboard. The reports provide additional insight into bounces and other key metrics.

To begin drilling into the reports, select one of the tiles on the dashboard. For example, if you select the Accepted Rate line chart it will drill into the Metrics report.

PowerBI and SparkPost analytics

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.

Power BI

You also have the ability to customize a report by selecting Edit Report in the top left corner of the page. The edit mode gives you access to the field list, allowing you access to any of the values included in the data set. It also gives you the ability you to edit or add visuals to reports. Any of the visualizations from the reports can be pinned to the dashboard by hovering over it and selecting the pin icon.

After the initial import, the dashboard and the reports will continue to update daily.

With the SparkPost content pack for Power BI, you’ll have a great initial set of metrics and insights, enabling you to explore your data even further! Product updates will roll out as new versions are released, and SparkPost will continue to support new data sets.

What you’ll need to get started:

Additional information:

 

 

Related Content

How to Generate Realistic Test Traffic Patterns in your SparkPost Account

Behold, a “bouncy sink” that behaves like real-world recipients and a “traffic generator” to easily test traffic patterns and complex sending environments.

read more

Target Engaged Users with New Smart Send Beta

Smart Send is an optional API feature that allows you to easily remove recipients who haven’t clicked on or opened your messages in the past six months.

read more

This is My Code

In This is My Code, our lead data scientist outlines code written in Javascript for a NodeJS process used to move data between AWS ElastiCache Redis and S3.

read more

Get started and start sending

Try SparkPost and see how easy it is to deliver your app’s email on time and to the inbox.

Try Free

Send this to a friend