The DataHero Blog

How To Connect Your Database to DataHero With Office 365

April 14th, 2014


One of the most common questions we hear at DataHero is “Can I connect my organization’s database to DataHero?”  After all, we know some of the most important data in your organization usually lies in your own internal databases and is most likely the cornerstone of your business.  Using Office 365 as an intermediary between your database and DataHero is a perfect way to analyze your internal data, keep it updated, and simply append new data with each SQL query.  In this post, I’ll show you step by step how to directly analyze the data in your database using DataHero.

DataHero’s Metrics

At DataHero, we track metrics like weekly user registrations, activations, service connections etc. all via this system. We created a scheduled cron job to run a SQL query and post the results directly to Zapier via webhook.  The Zapier service automatically appends the new data to our existing Google spreadsheet which is available for anyone in our company to view through our Office 365 account.

Importing Your Data

Once you have your data in Office 365, it is straightforward to turn your data into compelling visualizations.  To start, import your data warehouse spreadsheet and create the charts you need.  DataHero makes creating visualizations and dashboards painless by allowing you easily to do pivots, time groupings, filter out data, etc.

Keeping Your Data Up To Date

Once you have created the charts you need, make sure they’re automatically updated as the information in your Google Spreadsheet changes.  To do so, enable Live Charts from your charts homepage and DataHero will automatically update your charts with the most recent data from your cloud storage service while keeping a snapshot of your previous revisions.

Creating Your Dashboard

Finally, add the internal metric visualizations you created to a dashboard and combine it with your other key metrics from services like Stripe, Github or Salesforce.  You now have an up-to-date view of your latest internal data and all your business data in a single location.

Create your SQL queries, add them to your Google Spreadsheet, import it into DataHero and you’ll be able to visualize your database analytics quickly. Organize key charts into a dashboard and keep it all up to date within DataHero. Sign up for a free DataHero account today.

Start tracking your metrics today with DataHero

By Jeff Zabel

Create my Free DataHero Account

Get the fastest, easiest way to understand your data today.