04 Jun Tableau Dashboard for Administrative Decision-Making

In this assignment, you will use Tableau to create visualizations and a simple dashboard based on administrative data. The purpose of this assignment is to help you think about how data can be communicated clearly to decision-makers.

In many organizations, collecting data is only the first step. Managers must also be able to present data in a way that helps others understand trends, compare categories, and identify issues that may require action. Tableau is a useful tool for turning data into visual information that can support decision-making.

For this assignment, you will create visualizations and a dashboard that communicate a clear story from the dataset.

Learning Objectives
By completing this assignment, you should be able to:

import and work with a dataset in Tableau;

create charts that summarize administrative patterns;

design a simple dashboard for decision-making;

identify which visual formats are most appropriate for the data;

explain findings in clear nontechnical language.

Instructions
Use the provided dataset, or a cleaned version of the dataset from Assignment 1, to create visualizations in Tableau.

Part 1: Prepare the Data
Before building visualizations, make sure your dataset is usable.

You should:

review the variables you plan to use;

make sure date variables are in a usable format;

identify at least three variables that can help tell an administrative story.

Examples may include:

complaint type,

case status,

case creation year,

code officer,

neighborhood or geographic area if available.

Part 2: Create Visualizations
Create at least three visualizations in Tableau.

Your visualizations should include:

at least one chart comparing categories;

at least one chart showing a trend or distribution;

at least one chart that helps identify a management issue.

Examples:

top complaint types;

open vs. closed cases;

cases by year;

cases by officer;

complaint types over time.

Part 3: Create a Dashboard
Combine your visualizations into one simple dashboard.

Your dashboard should:

have a clear title;

include at least three charts;

be organized in a readable way;

help a supervisor or manager understand the most important findings.

Keep the dashboard simple. The goal is clarity, not complexity.

Part 4: Write a Short Explanation
Write a 300–500 word explanation of your dashboard.

Your explanation should address:

what story your dashboard tells;

what patterns are most important;

which chart is most useful and why;

how this dashboard could help an organization make decisions.

Deliverables
Submit the following:

Your Tableau dashboard share URL;

one short written explanation in Word or PDF format.