SLIDE 1
2
Fran Hawkins, MS, RD, LD Kentucky WIC Director 2 3 Data Warehouse - - PowerPoint PPT Presentation
Fran Hawkins, MS, RD, LD Kentucky WIC Director 2 3 Data Warehouse - - PowerPoint PPT Presentation
Fran Hawkins, MS, RD, LD Kentucky WIC Director 2 3 Data Warehouse Received 2011 special grant to develop and implement Purpose: Improve program management by providing tools for analysis and decisions Provide standardized
SLIDE 2
SLIDE 3
3
Data Warehouse
Received 2011 special grant to develop and
implement
Purpose:
Improve program management by providing
tools for analysis and decisions
Provide standardized reports and queries Allow user to analyze, visualize and share
information
Contains all of EBT data elements
3
SLIDE 4
4
Data Warehouse
Name of Data Warehouse is wdICE Imports the following data from Universal
Interface files which are created to transfer data between EBT and MIS systems on a nightly basis:
- Redemption – all of EBT data elements
- Issuance
- Product and retailer data
SLIDE 5
5
wdICE
Imports the following from MIS:
- Demographics
- Income
- Risk Codes
- Participation
- Enrollment
- Food Package data, etc.
SLIDE 6
6
Software
Uses Tableau Software as front end Software allows users to :
View existing canned reports; Create new reports; and Share reports between users.
SLIDE 7
7
Components of wdICE
Financial Management – Reporting of
settlement trends and 798 data
Retail Management – Analyze retailer
redemption by store, region, day, month, quarter, and year, looking at specific products redeemed and their relative price patterns.
SLIDE 8
8
Components of wdICE – cont.
Food Management - Analyze approved food
products (cost to the program, availability in authorized stores, and preference and utilization shown by clients)
Processing Metrics – Analyze redemptions by
day, hours, week, etc.
Risk Management - Identifies transactions
patterns that might indicate fraudulent activities
SLIDE 9
9
Components of wdICE – cont.
Participation and Reporting – Analyze
participation and enrollment data including participants receiving specified food packages
Participant Risk - Analyze participant
characteristics including obesity rates and trends.
SLIDE 10
10
Whole Grain Data
upc
comments exchange size Quantity
72945611030
Sara Lee 100% Whole Wheat 16 125,944 Bread
72250017671
Nature's Own 100% Whole Grain 16 95,087 Bread
24126008221
Bunny 100% whole wheat bread 16 65,682
73731071076
mission 8" whole wheat tortilla 16 13,943
14100071662
Pepperidge Farm Light Style 16 7,141
Soft Wheat Bread
24126008931
Healthy life 100% whole wheat 16 6,815 Bread
11110001320
Kroger 100% Whole Wheat Honey 16 6,374
77633700300
Roman Meal Sungrain 100% 16 6,300 whole wheat bread
SLIDE 11
11
SLIDE 12
12
SLIDE 13
13
SLIDE 14
14
SLIDE 15
15
SLIDE 16
16
SLIDE 17
17
SLIDE 18
18
SLIDE 19
19
SLIDE 20
20
SLIDE 21
21
SLIDE 22
22
SLIDE 23
23
SLIDE 24
24
SLIDE 25
25
SLIDE 26
26
SLIDE 27
27
SLIDE 28
28
SLIDE 29
29
Data to Analyze
Have about 89 reports Primary uses:
Food List decisions High Risk vendor decisions Review of participants by area
SLIDE 30
30
SO MUCH DATA! SO LITTLE TIME!
SLIDE 31
31