DODD Data Warehouse                                                      March 31, 2017
Waiting List Clean-Up

Thank you to all the counties who have been periodically sending local lists to keep us appraised of the clean-up progress! Feel free to email us whenever you want an updated merge.

There are currently 61 counties that have local and state waiting lists that match (green), 4 counties that are very close to having matching lists (blue), and 23 counties that are making progress on their clean-up (gray).

We are in the home stretch! Thank you for your continued work to finish up this clean-up project! For any questions, or to get an updated merge, please email [email protected].

Have you ever struggled manipulating data in Excel? We have prepared videos that can help you manage your data reports better! Just click on "learn how" to watch these 1 to 5 minute tutorials:

Learn how to unmerge cells and filter in excel
Learn how to remove duplicates
Learn how to remove extra spaces in cell (trim)
Learn how to find and replace
Learn how to transpose data
Learn how to change the format of a date
Learn how to rotate data from rows to columns or vice versa (transpose)
Learn how to combine text from different cells into one cell (concatenate)
Learn how to auto-fill columns
Learn how to match data from multiple columns (vlookup)
Learn how to make a copy of your tab
Learn how to do simple calculations
Learn how to make simple pivot tables
Learn how to create a chart
Learn how to cut, copy and move columns

If there is a particular excel topic you are interested in, please email [email protected]
DODD Data Warehouse User Support Site
We suggest you save this site in your favorite browser for easy access!  It is a one stop shop for all things Data Warehouse! Some of the available resources include links to training signups, recorded webinars, the Data Warehouse user manual and even documents that suggest which reports to run based on if you are a business manager or an SSA director.  We even update the status/availability of the data warehouse in real time!  
Anomaly Reports
Would you like to see how "clean" your county's data is? Follow the bread-crumbs above in the Data Warehouse and explore our available Anomaly Reports. 

A couple examples of anomalies include: "22 or Older and in Children's Services" and "On Waiver, No Service Coordination".  These anomalies are usually easily fixed and are a result of a data entry error. If you have questions on how to clean up your counties data please email [email protected]