Snowflake Dynamic Tables: Automatic Declarative Data Transformation Pipelines
Imperative vs. Declarative Programming There are essentially two primary approaches to coding: imperative and declarative. To put it simply, these approaches determine whether you instruct the compute engine on how to perform the program’s tasks (imperative) or what outcome you want to achieve (declarative). My colleague, Mike Oldroyd, recently shared the article A Better Alternative […]
Optimizing Tableau Relational Models With Row-Level Security: Performance
In a previous installment, we kicked off this blog series by materializing our policy and entitlement table and removing all physical joins in our data source. We are now left with a large volume of records due to combining users with what they’re entitled to. To address this growth, we need to profile our materialized […]
Tableau Hacks: The “Cloth Hanger” Method
Sometimes, we want to calculate summaries of our data that cannot be calculated at row level, but need to be calculated at the level of aggregation in our view. We can use Level of Detail calculations for some of these calculations. For example, if we want to calculate Averages of Sums. Other times, we need […]
Learn ThoughtSpot With Me: The Basics
This post is going to be my first of a 3-part series called “Learn ThoughtSpot With Me.” As an Enablement Consultant, I teach technical things. What I’m most passionate about are data analysis, trends, and visual analytics. I hope you enjoy the series and look forward to hearing your comments. Let’s get started. Sharpen Your […]
Snowflake External Tables: Connect Efficiently to Your Data Lake
In this blog post, we will dive into the realm of Snowflake External Tables, a feature redefining data management and analysis. If you find yourself grappling with massive datasets, complex data structures or ever-increasing data volumes, you’re not alone. In this age of information abundance, businesses face unprecedented challenges in efficiently storing, processing and accessing […]
Navigating the Data Analytics Landscape: Choosing Between Tableau Server and Tableau Cloud
In the dynamic realm of data analytics, making the right platform choice can significantly impact your business outcomes. With two powerful options on the table, namely Tableau Server and Tableau Cloud (formerly Tableau Online), the decision might seem daunting. Fear not, as we’re here to guide you through this critical decision-making process. In this article, […]
Optimizing Tableau Relational Models With Row-Level Security
Since Tableau’s release of relational data sources (AKA, “Noodle”) and the introduction of a logical layer, conventional wisdom has carried over into leveraging both physical and logical layers when modeling Tableau data sources. Typically, we see physical joins to enforce row-level security. We also know that creating Tableau Hyper extracts to package data increases dashboard […]
Why InterWorks?
My name is Sebastian, I am an Analytics Lead in Germany and I just celebrated my three year anniversary at InterWorks. My job today is to explain a few things for you about who we are. Why InterWorks? There are three groups of people who ask that question: Those who want to join us and […]
The Quest Game: Exploring My Favorite Typeform Capabilities
As a Marketing Research and Analytics student at Oklahoma State University, I find exploring a new survey platform very exciting. When I was given my first Typeform project, I knew I needed to start getting familiar with the Typeform interface. Exploring Typeform’s Capabilities To begin to understand Typeforms uses and capabilities, I first visited the […]
What Does an IT Director Do?
The modern workplace is constantly evolving, and the need for experienced IT directors has never been greater. In this article, we’ll explore what an IT director does, and the skills and qualifications needed to be an IT director. Then, we’ll dive into how smaller businesses can benefit from having an IT director while also outlining […]
