Custom Join in ThoughtSpot’s SQL Editor
To best use ThoughtSpot, we need to have a good understanding of the data structure being used. The best way to work with that data is in ThoughtSpot’s data pane. In the data pane, we need to connect to a data source (in our case Snowflake server), then we need to create some data relationships […]
Snowflake Row Access Policies Demystified
Row Access Policies are a convenient way to apply row-level security to multiple tables or views in one go. You simply create one policy and can apply that to as many objects as you like. Best of all, if you need to make adjustments, you only need to make them in one place. Row-Level Security […]
Making a Lot Out of a Little: A Data Visualization Story
Have you ever been asked to create a dashboard with some sub-standard data? Maybe you don’t have the amount of data columns you would want, or maybe you are trying to perform some data analysis to support a data-driven decision. You might even be trying to find a publicly available data source to train and […]
Using AWS Secrets Manager in Matillion Data Productivity Cloud
Last month, Matillion launched the Data Productivity Cloud (DPC). In our introductory blog post, we highlighted how this new SaaS product simplifies managing multiple data sources and performing transformations — all from a single pipeline and right within your web browser. This was made possible using Matillion-hosted containers and password manager. But what if you […]
Optimizing Tableau Relational Models With Row-Level Security: Filters
In Part two of this series, we covered a method of distillation to reduce data volume and size. However, we need to translate our distilled records into their non-distilled forms. In addition, we’ll cover the concept of global and local filters and how to effectively use each to optimize background queries for Tableau Dashboards. […]
Matillion DPC Agents on AWS: Turbocharge Your Data Productivity
Following on from the wonderful blog by Fadi Al Rayes, Getting SaaSy with Matillion’s Data Productivity Cloud, we’re going to look at the Matillion Agent deployment and why you may want to opt for this solution vs. the automatically deployed agent provided by Matillion. Let’s first cover what is the Matillion Agent and why do […]
Solution Stories: Deep Dive To Uncover Hidden Data Issues
Welcome to our latest Solution Stories blog series, where we delve into real-world client stories that offer valuable insights into navigating and solving everyday business challenges. These stories are often amalgamations of several real clients, merging real-life scenarios with standard, practical solutions. Our next story revolves around Jennifer, a senior data analyst at a global […]
How To Avoid the Dystopian and Dope Extremes of Dashboard Development
One of my favorite colleagues here at InterWorks is Sean Spencer. I’m pretty sure he’s my spirit animal and could be a distant cousin too. He loves Red Pepper Vodka Spaghetti sauce and IPAs. And he oftentimes uses the kind of lingo that could either leave you laughing for hours or second-guessing all of your […]
Solution Stories: Complicated Data Input and Getting to the Root of the Problem
Welcome to our latest Solution Stories blog series, where we delve into real-world client stories that offer valuable insights into navigating and solving everyday business challenges. These stories are often amalgamations of several real clients, merging real-life scenarios with standard, practical solutions. Ashley is a department leader at a prominent non-profit organization dedicated to uplifting […]
Solution Stories: From Manual to Automatic PowerPoint Reports
Welcome to our latest Solution Stories blog series, where we delve into real-world client stories that offer valuable insights into navigating and solving everyday business challenges. These stories are often amalgamations of several real clients, merging real-life scenarios with standard, practical solutions. Meet “Grant,” a diligent data analyst at a prominent organization tasked with delivering […]
