Let's Talk About Data

We're finally ready to talk about the decisions your team needs to make to really get going. 

Deep breath... here we go! 

How do we get our current data into SAM? 

There are three ways to get data into SAM: data entry, data import or a data migration. Let's review each and decide which way (or combination of ways) work best for your organization. 

Data Entry 

This is good, old fashioned, pull up your sleeves and get to the keyboard to start adding families, children and other records into SAM. However mundane this option may sound, the process of building muscle memory and confidence in that repetition is a worthwhile option for many agencies to consider, especially if you have less than 200 records or so. 

Having team members enter 20-40 records builds their comfort and confidence with SAM and allows you to move forward with other implementation tasks sooner.

Data Import 

This option is for clients with very simple spreadsheets that are being used to track clients. This option works best with spreadsheets under 20 columns and primarily dedicated to a single one of SAM's entity types (Family, Child, Birth Parent, etc.). An example would be a spreadsheet of families, with their address and contact information, along with which program and what team member is working with the family. Simple. 

This option will not work for spreadsheets where the entity types (family, child, and birth parent) data are all on one spreadsheet or data from a relational database. 

Data migration 

A data migration is for clients who've been using a relational database to track clients for some time. We have a few guides to walk you through this process, check them out! 

• Data Migration Guides: Moving into SAM

Where is your data now? 

Gather the sources of your data.

What file format is your data in? Is your data in a single spreadsheet, many spreadsheets, spreadsheets with many tabs, a database your team's been using, or paper files? Only electronic data can be imported, so if your data collection is on paper, it will need to be entered manually. 

Can the data be consolidated? 

Data can be organized a variety of ways. Get to know your data. Do you have separate types of data on different spreadsheets? Does your team know what each of the columns mean and why the team has been collecting it?

Combine what you can and let go of what data isn't necessary. Can multiple spreadsheets be combined into one or few? Can you delete columns or data points that you don't really need? Do you want to make changes to the data? 

The simpler the data and more you understand it, the more options, less time, and expense for this part of implementation.

Connect with us at support@inreachsolutions.com and we'll discuss your data needs.