Data Warehouse

What happens in the warehouse, stays in the warehouse. Or does it?

Data analysts are used to getting requests for data in Excel. It’s almost universally known – If you send someone a dashboard, they’ll ask for it in Excel.  But there’s a new request in town – “Can I get this data in Salesforce, and Hubspot, and Mailchimp, and Intercom, and….” Marketing, sales, and operations teams …

What happens in the warehouse, stays in the warehouse. Or does it? Read More »

Source control your SQL queries with Git. Use a SQL Runner + IDE hybrid!

Raise your hand 🙋‍♂️if you write SQL but are bad about saving your queries and wish they were source controlled in git. This was me for the last 10 years. I used a variety of tools to help but none got the job done. It’s actually amazing how many “rogue” SQL queries there are out …

Source control your SQL queries with Git. Use a SQL Runner + IDE hybrid! Read More »

Four Ways to Model Your Data in Chartio

Chartio is a cloud-based visualization tool for building charts and interactive dashboards. If you’ve used it before you know it’s a powerful tool with a drag-and-drop interactive mode as well as a SQL mode for making visualizations. If you’ve built dashboards in Chartio before you may have felt like you were repeating your SQL logic …

Four Ways to Model Your Data in Chartio Read More »

Do more with Hubspot data

We’re attending Inbound 2019 this week so Hubspot data has been top of mind.  We help clients work with Hubpost in a variety of ways. Here are a few ways you could be doing more with your Hubspot data. 1. The lowest hanging fruit:  Combine your Hubspot data with other sources and build a true …

Do more with Hubspot data Read More »

Before choosing the all-in-one analytics solution

Are you considering an all-in-one data analytics solution like Domo? A word of caution: you can move your data into these platforms but can you get it out? Data is the currency that powers your business and, in many cases, is the lifeblood for making money and selling products. Meanwhile, being able to visualize your …

Before choosing the all-in-one analytics solution Read More »