[Solved] dee

Assignment Prompt & Instructions

## **Assignment 2: Tableau Dashboard for Administrative Decision-Making**

### **Overview**

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:

1. import and work with a dataset in Tableau;

2. create charts that summarize administrative patterns;

3. design a simple dashboard for decision-making;

4. identify which visual formats are most appropriate for the data;

5. 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:

1. Your Tableau dashboard share URL;

2. one short written explanation in Word or PDF format.

– [\
\
FortWorth_CodeViolations_Memo.docx1.docx](https://www.sweetstudy.com/files/fortworth-codeviolations-memo-docx1-docx "FortWorth_CodeViolations_Memo.docx1.docx")
– [\
\
DataSoruce14.xlsx](https://www.sweetstudy.com/files/datasoruce14-xlsx "DataSoruce14.xlsx")
– [\
\
Fort_Worth_Codebook3.docx](https://www.sweetstudy.com/files/fort-worth-codebook3-docx "Fort_Worth_Codebook3.docx")