TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pagei JMP Connections (cid:2) (cid:2) (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pageii Wiley & SAS Business Series The Wiley & SAS Business Series presents books that help senior-levelmanagerswiththeircriticalmanagementdecisions. TitlesintheWiley&SASBusinessSeriesinclude: Analytics:TheAgileWaybyPhilSimon AnalyticsinaBigDataWorld:TheEssentialGuidetoDataScienceandIts ApplicationsbyBartBaesens APracticalGuidetoAnalyticsforGovernments:UsingBigDataforGood byMarieLowman BankFraud:UsingTechnologytoCombatLossesby Revathi Subrama- nian (cid:2) BigDataAnalytics:TurningBigDataintoBigMoneybyFrankOhlhorst (cid:2) Big Data, Big Innovation: Enabling Competitive Differentiation through BusinessAnalyticsbyEvanStubbs BusinessAnalyticsforCustomerIntelligencebyGertLaursen BusinessIntelligenceApplied:ImplementinganEffectiveInformationand CommunicationsTechnologyInfrastructurebyMichaelGendron Business Intelligence and the Cloud: Strategic Implementation Guide by MichaelS.Gendron Business Transformation: A Roadmap for Maximizing Organizational InsightsbyAimanZeid ConnectingOrganizationalSilos:TakingKnowledgeFlowManagementto theNextLevelwithSocialMediabyFrankLeistner Data-Driven Healthcare: How Analytics and BI Are Transforming the IndustrybyLauraMadsen Delivering Business Analytics: Practical Guidelines for Best Practice by EvanStubbs (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pageiii Demand-DrivenForecasting:AStructuredApproachtoForecasting,Second EditionbyCharlesChase Demand-Driven Inventory Optimization and Replenishment: Creating a MoreEfficientSupplyChainbyRobertA.Davis Developing Human Capital: Using Analytics to Plan and Optimize Your Learning and Development Investments by Gene Pease, Barbara Beresford,andLewWalker The Executive’s Guide to Enterprise Social Media Strategy: How Social NetworksAreRadicallyTransformingYourBusinessby David Thomas andMikeBarlow EconomicandBusinessForecasting:AnalyzingandInterpretingEconomet- ric Results by John Silvia, Azhar Iqbal, Kaylyn Swankoski, Sarah Watt,andSamBullard Economic Modeling in the Post Great Recession Era: Incomplete Data, Imperfect Markets by John Silvia, Azhar Iqbal, and Sarah Watt House (cid:2) EnhanceOil&GasExplorationwithDataDrivenGeophysicalandPetro- (cid:2) physicalModelsbyKeithHoldawayandDuncanIrving ForeignCurrencyFinancialReportingfromEurostoYentoYuan:AGuide toFundamentalConceptsandPracticalApplicationsbyRobertRowan HarnessOilandGasBigDatawithAnalytics:OptimizeExplorationand ProductionwithDataDrivenModelsbyKeithHoldaway HealthAnalytics:GainingtheInsightstoTransformHealthCarebyJason Burke HeuristicsinAnalytics:APracticalPerspectiveofWhatInfluencesOurAna- lyticalWorldbyCarlosAndreReisPinheiroandFionaMcNeill HumanCapitalAnalytics:HowtoHarnessthePotentialofYourOrgani- zation’sGreatestAssetbyGenePease,BoyceByerly,andJacFitz-enz Implement, Improve and Expand Your Statewide Longitudinal Data System:CreatingaCultureofDatainEducationby Jamie McQuiggan andArmisteadSapp Intelligent Credit Scoring: Building and Implementing Better Credit Risk Scorecards,SecondEdition,byNaeemSiddiqi JMPConnectionsbyJohnWubbel (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pageiv KillerAnalytics:Top20MetricsMissingfromyourBalanceSheetbyMark Brown MachineLearningforMarketers:HoldtheMathbyJimSterne On-Camera Coach: Tools and Techniques for Business Professionals in a Video-DrivenWorldbyKarinReed Predictive Analytics for Human Resources by Jac Fitz-enz and John MattoxII Predictive Business Analytics: Forward-Looking Capabilities to Improve BusinessPerformancebyLawrenceMaiselandGaryCokins Profit Driven Business Analytics: A Practitioner’s Guide to Transforming Big Data into Added Value by Wouter Verbeke, Cristian Bravo, and BartBaesens RetailAnalytics:TheSecretWeaponbyEmmettCox Social Network Analysis in Telecommunications by Carlos Andre Reis Pinheiro StatisticalThinking:ImprovingBusinessPerformance,SecondEditionby (cid:2) (cid:2) RogerW.HoerlandRonaldD.Snee StrategiesinBiomedicalDataScience:DrivingForceforInnovationbyJay Etchings Style&Statistic:TheArtofRetailAnalyticsbyBrittanyBullard Taming the Big Data Tidal Wave: Finding Opportunities in Huge Data StreamswithAdvancedAnalyticsbyBillFranks TheAnalyticHospitalityExecutivebyKellyA.McGuire The Value of Business Analytics: Identifying the Path to Profitability by EvanStubbs TheVisualOrganization:DataVisualization,BigData,andtheQuestfor BetterDecisionsbyPhilSimon TooBigtoIgnore:TheBusinessCaseforBigDatabyPhilSimon Using Big Data Analytics: Turning Big Data into Big Money by Jared Dean WinwithAdvancedBusinessAnalytics:CreatingBusinessValuefromYour DatabyJeanPaulIssonandJesseHarriott For more information on any of the above titles, please visit www.wiley.com. (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pagev JMP Connections The Art of Utilizing Connections In Your Data John Wubbel (cid:2) (cid:2) (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pagevi Copyright©2018byJohnWiley&Sons,Inc.Allrightsreserved. PublishedbyJohnWiley&Sons,Inc.,Hoboken,NewJersey. PublishedsimultaneouslyinCanada. Nopartofthispublicationmaybereproduced,storedinaretrievalsystem,or transmittedinanyformorbyanymeans,electronic,mechanical,photocopying, recording,scanning,orotherwise,exceptaspermittedunderSection107or108ofthe 1976UnitedStatesCopyrightAct,withouteitherthepriorwrittenpermissionofthe Publisher,orauthorizationthroughpaymentoftheappropriateper-copyfeetothe CopyrightClearanceCenter,Inc.,222RosewoodDrive,Danvers,MA01923,(978) 750–8400,fax(978)646–8600,orontheWebatwww.copyright.com.Requeststothe PublisherforpermissionshouldbeaddressedtothePermissionsDepartment,John Wiley&Sons,Inc.,111RiverStreet,Hoboken,NJ07030,(201)748–6011,fax(201) 748–6008,oronlineatwww.wiley.com/go/permissions. LimitofLiability/DisclaimerofWarranty:Whilethepublisherandauthorhaveused theirbesteffortsinpreparingthisbook,theymakenorepresentationsorwarranties withrespecttotheaccuracyorcompletenessofthecontentsofthisbookand specificallydisclaimanyimpliedwarrantiesofmerchantabilityorfitnessfora particularpurpose.Nowarrantymaybecreatedorextendedbysalesrepresentatives orwrittensalesmaterials.Theadviceandstrategiescontainedhereinmaynotbe (cid:2) (cid:2) suitableforyoursituation.Youshouldconsultwithaprofessionalwhereappropriate. Neitherthepublishernorauthorshallbeliableforanylossofprofitoranyother commercialdamages,includingbutnotlimitedtospecial,incidental,consequential, orotherdamages. Forgeneralinformationonourotherproductsandservicesorfortechnicalsupport, pleasecontactourCustomerCareDepartmentwithintheUnitedStatesat(800) 762–2974,outsidetheUnitedStatesat(317)572–3993,orfax(317)572–4002. Wileypublishesinavarietyofprintandelectronicformatsandbyprint-on-demand. Somematerialincludedwithstandardprintversionsofthisbookmaynotbeincluded ine-booksorinprint-on-demand.IfthisbookreferstomediasuchasaCDorDVD thatisnotincludedintheversionyoupurchased,youmaydownloadthismaterialat http://booksupport.wiley.com.FormoreinformationaboutWileyproducts,visit www.wiley.com. LibraryofCongressCataloging-in-PublicationDataisavailable: ISBN9781119447757(Hardcover) ISBN9781119453741(ePDF) ISBN9781119453727(ePub) CoverDesign:Wiley CoverImage:©Thirteen/Shutterstock PrintedintheUnitedStatesofAmerica. 10987654321 (cid:2) TrimSize:6inx9in (cid:2) Wubbel ffirs02.tex V1-09/13/2017 6:41am Pagevii Idedicatethisbooktomymotherandfather,mywifeRosmary Wubbel,andsonLeslieWubbelforalltheirloveandsupport. Iespeciallywanttothankthreestrongladies,sisterstomefor theirguidance,care,andconstructivecomments.Thankstomy bestfriendandsonLeslieforhisreviewsandthemany conversationsandtopicdiscussionsthathelpedmakethisbook possible.Thankstomynieces,especiallyCatherineMintmire,for (cid:2) (cid:2) producingthegraphicartwork.Andfinally,toonumerousto mentionthemanybusinessfriendsandmentorsinsoftware engineeringanddatasciencefieldsincludingPhilipDouglas Brownforhisinsightsandperspectivesonmakingthe connectionsindataforadvancinganalyticalcapabilities. (cid:2) TrimSize:6inx9in (cid:2) Wubbel ftoc.tex V1-09/13/2017 6:41am Pageix Contents Preface xv Chapter1 GeneralizedContextforDecisionProcess Improvement 1 1.1 SituationalAssessment(CurrentState) 3 1.2 ProblemStatement 11 1.3 VisualizingStateTransition 15 1.4 MetricsOn-Demand 20 Chapter2 Real-TimeMetricsBusinessCase 25 2.1 ProjectDescriptionandObjectives—ACase Study 27 2.2 SolutionDescription 31 2.3 CostandBenefitAnalysis 34 2.4 FinancialAssessment 37 (cid:2) (cid:2) 2.5 ImplementationTimeline 42 2.5.1 ContemplatingStartup 42 2.5.2 SkillsDependenciesandTimeline Consideration 44 2.5.3 ImplementationStartingPoint 46 2.5.4 ImplementationtoDeployment 49 2.6 CriticalAssumptionsandRiskAssessment 50 2.6.1 CriticalAssumptions 50 2.6.2 RiskAssessment 51 2.7 Recommendations:TransmigratetheEnterprise 58 Chapter3 TechnicalDetailsandPracticalImplementation 63 3.1 HardwareFoundations 69 3.2 SolutionStack 70 3.3 IntegrationofHardwareandSoftware Infrastructure 72 3.4 BuildOut 72 3.5 TheConstructionofaMetric 79 3.6 MetricCaseStudy 80 ix (cid:2) TrimSize:6inx9in (cid:2) Wubbel ftoc.tex V1-09/13/2017 6:41am Pagex x CONTENTS Chapter4 HarvestingBenefitsandExtensibility 99 4.1 BenefitsExample 100 4.2 Extensibility 101 4.3 ConfigurationManagementVersionControl 102 Chapter5 SoWhatAboutaBadEconomy? 107 5.1 Overachievement—DataVirtualization 110 5.2 JMPConnectionastheUniversalServer 114 5.3 Well-FormedData 117 5.4 LinkedData 120 Chapter6 DecisionStreams 133 Chapter7 DeliveryandPresentations 139 7.1 PushVersusPullDelivery 140 7.2 Presentation 143 7.3 DIY,ButLeavethePoorBiPersonAlone! 156 7.4 AdvancedPresentationMethod 157 Chapter8 InClosing(As-Built) 163 Glossary 169 (cid:2) (cid:2) AppendixA Server-SidePHPCode 173 AppendixB JMPJSLTimeConstantLearningCurve Script 175 AppendixC JMPGUIUserInterfaceCodeExample 181 AppendixD ResourceDescriptionFrameworkFile Example 185 AppendixE SampleHardwareRequirements 191 AppendixF EarlyWarningDeliverable 193 AppendixG JMPPROConnections:TheTransversality oftheCapabilityMaturityModel 203 G.1 TangentialConcept 204 G.2 TransversalConcept 205 G.3 UnivariatetoMultivariateProcessControl 206 G.4 JMPProcessScreening 208 (cid:2) TrimSize:6inx9in (cid:2) Wubbel ftoc.tex V1-09/13/2017 6:41am Pagexi CONTENTS xi G.5 TransversalMaturitySpaceinRelationtoJMP PROFeatures 210 G.6 Summary 212 References 213 SuggestedReading 217 Index 219 (cid:2) (cid:2) (cid:2)