best practices for uploads of data, chunking data, internal POCs
Grid components Weds next week, show stat data, talk Errors
Internal stat reporting team
getting faster at it
Crime being worked on
finishing up commercial property
Complete - place in the DB to handle putting stat data, way to decode the stat records to make them human readable
homeowners, dwelling property, personal and commercial auto
OLGA data quality checking - component - loading of positional data records into DB, thought process was more straightforward - loading of data isn't a major task as managing data quality?
no small tasks
simple one line of stat record into one table, simple as 50 attribute table is to load
intricate and time consuming, stat plan, ref tables
whats code 3 code 4 code 2
paid loss vs premium - ref table and analysis work more challenging than tech side of it is
Ref tables to expand codes, anticipated based on definitions, set in advance? Ref data tables "this code means this description for this line of business" - they wouldn't change - per line effort - the loading of the data, relates to description of what carrier needs to do to load data - loading of table is a first step
ETL on load, auto three digit date implies month/year and convert to ISO data, some of that, scripts for that
Sourcing harder than loading
can we get carrier involved for MS POC to use it?
Team talking to had the right permissions and could produce the dataset, for short term using BOX for data shipping and Peter loads into via OLGA
Carrier a reporting team and sharing data but if scripting, diff engineering team and more complexity
Data team vs IT team
need to inc an IT capability, will need to map those codes
level of engagement, participation
MS POC
talked to carrier, getting sense of what the work is
open and another meeting on the 10th
do loss codes need to be transformed? maybe, not like stat reporting but will be some work
NodeBuilder
current plan - varying degrees of completion
House calls - 1:1 sessions with carriers to get them thru completion, get each to have a node on the openIDL Network
Dependency killer - dont think need working nodes to spin up HDSs, use OLGA as a test harness - figure out baseline for setting up node