Exercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Split, Group By, Duplicate, Analyze (Summary)
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached
- FDIC Failed Bank List.txt
Exercise Overview
You are a new Financial Analyst at the FDIC and your manager has asked you to perform some analytics on the FDIC List of Failed Banks to answer the following questions:
- Which year had the most number of bank failures?
- Which state has had the most number of bank failures?
- Which bank has acquired the most failed banks?
Exercise Answer
Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.