This blog topic was born out of a training course I delivered which always brings new questions and observations. No matter how often I do them, I'm always learning something myself. It concerns the ability to expose sets once they been created to allow end...
As data breaches and cyber threads continue to rise, securing your data has become a top priority for businesses and organisations across all industries. Whether you want to safeguard sensitive customer data, protect your intellectual property or need to adhere to regulatory requirements, protecting your...
ThoughtSpot is a next-generation BI tool that addresses a specific pain point that almost all data practitioners have encountered — by the time an analytics solution is ready for me and my team to use, the business needs have changed. Can't we just get direct...
Corporate AI Projects are High Risk, High Return McKinsey report that the adoption of AI within businesses has surged in the last year, with 72% of companies now using AI in at least one business function (ref). There's a problem though: Most internal AI initiatives fail to...
In the video below, I go over how to implement a dynamic date axis in Power BI, giving the user the ability to show daily, monthly and yearly views of their data. This is especially useful for trends and timelines for seeing how your data...
Great dashboards engage users and encourage exploration and discovery. A great way to do this is using interactivity. Let’s look into how to achieve this with different BI tools. Interactivity in Tableau In Tableau this can be achieved with dashboard actions. There are a number of actions...
In the realm of product management, two seminal works stand as contrasting pillars of wisdom: "Build" by Tony Fadell and "The Lean Startup" by Eric Ries. These books represent the balance of product management: the art of visionary design and long-term craftsmanship, and the science...
Now more than ever, businesses are focused on investing time and capital into their data platform. There is so much work that goes into processing data to generate insights, yet in my experience, there seems to be some confusion surrounding this core concept. When developing...
At InterWorks, we regularly build data pipelines for customers that include tools for migrating and transforming data such as Fivetran or Matillion. Tools such as these have connectors for many common sources of data to save us the hassle of building and maintaining our own...
Or, What Nintendo’s Game Boy has to do with Analytics Back before the success of the Nintendo Switch or the motion-controller craze of the Nintendo Wii, there was a device that encapsulated a central driving philosophy of Nintendo and was key to its long-term success in...
We All Suck at Something I want to let you in on a journey I’ve been on lately, just in case it can be as profound for you as it has been for me. Picture this: You’ve been in auto racing for decades. You were self-taught in...
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...
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