Connecting SQL to Tableau Public

USE employees;

SQL Code Example

The first step in creating our SQL code is understanding what facts we want to know from our query. There are three major points we need to gather if we are to answer our business question: the year, the department name, and the number of employees.

SELECT
YEAR(hire_date) AS calendar_year
FROM
employees
GROUP BY calendar_year

Connecting SQL to Tableau Public

Even though we cannot connect our SQL database to Tableau Public, we are able to create a file that CAN be used in Tableau Public. When we run a query in SQL Workbench, there is an option to export the results of the query as a file.

--

--

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