Data Wrangling for Reporting and Analytics

Phil Robinson, CEO of Dithis Development Inc. will discuss data wrangling for reporting and analytics.

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.

***********************************

Phil Robinson is an independent database developer and BI consultant with more than ten years experience working with SQL Server. His industry experience includes financial services, manufacturing, sales/marketing and employee management services. Phil is active in the community as a SQL Saturday #44 organizer and currently serves as president of the San Diego SQL Server User Group.

Current areas of focus are data repository design, data mining, ETL and data visualization using SQL Server 2005/2008 business intelligence tools.