A Day At Races With TeamSQL 🏎
A DAY AT THE RACES WITH TEAMSQL
In this article, we took a public database with real and historical data about formula one races located at http://ergast.com/mrd/db/, we imported into a PostgreSQL database engine, and then we start querying using TeamSQL trying to cover and use a broad spectrum type of business queries and at the same time using different SQL clauses. We expect you can find some of the exciting queries presented here usable and applicable perhaps to your business data.
Getting Started with Charts in TeamSQL
Before you begin, please be sure to:
Download and install TeamSQL
Sign up for a TeamSQL account and use your credentials to log into your local instance of TeamSQL
Connect to a database that contains the data you want to chart.
Creating a Chart
The first thing you’ll need to do is open up a new query window.
Write your query and execute it so that you return the data you want to chart.
Notice that ...
TeamSQL Charts: Scatter Plots
Today, we’ll finish up our blog series on the types of charts you can create using TeamSQL’s new charting feature by covering the final chart type available: scatter plots.
Let’s say that we need to look at the correlation between height (in centimeters) and weight (in kilograms). Our returned data looks like this:
As always, once we return data, we can launch the TeamSQL charts wizard by clicking on Charts. Select the Scatter option, set your dimen...
TeamSQL Charts: Pie Charts
We’ve been covering some of the new charting features in TeamSQL, and today, we’ll take a look at the pie chart. If you’re already familiar with how the basic charting functionality works in TeamSQL, read on, but if you aren’t, please take a look at our overview post.
In today’s example, we’ll be looking at the market share each of the major browsers held in the period from January to May of 2015. Here’s what our data looks like returned from the database.
We click ...
TeamSQL Charts: Using the Bar Chart Feature to Create Funnel Charts
In today’s post, we’ll revisit bar charts, which we covered a couple of days ago. However, we will modify our use of bar charts a bit so that we can create a funnel-like chart.
If you haven’t already, please read our Charts 101 blog post before beginning this post.
Let’s say that you have a sales progression, and you want a funnel chart that shows the change in engagement as you proceed along the sales pathway. Here’s what our data looks like:
When we ...
Working with Area Charts in TeamSQL
In this article, we’ll take a look at creating area charts in TeamSQL. If you haven’t already, please review our summary of working with the charts functionality.
For our chart today, we’ll be looking at the number of weapons contained in the stockpiles of the USA and the USSR for the period beginning in 1950 and ending in 1960. Here’s what our data looks like in TeamSQL.
As always, once we have actionable data returned from our query, we can choose to graph our data ...
Creating Bar Charts in TeamSQL
We’ve already covered the basics on how to work with charts in TeamSQL, so today, we’ll go over how to create a specific type of charts in TeamSQL: bar charts. In today’s examples, we’ll be working with historical population data, but you can use whatever data you’d like.
Here’s what our data looks like:
Let’s say that I want to compare the population level of each continent for the year 2012. I can launch the charts wizard by clicking on Charts, which is located ...
Creating Line Charts in TeamSQL
Today, we continue our series on creating charts in TeamSQL. If you haven’t already, please see the summary of the charts features before reading this article.
The chart we’ll be looking at today is a line chart. Let’s say that we want to track employee growth over the past couple of years and that our data looks like this:
Once I have actionable data, I can click Charts to launch the chart creation wizard. I select the Line chart option and indicate that I want year on the ...