An issue and an opportunity for nearly every existing business intelligence system is keeping it running well and minimizing costs. Cloud-based software makes it easy to spin up a data warehouse or a data lake, use data transformation tools, create data science studies and publish dashboard...
What technologies can you pair to enhance the data experience? How can the right blend of tech help you do your job faster and more easily? In this webinar, we hear from Global Database Administrator & BI Analyst at TenCate, Scott Perry, alongside InterWorks’ Dan Murray as...
Too often, conversations about financial data turn traditional tools against visual analytics platforms like Tableau. Which is truly better? Excel is ubiquitous, but Tableau brings spreadsheets to life. In this webinar, Jimmy Steinmetz explains how the two cannot only coexist but greatly enhance each other....
Another great Denver Startup Week has come to a close with over 16,000 registrants engaging in all aspects of the weeklong event. The event brings together people from all realms into one energized and inspired week—small businesses and major corporations, job seekers and hiring managers,...
I'm a chartered accountant, and my background is in building finance functions and creating financial performance analysis reporting functions. I trained in a public practice, and after around six years, moved into industry. I've been working in industry for the last seven years, and analysing...
If you are an InterWorks client, then you hopefully already know about InterWorks Assist. If you’re not familiar with Assist, allow me to show you how much this ad hoc service has grown during its first year. Who Should Use InterWorks Assist? Initially launched at the end...
In 1519, Ferdinand Magellan attempted to be the first person to circumnavigate the world. I say attempted because…he didn’t make it. Good old Magellan died in the Philippines before completing his quest, meaning the first person to circumnavigate the world was most likely the surviving...
EXASOL offers the world’s fastest in-memory analytic database. It is built from scratch to offer the highest performance and scalability for in-memory analytics. You can now build in-memory data analytics in less than 15 minutes. Forget about maintaining and investing on expensive analytical tools used for...
Is there a better way to share your passion for Tableau, learn new things by the hour and touch base with the community than visiting a Tableau Conference? I will let you be the judge of that, but after an amazing conference in London we...
Tableau in the Cloud Tableau and Google already form a potent mix, as Tableau supports a number of Google's data sources with native connectors, such as Google BigQuery, Google Analytics and Google Cloud SQL. But as of last month, Tableau Server is certified for use on...
Who doesn’t love efficiency? We are finishing up with the rendering category today by returning to custom shapes. Let’s get started: "If using custom shapes, use transparent background PNGs instead of JPGs. Views will render cleaner, and shape files will take up less space." Didn’t know we’d get...
Let’s take a look at our next guideline from the Rendering category: "Minimize the file size of any images or custom shapes where possible. As a general rule of thumb, keep images under 50kb." Let’s get started, shall we? Images & Custom Shapes In regards to rendering, images and...
Let’s take a look at the next item on our rending category. "Limit the use of detailed text tables with lots of marks." Ah yes, the fabled Text Table. Mark Counts Let’s start this discussion by reviewing mark counts. We covered this in the previous Rendering article in the...
The first item in the Rendering category is: "Avoid high mark counts. More marks = longer rendering time." Let’s jump right in on this one. Mark Counts Marks are the points, plots or symbols on your visualization. They can be the bars in your horizontal bar graph or the...
Here’s the next item on the Performance Checklist: "Avoid row-level calculations involving parameters." Let's first take a look at what row-level calculations are. Row-Level Calculations Row-level calculations, also known as record-level calculations, operate on every record in the underlying data. An example of a row-level calculation is an IF...
Next up on the list of ways to make your dashboards be the best they can be, we take a closer look at blended calculations: "Limit blended calculations. They require sequentially querying multiple data sources and can be time-consuming. Where possible, create a view on the...
Let’s examine the following item on the checklist: "Use calculated fields carefully. Think about the data type as you code the calculation. Number and Boolean > date > string calculations when it comes to performance." This is another item that can quickly get you into performance trouble...
Today we’re examining the following guideline: "Watch for useless clauses, e.g. ORDER BY. Tableau is going to re-sort the data once loaded anyway." Let’s get started! SQL Overview SQL, or Structured Query Language, is designed for managing data within a relational database. It is essentially composed of two parts: Data...
Currently, we’re going through the best ways to employ custom SQL and what to avoid. Here’s what we’ll cover today: "Avoid parameters in custom SQL in Tableau. Tableau wraps the custom SQL in a subquery that many databases don’t handle well. Consider building a view in the...
The rule that we’ll cover today is: "Limit custom SQL in live connections as they can be inefficient. Where possible, create a view on the database server to implement your custom SQL and connect Tableau to your view." In other environments and in other tools, using your...
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