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 »| Hashpath
The infrastructure of a modern analytics stack is now the easiest part. 5, 10, or 15 years ago deploying an analytics stack was a huge investment of time and resources. Not anymore. In this video, we set up a modern analytics from scratch in under an hour. We start from…| Hashpath
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 »| Hashpath
We often recommend ELT solutions like Matillion and FiveTran to our customers as powerful tools for moving data into their warehouse from lots of sources and being able to transform that data to find useful insights. These tools have worked well with BI use cases for customers that are willing to invest in data engineering …ETL vs. ELT: Why Choose If You Can Use Keboola Read More »| Hashpath
The world probably does not need another COVID-19 dashboard. But, we couldn’t help building one using BigQuery and Looker since it was so easy and these are tools we use everyday. We’re focusing on Massachusetts and hoping that all our graphs turn green. You can view the site here: https://www.masscovidtracker.com/ The BigQuery dataset here (auto …A COVID-19 Dashboard for Massachusetts using Looker and BigQuery Read More »| Hashpath
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 »| Hashpath
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 »| Hashpath
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…| Hashpath
Meltano is attempting to be a single tool for the entire data ops workflow. From Extract to Load to Transform to Model to Visualization/Dashboarding. Doing all these steps well, often requires expensive proprietary technology or a highly technical internal team. If Meltano is able to truly deliver, it will be a game changer.| Hashpath
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.…| Hashpath
