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 »
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 »
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 »
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 »
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 …
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 »
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. …
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 …
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 …