Working With Research Methods and Performing Statistics in SQL

Teams Meeting: Link

Topic: Working With Research Methods and Performing Statistics in SQL
The presentation will focus on the ways in which T-SQL techniques can be used to conduct exploratory data analysis. Using the FBI’s Law Enforcement Employees dataset, I will show how to perform different techniques to sample data based on research contexts. Next, I will walk through the process of conducting descriptive statistics to gauge “typicality” and “outliers.” Lastly, I will demonstrate how one can perform basic hypothesis testing to better understand the relationships between variables. In conclusion, I will discuss how business intelligence analysts and database administrators can improve data management and modeling by conducting exploratory data analysis on their data.

Speaker: Ezekiel Kaufman
Ezekiel has over ten years of experience working as a data analyst in state government, university departments, and a software company. He has worked in the areas of criminal justice, child protection, and Medicaid. He also taught lab courses in social science research methods to undergraduate students. Ezekiel’s formal training is in the social sciences and humanities. He has extensive experience performing analyses using multiple analytical languages, including T-SQL, stata, SPSS, and MPlus.