An important step towards ensuring the security of your Snowflake account(s) is the appropriate use of network rules and policies to prevent unauthorised access. These policies are leveraged to ensure that access is only allowed through restricted methods and to/from exclusive sources. Without this protection, you...
Oftentimes, I find myself in training or enablement sessions, showing the full list of possible functions available to use in Tableau. It’s quite a list of possibilities that starts with ABS (for the absolute value of an integer) and runs through the ZN (zero null...
Welcome, dear readers, to the August 2024 Blog Roundup. Up here in the Northern Hemisphere, kids are back and school and the heat of the summer has finally broken. Fall's on the horizon (until Indian Summer shows up in a week or two and we're...
If you are familiar with SQL, you would be familiar with the concept of aggregate functions. For those who are still a bit fuzzy on what these aggregate functions intend to do, here’s a quick couple of quick examples: When you want to find the...
Ever found yourself stuck in development limbo, waiting for a job to finish, only to realize you might need to tweak it again? It's one of the less enjoyable parts of being a data engineer. But what if I told you there's a way to...
“If you want an exceptional outcome, you must be willing to be the exception.” wrote Sam Presti, the General Manager of the Oklahoma City Thunder. It was the summer of 2019 in an article penned to fans after trading away franchise cornerstones Russell Westbrook and...
Variables are a fundamental part of all programming languages, giving developers a flexible object in which they can store, update and retrieve data. What makes them extra useful in DPC is that the value of a variable can be set and updated using Python, the...
Welcome back to our journey in maturing analytics. We’ve gone from identifying the actual job to be done to many of the methods and tools you’ll use to deliver on it. In this final installment, we’re going to tackle the elephant in the room: artificial...
The Quick Version The Data Mesh architecture provides a credible blueprint for managing data at scale. It offers a solution for organisations that are simply too large or complex to be able to centralise all of their data within a single enterprise data warehouse. It enables...
If you attended the latest Tableau Conference earlier this spring, or if you’ve spent any time considering the feasibility of a migration to Tableau Cloud, you may be familiar with Tableau Pulse. Tableau Pulse leverages the capabilities of Tableau AI to deliver key insights on-the-go...
In the realm of analytics, measuring success can be a complex endeavor. It's crucial to differentiate between evaluating the success of your entire analytics platform or practice and measuring the success of individual dashboards, initiatives or products. Each requires a unique approach and set of...
In the video below, I go over Conditional Calculations using two of the most widely-used data visualisation tools on the market: Tableau by Salesforce and Power BI by Microsoft. Tune in here: ...
As Snowflake becomes more and more feature rich, we’ve become surrounded by all manner of suffixes to the word “Snow.” In this post, I’ll summarise the tools available and what their intended use is. This is only meant to be a brief overview, so I’ve...
The decline of a large enterprise is often the result of numerous small issues compounding over time. However, there is a tendency to focus on less relevant aspects and overlook the single most crucial element: the customers. This case study, presented in the form of a...
Welcome back to our journey in maturing analytics. In Part 3, we discussed why user adoption stumbles and explored different delivery paths for analytics. Now, in Part 4, we will talk about product management. I know — you’re in analytics and data. What does that have...
Being an avid music lover, I always wondered about various factors that make up an entire song. This project provided me an opportunity to do so. I stumbled upon an amazing data source in Kaggle that had authentic Spotify data with a lot of key...
Over the last couple of years, there has been a lot of interest in the data mesh architecture first proposed back in 2018 by Zhamak Dehghani. It offers a practical alternative to the previously dominant notion of a single centralised data warehouse. Trying to gather...
It can be a very confusing or frustrating experience whenever a technical tool doesn’t do what you want it to do, or even what it should be doing using common sense! I recently had some issues with the mapping visualization feature in Power BI and...
Welcome back to our journey in maturing analytics. In Part 1, we looked at our job to be done and why it wasn’t building dashboards. In Part 2, we dove into the details of how dashboards can be a mismatch to users’ needs. Now, we’ll...
File formats are database objects used by snowflake to ingest flat files. Consider file formats as your way of giving snowflake information about the file so it knows how to ingest those flat files in an optimal fashion. You specify the type of file along...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072