Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Monarch Learning Series 2023 Exercise 3 - FDIC Failed Bank List

Baba_Majekodunmi_703 · 2023-03-20T16:46:31+00:00

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…

Baba_Majekodunmi_703

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 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.

Altair_CommunityBlog_Default-11.jpg

FDIC Failed Bank List.xlsx

Find more posts tagged with

English

Monarch

Comments

Margi

My attempt

Monarch learning series exercise 3.docx

Shelton Vance_22282

My attempt...

Banks 05242023.pdf

Susan DeWitt

I'm new to Data Prep but have used Classic for years.

FDIC.xlsx

Baba_Majekodunmi_703

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).

Baba_Majekodunmi_703

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.

Baba_Majekodunmi_703

My attempt

Great job Margarethe! 100% correct.

David Nash

Attempt.

GroupBy Aquiring Bank.xlsx

GroupBy State.xlsx

GroupBy Year.xlsx

Cassandra Cassady

1 attachment

exercise 3 - FDIC_failedbank.xlsx