Student’s Name
Institution Affiliation
 

NO

 
 
Sales Process Business Process Map
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Phase 2: Querying Objectives
From the conversation it would be important to query data from the database based on some conditions to be able to measure the company’s performance.
The data can be queried basing on some conditions as follows;

  • Total Sales per salesperson
  • Total customers per salesperson
  • Total sales per model
  • Customers per salesperson
  • Sales per touchpoint used

The following querying objectives should be considered;

  • To determine the salesperson with highest number of customers.
  • To determine the most performing salesperson.
  • To determine the best touchpoint for the customers.
  • To find determine which model the customers are most interested in.
  • To determine which touchpoint attracted many sales.

 
 
 
 
 
 
 
 
 
 
Phase 3: Data model Diagram
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Phase 6: Querying objectives and implication to the dealership
Data Base Management
MEMORANDUM
To:
From:
Date
Ref: Data Base Management
Introduction
The purpose of this meeting will be to highlight the impact of the database management system to the BetaAuto dealer. This discussion is based on the data analysis from the access database and the queries. The main objectives from the previous meeting will be highlighted and their results from the queries analyzed.
 
Query objectives and analysis
From the discussion, the key objectives of the company for data analysis concerning their customers and salespeople can be highlighted. With the database it is possible to get the total sales of each sales person from Mesa and Peoria. With this, it is possible to know the highest performing salesperson as seen from the queries it is clear that Scott is and Bryce are leading in sales with total of 24 and 27 sales respectively while Keith and Lucy reported the lowest number of sales of 10 and 13 respectively.
The data in the database also is able to help the company determine the total number of customers each salesperson has conducted. This could help the company know how the salespeople interact with the customers.  As depicted from the customers per salesperson queries, it is clear that Lucy, matt and Keith had the highest number of customers who visited the auto dealer.
It is also important for the company to be able to measure and evaluate which model has the best sales and from this they can be able to control their stock. From the database queries, it is clear that in Mesa, Accord had the highest number of sales of 22 while in Peoria Element model is the leading with 21 sales. It is also seen that from both mesa and Peoria, CR-V has the least sales of 4 and 3 respectively. This is clear indication of which model to stock more basing on the profit margin that the company can be able to generate.
Having the queried data also helps in focusing the relationship between the total number of customers per salesperson and the total sales. From the data it is a clear indication that having the highest number of customers contacted or visiting does not directly predict high sales. Tim, Lucy and Matt from Mesa and Peoria respectively have the highest number of visiting customers but compared to their sales they are not the leading salespeople.
 
 
 
 
 
 
 
 
 
 
 
 
 
Beta Auto
Student’s Name
Institution Affiliation
 
 
 
 
 
 
 
 
 
 
Phase 1: Customer Visits  Process Map
 
 
 
 
 
 
 
 
 
 
 
 
 

NO

 
 
 
 
 
 
 
 
 
 
 
 
Sales Process Business Process Map
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Phase 2: Querying Objectives
From the conversation it would be important to query data from the database based on some conditions to be able to measure the company’s performance.
The data can be queried basing on some conditions as follows;

  • Total Sales per salesperson
  • Total customers per salesperson
  • Total sales per model
  • Customers per salesperson
  • Sales per touchpoint used

The following querying objectives should be considered;

  • To determine the salesperson with highest number of customers.
  • To determine the most performing salesperson.
  • To determine the best touchpoint for the customers.
  • To find determine which model the customers are most interested in.
  • To determine which touchpoint attracted many sales.

 
 
 
 
 
 
 
 
 
 
Phase 3: Data model Diagram
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Phase 6: Querying objectives and implication to the dealership
Data Base Management
MEMORANDUM
To:
From:
Date
Ref: Data Base Management
Introduction
The purpose of this meeting will be to highlight the impact of the database management system to the BetaAuto dealer. This discussion is based on the data analysis from the access database and the queries. The main objectives from the previous meeting will be highlighted and their results from the queries analyzed.
 
Query objectives and analysis
From the discussion, the key objectives of the company for data analysis concerning their customers and salespeople can be highlighted. With the database it is possible to get the total sales of each sales person from Mesa and Peoria. With this, it is possible to know the highest performing salesperson as seen from the queries it is clear that Scott is and Bryce are leading in sales with total of 24 and 27 sales respectively while Keith and Lucy reported the lowest number of sales of 10 and 13 respectively.
The data in the database also is able to help the company determine the total number of customers each salesperson has conducted. This could help the company know how the salespeople interact with the customers.  As depicted from the customers per salesperson queries, it is clear that Lucy, matt and Keith had the highest number of customers who visited the auto dealer.
It is also important for the company to be able to measure and evaluate which model has the best sales and from this they can be able to control their stock. From the database queries, it is clear that in Mesa, Accord had the highest number of sales of 22 while in Peoria Element model is the leading with 21 sales. It is also seen that from both mesa and Peoria, CR-V has the least sales of 4 and 3 respectively. This is clear indication of which model to stock more basing on the profit margin that the company can be able to generate.
Having the queried data also helps in focusing the relationship between the total number of customers per salesperson and the total sales. From the data it is a clear indication that having the highest number of customers contacted or visiting does not directly predict high sales. Tim, Lucy and Matt from Mesa and Peoria respectively have the highest number of visiting customers but compared to their sales they are not the leading salespeople.