Business intelligence software which includes databases, data transformation tools and software for searching and presenting interactive reports, as dashboards have been around for 25 years. In the last ten years, these tools have become easier to use and more able to deal with very large...
Often, discussions about data governance begin and end with security. Preventing unauthorized access or the loss of proprietary data is crucial. Data governance also ensures that your data systems comply with regulatory requirements and protect privacy. You are undoubtedly aware of the horror stories regarding data...
This article intends to provide a brief overview of what all the talk about Snowflake Native Apps Marketplace is about, how organizations can utilize the space to monetize their offerings, and how consumers can benefit from these third-party off-the-shelf applications, ending with detailed instructions to...
Selecting business intelligence software and planning a rollout is a significant undertaking. The real work should begin well before you start selecting software. You must comprehensively assess your entire organization’s information needs, wants and data workflows. Building a Strategic Vision Roadmap We call these planning sessions Strategic...
Executives understand the value of high-quality, timely information. When asked why they invested in business intelligence software, they can cite examples that explain how their investments paid off. Most feel the paybacks achieved justify their investments, but they also believe that the adoption of the...
Tableau is a robust tool that allows you to build dashboards in a multitude of ways, which is part of what makes it great. The flip side is that it can be easy to let little inefficiencies pile up and affect the ultimate performance of...
This article reflects on my attempt at transforming a previously created Tableau dashboard. This transformation was greatly influenced by the insights gained from the excellent two-week Tableau data visualization training provided to me as a BI intern at InterWorks. Most humans are visual creatures. We consume...
DAX Iterator functions are a subset family of aggregator functions used to iterate over a table of rows. First, they evaluate an expression for each row in a table. Then they apply some form of aggregation to the row-level results of the first expression calculated...
Hey, there, party people! Hope you all had an amazing June. We're halfway through the year. Hope you all have been keeping up with your New Year's Resolutions. (Didn't think we'd remember that, did you?) We had some great blogs out in June, so we hope...
Getting started in the Power BI Desktop application is a fun and exciting time. There are so many components that make up this masterful business intelligence tool, that at first glance it can appear a bit overwhelming. Not to fret. The good news is if you are...
Matillion ETL is a GUI-based orchestration and transformation tool for data movement that has many functionalities, including querying external data via API. There are three primary ways to query this data from Matillion ETL: Create a custom Python script to send requests to the API...
Recently, Snowflake released external access integrations into general availability. This allows Snowflake admins to create secure tunnels for Snowflake to communicate with the outside world, and can therefore communicate with external APIs to complete all manner of tasks. For example, external access could be used...
In this episode, IT Sales Simplified host Genna Callahan sits down with InterWorks Client Manager Seth Maston to chat about transitioning from an IT intern to a fully fledged IT salesperson at a global tech company....
In Part 1, we looked at our Job to be Done and why it wasn’t building Dashboards. The key takeaway is to focus on user value and solve their pain points. Now, let’s turn to why what building dashboards doesn’t deliver the user value we...
The data and analytics industry is changing. Buried beneath the marketing hype and buzzwords, there’s something real happening, and the data industry is going through a giant shift. I’ve heard it described as both “overhyped and underestimated.” Overhyped in that a sprinkling of AI is...
Python is a first class language in the Snowflake eco system, and there are multiple ways to use Python with Snowflake: Snowflake Connector for Python: Listed in Snowflake drivers, this is a standard connector to Snowflake written using Python. It supports developing applications using the...
Speed is of the essence in lots of things, and Tableau dashboards are no different. Developers and end users alike want dashboards loaded in a blink of an eye. Luckily, there are many resources online that will help you optimise your dashboards, such as optimising...
In my last blog post, where I introduced the concept of a universal semantic layer, we outlined the benefits that organizations with multiple business domains can recognize. These organizations use data and data consumption tools, and can adopt a universal semantic layer to gain a...
I want you to know, my first draft of this blog post was almost entirely made up of me slipping "May" into casual sentences or trying to come up with puns surrounding the month's name. I've spared you from reading all that, don't worry. It...
As many are already aware, there has recently been a lot of noise about security on the Snowflake platform. On June 2nd, 2024, Snowflake issued this statement regarding a targeted threat campaign against some Snowflake customer accounts. This appeared to be a targeted campaign directed...
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