Data Direct is CDP's Data Warehouse solution. It is a repository for the valuable, detailed information that is generated by Public Health Operations. Our goal is to empower federal, state and local agencies to use their data as a tool for active program monitoring, management, and evaluation.
The Data warehouse is a powerful engine that collects, collates, and integrates data into a cohesive information resource enabling users to dissect and analyze data across any number of dimensions and measures.
Originally developed for our WIC EBT Clients, the output is user-driven and user-actuated. It is intended to answer real-life questions about operations.
The possibilities the data warehouse presents are virtually unlimited. But here are a few things our data warehouse can provide:
The opportunities to use the information and the value it provides are virtually unlimited.
We recognize that our state agency customers have unique and ever-changing data analysis needs. The Data warehouse provides the tools that allow you to create and customize reports that are useful for your agency.
We use a standardized approach where common business rules are used in our back-end ETL (Extract, Transform, Load) processes, helping maintain consistency in the data used to populate the core data warehouse. For example, currently a key result of this strategy is that it allows our information solution to be used by any WIC Universal MIS EBT Interface (WUMEI) - compliant state agency regardless of their choice of EBT service provider.
The Data warehouse is hosted by CDP as a part of our processing service. Tableau is a web-based, business intelligence tool that we have incorporated in our information management solution to serve as the user interface. It is what our customer sees; it is where you sign in to use our data warehouse. This powerful combination enables you to have access to the information you want--when you want it. It allows you to define the information you need and format the output according to specific requirements.
The Tableau server can render workbooks through a regular web browser, on a mobile device using HTML 5, or through the Tableau application. After much research, we selected Tableau for several reasons including:
CDP will create pre-built workbooks for our clients when requested. Currently, WIC EBT workbook examples contain various sheets that provide detailed information for: