From fdd80eadcc2f147d0198d94b7b908764778184a2 Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Mon, 29 Apr 2024 14:18:55 -0500 Subject: format line wrapping and fix escaped characters --- content/blog/2024-01-27-tableau-dashboard.md | 99 ++++++++++++++-------------- 1 file changed, 48 insertions(+), 51 deletions(-) (limited to 'content/blog/2024-01-27-tableau-dashboard.md') diff --git a/content/blog/2024-01-27-tableau-dashboard.md b/content/blog/2024-01-27-tableau-dashboard.md index 4761676..71721fd 100644 --- a/content/blog/2024-01-27-tableau-dashboard.md +++ b/content/blog/2024-01-27-tableau-dashboard.md @@ -5,12 +5,12 @@ description = "" draft = false +++ -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: [Omaha Crime Data (2015 - +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: [Omaha Crime Data (2015 - 2023)](https://public.tableau.com/app/profile/c.c7042/viz/OmahaCrimeData2015-2023/OmahaCrimeData2015-2023#1). ![Tableau @@ -27,10 +27,10 @@ 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. @@ -77,90 +77,87 @@ Once pasted, save and close the file. You can execute the file like so: python3 data_processing.py ``` -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 -[Tableau Public](https://public.tableau.com/) 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. +[Tableau Public](https://public.tableau.com/) 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. ![Create Button](https://img.cleberg.net/blog/20240127-tableau-dashboard/create_button.png) ## 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. ![Connect Data](https://img.cleberg.net/blog/20240127-tableau-dashboard/connect_data.png) -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. ![Data Preview](https://img.cleberg.net/blog/20240127-tableau-dashboard/data_preview.png) -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: -- `Columns`: Lon -- `Rows`: Lat -- `Marks`: - - Description - - Datetime -- `Filters`: Datetime +- `Columns`: Lon +- `Rows`: Lat +- `Marks`: + - Description + - Datetime +- `Filters`: Datetime ![Worksheet Editing](https://img.cleberg.net/blog/20240127-tableau-dashboard/worksheet_edit.png) -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. ![Dashboard Editing](https://img.cleberg.net/blog/20240127-tableau-dashboard/dashboard_edit.png) ## 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. ![Tableau Dashboard](https://img.cleberg.net/blog/20240127-tableau-dashboard/dashboard.png) -- cgit v1.2.3-70-g09d2