The objective of this week's deliverable is to provide Robert M. Lopez with an executive summary of your findings. In a 2-3 page paper, summarize your findings. Give proof for your analysis. Within your paper, explain the process you did to come up with

lgaray_datacompliance_061216.docx

RUNNING HEADER: Data Compliance 1

RUNNING HEADER: Data Compliance 2

Data Compliance

Lisa Garay

Rasmussen College

Authors Note

This paper is being submitted for Anastasia Rashtachian’s B288 Business Analytics course.

The state of each of the clients in the analysis help trace where we get more of our customers. Sales consultant identification helps us track the specific individuals who facilitated the sales. A total cancellation helps us indicate the total number of orders that never matured and thus no payments were made. It helps track the number of cancelled transactions for every consultant. The total sales help us trace the sales a particular consultant did.

Some states have kept their sheets clean with their consultants since they make orders and honor their agreements. Manhattan state have done incredible honor in their contracts with the consultants since among more than 90 orders with the consultants only 10 orders were cancelled. They have maintained the best record with the consultants. Other states who have maintained their records include Louisville, Bronx, and El Paso.

New Orleans indicate one of the regions whereby the sales noncompliance increase at an alarming rate. The cancelation of 10 orders should worry the progress of the consultant since out of the 10 orders, cancellation of all of them was inappropriate. During the same month, New Orleans also cancelled a total of 13 orders which saw a total cancellation of 23 orders out of 24 contracts. Later in the month, New Orleans cancels some other two orders and the trend is now consistent.

Miami State has also a trend of cancelling their orders. The sales consultants need to find the reasons behind the numerous cancellations of orders after they gain the contract which consequently reduces the sales of the consultants.