The order in which my case studies categories are listed below is "from raw data to actionable intelligence." Click a title to go its case study page.

Data wrangling
  • Data cleansing & converting
  • Currency/language conversion
  • Deduping
  • Quality assurance management
  • Web scraping
Automation of MS SQL Server & MS Office
  • Stored procedures
  • Dynamic SQL
  • MS Access/SQL Server apps
  • MS Office/VBA automation
  • Software development lifecycle
Research & analysis
  • Data mining
  • Predictive data modeling
  • Geographic marketing
  • Campaign analysis
  • Competitor predictive intelligence
Process improvement
  • Innovative documentation
  • Reduce inputs through automation
  • Enforce process & quality through UI
Creative problem-solving
  • Discover new, free resources
  • Finding opportunity by rephrasing the question
  • Identifying analogs for difficult-to-measure market characteristics

Return to top