A strategic roadmap helped transform BI for Seattle Public Schools

Designed and implemented a server-less, cloud-based big data pipeline.

At a glance:

We work with a Seattle-based global retailer who needed to integrate data from multiple marketing campaign systems and automate the process for analysis and engagement. The customer needed to better understand who was engaging with marketing content and offers and if customers were progressing through the campaigns as expected. They also wanted to benchmark campaigns across platforms to see which were the most effective.

Customer Challenge

The customer’s data was spread across multiple campaign systems and data types and was being managed by several outside vendors; the processes included multiple manual steps. Additionally, they had poor visibility into which campaigns were the most effective at driving revenue for their business.

Approach and Solution:

The Logic20/20 data scientists:

  • Designed and implemented a serverless, cloud-based big data pipeline to process all datasets related to the campaign measurement data pipeline.
  • Built new connectors to ingest data from 3rd party systems; collected and transformed in the cloud
  • Automated previously manual data processes steps
  • Interview stakeholders to understand who used the data and how it was used
  • Implemented a reusable and robust data architecture which provides analytical data for future data science experiments

Value and Benefits - “the wins”

Logic20/20 designed a data management system that:

  • Shortens data processing turnaround times from five days to approximately 4 hours, through a combination of performance improvements and elimination of manual bottlenecks
  • Reduces cost and increases operational efficiencies
  • Supported the legacy system during transformation, eliminating disruption to the current analytics processes
  • Automated validation processes, resulting in fewer manual interventions.

 

A strategic roadmap helped transform BI for Seattle Public Schools

At a glance:

Seattle Public Schools needed a roadmap to help them get back on track with improving the use of data in their organization. Logic20/20 develop a strategic roadmap to achieve their goals and it led to a BI transformation across their organization.

Customer Challenge

Facing a loss of $1 million from the budget unless true value could be established, and a simultaneous need to improve the use of data within the organization, Seattle Public Schools needed a roadmap to help them plan key initiatives to help get their budget back on track and transform their BI.

Approach and Solution:

We worked with Seattle Public Schools to help them assess the current state of their organization, find their true problem, and build a comprehensive strategic plan to solve their challenge. We:

  • Prepared and conducted stakeholder interviews to understand the existing culture
  • Created a clarity of vision by building a program management roadmap
  • Packaged a set of actionable initiatives with a strategic plan to address the larger goals of Seattle Public School’s business

Value and Benefits - “the wins”

With the combined efforts of Logic20/20 and Seattle Public Schools, the $1 million was successfully restored to the budget.

About Seattle Public Schools

Seattle Public Schools is the largest public school district in the entire state of Washington. The school district servers the entire city of Seattle with over 3,000 teachers teaching grades Pre-K through year 12.