Open in app

Sign In

Write

Sign In

Malcolm Katzenbach
Malcolm Katzenbach

64 Followers

Home

About

Nov 16, 2021

Tableau: Using Filters

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…

Data Science

5 min read

Tableau: Using Filters
Tableau: Using Filters
Data Science

5 min read


Nov 9, 2021

Connecting SQL to Tableau Public

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…

Data Science

5 min read

Connecting SQL to Tableau Public
Connecting SQL to Tableau Public
Data Science

5 min read


Nov 3, 2021

Tableau: From Visualizations to a Dashboard

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…

Tableau

8 min read

Tableau: From Visualizations to a Dashboard
Tableau: From Visualizations to a Dashboard
Tableau

8 min read


Oct 25, 2021

Tableau: A Basic Example with Volcanic Eruptions

In the previous post, I gave an introduction to Tableau, which is a powerful platform to create data visualizations and dashboards. I also mentioned that we would later take a look at some of the basics of Tableau. Well, here we are! One of the best ways to get an…

Data Science

6 min read

Tableau: A Basic Example with Volcanic Eruptions
Tableau: A Basic Example with Volcanic Eruptions
Data Science

6 min read


Oct 18, 2021

An Introduction to Tableau

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…

Data Visualization

4 min read

An Introduction to Tableau
An Introduction to Tableau
Data Visualization

4 min read


Oct 11, 2021

SQL: An Introduction to MySQL Workbench

In my previous post, I wrote on how to install MySQL Server and Workbench. In this post, we will take a closer look at MySQL Workbench. It is a great tool for working with databases and tables, as well as making queries. As one might expect, the first thing to…

Data Science

6 min read

SQL: An Introduction to MySQL Workbench
SQL: An Introduction to MySQL Workbench
Data Science

6 min read


Oct 3, 2021

SQL: Installing MySQL Server and Workbench

Over the past few posts, I have written about the different ways queries can be formed and how SQL can be used to analyze large amounts of data. …

Data Science

5 min read

SQL: Installing MySQL Server and Workbench
SQL: Installing MySQL Server and Workbench
Data Science

5 min read


Sep 27, 2021

SQL: Introduction to Subqueries

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. …

Data Science

3 min read

Data Science

3 min read


Sep 20, 2021

SQL: Stored Routines

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…

Data Science

5 min read

Data Science

5 min read


Sep 12, 2021

SQL: Introduction to Full Text Search Functions

In a previous post, I wrote about different ways to filter data in SQL. One of those was using the LIKE operator, which is useful when trying to find patterns within data tables. This method will simply look for the pattern within the specified columns. However, there is another function…

Data Science

3 min read

Data Science

3 min read

Malcolm Katzenbach

Malcolm Katzenbach

64 Followers

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech