You are a data analyst working for a nonprofit organization that reviews business. You have been tasked to provide a briefing on consumer complaints. Using this Web site (http://catalog.data.gov/dataset/consumer-complaint-database) which has over 200,000 records, analyze the data, and provide insight regarding the following:
Which type of product had the most complaints ordered by state?
How many complaints have been filed for each company?
Summarize the responses for each company (i.e., 32 in progress, 67 closed, and 22 closed with explanation).
Please provide the report as a database application document. The final product will include a customer complaints table and a query for each of the questions above.
Leave a Reply
You must be logged in to post a comment.