3KPC, INC
transformation simplified...
Case Study: Digital Transformation - Data Analytics & Visualization
$2Bn Job Corps Program, ETA, US Department of Labor (DOL)
RAPID PAPER-DIGITAL INSIGHTS DELIVERY
THE PROBLEM
COMMAND CENTER ANALYTICS PLATFORM
Job Corps is a $1.7 Billion program and is part of Employment Training Administration (ETA) at the U.S. Department of Labor (DOL). Through contract operators, Job Corps oversees and manages performance across 125 Centers, spanning 6 Regions nationwide.
With reduced Federal staff while simultaneously increased number of Centers, the leadership’s strategic plan imperative required investing into data-driven decision-making capability. To improve performance, leadership needed timely insights, comparisons, and trends across major Job Corps functions.
Large proportion of key metrics existed in legacy systems and print form requiring much effort to even perform basic data analytics. Considerable organization inertia went into custom data calls, gathering, manipulation versus decision based on insights.
OUR CHALLENGE
Stand-up comprehensive (strategic, operational) decision-making platform for Job Corps leadership under 12 months.
2-Networks impacting technology, user experience limited due to lack of Single-Sign-On (SSO) capability
Legacy data infrastructure with PDF reports as output
Critical decision metrics in legacy database systems (Sybase)
Reverse engineer business rules from legacy stored procs (Analyzed ~ 35K lines of code as part of Data Assessment)
Reporting-centric legacy data model design limited in dimensional structure versus insights-driven, flexible data model
Lacking visualization environment and infrastructure
TRANSFORM DATA-ACTIONABLE INTEL
OUR APPROACH
1.
2.
3.
4.
Stakeholder interviews to understand critical mission-centric metrics and KPI needs.
Visualization-As-A-Service –Iterative process to define, design, and develop an intuitive UX that supports Executive Leaders with rapid data-driven decision insights.
Data-As-A-Service –Iterative data transformation of legacy data structures to create a flexible data model that powers Tableau Visualizations, from aggregated and summarized Fact Tables and Views.
Repurpose legacy stored procedure rich environment to standup an On-demand DataMart that is flexible and supports aggregation and summarization of data.
5.
Automated DevOps Design –Fully integrated source-target data ETL process, including refresh data in UAT and Production Environment.
THE HOW?
TRANSFORM USER EXPERIENCE
THE RESULT
1.
Strategic decision-making based on facts and insights versus management by experience and intuition.
2.
“On-the-Go” Tablet ready intelligent dashboards for 5 key subject areas with over ~ 25 metrics.
3.
Completed Data Assessment in 12 weeks.
4.
One-click” ready highly interactive UX in Tableau involving 40 Visualizations over 3 months.
5.
Extensible, Intuitive, and Interactive Visualization Design to rapidly deliver additional insights.
6.
Scalable data architecture to bring additional subject areas and metrics into live dashboards with agility.
SHARING OUR EXPERIENCE
“USER EXPERIENCE IS KEY…
Rapid mock-up / UX design iterations that support leadership decisions in user story narrative form.
Deep understanding of data domain to support assessment with agility.
Iterative design, development, testing, and rollout.
Give users something to react to (visuals, wireframes) versus asking for inputs.
Do not aim to perfect visualization at first but iterate on key decision metrics with the leadership.
Visual representation is as important as the data.