San Fran Payroll Crisis

The goal of this project is to review the following in order to determine the best possible recovery plan for the City of San Francisco.

• Overall payroll
• Overtime pay, Other Pay, Extra Pay (OT + Other pay)
• Employee counts
• Departments with the largest impact on Payroll
• Average hourly rates
• Proposed solution -Estimations for upcoming 4 years The business need for the City is to reduce it's most expensive and out of control budget line, payroll. I used excel to clean and research my data, then Tableau to visualize my results.