You have a 6-hour case exercise with the following tasks: 1) Download the latest ADV reports from the SEC website and parse them to extract information about various funds, including name, address, phone number, and number of employees. 2) Implement error logging and write log entries to a local SQLite file. 3) Clean and transform the data to extract insights such as fund size by assets under management (AUM) and number of employees. 4) Create an API to expose the processed data. 5) Write mock tests for the API. 6) Create visualizations based on the extracted data.