Navigating Your Compensation Journey: NYC Teacher's Payroll Insights
Project Description:
This project aims to provide NYC teachers with a comprehensive understanding of their expected annual salary growth, factoring in the impact of UFT salary contracts from 2014 to 2023. The analysis will consider variables such as union dues and inflation to assess the overall financial implications for teachers. By offering insights into the relationship between salary contracts, individual compensation, and economic factors, the objective is to empower teachers to make informed decisions about their financial well-being and evaluate the value they receive from UFT-negotiated contracts.
Executive Summary:
Table of Contents:
Project Charter
Getting Started
Data Sources
Data Dictionary
Data Cleaning
Analysis
Results
Visualizations
License
Acknowledgments
Getting Started:
Data Sources:
(link to the dataset)
Data Dictionary
| Column Name | Description | Type |
|---|---|---|
| Fiscal Year | Fiscal Year | Number |
| Payroll Number | Payroll Number | Number |
| Agency Name | The Payroll agency that the employee works for | Plain Text |
| Last Name | Last name of employee | Plain Text |
| First Name | First name of employee | Plain Text |
| Mid Init | Middle initial of employee | Plain Text |
| Agency Start Date | Date which employee began working for their current agency | Date & Time |
| Work Location Borough | Borough of employee's primary work location | Plain Text |
| Title Description | Civil service title description of the employee | Plain Text |
| Leave Status as of June 30 | Status of employee as of the close of the relevant fiscal year: Active, Ceased, or On Leave | Plain Text |
| Base Salary | Base Salary assigned to the employee | Number |
| Pay Basis | Lists whether the employee is paid on an hourly, per diem, or annual basis | Plain Text |
| Regular Hours | Number of regular hours employee worked in the fiscal year | Number |
| Regular Gross Paid | The amount paid to the employee for base salary during the fiscal year | Number |
| OT Hours | Overtime Hours worked by employee in the fiscal year | Number |
| Total OT Paid | Total overtime pay paid to the employee in the fiscal year | Number |
| Total Other Pay | Includes any compensation in addition to gross salary and overtime pay, i.e., Differentials, lump sums, uniform allowance, meal allowance, retroactive pay increases, settlement amounts, and bonus pay, if applicable | Number |
Data Cleaning:
Describe the steps taken to clean and preprocess the data, including any challenges encountered and solutions implemented. Analysis:
Detail the methodologies and techniques used to analyze the data, including key metrics and parameters considered. Results:
Summarize the key findings from the analysis, highlighting any trends, patterns, or noteworthy insights.
Visualizations:
License:
This project is licensed under the MIT License.
Acknowledgments:
Give credit to any resources, datasets, or libraries used in the project.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent