Data

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 »

An analytics engineer is really just a pissed off data analyst

Sitting through dbt Coalesce conference this week, my biggest takeaway is that data is less trustworthy than ever and people are fired up about it. Often times, an analytics engineer is really just a pissed off analyst who has the tools and motivation to make things better for everyone else. The momentum around dbt is …

An analytics engineer is really just a pissed off data analyst Read More »

Focus Areas: Custom Apps with Looker and dbt Modeling

We thought it was a good time for a brief update on Hashpath.  In addition to focusing on traditional BI consulting, we are seeing strong growth in our other area of speciality, namely customer-facing analytics with our White Label Data product.  Our bets on Looker and dbt have been paying off, with strong enthusiasm for …

Focus Areas: Custom Apps with Looker and dbt Modeling 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 »

Why your organization may need a Data Product Manager

If your organization doesn’t have a “Data Product Manager”, it might be time to start thinking about hiring one full-time. If you’re not quite ready, hiring a “fractional” data product manager may make sense. McKinnsey states that organizations should “treat data as a product with real return on investment just like they would a consumer-facing …

Why your organization may need a Data Product Manager Read More »

Open Source Analytics: Meltano just released version 1.0. Here’s what it is and why you should care

There’s been a lot of action and consolidation in the data analytics space recently (Looker to Google and Tableau to Salesforce to name a couple major ones).  But there’s also been a ton of action in the open source space, and we think everyone should be taking notice and celebrating the progress. We certainly are. …

Open Source Analytics: Meltano just released version 1.0. Here’s what it is and why you should care 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 »

Why Salesforce’s Acquisition of Tableau is Confusing and Straightforward at the Same Time, Days After Looker Acquisition

I’ll see your $2.6 billion and raise you $15.7 billion.  Today, Salesforce.com (CRM) announced a major deal to acquire Tableau Software, a company so synonymous with data, their stock symbol is DATA.  This follows last week’s major reveal that Google Cloud is buying Looker, another top data analytics player.  It’s hard to know if these …

Why Salesforce’s Acquisition of Tableau is Confusing and Straightforward at the Same Time, Days After Looker Acquisition Read More »