BUS5PB Principles of Business Analytics Assignment

Assignment Help Other Subject

Reference no: EM133142855

BUS5PB Principles of Business Analytics Assignment - Descriptive Analytics in Practice

Learning Objective - The aim of the second assignment is to enhance your understanding of business analytics and its implementations in industry. This assignment also provides a chance for you to practise descriptive analytics techniques in the real-world analytics setting. The assignment comprises of two main tasks. The first task is to develop an extensive review report of the landscape of business analytics in industry. In the second task, you are required to work in an analytics case from the real estate market.

Tasks -

Task 1 - Compile a review report (approximately 1000-1200 words) that:

-describes the purpose, importance and role of business analytics in creating strategic value and competitive advantage.

-defines the analytics ecosystem (descriptive, predictive, prescriptive and exploratory analytics) and illustrates how they are adopted by various industries in their key business functions ranging from strategy, marketing and sales, operations (production), customer services, etc.

-illustrates how the data analytics lifecycle can be implemented and in particular, challenges in implementing business analytics and artificial intelligence in an agile business environment.

-demonstrates how Big Tech (Facebook, Apple, Microsoft, Google and Amazon) are leveraging analytics and artificial intelligence to generate organisational value for internal and external stakeholders.

Task 2 - PropertyExperts, a recently formed real estate buyer's advocacy firm is looking to enter the Melbourne property market. The senior management is keen to capitalise on large volumes of historical real estate data to generate insights into various aspects of this booming market. The firm has acquired a relatively large dataset of real estate sales in Melbourne, over 2000 records from 2019. You have been hired as a business analyst to demonstrate the application of descriptive analytics techniques using Excel, in the context of real estate buyer's advocacy. You will be working on two sanitised subsets of data.

Task 2.1 - Identify key descriptive statistics of the property price found in the first dataset given [BUS5PB_Assignment2_Task2_1.xlsx]

a) Perform the initial distribution analysis on 'Price' from the given dataset using the histogram. Make sure to choose the reasonable bin size.

b) Calculate and discuss the key descriptive statistics (mean, median, mode, range, IQR, quartile, skewness, variance, standard deviation) for the 'Price'.

c) Compare the price distribution for 'Eastern Metropolitan' and 'Western Metropolitan'. What can you find out? Perform the outlier analysis on 'Price' for these two areas and identify the price ranges for these outliers. (Hint: Use box plots.)

d) Can you identify which suburbs have the highest and lowest house prices?

Task 2.2 - Perform linear correlation analysis using Excel on the second dataset given [BUS5PB_Assignment2_Task2_2.xlsx]

a) Develop a simple linear regression model using Excel. You need to use 'Price' as the dependent (or response) variable and 'Distance' as the independent (or explanatory) variable. You are required to submit the Excel file.

b) Refine and improve the developed linear regression model. Illustrate and explain why the model is enhanced.

(Hint: Try to focus on the model and/or remove several influential points, use the coefficient of determination and other appropriate metrics to explain.)

Task 2.3 - Write a report (approximately 800-1000 words) to discuss key contributing factors for the property price based on the results obtained from Tasks 2.1 and 2.2.

Extend your analysis from Task 2.2 to include other independent variables available in the given dataset. You may include some external research - use graphs, tables and external references to support your explanation.

Data Dictionary:

Metadata

1. Suburb: Suburb

2. Rooms: Number of bedrooms

3. Price: Price in Australian dollars

4. Date: Date sold

5. Distance: Distance from CBD in kilometres

6. Postcode: postcode

7. Landsize: Land size in square metres

8. Regionname: General region (West, North West, North, North East, etc.)

The referencing style for this subject is APA6.

Attachment:- Assignment - Descriptive Analytics in Practice.rar

Reference no: EM133142855

Questions Cloud

Provide a motivation plan for goggle : Provide a Motivation plan for goggle/amazon company.

Globally distributed pharmaceutical procurement : Guiding teams to work effectively in large, complex global organizations can be daunting. This case study provides an overview of a performance challenge in pha

Does any theory disagree translation method : Does any theory disagree translation method in the classroom for teaching language? Can you provide some examples of article links?

Explain the olympics snowboard sport : Describe and explain the olympics snowboard sport including the venues required?

BUS5PB Principles of Business Analytics Assignment : BUS5PB Principles of Business Analytics Assignment - Descriptive Analytics in Practice - describes the purpose, importance and role of business analytics

How different societies in east asia developed : Discuss how scientific creation theory explains human migration out of Africa and the establishment of civilizations around the world including in East Asia.

Component of workforce management : After reviewing the article, write a critique that addresses and offers your opinion in the following areas:

How do labor unions affect the attitude : 1.) 1.) Is it necessary to have a labor union in the workplace? Why or why not?

Judge a job description and job specification : HR should perform a job analysis. To have a better understanding about the job analysis, you should answer all of the following questions for this assignment:

User Account

All Pages