Using Looker to Analyze and Visualise your Customer Concentration
As a consultancy we monitor and visualize our customer concentration in the form of two data visualisations; one that shows our customer concentration curve and another that shows the trend of customer concentration for our business over time. In this blog I’ll explain how we do this using Looker, Google BigQuery and the modern data stack.
Adding Forecasting to your Looker Reports and Dashboards
A new feature introduced in Looker recently is Forecasting, giving you the ability to forecast forward one or more measures in your look or dashboard based on historical data in your application or data warehouse.
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.