ISYS3375 Business Analytics

ISYS3375 Business Analytics

Assessment Task 1: Business Analytics Exercises

Assessment Type: Individual written report for 2 cases

Word limit: 1500 words excluding tables and plots. (750 words per case.)

Weighting: 25%

Overview

In this assessment, you are required to submit an individual report for the following two cases:

  1. AuCement
  2. Ambulance Victoria

You are required to provide insights into large datasets for the two cases. You will use appropriate data visualization techniques with interpretations to communicate these insights in a managerial report.

Please note: Each report in the assessment is of equal weighting. Datasets are available for both cases in excel sheet form and attached with this file.

Please note: Datasets provided have been modified for this assessment. You can access the datasets on the assessment page in Canvas.

Learning Outcomes

After completion of this assessment, you should be able to:

  1. Work with real data and gain understanding of type of data available in various organizations.
  2. Apply basic analysis to understand the data in order to provide managerial insights.

Assessment details

Case 1: AuCement (Word limit: 750 words excluding tables and plots.)

AuCement want to research customer satisfaction on a new product across different Australian cities.

They produce many types of cement products at its factory in Sydney which they sell in Sydney, Brisbane, Canberra, and Melbourne.

Six months ago, the company established a new cement facility to produce a new 20Kg packaged cement. The company sells this new product for a competitive price. In every contract the price of the product is partly based on the delivery time.

To investigate sales further, the company surveyed the customers who have purchased this new product and a sample of 50 receipts was selected.

For a better comparison, the delivery time has been scaled through dividing the hours spent for delivering the order by distance (kilometers) travelled and weight (kilograms) of the order.

The AuCement file (available on the Canvas assessment page) contains data showing the customer’s location, the payment type, the scaled delivery time, customer satisfaction, and price for every tonne of this product paid by each of 50 customers.

AuCement would like to get some insights from the collected data. You are required to use descriptive analytics methods to provide insights to the data sets.

Create a managerial report for AuCement

Apply the appropriate descriptive statistics methods to analyse the provided datasets for AuCement. You must include your interpretation of the data in your report.

MUST Include the following in your report:

  1. Executive Summary (In short)
  2. Introduction (In short)
  3. Data-visualization methods including 5 plots/tables that give insights on the AuCement dataset. (For example, use any five of them like Histogram, XY scatter plot, Line chart, Bar chart, Boxplot, stacked area, Pie chart, Pivot tables and so on.
  4. Your interpretation of each table or plot in one paragraph.
  5. Explain each table and figure.
  6. Each paragraph is limited to 150words.
  7. Data analysis and Discussions
  8. Conclusion (In short)
  9. Reference (If applicable)

Remember:

  1. To use concise language
  2. To add titles to diagram axis
  3. Read and follow submission format details below.

Case 2: Ambulance Victoria (Word limit: 750 words excluding tables and plots.)

Ambulance Victoria has requested data on the performance of their Response Time (RT) target.

The RT target is to respond to incidents within 15 minutes for 85% of incidents state-wide. Response time is an important measure of the quality of service that they provide.

The response time is measured from the time that a triple zero (000) call was received until paramedics arrive on the scene. Response times are influenced by many factors including traffic, distance required to travel, availability of ambulances, and demand for the services.

The paramedics designate patients who require urgent paramedic and/or hospital care as “Code 1” and these patients receive a “lights and sirens” response.

The Ambulance Victoria dataset (available from the assessment page in Canvas) provides information regarding the “Code 1” response times for various Local Government Area (LGA) categories during the 3rd quarter of the financial year 2015-2016.

Create a managerial report for Ambulance Victoria

Apply the appropriate descriptive statistics methods to analyze the provided datasets for Ambulance Victoria. You must include your interpretation of the data in your report.

MUST Include the following in your report:

  1. Executive Summary (In short)
  2. Introduction (In short)
  3. Data-visualization methods including 5 plots/tables that give insights on the Ambulance Victoria dataset. (For example, use any five of them like Histogram, XY scatter plot, Line chart, Bar chart, Boxplot, stacked area, Pie chart, Pivot tables and so on.
  4. Your interpretation of each table or plot in one paragraph.
  5. Explain each table and figure.
  6. Each paragraph is limited to 150words.
  7. Data analysis and Discussions
  8. Conclusion (In short)
  9. Reference (If applicable)

Remember:

  1. To use concise language
  2. To add titles to diagram axis
  3. Read and follow submission format details below.

Referencing guidelines

You must acknowledge all the courses of information you have used in your assessments. USE HARWARD STYLE format.

Submission format

The two reports must be uploaded as a single PDF document with Excel data visualisations pasted into the document.

Create your data visualisations in Excel and once completed, use the snipping tool (or similar, CTRL F4 on Mac) to bring the graphs, diagrams or tables from Excel into the report in Word. Then save as a PDF to upload. Don’t compress the PDF as this can make the visuals poor quality.

Upload as one single PDF file via the assignment’s submission page within Canvas.

Academic integrity and plagiarism

Academic integrity is about honest presentation of your academic work. It means acknowledging the work of others while developing your own insights, knowledge and ideas.

You should take extreme care that you have:

  • Acknowledged words, data, diagrams, models, frameworks and/or ideas of others you have quoted (i.e., directly copied), summarized, paraphrased, discussed or mentioned in your assessment through the appropriate referencing methods,
  • Provided a reference list of the publication details so your reader can locate the source if necessary. This includes material taken from Internet sites.

If you do not acknowledge the sources of your material, you may be accused of plagiarism because you have passed off the work and ideas of another person without appropriate referencing, as if they were your own. University treats plagiarism as a very serious offence constituting misconduct. Plagiarism covers a variety of inappropriate behaviors, including:

  • Failure to properly document a source.
  • Copyright material from the internet or databases
  • Collusion between students

WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

Order from Academic Writers Bay
Best Custom Essay Writing Services

QUALITY: 100% ORIGINAL PAPER NO PLAGIARISM - CUSTOM PAPER

Why Choose Us?

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How It Works

  • Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
YOU MAY ALSO READ ...  Discussion Question 1 and 2

About AcademicWritersBay.com

AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.

AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master's degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.

NO PLAGIARISM