Analysis

Introduction to SQLite

Presented May 31st, 2019 @ Memphis NonProfit Data Professionals Meetup The git repository for this talk can be found HERE. The presentation can be viewed HERE. Resources cited in this talk include: SQLCourse: An interactive online training course for SQL, includes good background information about SQL in general. SQLite.org: Website for the SQLite project, houses downloads, documentation, and just about anything else you’d need regarding SQLite. sqlitetutorial.net: A collection of SQLite tutorials.

Continue reading

MemTech Presentation: Introduction to R

On 09/04/2018, I gave a presentation to a gathering of non-profit and foundation IT and data professionals in Memphis. The git repository for this talk can be found HERE. The presentation can be viewed HERE. Resources cited in this talk include: Tidy Data: A paper by Hadley Wickham providing practical advice on formatting data for programmatic workflows. Data Camp: A really useful site for interactive R training. R for Data Science: An online book by Garrett Grolemund and Hadley Wickham that introduces the basics of data science using R.

Continue reading

Report Development – Olivia Y STRO Reporting

During 2017, the state of Mississippi entered a period governed by a court order known as the Stipulated Third Remedial Order, or STRO, pursuant to the ongoing Olivia Y lawsuit. This order included language compelling the state of Mississippi to establish baselines, in partnership with an independent consulting agency, with regards to caseworker contacts with foster children, maltreatment in care occurrence, permanency outcomes for foster children, and statistics related to adoption of foster children.

Continue reading

Focus on Data – MDCPS Actionable Reporting System

Repository In the spring of 2017, I prepared a demonstration of an interactive reporting system built on the R/Shiny platform for providing up-to-date and actionable information to MDCPS Social Work Supervisors and Social Workers. The system was built on a philosophy that effective management by data is predicated on providing the right information to the right people in as readily accessible format as possible. For a direct supervisor, this meant providing information about the individual performance of each supervised social worker, highlighting areas needing improvement before a policy requirement had failed to be met.

Continue reading