Track 13 -Data Analysis Tips and Techniques

Track 13

Data Analysis Tips and Techniques
(Fun with Excel Pivot Tables and Minitab)
Eric Alden
Lean Six Sigma Master Blackbelt
Xerox

Abstract: Data is everywhere! The challenge is to deliver action plans based on the data analysis. Data comes in many forms such as hand written notes, emailed spreadsheets or downloads from huge Data Warehouses. One thing is for certain, the power of personal computers and advances in software enable mere quality professionals to tackle challenges that previously only high level specialists could do.

This talk will:

Define the structure of “Standard Database Format”
Review simple Excel Database Functions such as Filter and Sort
Demonstrate the ease in which Minitab and Excel work together
Introduce Excel “Pivot Tables” (A very powerful tool at everyone’s fingertips. I am surprised at the number of people I work with who do not yet know this tool!)

Laptops are welcome, but not required. The intent is to expose individuals “Database Etiquette” and increase awareness to powerful data analysis tools.

Level: Basic to Intermediate

Bio: Eric Alden is a practicing quality professional supporting the Rochester area for over 20 years. Eric is a Xerox Lean Six Sigma Master Blackbelt, and is currently working for Xerox as a Reliability Manager. He has performed a wide variety data analysis during previous employment with Mobil Chemical and Bausch and Lomb. He holds a Master’s degree from RIT in Quality and Applied Statistics, and an undergraduate degree from RIT in Mechanical Engineering. Eric served as the 2003 - 2005 Chair of the Rochester ASQ section, and holds CQE, CQM, and CSSBB certifications through ASQ.

Back to Schedule

Back to Abstract and Bio Page

Back to Conference Page

Quick-jump to sessions: opening-keynote-closing-1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16-17-18-19-20