Analytics Presentation

Business Analytics Report

ID 19091154

ANALYSIS OF THE GROSS PROFIT STATUS OF VUE ENTERNTAINMENT

12. Further Studies

6. Correlation & Regression Analysis

11. Conclusion

5. Descriptive Statistics

10. Data Modelling

4. Data Pre-processing

9. Forecasting

3. Objectives

8. Multiple Regression Analysis

2. Problem Identification

7. Multiple Correlation Analysis

1. Introduction

index

Introduction

• 500 Screens

50 MOVIE THEATRES

• Located in the United Kingdom

Vue cinemas

• Measuring the performance of the company

Problem Identification

Objectives

Defining and analysing relevant gross profit data requirements within the business’ processes by applying appropriate data modelling techniques

Applying appropriate forecasting techniques and determining the most accurate forecasting technique to estimate future occurrences in gross profit

Identifying any past relationships between gross profit and other business parameters by applying relevant correlation and regression analysis techniques

Determining summary statistics of their gross profit data from 2006 to 2020 by applying relevant data summary techniques

Applying pre-processing techniques to the available data

Null Hypotheses

i. No summary statistics can be determined from the gross profit data of Vue Entertainment Limited generated from 2006 to 2020. ii. There are no past relationships between gross profit of Vue Entertainment Limited and other business parameters. iii. No forecasting technique can accurately estimate future occurrences in the gross profit of Vue Entertainment Limited. iv. There are no relevant gross profit data requirements within Vue Entertainment Limited’s business processes.

DATA Pre-Processing

Figure 2.

REPLACED

Figure 1.

INVALID DATA

PRE-PROCESSING - CONDITIONAL FORMATTING

Figure 4.

Figure 3.

Period

Bar Chart

visualisation of data

figure 6.

Box Plot

Figure 5.

Profit of Vue Entertainment

Summary

Figure 7. Data Analysis

DESCRIPTIVE statistics

Profits

33%

67%

IS vue on target profit wise?

Figure 9.

Figure 8.

r = 0.8991

Correlation and Regression Analyses(PROFIT AND COST OF SALES)

Figure 11.

Figure 10.

r = 0.7899

Correlation and Regression Analyses(PROFIT AND ADMIN EXPENSES)

Figure 13.

Figure 12.

r = 0.6930

Correlation and Regression Analyses(PROFIT AND Number of employees)

Figure 15.

Figure 14.

r = 0.8479

Correlation and Regression Analyses(PROFIT AND Wages & Salaries)

Figure 17.

Figure 16.

r = 0.5368

Correlation and Regression Analyses(PROFIT AND SHAREHOLDER FUNDS)

Figure 19.

Figure 18.

MULTIPLE CORRELATION ANALYSIS

Figure 20.

adjusted r square

Figure 21.

Multiple Regression Analysis of the Business Parameters (1)

Figure 22.

Multiple Regression Analysis of the Business Parameters (2)

Figure 23.

Multiple Regression Analysis of the Business Parameters (3)

Forecasting for the period November 2016 to November 2020

Figure 24.

Forecasting

Forecast Sheet Method

Figure 25.

Figure 26.

Forecasting Techniques

Comparing the accuracy of ‘Solver’ generated alpha factor, Forecast Sheet, mean, naïve, and moving average estimations

Forecasting to Predict Future Occurrences in Gross Profit

Figure 28.

Predicting Trends in Gross Profit by Forecast Sheet

Figure 27.

Figure 30.

Figure 29.

Mean Absolute Percentage Error (MAPE)

Figure 33.

Figure 32.

One-Way Table

Data Modelling

Gross Profit Model for Vue Entertainmennt Limited

Figure 31.

What-If Scenarios

Figure 35.

Figure 34.

Figure 36.

Data Modelling - Economic Value of a vue Customer

Two-way table

Conclusion

The general conclusion is that, gross profit status of the company can be analysed using appropriate business analytics techniques. Specific conclusions that have been made are as follows;- Summary statistics can be determined from the gross profit data of Vue Entertainment Limited generated from 2006 to 2020. - There are past relationships between gross profit of Vue Entertainment Limited and other business parameters. - Naive forecasting technique can accurately estimate future occurrences in the gross profit of Vue Entertainment Limited. - There are relevant gross profit data requirements within Vue Entertainment Limited’s business processes.

* Include 2021 data in the study to bring more insight* Find out if there any other variables (macroeconomic variables like GDP and disposable income) affecting the gross profit * Use data from other regions in order to find out where to expand the business * Using the data from 2006 figure find out ways to recover, apply the same strategies and monitor the effects

Further Studies

That's all Folks!

THANK YOU FOR WATCHING!