what goes on behind
play

What goes on behind that Visualisation Its more than meets the eye - PowerPoint PPT Presentation

Sep 26, 2022 •238 likes •454 views

What goes on behind that Visualisation Its more than meets the eye So what does this mean? The most eye catching or ple leasing visualisation ..gets the most attention How do we bala lance this How can we trust what we see What happens behind

  1. What goes on behind that Visualisation Its more than meets the eye

  2. So what does this mean?

  3. The most eye catching or ple leasing visualisation …..gets the most attention

  4. How do we bala lance this How can we trust what we see What happens behind the scenes …..behind the vis isualis isation

  5. Building from the ground up Getting th the rig right data a in in • Ingestion • Migration Mak aking su sure th the rig right data a is is avai ailable • Monitoring • Treatment • Reconciliation Getting th the rig right data a ou out • Transformation • Optimisation for the Target and Objective

  6. Getting the right data in • SAS Ingestion Process • Receive Data from State and Commonwealth entities • Data Matching between entities and source system • Golden Record / Record Survivorship • Data Management Schemes • Restful services, JSON, ODATA and SAP

  7. Getting the right data in - STCL INCREMENTAL SAP LOAD PROCESS, with STATE-BASED GOLDEN RECORDS MASTERSOFT State 1 Data APPLY DQ AND APPLY DQ AND SAP DAILY Clustering Rules TBD – NDIA CLEANSING RULES, CLEANSING REGULAR FEEDS State 2 Data DATA Daily Extract – Match & ID data only Pre-Cluster by STATE Agencies PRE-CLUSTERING RULES, CREATE SAP EXTRACT by STATE MATCH FIELDS State 3 Data All data Incl. Plus more States, and Commonwealth, as applicable Match fields MASTERSOFT Resubmitted Data Match & ID fields only New records CLUSTER TO accepted From failed CREATE SAP uploads GOLDEN RECORDS FOR EACH STATE END Yes Clustering Rules TBD STATE 1 GOLDEN CLUSTER SAP EXTRACT, RECORDS NEW NATIONAL Create New Prepare data GOLDEN RECORDS, CRITICAL DATA Record has Execute SAP STATE 2 No NDIS ID, Add for SAP Upload PREVIOUSLY CHECK, e.g. DOD SAP ID? Upload GOLDEN Golden Record (FUTURE!!) ESTABLISHED Separate Master File for RECORDS GOLDEN RECORDS each state STATE 3 GOLDEN Web Service Call, or Web Service Call, or RECORDS Other Access TBD Other Access TBD All Client Data Match Such as Timeout = Retry Pass, & ID Fail, Centrelink Fields OTHER OTHER Timeout only SOURCES TBD SOURCES TBD All data Incl. Match fields Clustering Rules TBD CLUSTER GOLDEN RECORDS FROM NATIONAL MASTER Status? ALL STATES SAP UPLOAD GOLDEN GOLDEN INTO SINGLE AUDIT RECORDS RECORDS MASTER Fail Assess and Resubmit for Excel Spreadsheets Remediate Processing Data

  8. Ingestion - Rest

  9. Ingestion - Methods Methods • GET • POST • PUT • MERGE Data Cleansing • Address ( REST web services)

  10. Ingestion – Sample JSON

  11. Ingestion - Results

  12. Ingestion - Generated Sample

  13. The right data is available • Automated Checks • Treatment of problem data areas, default values, manual adjustment • Reconciliation

  14. The right data is available - Checks

  15. The right data is available - Change

  16. Getting the right data out • Analysis vs Analytics • Optimisation for target and objectives • Role types • Role Metadata

  17. Getting the right data out

  18. Getting the right data out

  19. Getting the right data out - Integrate

  20. Visualise Cas ase 1: : Build ild Cal all Cen entre dash ashboar ard Features – auto reload/refresh every 5 mins that reflects Call Centre stats. i.e. Number of calls, severity etc Cas ase 2: : Regional Med edicare serv service ar area eas visu visualisation Features – maps with shapes and regional outlines (integration with ESRI). E.g. With Dashboard that displayed summarised data such as total Medicare services rendered etc.

Recommend

More recommend