Many of our users request that DataHero connect directly with their individual databases, so they can run custom SQL queries and analyze internal data in DataHero. In this post, we’ll outline a solution where you can continually replace the entire file from your database using OneDrive so that the file and charts stay current with your own database statistics.
In many situations, our customers receive an entirely new data file. Once you import this data file into DataHero, you can easily keep the charts you created up to date with the latest data. Sometimes you don’t want to append data to an existing sheet. Perhaps you receive a new file every day or week, and you’d like to overwrite the previous file. OneDrive is ideal for this type of data overwriting. Create a SQL query (or have someone from your team create one) and have the file be output into OneDrive. Then connect your OneDrive account to DataHero and each time the file is overwritten with new data in OneDrive, DataHero will automatically update your charts.
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 OneDrive. This will automatically overwrite the existing file in OneDrive with the newest data.
Once you have your file in OneDrive, it is straightforward to turn your data into compelling visualizations. To start, import your data warehouse file 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.
Once you have created the charts you need, make sure they’re automatically updated as the file is overwritten in OneDrive. 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.
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.
We also recently published a blog post on running queries that append data to an existing dataset in a Google Spreadsheet. Check that out if you’d like to be able to add data to a current file instead of replacing it.
Create your SQL queries, overwrite the file continually in OneDrive, 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 to give it a try.
Jeff Zabel is a CoFounder at DataHero and strives to make usability matter in everyday experiences. He loves unearthing customer needs and innovating intelligent solutions. Say hey to him on Twitter.
Get the fastest, easiest way to understand your data today.Sign up for free