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

A FreeMarker Converter in C#

One of our engineers walks through step by step how he created a FreeMarker conversion tool in C# to support SparkPost templates.

read more

Why We Hack

A look inside the internal hackathon trend, the cross-functional relationships that hackathons encourage and more reasons why we hack at SparkPost.

read more

High Touch Client Onboarding Using Process Street and Zapier

How to build a zap connecting SparkPost with Process Street to produce a high touch client onboarding experience for your sales outreach teams.

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