Seth Rosen

Seth Rosen

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 »

Build a modern data analytics stack from scratch in under an hour

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 the very beginning. We signup …

Build a modern data analytics stack from scratch in under an hour Read More »

A COVID-19 Dashboard for Massachusetts using Looker and BigQuery

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 »

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 »

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 »

Build beautiful customer-facing applications powered by Looker (and do it super fast and without an engineer)

We all know how powerful Looker can be for modeling your data.  Its “explore” capability is an absolute killer feature and why so many companies choose it for their data platform. Looker is also a platform for companies who want to build customer-facing applications with Looker under the hood. There are lots of reasons why …

Build beautiful customer-facing applications powered by Looker (and do it super fast and without an engineer) 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 »