For this assessment, you will develop an 8–14 slide PowerPoint presentation with thorough speaker's notes designed for a hypothetical in-service session related to the improvement plan you developed in Assessment 2.

[SOLVED] BUSN 331 Business Analytics II Week 6 Assignment Instructions

$ 75.55

BUSN 331 Business Analytics II Week 6 Assignment Instructions

Description

Report 1. Use The “CustData” Query to create a report that alphabetically lists all customers for Statewide. Include Customer ID, Last Name, First Name, customer type, contract type, & Contract number – Organize the report alphabetically by Customer name (Report Name – CustData)

Order Now
Category:
Order This Paper

BUSN 331 Business Analytics II Week 6 Assignment Instructions

Description

Report 1. Use The “CustData” Query to create a report that alphabetically lists all customers for Statewide. Include Customer ID, Last Name, First Name, customer type, contract type, & Contract number – Organize the report alphabetically by Customer name (Report Name – CustData)

Report 2. Use the “ContrTypeFinancials” Query to create a report that includes Customer ID, Contract number, Contract type, Contract amount, Contract profitability, Profit Generated – Organize the Report by contract type (All Landscape contracts first, then all Swimming Pool contracts following). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Landscape and Swimming pool). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of contract (Landscaping and Swimming Pool installation) for the 2016 fiscal year (Report Name – ContrTypeFinancials)

Report 3. Use the “CustTypeFinancials” Query to create a report that includes Customer ID, Contract ID, Customer type (Commercial or Residential), Contract Amount ($), Contract Profitability (%), and profit Generated ($) – Organize the report by customer

Note: Full answer to this question is available after purchase.
type (All Commercial first, then Residential). Include an average contract amount, average contract profitability, and average Profit Generated at the end of each sub-group (Commercial and Residential). What this provides is an analysis of the relative average contract amount, contract profitability and average profit generated during 2016 by type of customer (Commercial or Residential) for the 2016 fiscal year (Report Name – CustTypeFinancials)

Report 4. Modify the “2016 CustHistory” Query in order to create a report that includes Contract #, Customer Type, Repeat (yes or no), contract Amount ($) and Profit Generated ($) – Organize with “Yes Repeats” first, then “No Repeats” Insert a subtotal of Contract amount for the “Yes Repeat” sub-group and the “No Repeat” Subgroup. (Report Name – RepeatFinancials)

Report 5. Modify the “2016 CustHistory” Query in order to create a report that includes Contract #, Customer Type, Referral (yes or no), contract Amount ($) and Profit Generated ($) – Organize with “Yes Referrals” first, then “No Referrals” Insert a subtotal of the Contract amount for the “Yes Referral” sub-group and the “No Referral” Subgroup. (Report Name – ReferralFinancials).

Read; BUSN311 Week 5 Assignment.

Order This Paper

Reviews

There are no reviews yet.

Be the first to review “[SOLVED] BUSN 331 Business Analytics II Week 6 Assignment Instructions”

Your email address will not be published. Required fields are marked *

Related products

error: Content is protected !!