Dashboarding is Like Music: Communication
Welcome to our new series, Dashboarding is Like, where we will explore connections between data visualization and other creative pursuits! For our first set of posts, Dashboarding is Like Music, we will delve into the sometimes surprisingly rich relationship between, as the title suggests, dashboarding and music. Though we joined InterWorks about two years apart […]
Automated Ingestion from Azure Storage into Snowflake via Snowpipe
If you wish to automatically stream/ingest data from an Azure Storage container into Snowflake, using native functionality, you will most likely be considering what is commonly referred to as a Snowpipe. In real terms, a Snowpipe for Azure is actually a combination of multiple components: Azure Storage Container – stores files to be ingested into […]
Configuring Storage Integrations Between Snowflake and Azure Storage
If you have data stored in an Azure Storage container and wish to ingest it into Snowflake using native functionality, you will most likely be considering either direct COPY INTO statements or an automated Snowpipe to ingest the data. Both of these options would expect to use a Snowflake object called an external stage, which […]
Scripting Made Easy with ThoughtSpot Modeling Language
If you’ve heard about ThoughtSpot, you are probably as excited as we are here at Interworks about its potential. If you are not too familiar with this tool I’d strongly suggest this article series. Several of our clients in Sydney and Melbourne all agree on one aspect of the delivery of BI solutions: the development […]
Setting Up Tableau Dashboard Data Alerts
Data Driven Alerts in Tableau Server and Tableau Cloud is a built-in feature that allows you to tell Tableau Server you want to be notified if your data reaches a set threshold for your business. When they’re set up, data driven alerts can automatically notify people who are subscribed to the alert notification. They can […]
Getting to Know dbt
On a recent project, I heard a colleague recommend dbt and it sounded amazing. Every feature of this product seemed to address challenges I run into on almost every data project. I decided it was time to take a look. Unravelling the Spaghetti As a consultant, I often get introduced to new data sets. If […]
Intro to Azure Functions and Snowpark: Populating Snowflake Control Tables
Snowflake is a powerful software that can store data points that are important for auditing the ETL process. This is done by creating a control table, which tracks ETL jobs that have been run and their statuses. There are a variety of methods for populating a control table and in this post, I will review […]
InterWorks Blog Roundup — December 2022
Happy New Year, everyone! We hope you all had a fantastic holiday season and are coming into the new year refreshed and ready for a fantastic 12 months. To cap off 2022, we opted for quality over quantity on the blog front. (It also helps that most of us spent the latter half of December […]
Webinar-Wiederholung – Tableau Formatierungen
In diesem Webinar tauchen wir tiefer in die Formatierung in Tableau Desktop ein und lernen die unterschiedlichen Formatierungsebenen kennen: – Was kann alles formatiert werden, was nicht? – Formatierungshierarchien – warum ändert sich mein Text nicht immer, wenn ich ihn formatiere? – Globale Formatierungen (Worksheets, Dashboards) und Tipps und Tricks für Zahlen, Symbole, Tooltips und […]
Quick Start Guide: Snowflake Direct Shares
Snowflake Secure Data Sharing enables users to provide specific data points to consumers using the same cloud provider within the same region. Providers can share tables, external tables, secure views, secure materialized views or secure user defined functions with consumers. Data sharing is customizable, and in this post I will do my best to cover […]