Monarch Learning Series 2023 Exercise 3 - FDIC Failed Bank List
Baba_Majekodunmi_703
Altair Employee
Altair EmployeeExercise 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 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?
Answer
- Please upload your answers below in the comment section for the exercise
- A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Learning Series Solution' section.
0
Comments
-
-
-
-
Shelton Vance_22282 said:
My attempt...
Hey Shelton, did you do this in Classic? :-) Not bad, but can you do it in Data Prep Studio? You got them all right, well, except for #3 (it's a technical).
0 -
Susan DeWitt said:
I'm new to Data Prep but have used Classic for years.
Great job Susan! Yes, Data Prep is relatively newer than Classic, but it really is a game changer. I used Classic myself for a few years and took me a few weeks/months before I started to try Data Prep Studio. I promise you, learning it will be worth it.
0 -
Margarethe Coelho_20640 said:
My attempt
Great job Margarethe! 100% correct.
0 -
-