PresentationtotheStatePresentationtotheStateInformationTechnologyAdvisoryInformationTechnologyAdvisoryInformationTechnologyAdvisoryInformationTechnologyAdvisoryCommittee(SITAC)Committee(SITAC)Presentedby:LisaFeldner,CIOPresentedby:LisaFeldner,CIOInformationTechnologyDepartmentInformationTechnologyDepartmentInformationTechnologyDepartmentInformationTechnologyDepartmentMarch25,2008March25,2008ProjectRoom/LectureRoomAProjectRoom/LectureRoomA––StateHeritageCenterStateHeritageCenterProjectRoom/LectureRoomAProjectRoom/LectureRoomA––StateHeritageCenterStateHeritageCenterCIOUPDATECIOUPDATELisaFeldner,CIOLisaFeldner,CIOInformationTechnologyDepartment2CONNECTNDUPDATEPamSharp,DirectorPamSharp,DirectorOfficeofManagement&Budget3ConnectND–Initiatives•PeopleSoftApplicationsConnectND–Initiatives•PeopleSoftApplications•Finance•HumanCapitalManagement•Portal•Portal•BusinessIntelligence/DataWarehouse•BusinessIntelligence/DataWarehouse44ConnectND–Finance•Financialapplication9.0UpgradeConnectND–Finance•Financialapplication9.0Upgrade•Upgradingfromversion8.4to9.0•Oracleproductsupport•Endusertraining•Endusertraining•GoLive–May13,200855ConnectND–Finance•FollowingtheFinancialUpgradeConnectND–Finance•FollowingtheFinancialUpgrade•EmployeeExpensemodule•EmployeeExpensemodule•AchemailnotificationtoVendors•V-payment(ach,p-cardorcheck)toVendors66ConnectND–HCMInitiatives•AbsenceManagementprojectConnectND–HCMInitiatives•AbsenceManagementproject•Onlineleaverequests•Displaycurrentleavebalances•Displaycurrentleavebalances•Includesworkflow,approvals&status•PilotAgencies;Tax,SupremeCourt,BND,•PilotAgencies;Tax,SupremeCourt,BND,NDPERS,WSIandOMB•ContractingwithCiberInc.•ContractingwithCiberInc.•Projectstartdate–April,200877ConnectND–Portal•ResourceFinderprojectConnectND–Portal•ResourceFinderproject•EmployeeDirectory–EmployeeContactinfoinfo•RetrievedataalreadyenteredinHRapp•StayinSyncwithActiveDirectory•StayinSyncwithActiveDirectory•Employeeupdatecapabilityrequested8899ConnectND–Portal•ResourceFinderproject’snextsteps;ConnectND–Portal•ResourceFinderproject’snextsteps;•Definescopeoffunctionality•Definescopeoffunctionality•Determineadditionalagenciesthatelecttoparticipate1010BI/DW–PeopleSoftFin&HCM•BusinessIntelligence/DataWarehouseBI/DW–PeopleSoftFin&HCM•BusinessIntelligence/DataWarehouse•UserFriendly/intuitivetooltoaccessandviewdata•Applyapplicationsecurity•Applyapplicationsecurity•Reportarchiving•Adhocreportingcapability1111BUSINESSINTELLIGENCEARCHITECTURETracyKorsmo,BusinessIntelligenceArchitectInformationTechnologyDepartment12BIArchitecture3ComponentsBIArchitecture3Components•BISoftware•Reporting,Analytics,DashboardsandKPI•DataIntegrationSoftware•Toolsusedforextractingdatafromoneormore•Toolsusedforextractingdatafromoneormoresystems,cleaning,transformingandloadingthedataintoawarehouse(ETL)•DataWarehouse•DataWarehouse•Physicalstorageoftransformeddata1314NDBIArchitectureHistoryNDBIArchitectureHistory•2006CiberBIAssessment•RecommendedsoftwareandhardwaretoestablishandadoptstandardsonenterpriseestablishandadoptstandardsonenterpriseproductscomprisingBIsoftware,dataintegrationanddatawarehousesintegrationanddatawarehouses•NDProofofConcept•ValidatedCiberRecommendations•ValidatedCiberRecommendations•EstablisheddirectionforenterpriseBIcomponentscomponents15BISoftwareStandardsBISoftwareStandards•NDBISoftwareVendor•Cognos–primaryenterprisesoftware•SAS–specialsituationsrequiringdatamining,predictiveanalytics,textminingandgeospatialdatadata•Unabletonegotiatereasonableenterprisepricing•SASontheMainframewillnotmigrate•SASontheMainframewillnotmigrate•ITDwillprovideagenciesusingSASontheMFwithindividualdesktopversionsforagencyusersresponsibleforanalyticalanalysistodayresponsibleforanalyticalanalysistoday16BICurrentMarketEventsBICurrentMarketEvents•SinceCiber’sRecommendations•Over18of30someBIvendorshavebeenpurchasedinanindustryconsolidationanindustryconsolidation•Infrastructureandapplicationvendors(Oracle,IBM,Microsoft,SAP)aremergingBIintotheirarchitecturesMicrosoft,SAP)aremergingBIintotheirarchitecturesandeliminatingpure-playBIvendors•Thedataintegration(ETL)andDWarchitecturescontinuetomigrateintotheRDBMSarchitecturescontinuetomigrateintotheRDBMSarchitectures•ConsolidationEffects:futurepure-playBIvendorswillbelefttospecialtycompaniesbelefttospecialtycompanies17AtaGlimpseAtaGlimpse•SAPacquiringPilotSoftware,OutlooksoftandBusinessObjects;•OracleacquiringPeopleSoft,SiebelandHyperion;•OracleacquiringPeopleSoft,SiebelandHyperion;•MicrosoftacquiringProclarity(andthereleaseoftheirPerformancePointSever);theirPerformancePointSever);•SASannouncedastrategicpartnershipwithTeradata(justseparatedfromNCR);Teradata(justseparatedfromNCR);•CognosacquiringAdaytum,Frango,Celequest,Applix18AtaGlimpseAtaGlimpse•IBMbuysCognos•2007aloneMS,Oracle,SAPandIBM•2007aloneMS,Oracle,SAPandIBMcollectivelymovedfromowning25%ofthemarketto65%ofthespacethemarketto65%ofthespace•RumorofMSSAPBuyout(BusinessObjects)Objects)19BISoftwareFutureDecisionsBISoftwareFutureDecisions•CognosremainstheEnterpriseselectedB