As we end the year by wrapping up projects, getting ready for the holidays and looking toward the future, we here at InterWorks wanted to take a quick step back and review some of the projects that stuck out to us over 2024. Be they...
Typically, the customization of Top N filters in Tableau involves allowing the user to pick the number of records, or N, that shows in a visualization. What if we could add even more customization by allowing the user to pick the field that the Top...
This blog could well begin with a familiar dilemma for any data analyst, with two split messages: a) a Superman-like figure armed with what I've learned and thought I'll need in my daily work b) a somewhat disappointed knowledge worker finding out what I'll be...
In the newsletter I usually send out at the end of the month for the blog (which you can subscribe to via the banner at the bottom of the page), I filled the intro with Halloween-themed puns that, quite frankly, were frighteningly spooktacular. I will...
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...
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