kris rowley - gsa - presentation at the chief data officer forum, government

D2D BriefingCDO Government Forum

on June 8, 2016

SENSITIVE & PRE-DECISIONAL NOT FOR EXTERNAL DISTRIBUTION

DRAFT for discussion only

June 8, 2016 CDO Forum objectives

Present evolution of data usage in the government over time

Introduce D2D definition & capabilities

Discuss D2D business benefits & key success stories

2



Data usage in the Government continues to shift toward open sources & overwhelming cultural change/support

Past Present/Future

Owner-by-owner data sets

Little to no data driven culture

Analytics as a very narrow focus, important only to “techies”, no

agency-promoted training

Multiple different systems & technical platforms

Open Data/Open Government

• Supportive Legislation: FITARA, DATA Act

• Centralizing from multiple legacy environments

Data-Driven Culture from the Top

• Nurtured agency-wide analytics expertise

• Constant training & change management

3



Various governance groups support D2D efforts on both executive and advisory levels

Executive Working Group

Steering CommitteeDeputy Administrator, Chief of Staff, Deputy FAS and PBS Commissioners, Associate Administrator OGP,

CIO and CFO

Key responsibilities:▪Set overall purpose and scope▪Review Working Team updates

Meeting cadence

Steering Committee will meet every 6-8 weeks

Executive Working Team will

meet every 3-4 weeks

Executive points of contact from each SSO + FO

Key responsibilities:▪Assess options and approaches▪ Facilitate idea generation/implementation▪Ensure adherence to project timelines ▪Support data gathering across offices

Indicates decision-making stream

Indicates analysis and advisory stream

Data Warehouse Consolidation Team

• GSA-IT Working Group• Responsible for guiding/addressing

technical issues related to platform, hosting, and security

• Developing to Data Warehouse Consolidation Roadmap

Data Stewards

• Representatives across GSA that are subject matter experts on their data sets from a technical access, to usability for decision-making

• Informs the Data Warehouse team on priority migration activities

Advisory groups will

meet regularly every 2-4 weeks

Data Visualization and Analytics

• Representative from across GSA skilled in analytical software

• Creating Executive level dashboards on D2D

• Champion and support analytical training across GSA



What D2D IS and what it is NOT

• GSA-wide capability to aggregate data, store securely using latest technology, and develop flexible reports

• Multiple datasets and reports encapsulated within GSA’s D2D portal at https://d2d.gsa.gov

• Core team within GSA IT to drive the effort supported by data stewards/managers agency-wide

• Cultural shift to bring GSA datasets together, ensure consistency of reporting and empower employees at all levels to make decisions based on objective facts

• a dashboard

• a dataset

• a report

• an application

• Some GSA IT “thing” that sits on a server in Kansas

• GSA IT function to “crunch data and present reports”

D2D is not … D2D is …

✓

✗✗✗✗✗✗

✓✓

✓

5

https://d2d.gsa.gov/



D2D supports GSA across the full data lifecycle

Entering data into an application

Report data for specific functional

reasonsData

TransformationAccess data from

origin to be combined

Data Visualization & Analytics

Are

aD

2D In

volv

emen

t

Any software1 used to create an application2 intended to collect and restore data

Includes tapping into a single database to create an executive level report used to make specific functional decisions3

Multiple data sets combined for cross-functional reporting in a logical data warehouse4

Data displayed in a consumable, analytical way by individuals with knowledge of both technical & business line aspects

LowMediumHigh

Level of Involvement

Interested in applying backend storage in new application development in terms of: • What data the

application is storing

• How data may be used for reporting

• Recommend appropriate analytic tools available for need

• Interested in learning about how the data is extracted and transformed to best support overall reporting process

• Interested in learning about the report business rules

Process by which transactional data transformed to warehouse data

• Gather requirements on data transformation to support reporting needs

• Design and develop transformation solution

• Develop both a technology and an environment to build data set connections

• Create opportunity for IT and business to combine for best possible decision making

• Provide technical expertise and create necessary reporting data sources available

• Provide a centralized location where business line information can be stored/shared

• Coordinate a training plan, at various levels, on analytics tools

• Present data across common terminologies, visualizations, data usage, and governance

GSA-specific examples for context1 Alfresco, Salesforce, Oracle 2 CHRIS, Pegasis, GREX, FRPP, GSA Advantage3 Financial reports, human capital reports, construction project status, fleet reports4 Labor projections, construction project status on cost information

6



D2D Portal includes customer, report & dataset tabs that cater to & analyze information from various GSA offices

D2D Portal

Customers Reports Dashboards Datasets• Ability to navigate the

agency and specific offices D2D caters to

• Includes office descriptions & missions, data themes & specific projects

• Collection of information to provide understanding and ultimately analysis pertaining to a specific business initiative

• Often collected into visualizations via dashboards

Provides clear, descriptive views of key performance indictors related to GSA objectives & business efforts across business lines/offices

• Named collections of data extracted from a single source into a flat file

• Usually presented in a tabular form where each column represents a particular variable

Projects & Product Lines

GSA FY14 Federal Aviation Open Data Visualization

PBS Capital Program Information Dashboard

(CPID)

GSA Building Vacancy

CXO

Administrator’s Dashboard

CXO Performance Management

HR Business Partner Report

Examples

Integrated Competition Report

GSA Staff Roster

GSA Leases

FAS Customer Analysis & Research (CAR)

HR Data Warehouse Interim Dashboard



D2D takes traditional data visualization & analytics through a detailed business approachSimplified, generalized analytics process▪Start with a business question▪Gather data/information needed to answer it▪Analyze the data/information to create knowledge▪Act on the knowledge

Simplified D2D visualization process▪Start with necessary data of sufficient quality▪Define the data product’s audience, requirements,

and constraints▪Design a visualization or other data product meeting

all criteria with input from business team▪Validate and roll out to the necessary audience on

the D2D Portal in collaboration with business team

+Training as needed to ensure business goals are met

Priorities and top-line execution



D2D platform has many business benefits, such as data management & organization decision-making

D2D Business Benefits• Allows data and information management

multi-dimensionally

• Provides a framework to architect and manage the entire “Data -> Information -> Knowledge-> Decision” path

• Gives ability to support data marts which empower specific teams, groups, or departments to manage their own data and perform cross-functional analytics/reporting

• Enable business analysts and managers to make data-driven decisions based on real-time information and pre-built data queries covering necessary areas.

9



Success stories: CXO SLA Dashboards

Challenge Solution Current Status

Inconsistent depth of data understanding on CXO level

Lack of cross-office collaboration on data sharing

Inconsistent understanding of scope, quality & responsibility within agency service-level agreements

Deputy Administrator suggested drive for consistency in reporting

Created landing page jointly developed by four different offices initially launched by D2D:-Human Resources Management (OHRM)-GSA Information Technology (IT)-Administrative Services (OAS)-Chief Financial Officer (OCFO)

KPI & targets set for the year

Identified calendar of drill downs

Coordinated cross agency trainings to utilize dashboards

10

Q1 Meeting w/ Deputy Administrator

Q2 drilldowns in progress & scheduled for deployment



Success stories: Administrator Travel Dashboards

Challenge Solution Current Status

Lack of real time data during Administrator trips

Frequent meetings with local governments on PBS & FAS matters

Existing efforts present data deep in multiple dashboards across business lines & offices- no centralized location

Initial development of OGP "ad-hoc" dashboards for lease & acquisition info

Now developed centralized access to FAS Contracts & GSA Real Property drill downs for:• Boston• Cleveland• Detroit • New York city• Indianapolis• Washington, D.C.

Accessible via Administrator Dashboard inventory

11

Initial dashboards pushed to Staging in early March 2016

Additional additions scheduled as travel schedule develops

kris rowley - gsa - presentation at the chief data officer forum, government

Data & Analytics