Explain which other data sources you might use to understand

Assignment Help Operation Management

Reference no: EM133580408

Homework: Business Finance- Operations Management- Data and Decision Analytics

Prior to beginning work on this homework, read the following:

I. Chapter I: Introduction to Business Analytics
II. Chapter II: Data Management and Wrangling
III. Chapter III: Summary Measures

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 five years and identify trends that will allow them to understand their customers better.

Download your chosen bank's annual income statements from the last five years from the Mergent Online database in the University of Arizona Global Campus University Library. Review the Mergent Online: Accessing Mergent Online resource for tips on accessing and searching the database. Use the "Company Financials" tab in Mergent to access the income statements.

In your paper,

Question I. Identify an area of the bank's income statement related to customer spending.

Question II. Describe the data points or variables that give a complete picture of the customers' spending pattern for the last six months.

Question A. In addition to the income statement, explain which other data sources you might use to understand the customers' spending patterns.

Question B. List the steps you will take to prepare all these data sources such that they afford clear and accurate information.

Question III. Build a frequency table, a bar chart, and a pie chart using Excel for the identified variables that explain the customers' spending patterns. Review the Microsoft Excel Help: Home webpage, available for resources to help utilize Microsoft Excel. Use the same three variables in each table and chart to display the same data in three different formats.

Question IV. After presenting your data in three formats, evaluate which tables and charts you find most helpful for communicating the desired message about the bank's customers. For assistance on when and how to use tables, refer to resource Tables, Images, & Appendices.

Reference no: EM133580408

Questions Cloud

What modifier is appended to the cpt code for the foot care : A physician plans to provide routine foot care and, to be sure the patient understands that this is not a covered Medicare benefit.

What web service based mechanism supports location : What web service based mechanism supports location- and transport-transparency by allowing service implementations to register their characteristics

What types of performance what are work breakdown structure : What types of performance what are the Work Breakdown Structure phaseevaluation methods are there and why are performance reviews important?

Identify information about the medications : As a nurse giving medications to prevent rejection and complications for the client who received a transplanted organ.

Explain which other data sources you might use to understand : In addition to the income statement, explain which other data sources you might use to understand the customers' spending patterns.

How these job roles may range from entry-level to higher : how these job roles may range from entry-level to higher-level leadership job roles. In your review of these jobs did you notice an similarities or differences

Provide how you can show compliance with these policies : Provide how you can show compliance with these policies through the scenarios below:You injured yourself at work but do not want to report it

What is the most sensitive-specific to determine diagnosis : Upon examination, the dorsalis pedis and posterior tibial pulses are diminished. What further testing is the most sensitive and specific to determine diagnosis?

Maintaining requirements in an organisational context : Synthesise key principles of requirements management and communicate to stakeholders in order to solve problems

User Account

All Pages