Sydney Business Analytics Worksheet

User Generated

Wwalz

Business Finance

Sydney University

Description

Description:

This is an individual assignment. It focuses on materials presented up to and including Week 4.

To complete the assignment, you need to:

a) visualise the data set, and

b) create an interactive dashboard.

All your responses are to be presented in the Excel file which you are asked to submit.

The data set is based on actual data provided by RACV Solar. For confidentiality and anonymity

reasons actual data has been manipulated in the assessment task. Following is an introduction to this

scenario and detailed guidelines.

Unformatted Attachment Preview

RACV SOLAR CLIENT DATA Variable Name and Description: RACV Solar Data Set Client ID: Enquiry: Quote Acceptance: Conversion Period: Method of Enquiry (CAT = categorical data) Sales Person: (CAT) Gender (CAT): Location: (CAT) System Size: System Cost: Cost of Current Consumption: Revenue from Surplus: Annual Payoff: Client Satisfaction: Satisfaction Type: (CAT) e and Description: Numbered list from Client 1 to Client 250 Date the client made their first enquiry about purchasing an RACV Solar installation Date the client cmade a commitment to purchase an RACV Solar installation Number of days between the client's first enquiry and their acceptance of the quote from RACV Solar Option chosen by the client to make their first enquiry: - RACV Store, the client came into an RACV Store to enquire about installing a solar electricity system - Website, the client submitted an enquiry about installing a solar electricity system via the RACV Solar website - Other, client enquiry came via a referral from a previous RACV Solar client, or from one of the RACV Solar social medi Client enquiries were managed by one of RACV Solar's three sales people: - Anand - Clayton - Daiyu Client gender was recorded as either Male (M), Female (F), or Prefer (Not To Say) (P) Clients fell into one of three broad locations: - Geelong (the City of Greater Geelong) - Surf Coast, which includes locations on the Bellarine Peninsula and along the coast line to Apollo Bay. - Otway, which includes inland locations to the west of Geelong, including Colac and Camperdown. The capacity of the solar installation to generate electricity, measured in kilowatts (kW) Revenue generated by RACV Solar for installing the system (cost to the client) The amount of money paid by each client to their existing electricity supplier for electricity consumed in the year prior The value of surplus electricity exported by the client to the national electricity grid. The financial benefit to an RACV Solar client following installing a new system, based on the value of electricity no longer imported The experience of RACV Solar clients on a scale from zero (completely unsatisfied) to 100 (completely satisfied). The experience of RACV Solar clients is classified into four different Satisfaction Types: - Unhappy, Satisfaction Rating Extension Request). When requesting an extension, you need to provide evidence to support your request and a draft of the work that you have completed on the assessment to date. You must be able to demonstrate exceptional circumstances. Applications for special consideration after this time must be submitted via StudentConnect. Late submission The following marking penalties will apply if you submit an assessment task after the due date without an approved extension: 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five days after the due date will not be marked and will receive 0% for the task. 'Day' means working day for paper submissions and calendar day for electronic submissions. The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date. Calculation of the late penalty is as follows: • 1 day late (5% penalty): submitted after Monday (4 April 2022) 11:59 pm and before Tuesday (5 April) 11:59 pm • 2 days late (10% penalty): submitted after Tuesday 11:59 pm and before Wednesday 11:59 pm • 3 days late (15% penalty): submitted after Wednesday 11:59 pm and before Thursday 11:59 pm • 4 days late (20% penalty): submitted after Thursday 11:59 pm and before Friday 11:59 pm • 5 days late (25% penalty): submitted after Friday 11:59 pm and before Saturday 11:59 pm The Dropbox closes after 11:59 pm AEST on Saturday 9 April 2022. Support The Division of Student Life (see link below) provides all students with editing assistance. Students who wish to take advantage of this service must be organized and plan ahead and contact the Division of Student Life in order to schedule a booking, well in advance of the due date of this assignment. http://www.deakin.edu.au/about-deakin/administrative-divisions/student-life Referencing Any material used in this assignment that is not your original work must be acknowledged as such and appropriately referenced. You can find information about plagiarism and other study support resources at the following website: http://www.deakin.edu.au/students/study-support Academic misconduct For information about academic misconduct, special consideration, extensions, and assessment feedback, please refer to the document Your rights and responsibilities as a student in this Unit in the first folder next to the Unit Guide in the Resources area of the CloudDeakin unit site. Good luck everyone. All the best, The Unit Team RACV SOLAR CLIENT DATA Variable Name and Description: RACV Solar Data Set Client ID: Enquiry: Quote Acceptance: Conversion Period: Method of Enquiry (CAT = categorical data) Sales Person: (CAT) Gender (CAT): Location: (CAT) System Size: System Cost: Cost of Current Consumption: Revenue from Surplus: Annual Payoff: Client Satisfaction: Satisfaction Type: (CAT) e and Description: Numbered list from Client 1 to Client 250 Date the client made their first enquiry about purchasing an RACV Solar installation Date the client cmade a commitment to purchase an RACV Solar installation Number of days between the client's first enquiry and their acceptance of the quote from RACV Solar Option chosen by the client to make their first enquiry: - RACV Store, the client came into an RACV Store to enquire about installing a solar electricity system - Website, the client submitted an enquiry about installing a solar electricity system via the RACV Solar website - Other, client enquiry came via a referral from a previous RACV Solar client, or from one of the RACV Solar social medi Client enquiries were managed by one of RACV Solar's three sales people: - Anand - Clayton - Daiyu Client gender was recorded as either Male (M), Female (F), or Prefer (Not To Say) (P) Clients fell into one of three broad locations: - Geelong (the City of Greater Geelong) - Surf Coast, which includes locations on the Bellarine Peninsula and along the coast line to Apollo Bay. - Otway, which includes inland locations to the west of Geelong, including Colac and Camperdown. The capacity of the solar installation to generate electricity, measured in kilowatts (kW) Revenue generated by RACV Solar for installing the system (cost to the client) The amount of money paid by each client to their existing electricity supplier for electricity consumed in the year prior The value of surplus electricity exported by the client to the national electricity grid. The financial benefit to an RACV Solar client following installing a new system, based on the value of electricity no longer imported The experience of RACV Solar clients on a scale from zero (completely unsatisfied) to 100 (completely satisfied). The experience of RACV Solar clients is classified into four different Satisfaction Types: - Unhappy, Satisfaction Rating
Purchase answer to see full attachment
Explanation & Answer:
50 Pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

RACV SOLAR CLIENT DATA
Variable Name and Description:
RACV Solar Data Set
Client ID:
Enquiry:
Quote Acceptance:
Conversion Period:
Method of Enquiry
(CAT = categorical data)

Sales Person:
(CAT)

Gender (CAT):
Location:
(CAT)

System Size:
System Cost:
Cost of Current Consumption:
Revenue from Surplus:
Annual Payoff:
Client Satisfaction:
Satisfaction Type:
(CAT)

e and Description:

Numbered list...


Anonymous
Really helpful material, saved me a great deal of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags