IntroducingTitangeo-serverdatacontainerandservices

GeoffreyClark|2016-03-29|US-WA-SeaClecopyrightLucidata2016

HowtoconnecttotheworldofSupplyChain,LogisKcsandTransportaKon?

OracleTransportaKonManagerMagicQuadrant#1TMSsystem.PurchasedfromG-Log,andevolvedsincethen.Whynotletthemachinesdoit?

UseLucidataTitanserver

Market

TMS

CRM

Lucidata Titan StandardBIFormal,Trusted,Shared,PublicDataExplora6onAd-hoc,AgileExperimental

individualsPowerUsers

Clean,Load&JoinData

FormNewBIQuesKons

AnalyzeData

FindNewData

Analytics User Segments

FIN

YourData

Knowledge,DefiniKons,Hierarchies,RelaKonships

Ad-HocDataPlayground

Standard,IndustryDataIndustry

Reference

ExecuKves,Managers

Analysts,KnowledgeWorkers

TechnicalChallenge,DataIntegraKon CulturalChallenge,UserIntegraKon

HowUniqueisyourdata?*

*isthatasourceofadvantage,orconfusion?

GlobalAll-ModesrouKng

Mk1hasRoadWalkAirSeaRiverMk2hasSpace&Cyber

Whatdoes“ALL”modesmean?

Whydowecare? McLean’sshippingcontainerrevoluKoncutthecostofseabournetradebyafactorof50versusloose-cargostevedoring.--FredSmith,CEOofFedexCorp.viaWSJ.

Weaimtodothesameforsupplychain,logisKcsandtransportaKondata.

How?StandardizaKon.

HowmuchKmedoyouspendcleaningupdata?

Don’tdomanualdataintegraKon!

Wheredoesthedatacomefrom?OurDataFactory

LotsofdataavailableforpurchaseandintegraKon,pendinguponneed.

HowdoesMulK-ModalRouKngwork?

mulK-modalnetworktopologyisacombinaKonofmovementslinkedtogetherinaspaKalnetworktopologywhichcanberoutedasasinglenetwork.Itrequiresyournetworknodesandflowstosetupandworkcorrectlyandquicklyforyoursupplychain.

HowdoIgetlanesrouted? UsethiscallthisservicetoinputanyOriginDesKnaKonpairandselectoneormoremodestogetapathacrossthenetworktopology.SQLaccessviaJDBC,ODBC.Bolt-ontoMSSQLServerviaFDW,orwecancustombuildanAPI.ConnecttoSupplyChainGuruorSCIDandcustomizeyourcosts!

Whatdatabasesdoweuse?

Greenplum4.3MPPandcolumnar

PostgreSQL9.5Row-wiseservice

Geo-SpaKalanalyKcsOmni-modeglobal

rouKng Neo4j+spaKalRDFTriplestore

Data,Metadata,Solware.ExactmanifestandpedigreetobedeterminedatorderKme. Ourreferencearchitecture

supportsstructuringdatain3differentways.

Availablenow

Whatdataisavailable?(parKallist)

Wheredoesthedatacomefrom? Mostly,UncleSam,butglobaldatasetsfrommanyIntra-GovernmentalOrganizaKons

Source,DHL,GlobalConnectednessSurvey

ThePresiden6alOpenDataIni6a6ve

Let’sdemocraKzeUncleSam’sdata!

Whatisinthebox?

TheLucidataTitanisastandardizedcontainerisaserverrunninginyourenvironmenttoprovideareliablereferencedataservices,andsupplychaingeo-analyKcs.Buyitonce,orbuyservicestokeepituptodate.UseittocreatecustomsetsofspaKaldatainfrastructurethatmatchesyoursupplychain.Thisgivesyoutheabilitytogetgranular,routedvisualizaKons,butwithmuchsmallerfilesize.Globallystandardsdata–ISO,UN,ANSI,DOD,NASA,etc...Proprietary,licenseddatastandardsareavailable,butavalidsubscripKonisrequired.Thedataisopendata–copyit,distributeit,integrateit,encryptit...allisOK.Pleasereferencethesource–LucidataInforma=cs.ItisaCentOS6.7virtualmachine,runningPostgreSQL9.5.Yougetsudorightsinlinux,andcreatetablerightsinthe“publicschema”,butwekeepthe“postgres”useraccount.AvailabletointegratetoMSSQLviaForeignDataWrapperODBC/JDBC,XML,JSON,GeoJSON,SQLite,SpaKalLite.•  Data,Metadata,Solware.•  ExactmanifestandpedigreetobedeterminedatorderKme.•  BuildyourdatascienceteamonastrongfoundaKonofdataWewillcustombuildanalyKcsonopensourcetoolsforyou,suchasRstudioandShiny,orlicensedanalyKcstoolslikeTableauorQlik,orheavyweightslikeMicroStrategy,Jaspersol,OBIEE.

Data,Metadata,Solware.

AirExpress,AirCargoflows

Auto-routeyoure-Commerceshipmentfile!SelectyourservicelevelstoseeexpectedrouKng,

servicelevelandcost.

UsethesametechniquesUncleSam

Metadatalibrary

OakRidgeNaKonalLabs,CTA

CustomIntelligence

CompeKKveIntelligenceforLTLtruckingonNetworkTerminalCapacity,asdefinedby“doorpressure”averageloadedorunloadedpoundsperdoorpershil.Thiswasdonewith“mechanicalturk”

laborasbusinessprocessoutsourcing.

MilitaryModelingwithpartners

Howtoaddressthisimbalance?

hCp://www.delphianalyKcs.net/

WhoisLucidata?

•  GeoffreyClark,PrincipalandCEO– DataModeler:logicalandraKonalDW– SoluKonArchitect:analyKcs– Strategy:risks,what-if,sims,wargames

•  AssociatesatLucidata– SeniorDataModeler,requirementsexpert– AdvancedAnalyKcsexperts– SeniorGISanalystsandFOSS4Gevangelists

copyrightLucidata2016

WhatisourVision? •  Wehelpcustomerswrangletheirdata

–  opensourcesolware,automaKonand“bigdatatechniques”havedramaKcallyloweredthecostsforintegraKngdataanddemocraKzinganalyKcs.

–  ifyouhavenotintegratedyourdata,yourcompeKtorsareworkingonit,andtheywanttoeatyourlunch.

•  WeprovideconsulKngservices–  Technicalservicestomanagedataandmetadata.–  Businessmanagementtochangeculture.–  TrainingservicestobuildyouownFTEdatascienceteam.

•  WeprovideData-as-a-ServiceanalyKcsproducts–  KeepyourinvestmentindataschemasuptodateandreadyforstrategicquesKons,especiallythead-hocandunexpected.

copyrightLucidata2016

Whoareourpartners? Partners•  MicroStrategy•  AcKan•  Datamorphosis•  SimaFore•  TheDupuyInsKtute•  MossAdams •  AirTransportResearch

Society•  Tamr•  SpaceCurve

Customers•  GM•  Chrysler•  Con-way•  Takata•  NEC•  LLamasol•  INFORMS•  Classmates•  HiltonWorldwide

We’vebeenworkingthissamedatastandardsproblemsince2001

IndependentConsultants •  WearetechnologyagnosKc,wedonotprofitbyanytechnologypreferenceorrecommendaKon.

•  WerecommendevaluaKngopensourcetechnologywheneverpossible.

•  Wedoformpartnershipswithcompanieswithsuperiorproductsthatwefrequentlyrecommend.

•  WeprefertohavedirectrelaKonshipswithourcustomers,butthisisnotalwayspossible.

•  Wearefrequentlysoldas“seniortalent”,re-brandedbyconsultanciestoimpresscustomers.

copyrightLucidata2016

WhyMicroStrategy? MicroStrategyisaCracKveforseveralreasons:1.  InnovaKonhaswidenedtheavailabledatamanagement

toolssignificantly,thusindependenceandconKnuedR&DandfocusoninteroperabilitywithSQLandNoSQLsoluKonsisavaluablestrategicadvantage.

2.  NoSQLsolutonsareincreasingly“NotYetSQL”(sosaysMichaelStonebraker),whichmeanstheROLAPmodelwillremaininplace.

3.  MicroStrategywritesthebestmachine-generatedSQL.4.  MicroStrategyisEnterpriseClass(vsTableau)

–  ReinforcestheneedforSchema,howdoesthedatarelate?–  SupportsFederaKon,importantforLogicalDataWarehouses–  NowincludesvisualizaKoncapabiliKes*almost*onpar

copyrightLucidata2016

MicroStrategyviewofdata,2016

MicroStrategyNetworkViz

Simulate

Op3mize

Forecast

Derive(datamining)

Summarize&Describe(staKsKcs)

Visualize

Join&Filter(datawarehousing)

Measure&Store(sourcesystems)

En33es&Rela3onships(datamodeling)

BI

EA

STAT

SOR

Analy3

cs

QualityAMATEUR PROFESSIONAL

...restuponthisfoundaKon

WhatisAnalyKcs?

copyrightLucidata2016 31

TheuniverseofData

Wheredidyougetyourinforma6on? Da

tato

Infore

finem

ent

Generatedinsights$$$

Reference Data

Operational Execution Data

Strategic Analytics

Planning Data Forecasts , Orders and Trip Plans

Strategic Planning, What-if Modeling

Competitive Intelligence Game Theory, Simulation

Risk Management Service Provider Management Supply Chain Visibility Exception Management Performance Management Continuous Improvement Predictive Analytics

Production Schedules Optimization Applications

Service Provider Planning Process Improvement

Predictive Analytics

Integration, Validation, ad-hoc Analysis

SupplyChainAnalyKcs

copyrightLucidata2016

WeareEconomists