Download - Jonathan Moxham, Head of Analytics and Data Strategy, British Red Cross - CDO Europe 2017
Altius PowerPoint Template
Implementing a Strategy for Data Centric Transformation at the British Red Cross
#
Introduction and context - Red Cross and Red Crescent
#
British Red Cross What we do and why we do it
#
What does that mean in terms of data?Complexity and variety
Disparate systems of capture
Data quality, people and culture
SensitivityMedical recordsDestitute individuals personal details
Large volumes of individuals and financial transactions6million supporters on our fundraising database100millions of marketing approaches and financial donations
Data privacy and consent
#
Earning the Right to Data Centric GrowthRevenue growth through Individuals
#
Earning the Right to Data Centric GrowthChange in Leadership
#
Earning the Right to Data Centric GrowthApproach
Define the roadmapBuild the visionBusiness AnalysisReview Source Systems and DataPlanning
#
Scope of the project quite wide intentionally as data can be used in a multitude of ways and for a variety of reasons across the organisation.
Outline a vision
Core principles grow over time as we grow
Earning the Right to Data Centric GrowthVisionOutput &OutcomeFinancial & People PerformanceAudienceEngagementWe will use data to understand outputs, improve outcomes and increase impactWe will use data to increase access to time, talent and treasure"We will use data to ensure we are targeting our financial and people resources effectively"
#
Earning the Right to Data Centric GrowthPrinciplesGOVERNANCE
STANDARDSITERATIVETECHNOLOGYPEOPLE
#
Earning the Right to Data Centric Growth Key user groups served
Pyramid shows recommended breakdown for information consumption.
Analyst / ProducerUser Profile:Analysts derive insight for others to consumeConsumption Types:Ad-hoc analytics, data science, report and dashboard creationExample Teams:Innovation and Insight, Fundraising BI Analysts, Finance, Retail, HR and Digital Analysts .Estimated Number of Users: 30 - 50Insight ConsumerUser Profile:Role based content with some flexibility where appropriateConsumption Types:Dashboards / Mobile / Some Ad-hoc reporting.Example Teams:Exec BoardDirectorsRegional and Line ManagersEstimated Number of Users: 300-500Information ConsumerUser Profile:Extended users with standard output with role specific detailConsumption Types:Role Specific fixed content
Example Teams:Service delivery teamsVolunteers
Estimated Number of Users: 1000+
#
Earning the Right to Data Centric Growth How it may feelPotential impact on the different roles in the business.CIOCEOI can see that impact we are having with our services across the UK.Exec Director of ServicesI can see which services are performing well and where we have unmet need.Director of Individual GivingService DeliveryCFOI can effectively measure the financial performance of our social enterprises and cost to deliver our services.I can leverage data from across different Red Cross departments to drive increased fundraising and engagement. Data is secure and well governed. Business users and analysts are enabled through self service.I can see simple metrics on the output and outcomes we are delivering as a team.ServiceAnalystFinance AccountantI can get quick and easy access to financial data and can drill down to individual transactions to identify route cause. I can quickly access appropriate data across the organisation and my time is spent deriving insight rather than moving and integrating data.
#
Earning the Right to Data Centric GrowthFoundations
PeopleTechnologyProcesses & FrameworksPeople with the requisite skills will maximise the potential of our data.
Frameworks and processes will protect the data and ensure we have the right level of quality.The deployment of the right technology will unlock the opportunity to use our data to help us grow.
#
Earning the Right to Data Centric GrowthSummaryVision
Understand the current situation technology, data, people and processes
Gain credibility through POCs - be aware of how to operationally deliver too!
Be bold and fearless you are a change agent
Build foundations data access, data quality, limited data
Watch for in-flight data projects work with your PMO
Change is always going to hit some resistance focus on the change culture
Search for a quick visible early momentum as a lot of the data foundations will take time
#
Impact of Digital and Data - Big Data
#
Impact of Digital and Data DW Approachdata warehousing has reached the most significant tipping point since its inception. The biggest, possibly most elaborate data management system in IT is changing.GARTNER, THE STATE OF DATA WAREHOUSING IN 2012
DashboardsReportingBI AND ANALYTICS
DATA WAREHOUSE
ETL
DATA SOURCES
OLTPERPCRMLOB
#
2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.2/22/201715
1 Increasing data volumes2 New data sources and types3 Real-time data4 Cloud-born data and hybrid IT infrastructure
DashboardsReportingBI AND ANALYTICS
DATA WAREHOUSE
ETL
DATA SOURCES
OLTPERPCRMLOB
DATA SOURCES
OLTPERPCRMLOB
Web LogsGeo LocationNoSQLServer LogsNON-RELATIONAL BATCH DATA
DevicesWebSensorsSocial
REAL-TIME DATAImpact of Digital and Data The Challenges
#
2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.2/22/201716
Impact of Digital and Data - the 5 drivers of technology changeThese factors open up a wealth of different options for storing, analysing and understanding data but they also mean that traditional approaches are no longer optimal.++++
Lots of dataFast NetworksCommodity StorageElastic ComputeFree software
#
Impact of Digital and Data - Evolving Approaches to AnalyticsEDWs to Data PlatformETL Tool(SSIS, etc)
EDW(SQL Svr, Teradata, etc)ExtractOriginal DataLoadTransformed DataTransformOLTP
ERP
LOB
BI ToolsData MartsData Lake(s)
DashboardsApps
#
2/22/201718 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Impact of Digital and Data - Evolving Approaches to AnalyticsEDWs to Data PlatformETL Tool(SSIS, etc)
EDW(SQL Svr, Teradata, etc)ExtractOriginal DataLoadTransformed DataTransformOLTP
ERP
LOB
BI ToolsData MartsData Lake(s)
DashboardsAppsDevicesWebSensorsSocial
Ingest (EL)Original Data
Scale-out Storage & Compute(HDFS, Blob Storage, etc)
Transform & Load
Streaming data
#
2/22/201719 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Impact of Digital and Data - Evolving Approaches to AnalyticsEDWs to Data PlatformETL Tool(SSIS, etc)
EDW(SQL Svr, Teradata, etc)ExtractOriginal DataLoadTransformed DataTransformOLTP
ERP
LOB
BI ToolsData MartsData Lake(s)
DashboardsAppsDevicesWebSensorsSocial
Ingest (EL)Original Data
Scale-out Storage & Compute(HDFS, Blob Storage, etc)
Transform & Load
Streaming data
#
2/22/201720 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
SYSTEMSIDENTITY + SECURITY OPTIMISATIONSTREAM ANALYSISLOGGINGBritish Red Cross Data Platform Proof of ConceptBRCS MANAGEDTOOLSORCHESTRATIONDATA LAKE
POWERPIVOT / QUERY
DATA FACTORY
BROWSERLOG ANALYTICS
AZURE SQL DATABASE(DATA WAREHOUSE)
DATA LAKE ANALYTICS
TRANSFORMATION
BLOB STORAGE(RAW)
REFERENCE DATABASE
DATA LAKE STORE (CLEAN & PREPARE)
3RD PARTY / PUBLIC DATA
TABLEAU
PUBLIC DATAMOBILE
LOBS
AZURE ACTIVE DIRECTORY
POWER BIEVENT HUBSTREAM ANALYTICSBRCS DONATIONSWEBSITE (AWS)STREAM ANALYTICS
WEB DONATION
#
Case Study - Website Transformation
#
Case Study - Website Transformation
#
Case Study - Website TransformationReal and Near Real Time Data
Blob Storage (raw)AWS and Azure APIConnector
SQL Database
#
Case Study - Missing Maps A mapping revolution that is saving lives
#
Case Study - Missing Maps A mapping revolution that is saving lives
#
Case Study - Missing Maps A mapping revolution that is saving lives
#
Thank youFor more information, please [email protected] | Jonathan Moxham LinkedIn
#