Services

The work we do best. We scale the team to the size and complexity of each project.

Database development and data integration

When data lives in several systems, or arrives faster than people can process it by hand, we build the database work that keeps it organized and moving.

  • SQL scripts, stored procedures, tables and other database objects
  • SSIS packages that move and transform data on a schedule
  • Data migration between systems, with checks at each step
  • Documentation of database functions, objects and standards

Tools

  • SQL Server / SSMS
  • SSIS
  • MySQL
  • MongoDB

Delivered for

NORC at the University of Chicago

Data cleaning and QA/QC

Bad data costs the most when it's found late. We set up validation and quality checks so problems are caught early and every dataset is consistent and complete.

  • Validation workflows for survey and field data
  • Consistency, completeness and formatting reviews before analysis
  • Dataset cleaning, formatting and transformation
  • Documented QA/QC procedures your team can keep using

Tools

  • Excel
  • Power Query
  • Python
  • SPSS

Delivered for

O’Hare mystery shopper program, CDC heat stress research, Pace rider survey

Workflow automation and ETL

Repetitive work slows teams down and invites mistakes. We automate it, from daily data reviews to file handling and report preparation.

  • Automated daily data review and processing
  • ETL pipelines that extract, transform and load data for reporting
  • Spreadsheet automation for teams that work in Excel
  • Notifications and tracking for project workflows

Tools

  • Python
  • SSIS
  • Power Query
  • Power BI

Delivered for

NORC, CDC heat stress research

Data analysis and reporting

We turn survey, operational and research data into results people can act on, with the method documented so the numbers hold up.

  • Respondent sampling and weighted cross-tabulations
  • Statistical analysis tools built in Python
  • Dashboards and data visualization
  • Reports that combine survey and qualitative findings

Tools

  • Python (pandas, NumPy)
  • Power BI
  • Excel
  • SPSS

Delivered for

Pace ADA/Vanpool rider satisfaction survey

AI and natural language processing

For large volumes of text, such as open-ended survey answers or focus-group transcripts, we build models that classify sentiment and surface patterns.

  • Supervised NLP models for sentiment and topic classification
  • Trend recognition and forecasting models
  • Data preparation for model training and evaluation
  • Plain-language summaries of what the models found

Tools

  • TensorFlow
  • Keras
  • Python

Delivered for

CDC heat stress research

System setup and deployment

We standardize how computers and software are set up, so new machines are ready quickly and every one is configured the same way.

  • Automated, unattended Windows deployment and imaging
  • Pre-configured software environments
  • Batch, Bash and PowerShell scripts for file, user and system management

Tools

  • Windows deployment
  • PowerShell
  • Bash
  • Batch / XML

Delivered for

NetWeaver

Survey and field data operations

We run the operational side of data collection: survey programming, staff and devices in the field, tracking and daily reporting.

  • Survey programming and software management
  • Recruiting, training and supervising field staff
  • Device management, progress tracking and daily status reports
  • Secure intake and transfer of collected data

Tools

  • Survey platforms
  • Microsoft Teams
  • Agile / Jira

Delivered for

O’Hare traveler satisfaction survey and mystery shopper program

Web and information design

We build websites and the materials that collect or present information, such as surveys, forms, reports and presentations.

  • Responsive websites on custom code, Wix or WordPress
  • Site structure, navigation and search optimization
  • Surveys, forms, reports and presentation materials

Tools

  • HTML / CSS / JavaScript
  • Wix Velo
  • WordPress

Delivered for

C R Market Surveys

Have a data problem or a bid that needs a data partner?

Tell us what you’re working on, and we’ll follow up.

Contact us