diff options
author | Christian Cleberg <hello@cleberg.net> | 2024-09-01 22:03:26 -0500 |
---|---|---|
committer | Christian Cleberg <hello@cleberg.net> | 2024-09-01 22:03:26 -0500 |
commit | a0578880ef14f54647d7cfd96382395ab1e3cddb (patch) | |
tree | 3b48908939708db6580a90d99bf88ff045311e9d /content/blog/2024-01-27-tableau-dashboard.org | |
parent | 17d0e7fa0f46eae4ef284af4593e33ad24da3bef (diff) | |
download | cleberg.net-a0578880ef14f54647d7cfd96382395ab1e3cddb.tar.gz cleberg.net-a0578880ef14f54647d7cfd96382395ab1e3cddb.tar.bz2 cleberg.net-a0578880ef14f54647d7cfd96382395ab1e3cddb.zip |
format 2024 blog posts
Diffstat (limited to 'content/blog/2024-01-27-tableau-dashboard.org')
-rw-r--r-- | content/blog/2024-01-27-tableau-dashboard.org | 89 |
1 files changed, 42 insertions, 47 deletions
diff --git a/content/blog/2024-01-27-tableau-dashboard.org b/content/blog/2024-01-27-tableau-dashboard.org index 7e0e078..f1efc36 100644 --- a/content/blog/2024-01-27-tableau-dashboard.org +++ b/content/blog/2024-01-27-tableau-dashboard.org @@ -3,14 +3,12 @@ #+description: #+slug: tableau-dashboard -In this project, I am going to show you how to use Tableau Public for -free to create simple dashboards. +In this project, I am going to show you how to use Tableau Public for free to +create simple dashboards. -I will be creating simple visuals from an Omaha crime data set and -combining them to create the dashboard below. You can view this -dashboard interactively online here: -[[https://public.tableau.com/app/profile/c.c7042/viz/OmahaCrimeData2015-2023/OmahaCrimeData2015-2023#1][Omaha -Crime Data (2015 - 2023)]]. +I will be creating simple visuals from an Omaha crime data set and combining +them to create the dashboard below. You can view this dashboard interactively +online here: [[https://public.tableau.com/app/profile/c.c7042/viz/OmahaCrimeData2015-2023/OmahaCrimeData2015-2023#1][Omaha Crime Data (2015 - 2023)]]. #+caption: Tableau Dashboard [[https://img.cleberg.net/blog/20240127-tableau-dashboard/dashboard.png]] @@ -18,18 +16,17 @@ Crime Data (2015 - 2023)]]. * Gather the Data You can download incident data from the Omaha Police Department on their -[[https://police.cityofomaha.org/crime-information/incident-data-download][Incident -Data Download]] page. They currently have files for the years 2015 +[[https://police.cityofomaha.org/crime-information/incident-data-download][Incident Data Download]] page. They currently have files for the years 2015 through 2023. Each file will be downloaded as a CSV file, approximately 3 MB - 8 MB. * Clean and Transform the Data -I have used Python to combine the files into a single CSV file, as well -as adding a custom =datetime= column. You could do this step in any -software you prefer, but I prefer Python as its free, easy to use, and -has a plethora of support resources online. +I have used Python to combine the files into a single CSV file, as well as +adding a custom =datetime= column. You could do this step in any software you +prefer, but I prefer Python as its free, easy to use, and has a plethora of +support resources online. Start by opening a terminal, navigating to your Downloads directory, and creating a python script. @@ -76,38 +73,37 @@ Once pasted, save and close the file. You can execute the file like so: python3 data_processing.py #+end_src -After this, you should have a combined data file that contains all -incidents between 2015 and 2023. Mine was approximately 55 MB. +After this, you should have a combined data file that contains all incidents +between 2015 and 2023. Mine was approximately 55 MB. * Tableau Public -[[https://public.tableau.com/][Tableau Public]] is a free-to-use web -application that allows you to create visualizations by uploading data -sources. Note that there's no way to keep the data and visualizations -private, so don't upload anything private. +[[https://public.tableau.com/][Tableau Public]] is a free-to-use web application that allows you to create +visualizations by uploading data sources. Note that there's no way to keep the +data and visualizations private, so don't upload anything private. -After creating an account, you can click the =Create= > =Web Authoring= -link to create your first visualization. +After creating an account, you can click the =Create= > =Web Authoring= link to +create your first visualization. ** Upload the Data -Once you've opened your first project, Tableau will ask you to connect -to your data. For this project, click the =Upload from computer= button -and select the CSV file previously combined in the step above. +Once you've opened your first project, Tableau will ask you to connect to your +data. For this project, click the =Upload from computer= button and select the +CSV file previously combined in the step above. -Once connected, you can refresh the preview of the data with the -=Refresh Data Source= button in the toolbar. +Once connected, you can refresh the preview of the data with the =Refresh Data +Source= button in the toolbar. -If you need to edit any of the data types, column names, etc., you can -do so now. Once complete, generate an extract so that you can start -creating visualizations. +If you need to edit any of the data types, column names, etc., you can do so +now. Once complete, generate an extract so that you can start creating +visualizations. ** Create Visualizations To start, create a worksheet in the toolbar at the bottom of the screen. -Within this screen, select a column from the =Data= side bar on the left -and drag it into the =Columns= or =Rows= area of the canvas. +Within this screen, select a column from the =Data= side bar on the left and +drag it into the =Columns= or =Rows= area of the canvas. See below for the map visualization. You can recreate this by adding the following fields: @@ -119,30 +115,29 @@ following fields: - Datetime - =Filters=: Datetime -You can repeat this process for each visualization you want to create. -Explore your options by dragging data fields to different areas and by -opening the field options to explore what operations can be performed on -different data types (e.g., average, count, etc.). +You can repeat this process for each visualization you want to create. Explore +your options by dragging data fields to different areas and by opening the field +options to explore what operations can be performed on different data types +(e.g., average, count, etc.). ** Create Dashboard -To create a dashboard, click the button on the toolbar at the bottom of -the screen. Within the dashboard, drag each sheet from the left side bar -onto the dashboard canvas. +To create a dashboard, click the button on the toolbar at the bottom of the +screen. Within the dashboard, drag each sheet from the left side bar onto the +dashboard canvas. ** Formatting -You can explore a ton of different formatting options throughout the -worksheets and dashboard. Specifically for maps, you can alter the map -layers, background, and visible features through the =Map= menu in the -top file menu of the editing screen. +You can explore a ton of different formatting options throughout the worksheets +and dashboard. Specifically for maps, you can alter the map layers, background, +and visible features through the =Map= menu in the top file menu of the editing +screen. -In the finished dashboard below, I opted for a dark mode with a map that -showed county lines and city names. +In the finished dashboard below, I opted for a dark mode with a map that showed +county lines and city names. -There's a ton of other options available to be used in a dashboard like -this, but this project shows a quick preview of what you can do in -Tableau Public. +There's a ton of other options available to be used in a dashboard like this, +but this project shows a quick preview of what you can do in Tableau Public. #+caption: Tableau Dashboard [[https://img.cleberg.net/blog/20240127-tableau-dashboard/dashboard.png]] |