Skip to content 
Tableau in the Modern Data Stack
Tableau has been a leader in the business intelligence space in the last decade. It entered Gartner’s leaders quadrant in 2013 and remains one of the platforms with the greatest ability to execute and completeness of vision today. The simplicity of the drag and drop functionality, combined with the lightning speed of the extracts (at […]
Leveraging Snowflake Data Shares: an E-commerce Case Study
A primer on data sharing Data shares are a cutting-edge new tool developed by Snowflake, allowing any organisation with a Snowflake account to seamlessly and instantly provide data access to other organisations anywhere in the world. Snowflake themselves are leveraging this technology to provide a data marketplace, most recently being deployed by Starschema to provide […]
Our Looker Power Tools: Automatic Content Validation and Dashboard Recovery
If your organisation is using Looker, great – you’re probably on your way to higher data literacy across teams and a more data-driven culture. But as uptake increases and more users start producing their own content, modifying dashboards, and adding or deleting views and models, you may also have run into two common issues: a […]
Looker Activities Dashboards
Looker has developed a couple of handy models to track instance activities, which are available for users with the necessary admin permissions. Below we follow the evolution of activity tracking provided by Looker, starting with the i_looker model and then moving onto the newer iteration available with Looker 7.0. We'll close with a few ideas […]
Looker Visualisations
Looker offers a wide range of visualisation options such as pie charts, funnels, and single-value metrics. However, as you are working with stakeholders in different business contexts, you occasionally need to showcase data in a way that is not readily available. For example, let’s say you want to represent customer journeys on a website using […]
dbt Testing Tools Gap
As explained in a previous post, we had a unique request from our client to physically (i.e. not logically) delete records from a data warehouse. dbt as our tool of choice for advanced data transformation was used to incrementally load the data. Due to the unusual request and implementation, we wanted to ensure that the […]
Deleting Records with dbt
dbt is a great tool for managing data transformations. It is built from the ground up to support version control and peer review, it enables and encourages best practices such as automated testing, environment separation and modularity. One of the most powerful features of dbt is the ability to only transform and load new and […]