The dashboard is built in Microsoft Power BI. Below are general instructions on how to use the dashboard. It is recommended to use the dashboard on a desktop for best user experience.
Navigation
This dashboard is organized into a single page with different visual components. The dashboard consists of the following visualizations:
Confirmed ES Silicosis Cases: This displays the number of confirmed Engineered Stone (ES) Silicosis cases identified in California as of the date of the last dashboard update.
Deaths: This displays the number of known deaths due to silicosis among confirmed ES Silicosis cases.
Four data cards that display the median age at diagnosis, the median age at death, the percent male, and percent Latino of all confirmed ES Silicosis cases in California.
Median age at diagnosis: age midpoint for diagnoses. Half of the cases were older than the median age at diagnosis and half of the cases were younger than the median age at diagnosis.
Median age at death: age midpoint for deaths. Half of the silicosis-related deaths were among individuals older than the median age at death and half of the silicosis-related deaths were among individuals younger than the median age at death.
Percent Male: the percentage of all confirmed ES Silicosis cases who are male.
Percent Latino: the percentage of all confirmed ES Silicosis cases who are Latino.
Last known transplant status for confirmed ES Silicosis cases: A bar chart that displays counts of known transplant-related outcomes among ES Silicosis cases identified in California. The categories reflect whether CDPH is aware that a worker with ES Silicosis has undergone or been evaluated for a lung transplant. Availability of follow-up and outcome data once cases are identified is not consistent across data sources, so these counts may be underestimates.
Year confirmed ES Silicosis cases identified by CDPH: A bar chart that displays the number of cases that CDPH has identified over time. The number of cases identified in the current year is only partially complete and is expected to increase over time.
Year of diagnosis for confirmed ES Silicosis cases: A line chart that displays, by year, the number of ES Silicosis cases diagnosed over time. Diagnosis data are only displayed through 2022. Data for more recent years are incomplete due to reporting lags.
Confirmed ES Silicosis cases have been identified in the following counties: A map that displays California counties in color where ES-Silicosis cases have been identified. If you hover the mouse pointer over a county, the number of cases identified in that county will be displayed. In instances where the county has no known cases, it will just display the county name. These reflect the case’s county of residence at the time of case identification.
County and Count: A table that displays the county name and confirmed ES Silicosis case count for all counties in California. These counties reflect the county of residence at the time of case identification.
County of residence drop down list: The drop down displays a list of all counties in the state. When you select a county name, the table below will filter to display the corresponding county’s data.
Tooltips
Move the mouse pointer so that it hovers over a visual on the dashboard. A popup window referred to as “tooltip” will appear. Tooltips contain additional data details, such as the year, number of cases, location, and/or category. In some cases, such as the median age at diagnosis and median age at death, there are additional summary statistics. As you move the mouse pointer over different visuals, the tooltip will automatically update to describe the data it is hovering over. Below are a few examples of tooltips within the dashboard: