The director of sales receives a regional monthly sales report. As the business analyst you have been asked to meet with the sales director to fine tune the report. In preparation for the upcoming meeting, you decide to plan to review with the sales director.

You received a copy of the last three months regional sales report for your review. You plan for the upcoming meeting with the sales director

1. Discuss the fields that could be omitted from the report and why? Which fields would remain and why?
2. Recommend other possible information that could be included in future reports? And why?
3. Review any additional ways to collect information from the sales teams.
4. Discuss any possible security areas that might need to be addressed with the current report.

 

Transcribed Image Text:

Extract Date Sales Consultan SC Last name 7/1/2020 26354410 Smith 7/1/2020 4027830 Nova 7/1/2020 26621106 A 7/1/2020 66464567 Wire 7/1/2020 41107218 Buster 7/1/2020 26354410 Smith 7/1/2020 57575758 Frank 26621106 A 7/1/2020 7/1/2020 $3748200 Travas 7/1/2020 26150025 Jones 7/1/2020 26152889 Smith 7/1/2020 26621106 A 7/1/2020 26526109 Priter 7/1/2020 26161204 Ure 33255099 York 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 26520168 3535335 Rucco 26457518 Hansen 35265980 Manute 33407197 Heston 33011618 K 26525752 Regan 26356778 Dimit 33155393 Williams 33253704 Amisher 26621106 An 12658262 Werever R SC First Name State Debbie Jeremy S Micah Ra Carol P Jacqueline M Debbie Benjamin Micah Rae Francisco A Jennifer Debbie Micah Rae Yan Alex V William Adriano F Vanessa Victor Kelly David N Andres A Enrique Clarence Ash T Micah Rae trick LA GA MS K PL LA TX NY K LA NY NY NY NY NY NY NY AR KY NY PL KY NY LA NY Region FUHI SOUTHWEST SOUTH SOUTH SOUTHWEST Office MIAM Arkansas NEW ORLEANS ATLANTA Tri-Stat MUAM MIAMI NEW ORLEANS SOUTH PUNI FUNI EL PASO SOUTH MANHATTAN NORTH MIAM FUHI NEW ORLEANS SOUTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH Arkansas SOUTHWEST LOUISVILLE SOUTH MANHATTAN NORTH MIAM FUMI LOUISVILLE SOUTH BRONX NORTH NEW ORLEANS SOUTH MANHATTAN NORTH Territory SOUTH FLORIDA Tax Type 1099 1099 W2 ARKANSAS LOUISIANA ATLANTA NORTHGW2 MISSISSIPPS 1099 SOUTH FLORIDA 1099 SOUTH FLORIDA 1099 LOUISIANA W2 SAN ANTONIO 1099 DOWNSTATE NEW W2 SOUTH FLORIDA 1099 LOUISIANA W2 DOWNSTATE NEW W2 DOWNSTATE NEW Wa DOWNSTATE NEW W2 DOWNSTATE NEW W2 DOWNSTATE NEW W2 DOWNSTATE NEW wz DOWNSTATE NEW wa 1099 ARKANSAS KENTUCKY DOWNSTATE NEW W SOUTH FLORIDA WZ KENTUCKY 1099 DOWNSTATE NEW 1099 LOUISIANA W2 DOWNSTATE NEW W2 Taxi ******* ****** K*XXX ******** xxxxxxxxxX XXXxxxXXXX kxxxxxxxX KAKER XXXXXXXX K KKKKK *XXXXXXX XXXXXXX ******** wxxx.co xxxxxxxx 0000000 KALLX xxxxxxxx xxx XXXXXXXX xxxxxxxxx wwxx.com *XXXXXXX Total Contracts Total Sales Total Cancellations 。 S 10 9 3 1 9 1 0 18 14 16 4 9 3 18 16 O 2 16 4 1 2 16 50.00 $10,000.00 $0.00 $7,000.00 $4,000.00 $500.00 $2,000.00 $1,000 00 50.00 $7,000.00 $1,000.00 $0.00 $20,000 00 $10,000.00 $50,000.00 $5,000.00 $10,000.00 $7,000.00 $20,000.00 50.00 $900.00 $20,000.00 $5,000.00 $20,000.00 $0.00 $0.00 $20,00000 3 10 3 0 0 5 0 0 5 13 11 0 0 2 0 0 10 0 0 0 0 0 0 0 2 0 Extract Date Sales Consultan SC Last name 7/1/2020 26354410 Smith 7/1/2020 4027830 Nova 7/1/2020 26621106 A 7/1/2020 66464567 Wire 7/1/2020 41107218 Buster 7/1/2020 26354410 Smith 7/1/2020 57575758 Frank 26621106 A 7/1/2020 7/1/2020 $3748200 Travas 7/1/2020 26150025 Jones 7/1/2020 26152889 Smith 7/1/2020 26621106 A 7/1/2020 26526109 Priter 7/1/2020 26161204 Ure 33255099 York 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 7/1/2020 26520168 3535335 Rucco 26457518 Hansen 35265980 Manute 33407197 Heston 33011618 K 26525752 Regan 26356778 Dimit 33155393 Williams 33253704 Amisher 26621106 An 12658262 Werever R SC First Name State Debbie Jeremy S Micah Ra Carol P Jacqueline M Debbie Benjamin Micah Rae Francisco A Jennifer Debbie Micah Rae Yan Alex V William Adriano F Vanessa Victor Kelly David N Andres A Enrique Clarence Ash T Micah Rae trick LA GA MS K PL LA TX NY K LA NY NY NY NY NY NY NY AR KY NY PL KY NY LA NY Region FUHI SOUTHWEST SOUTH SOUTH SOUTHWEST Office MIAM Arkansas NEW ORLEANS ATLANTA Tri-Stat MUAM MIAMI NEW ORLEANS SOUTH PUNI FUNI EL PASO SOUTH MANHATTAN NORTH MIAM FUHI NEW ORLEANS SOUTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH MANHATTAN NORTH Arkansas SOUTHWEST LOUISVILLE SOUTH MANHATTAN NORTH MIAM FUMI LOUISVILLE SOUTH BRONX NORTH NEW ORLEANS SOUTH MANHATTAN NORTH Territory SOUTH FLORIDA Tax Type 1099 1099 W2 ARKANSAS LOUISIANA ATLANTA NORTHGW2 MISSISSIPPS 1099 SOUTH FLORIDA 1099 SOUTH FLORIDA 1099 LOUISIANA W2 SAN ANTONIO 1099 DOWNSTATE NEW W2 SOUTH FLORIDA 1099 LOUISIANA W2 DOWNSTATE NEW W2 DOWNSTATE NEW Wa DOWNSTATE NEW W2 DOWNSTATE NEW W2 DOWNSTATE NEW W2 DOWNSTATE NEW wz DOWNSTATE NEW wa 1099 ARKANSAS KENTUCKY DOWNSTATE NEW W SOUTH FLORIDA WZ KENTUCKY 1099 DOWNSTATE NEW 1099 LOUISIANA W2 DOWNSTATE NEW W2 Taxi ******* ****** K*XXX ******** xxxxxxxxxX XXXxxxXXXX kxxxxxxxX KAKER XXXXXXXX K KKKKK *XXXXXXX XXXXXXX ******** wxxx.co xxxxxxxx 0000000 KALLX xxxxxxxx xxx XXXXXXXX xxxxxxxxx wwxx.com *XXXXXXX Total Contracts Total Sales Total Cancellations 。 S 10 9 3 1 9 1 0 18 14 16 4 9 3 18 16 O 2 16 4 1 2 16 50.00 $10,000.00 $0.00 $7,000.00 $4,000.00 $500.00 $2,000.00 $1,000 00 50.00 $7,000.00 $1,000.00 $0.00 $20,000 00 $10,000.00 $50,000.00 $5,000.00 $10,000.00 $7,000.00 $20,000.00 50.00 $900.00 $20,000.00 $5,000.00 $20,000.00 $0.00 $0.00 $20,00000 3 10 3 0 0 5 0 0 5 13 11 0 0 2 0 0 10 0 0 0 0 0 0 0 2 0