Author: Aizhan Uteubayeva (NetID: au198)
Published: June 18, 2023
This project involves using Tableau to explore and visualize healthcare data. The focus is on identifying discrete vs. continuous values, creating aggregate values, filtering data, and applying various formatting and visualization techniques to effectively present the information.
- Install Tableau Desktop from the Tableau website.
- Open the provided Tableau workbook file (
HW9_Aizhan_au198.twb
) in Tableau Desktop.
-
Identification of Values
- Identify discrete vs. continuous values in the data.
-
Creating Aggregate Values
- Create an aggregate value for hospital count (Hosp C) using the COUNT (CNT) function.
-
Filtering Data
- Apply filters to focus on specific subsets of the data.
- Filter for average Length of Stay (LOS) greater than Medicare LOS.
- Filter by gender (female vs. male).
- Apply filters to focus on specific subsets of the data.
-
Graph Customization
- Transpose graphs for better visualization.
- Sort data in descending and ascending orders.
- Use the "Show Me" option to explore different graph types.
- Format titles and text, including font, size, italics, and colors.
-
Enhancing Data Presentation
- Edit tooltips to include values and enhance clarity.
- Apply labels and adjust size for readability.
- Format values to avoid overlapping.
- Use Dual Axis to present data on two axes.
-
Identifying Data Issues
- Identify and handle a large number of ungroupable patients in the data.
- Discrete vs. Continuous Values: Differentiating between data types.
- Aggregate Values: Creating and using aggregate functions.
- Filtering: Applying both functional and automated filters.
- Graph Customization: Transposing, sorting, and formatting graphs.
- Data Presentation: Enhancing tooltips, labels, and using dual axes.
- Data Issues: Identifying and managing ungroupable data points.
- Tableau Desktop: For data visualization and analysis.
This project is licensed under the MIT License.