Taylor Is a New Staff Accountant for a Fortune 100

question 5

Essay

Taylor is a new staff accountant for a fortune 100 company.After hearing that she just successfully completed an Accounting Data Analytics course,her boss said,"Get me a listing of all our deadbeat customer,so I can cut off their credit." After asking clarifying questions,Taylor was able to determine that root request was "Which customer,with a credit limit over $10,000,have more than $5,000 outstanding for more than 90 days at the prior quarter's end?" Use the ETL Techniques briefly describe the process Taylor with have to complete to answer her boss' question.(Assume that Taylor does not have direct access the data,data will export into an Excel file,and she will complete the analysis with an Excel Pivot Table.)

---

Definitions:

Blindness

The state or condition of being unable to see due to injury, disease, or a congenital condition.

Paralysis

The loss of the ability to move (and sometimes to feel anything) in part or most of the body, typically as a result of illness, poison, or injury.

Somatoform Disorders

A group of psychological disorders in which patients experience physical symptoms that have no identifiable physical cause.

Hypochondriasis

A psychological disorder wherein an individual is excessively worried about having a serious illness, often misinterpreting normal bodily functions as symptoms of serious conditions.