Data analyst for a bank.

 

 

 

Imagine that you are hired as a data analyst for a bank. The bank would like to learn more about its customers’
spending and banking habits to identify areas of improvement. You have been asked to review the bank’s income
statements over the last 5 years and identify trends that will allow them to better understand their customers.
Download your chosen bank’s annual income statements from the last 5 years from the Mergent database in the
University of Arizona Global Campus Library. Review the Mergent Online: Accessing Mergent Online resource
for tips on accessing and searching the Mergent database. Use the “Company Financials” tab in Mergent to
access the income statements.
Identify three variables or categories that the bank may be interested in further researching, such as sales or
revenue. Using these three variables or categories, build a frequency table, a bar chart, and a pie chart using
Excel. Review the Microsoft Excel Help: BUS625 Excel Guide webpage for resources to help utilize Microsoft
Excel. You will be using the same three variables in each table and chart, so the same data will be displayed in
three different formats.
After creating the three tables, which of the tables and charts do you find most useful for communicating
information about the bank’s customers? Write a brief case report summarizing your analysis and results.
In your paper,
Identify three variables in the income statements that the bank may be interested further researching to learn
more about its customers.
Develop a frequency table, a bar chart, and a pie chart using variables in the income statements for your bank.

Analyze the table and charts to find the most useful information for communicating information about the bank’s
customers.
Summarize your analysis and results, including how the charts were useful in your research

Sample Solution

  1. Identify the variables of interest. The first step is to identify the variables in the income statements that are relevant to understanding customer spending and banking habits. Some potential variables include:
    • Interest income: This is the income that the bank earns from loans and other interest-bearing investments.
    • Non-interest income: This includes income from fees, commissions, and other sources.
    • Operating expenses: This includes the costs associated with running the bank, such as salaries, rent, and utilities.
    • Net income: This is the bank’s profit after all expenses have been deducted.
  2. Collect the data. Once the variables of interest have been identified, the next step is to collect the data from the income statements. This can be done by downloading the income statements from the bank’s website or from a financial data provider such as Mergent.
  3. Analyze the data. The data can be analyzed using a variety of methods, such as frequency tables, bar charts, and pie charts. These methods can be used to visualize the data and identify trends.
  4. Interpret the results. The results of the analysis should be interpreted in the context of the bank’s business and its customers. For example, if the interest income is increasing, it could mean that the bank is lending more money to customers. If the non-interest income is increasing, it could mean that the bank is charging more fees for its services.
  5. Make recommendations. The final step is to make recommendations based on the results of the analysis. These recommendations could include changes to the bank’s products and services, marketing campaigns, or lending policies.

Here are three variables in the income statements that the bank may be interested in further researching to learn more about its customers:

  • Interest income: This variable can tell the bank how much money it is earning from loans and other interest-bearing investments. The bank may want to research this variable to see if there are any opportunities to increase interest income, such as by lending more money to customers or investing in higher-yielding securities.
  • Non-interest income: This variable can tell the bank how much money it is earning from fees, commissions, and other sources. The bank may want to research this variable to see if there are any opportunities to increase non-interest income, such as by charging more fees for its services or offering new products and services that generate fees.
  • Operating expenses: This variable can tell the bank how much money it is spending to run its business. The bank may want to research this variable to see if there are any opportunities to reduce operating expenses, such as by negotiating lower rents or reducing staff costs.

The most useful table or chart for communicating information about the bank’s customers will depend on the specific variables that are being analyzed. For example, if the bank is interested in interest income, a bar chart may be the most effective way to visualize the data. If the bank is interested in non-interest income, a pie chart may be more effective.

The case report should summarize the analysis and results, and make recommendations based on the findings. The report should also discuss the limitations of the analysis and how the results could be improved.

 

 

 

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.