In my previous post, I wrote about one of the ways that SQL Workbench can be indirectly connected to Tableau Public. This method was to export the results of a query to a CSV file, which could then be opened through a text file connection in Tableau Public. The query…

In one of my previous posts about Tableau, I wrote about some of the differences between the full version of Tableau and Tableau Public. One of the major differences is the capability to connect to larger databases. The full version of Tableau can do this, however the Public version can…

In my previous post, I went into a quick example of creating a visualization using sample data regarding Volcanic Eruptions. However, normally there are multiple visualizations that can be created using one dataset that can give different insights for those viewing them. Many individuals will want all the information in…

What is Tableau? Tableau is an analytics platform, well known for it uses in data visualizations. It was founded in 2003, and since then has become one of the dominant tools used by Business Intelligence Analysts to create data visualizations and dashboards. It is a powerful tool that reduces the…

In this post, we will go over the uses of Subqueries.

What is a Subquery?

A subquery is a query made within another larger query. Subqueries can also be called an inner query or a nested query. Since subqueries are nested within a larger query, that larger query is considered an outer query. …

In previous posts, I have described where certain options could be taken to help increase the efficiency of making queries in SQL. In this post, I will go over one the most helpful tools to increase efficiency: Stored Routines.

What are Stored Routines?

Stored Routines are prepared pieces of SQL code that are saved…

Malcolm Katzenbach

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store