Customer 360 Data Warehousing and Sync to Hubspot using BigQuery, dbt, Looker and Hightouch
In this blog I’ll show how we’ve used Google BigQuery together with Looker, Segment and our RA Warehouse for dbt to do just this, connecting offline and online data together for both clients and contacts and syncing that data to our Hubspot CRM system using a new “reverse ETL” service, Hightouch.
Deduplicating Company Records in a Multi-Source Data Centralization Project using dbt, Google BigQuery or Snowflake
One of the most common tasks in a data centralization project is to create single, deduplicated records for each of the companies, contacts, products and other entities the business interacts with. Doing this allows you to connect sales activity from Salesforce and Hubspot to project delivery and invoicing data from Jira and Xero, for example, and this article shows you how.
A New Look for Looker : Cross-Filtering, Interactive Dashboards, Aggregate Persistence and a New Data Visualization Marketplace
Looker’s front-end features have had a serious overhaul over the past year, adding a whole new dashboard user experience along with a range of new data visualization types available through a marketplace.
Ad Spend and Campaign RoI Analytics using Segment, Looker, dbt and Google BigQuery
You’ve probably heard of the saying “Half the money I spend on advertising is wasted; the trouble is, I don’t know which half.”, and digital marketing was supposed to fix this problem. If only it were that easy.
COVID-19 Update, Supporting the National Care Force and Analytics Consulting-as-a-Service
In this blog post I’ll talk about how we’re trying to solve the business problems we’re all facing during the coronavirus lockdown using data, analytics and the insights it can provide, and we highlight a volunteer initiative we and our partners at Looker and Segment have been helping get started in the UK, The National Care Force.