Question: Use the School-expenses spreadsheet, import the district-level (CDS) data. When loading the Excel document in Tableau, check the box Use Data Interpreter to clean the
Use the School-expenses spreadsheet, import the district-level (CDS) data. When loading the Excel document in Tableau, check the box "Use Data Interpreter" to clean the Excel file before using it. 1. create a highlight tables that lists all schools DISTRICT that has the most current expenses. Filter to show only those that have expenses greater than $40,000. Rename the title of your worksheet from Sheet 1 to Top Spending School Districts. Order the list from top to bottom (highest first) and indicate how many school districts are there with spending of more than $40,000. 2. by filtering the data using the LEA Type dimension for Community Admin (Comm Admin), create a tree maps graph that will list the top spending per average daily attendance (i.e. per ADA). Who are the highest and lowest spending schools? 3. create a horizontal bars graph that lists all the DISTRICTS with the current per average daily attendance (per ADA). Update the tooltip to read School District and Expenses per Average Daily Attendance. Sort from Lowest to highest. Rename the title of Sheet 3 to Least School Districts per ADA. 4. Build and design a Dashboard using the 3 charts built in the previous questions. A separate dashboard is to be optimized for Samsung Galaxy Note Series phone for the 3 charts.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
