Jun 10, 2015
Visualizing Your MailChimp Data With Microsoft’s Power BI
Recently, Microsoft approached us about integrating with their Power BI analytics platform. We’re excited to announce our new partnership with them, especially because of what it means for our customers. Now, when MailChimp users connect their accounts with Power BI, they can visualize their email data in ways they haven’t before. And that means bringing it to life with interactive dashboards like this one:
But more than that, integrating Power BI and MailChimp gives small business owners the power to analyze their email marketing analytics in ways traditionally reserved for data scientists. Empowering those users to dig deeper into their data without any coding skills is a great opportunity for us to help them do more with the information that’s already available to them. And since this analysis can be done with very little extra effort on their parts, it democratizes the process for any skill level.
The Power BI platform allows MailChimp users to import their account data in a read-only format where they can start manipulating it to gain insight into any number of metrics. Dashboard analytics provide insight across campaigns and lists, allowing for tons of comparison options. Users can compare metrics across campaigns, see the total number of emails sent from their account, and view total open rates across all campaigns as well as their most active lists.
Want to visualize where your most engaged subscribers are across campaigns? There’s a map for that. Want to see how your campaigns have done historically based on sending day? There’s a graph for that. Thinking about deleting, cleaning up, or combining lists in your account, but you’re unsure which lists are historically more active? There’s a breakdown of campaigns by list for that.
Four unique dashboards come with Power BI: Campaign Overviews, Top Campaigns, Lists Overview, and List Members. And each dashboard becomes further customizable as users dive deeper into their data.

And if you’ve got a data scientist on your team, Power BI provides a raw Excel file of your data. Analyze it on your own terms without having to learn MailChimp’s API.
Check out Power BI in our integrations directory for more information. Oh, and be sure to let us know which metrics help you the most. Happy analyzing!
Brenda
Is there also a connection possible with Microsoft Access now?
06.10.2015
Tom MailChimp
Hi Brenda,
Currently, we don’t have a Microsoft Access integration, but l’ll pass along your feedback to the team. Thanks!
06.10.2015
Bjoern Sjut
Hi Brenda,
what would be the scope of an Access integration? To import data from MailChimp for analytical reasons into a database? Or to sync email addresses from and/or to Access?
06.10.2015
Bjoern Sjut
That’s really great. It’s also great for agencies, who have to monitor several accounts, because Power BI allows you to aggregate metrics from several data sets onto one dashboard. We just tested it with an account that has several thousand campaigns and more than 500k sends and the data loaded nice and reliably!
06.10.2015
Victoria
Does this mean an integration with Microsoft Dynamics may be forthcoming? It would make me extremely happy if so!
06.11.2015