2016-2017 Race and Gender CPI Tableau Dashboards

Once the Tableau Reader has been downloaded and installed on your computer, you will be able to open the Tableau Packaged workbooks:

2017 CPI Dashboards Gender

2017 CPI Dashboards Race

2017 CPI Dashboards Gender by Race

 

The three workbooks contain CPI breakdowns by race and gender for each individual year (2017).

Instructions for Using the 2016-2017 CPI Dashboards

  1. There are 8 dashboards in the Tableau workbook
      • 1S1: Reading Attachment
      • 1S2: Math Attachment
      • 2S1: Assessment Attachment
      • 3S1: School Completion
      • 4S1: Graduation
      • 5S1: Placement Dashboard
      • 6S2: Nontraditional Completion
  2. Each dashboard looks similar and has similar controls to manipulate the 2016-2017 data.
  3. The tables display the numerator and denominator for each indicator for the specific year or for all years combined. The definitions of the numerator and denominator for each CPI are provided in an attached MS Word document.
  4. The graphs on each dashboard display each of the indicator values for user selected levels along with the State Target (blue line with value shown). The blue column in each graph indicates thresholds for the CPI that meet/exceed the state target, the orange column indicates the 90 to 100% range, and the black column indicates CPI values below the 90% level. (** The combined year workbook is not color coded due to changing annual state targets and 90% thresholds)
  5. There are 6 user Selected levels (**7 for the combined year workbook):
    1. Region (‘All’ allows the user to select all 25 OCTE Regions. The user additionally can select individual or multiple Regions as they prefer)
    2. EPD (‘All’ allows the user to select all 53 OCTE CEPDs. If the user picks a specific Region, then only CEPDs within that particular Region will be displayed)
    3. Federal Cluster Code (This displays the 16 career clusters. The user can select which of the 16 clusters they want to observe the data for or select ‘All’)
    4. CIPCode (This displays the 50+ CIP codes available within the state and again allows the user to select the CIPCode for which they want to observe the data for or select ‘All’)
    5. Race (This displays the 7 possible race categories for each CPI. The user can select ‘All’ or look at specific race breakdowns)
    6. Gender (This displays the 2 possible gender categories. The user can select ‘All’ or look at a specific gender breakdown)
    7. ** Year (This displays the 3 years of data for which gender and race breakdowns are available. The user can select ‘All’ or examine a specific year)
  6. If denominator or numerator values are less than 6, then the table and the graph will be blank and no data will be displayed.
  7. Tableau is a powerful tool to display and manipulate data. Please play with the dashboards and see what you like/do not like about they work.