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

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 the scenes …..behind the vis isualis isation

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

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

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

Ingestion - Rest

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

Ingestion – Sample JSON

Ingestion - Results

Ingestion - Generated Sample

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

The right data is available - Checks

The right data is available - Change

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

Getting the right data out

Getting the right data out

Getting the right data out - Integrate

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.