false
OasisLMS
Login
Catalog
Supporting Financial Stability: Advanced Analysis ...
Recording - Advanced SAO FIT Tool
Recording - Advanced SAO FIT Tool
Back to course
[Please upgrade your browser to play this video content]
Video Transcription
Video Summary
The second FIT training session focused on intermediate and advanced financial analysis for Washington school districts. Presenter Niles reviewed FIT’s purpose and data sources: the State Auditor’s Office publishes comparable local-government financial information, including school-district F-196 data received from OSPI. FIT does not alter reported figures, though it applies formatting and categorization to support comparisons.<br /><br />The session demonstrated how to use individual-government profiles and financial views to examine trends, filter by fund, and display percent changes, percent of total, or dollars per student. Users can add statewide averages and other benchmarks, click data points to find similar districts, and build side-by-side comparisons. Some features, such as expenditure-object analysis, are not currently available for school districts.<br /><br />For analysis beyond FIT’s built-in options, users can export a view to Excel or download full data extracts. The presenter shared basic Excel techniques for preparing data, creating charts, and generating forecasts. He also demonstrated importing and combining data in Power BI to build tables and visualizations, while noting that these tools require some data preparation and practice.<br /><br />The central recommendation was to begin with FIT to explore and frame a question, then export data when deeper customization is needed. Users can get help through FIT’s help tab, live chat, or the State Auditor’s Office. The session recording and materials will be available through the learning management system.
Keywords
FIT training
financial analysis
Washington school districts
State Auditor's Office
OSPI data
F-196 financial data
individual-government profiles
financial views
statewide averages
Excel export
Power BI
data visualization
school district benchmarks
×
Please select your language
1
English