Please enable JavaScript.
Coggle requires JavaScript to display documents.
MAX Data Model 2025 Mar 18 - Coggle Diagram
MAX Data Model
2025 Mar 18
Use cases within MAXSys2
As a Reporting Solution
Personas
Venues
DMS users/ Help desks
Regulators
Technicians
L3 Support teams
L2 Support teams
Support staff
What sources of information to be used need to be identified
Operational Views or live dashboards
Floor View
These views are rapidly changing
For how long (duration) ? what next afetr the period
Performance, a key factor
Configuration purposes
IMac
Software Catelogue
Approval requirements
Data lake
Data that needs projection and
Data that is not readable and data is not readable directly which need other data
How data can be used
Data that can be used as it is
EGM Status data?
Data that needs massaging/ transformed before use
ETL Requirements
Corelated data
Meter Read data ?
Data that needs to be used with other data to make sense
Current Technologies used
Redshift
ODS
Mongo DB
Not heavily used ?
How data is/ should be stored
Structured
Examples
Unstructured
Semi structured
Integration requirements
Type of use
Internal
External
To be provided to CMAC
What else
When do we the reporting
Tech Strategy discussion on28th March
Self serving capability
Tableau
Power BI
Actionable and non actionable reprots
Actionable
Live data
Non actionable
Can provide the tool so users could do ad hoc reporting
AT the moment we handroll all the reports
Some reports have to be standardized
Regulatory data feed
we do have a pattern here
What we use in TAS is not ideal
provide operational data nevertheless
Two options
lite version and full blown option
End to end cost needs to be considered
Additioanal cost
Develop future reports while keeping the data platform end state in mind
Migration Requirements
Maxsys 1 reports
Analysis to be done
To be retired
To be migrated as is
To be served with a standard report elsewhere - Might loose a few fields, etc
To be served via a self serving platform
Tableau?
Power BI?
MAX Web Portal
User management
View invoice
What are the other functionality convered by portal