Miral [TLP/BU/PROC/Capex]

Scope

  1. TLP/COC onboarding
  1. Retrofit of MX procurement dashboards
  1. Retrofit of MX Capex dashboards
  1. Maintain, Retrofit & develop YAS Asset Management Procurement Dashboards
  1. Miral LLC Budget Utilization dashboards

Expected Project Implementation Timelines by Dec 2024

Expected Roles

PM

BA

SA

Engineering Team

BI

Sr DE + BI + DE

Requirements

  1. TLP
  1. MX Proc
  1. MX Capex
  1. YAM Proc
  1. Budget Utilization

Clarifications

Other Important Requirements

For Oracle Fusion based dashboard viz, Procurement, Capex Utilization and Budget Utilization dashboard, the vendor should have resources who have the expertise in the functional consultants in the domain of Finance and Procurement in Oracle Fusion who will assist during the requirements phase. There should also be technical expertise to work with the Oracle Fusion as required. This is a must.

• Miral Experiences requires a hybrid on-shore, off-shore approach, with 1 or 2 staff on-site and other developers off-shore for communications and cost effectiveness.

3 months Warrantly

Timelines/Limitations

Attendance and Revenue Dashboards must be operational before the week of TLP Launch (Last week of Sep'24)

Assumptions

  1. General

Specific Assumptions

  1. TLP
  1. MX Proc
  1. MX Capex
  1. Yas Proc
  1. Budget Utilization

Timelines/Limitations

Dec-2024

Timelines/Limitations

Timelines/Limitations

Timelines/Limitations

Dec-2024

Dec-2024

Dec-2024

Functional Requirements

FS-TLP1

Build Data Source Connections

  1. We assume that Rackspace PM or BA will be responsible for reminding technical system owners to provide access to their systems with the correct configurations. Any delays in fulfilling this request by the Miral TLP users/Team may impact project timelines and this will be recorded in the delay log.

Data Sources

Oracle

Viva Omni

InfoGenesys (IG)

Maximo

EATEC

Sharepoint

QuestionPro

Wifi Access data

SurveyHero

  1. Data pipelines are limited to extract data for the data sources as mentioned in the Appendix B - Source systems for TLP

FS-TLP2

Data Accèss Security

TLP data to be restricted to TLP Staff only. Miral Experiences staff can view the data as well.
Roles will be created for TLP data to be viewed by TLP staff, not other theme park staff.

FS-TLP3

Executive Dashboard - Daily Revenue Report Dashboards (Desktop/Mobile)

• Existing Daily Revenue Report dashboards need to be updated to include TLP data.

• The DRR Dashboards to be updated to include TLP data:

o Revenue Per Hour is needed.

FS-TLP4

Existing Tabular Daily Revenue Report dashboards need to be updated to include TLP data.

FS-TLP5

• To update the Sales data set and include TLP data in the existing Sales dashboard.
• This is the Tableau dashboard that needs to be updated: Sales Dashboard: Summary - Tableau Online

FS-TLP6

• Existing dashboard needs to be updated to include TLP data.
• Hourly Attendance: Hourly Attendance - Tableau Online

FS-TLP7

• The demographics dashboard - all park summary - should be updated to include TLP data.
• The dashboard is located here: Demographics Data: Demographics Dashboard (all Parks) - Tableau Online

FS-TLP8

Executive Dashboard – Length of Stay

• A new dashboard to be created that displays the length of stay of guests

Commercial Dashboards - Retail Sales Dashboard

• The existing Retail Sales dashboard to be updated to include TLP data: Retail Sales Dashboard: Retail Sales Dashboard - Summary - Tableau Cloud

FS-TLP10

Commercial - F&B Sales Dashboard

• F&B Sales dashboard to be updated to include TLP/AAZ data
• A length of stay view to be created for the TLP restaurant, the Japanese Tea Room:
• A reservation tracking view to be created as well:

FS-TLP11

Commercial - TLP Summary Dashboard

• Creation of a dashboard that aggregates important metrics from other dashboards. Requirements will be gathered in consultation with the TLP General Manager to give them a summary of TLP operations.

FS-TLP12

click to edit

FS-TLP13: Maintenance - Labour Hours Report

FS-TLP14: Maintenance - Work Order Analysis Report

FS-TLP15: Maintenance - Breakdown Maintenance Analysis Report

FS-TLP16: Maintenance - Service Request Report

FS-TLP17: Maintenance - Downtime Reports by Exhibit (Show Uptime)

FS-TLP18: Popularity / Throughput – Movement between zones.

FS-TLP19: Demographics Dashboard (with Park filter)

FS-TLP20: GSS/NPS Dashboard (Daily):

FS-TLP21: Health and Safety (HSE) Dashboard

FS-TLP22: Commercial - Inventory Dashboard

FS-TLP23: Self-Service Dataset DRR/Sales/Attendance

FS-TLP24: RMCS Input Files

FS-TLP25: AR Transaction Files

FS-TLP26: Revenue Rules Recognition - Time Slots - TLP