Data Dashboards

The usual source of population data from the Office of Financial Management (OFM) that we use to calculate health-related rates is unavailable until 2024. DOH is using population interim estimates (PIE) developed by Public Health - Seattle and King County. These have been vetted by subject matter experts and stakeholders from the Department of Health, local health jurisdictions and Tribal Epidemiology Centers. PIE are available for 2000-2022 so that a consistent series of population data is available. Because we have applied PIE to historic data, some rates will be different from what we published previously. We are in the process of updating rates with PIE; the date that each dashboard is updated is noted on the dashboard itself. For more information, please email DOH.WTN@doh.wa.gov.

Data dashboards provide an interactive way to explore public health and environmental data. Most dashboards have filters for easily selecting the measure, geography, and timeframe of interest. Data can be viewed as a map or as trends over time and are available for download. If a topic has data available in a dashboard format, you will see a button on the topic page that looks like this:

Dashboards

How to Use

We currently have dashboards built using two different platforms: Tableau and PowerBI. There are differences in how to use each platform, but the overall functionality is the same. You can select and filter data to see visualizations of that information and you can download the un-visualized data.

Dashboards have multiple pages to view different data related to each topic. For Tableau dashboards, these are listed in the gray tabs across the top of the dashboard.

Menu of dashboards with active dashboard highlighted with darker gray background

For PowerBI dashboards, these are the buttons at the top left of the dashboard.

Page selection buttons on a PowerBI dashboard

You can filter the data that you are viewing. Choose what data you want to see on a dashboard by selecting the appropriate buttons, sliders, or dropdown menu option. In PowerBI dashboards, these filters are typically on the left side of the dashboard. Summary pages may not have filters, but other pages do. For Tableau dashboards, the filters may be anywhere on the display.

Button and dropdown menu filters on a PowerBI dashboard

Information about the data or display is shown at the bottom of the dashboard page.

PowerBI dashboards also have an information button on the top, right-hand side of each page containing more information about to interact with that specific dashboard.

Downloading the Data Table

Data can be downloaded through the dashboards, and we are in the process of adding links to the data on our webpages underneath the dashboards as well.

In PowerBI dashboards there is a button at the bottom right of the dashboard that says “Download.” If the dashboard has a summary page, there may not be a download button on that page, but other pages will have download buttons. When you click the download button, you will automatically be taken to a spreadsheet of the data underlying that page.

In Tableau dashboards, you can download the data from the far-right page tab, titled “Data Table” or “Download Data Table.” There you can select which data you would like to download.

To download the data once you have selected your filters, follow these five steps:

Step 1: Select data in drop down menus to the right.

Step 2: Click anywhere on the data table once.

Step 3: Select “Download” at the bottom of the dashboard or in the tool bar above the data.

Step 4: Select “Data.” If “Data” is grayed out, go back to Step 2 and ensure that you have clicked a cell in the data table.

Step 5: Select “Download” again.

Privacy and Protection

To protect privacy, the dashboards do not display any personally identifiable information. The source data has been aggregated and de-identified in compliance with state and federal law.

Contact Us

For information or questions related to the Washington Tracking Network, email DOH.WTN@doh.wa.gov.

Let Us Know How You Used the Data

We love hearing about how our data is being used to make an impact on the health of Washingtonians. It also helps us to know what is meeting our users’ needs and how we can improve the information we provide. If you used our data, please tell us about it by sending an email to DOH.WTN@doh.wa.gov.

Would you like to receive updates?

Receive updates and information about WTN by joining our email newsletter.

Image
Environmental Public Health Tracking logo