The Texas Department of Insurance (TDI) is a government regulatory body responsible for regulating the Texas insurance industry. As part of their regulatory responsibilities, TDI is responsible for investigating and resolving complaints submitted by insureds against insurance companies. The objective of this project is to clean / pre-process the insurance complaints dataset.
To see a complete project overview, please take a glance at the Insurance Complaints Cleaning Project document or visit the google document for a quick overview (https://docs.google.com/document/d/1kCWQdGYbdxT5I6GhyyIapBMBfyAJoKA_Ukn6cQ8OZrw/edit?usp=sharing). To view the code, please click on any of the SQL files.
For this project, I used T-SQL as my SQL dialect and SQL Server Management Studio as my SQL Client.