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…

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…

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

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

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…

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…