1. ArchMiner An exploratory data analysis tool for the Center for the Built Environment Stephanie Hornung Leah Zagreus Masters Candidates 2003

2. What is CBE? • Center for the Built Environment (CBE) • Research group in the College of Environmental Design • Aims to inform the building industry of new building technologies and design strategies that improve efficiency and occupant comfort

3. Occupant Satisfaction Survey • Web-based survey • Measures occupant satisfaction with a variety of metrics (such as air quality, acoustics and lighting) It’s cold at my desk, I think there’s a draft There’s a terrible glare on my screen in the afternoon Everyone can hear what I say on the phone, and sometimes its personal The air would be so much better if we could open a window!

4. Benchmarking • Survey data used to correlate occupant comfort with building technologies • How do the occupants in this building feel about the temperature in their workspace? • Is the occupants’ feeling about the temperature related to having a thermostat? • How do the results from this building compare with other buildings in the same geographical area?

5. Analysis Process • View survey results using in-house reporting tool • Create many charts and pivot tables using Microsoft Excel to try to find interesting relationships Process is inefficient and very time consuming!

6. Reporting Tool • Provides easy viewing of survey results • New filtering capability allows some exploration • How do occupants with individual thermostats feel about the temperature in their workspace? But: • Side-by-side comparison is not easy • Is the occupants’ feeling about the temperature related to having a thermostat?

7. Microsoft Excel • Researchers make charts and pivot tables looking for interesting relationships • Can result in many charts, with only a few yielding results • Chart-creation process is time consuming • Raw data difficult to parse

8. Researcher’s Need A fast, simple way to explore relationships in the survey data without having to manually create each chart or table — fill gap between viewing survey results and doing statistical analysis • Solution: • A visual crosstab design that requires little set-up and yields useful information

9. Our Design Process • Two rounds of low-fi prototype testing • Designs are easy to make and change, and even easier to discard • Heuristic Evaluation done by colleagues in is213 • Pilot usability test

10. ArchMiner Demo

11. Implementation Tools • Java 2SE v1.4.1 • Swing UI components • Threads • JDBC • MS SQL Server 2000 • Visual Mining NetCharts Server 4.0

12. Evaluation and Feedback • CBE partner meeting demo • Pilot usability study • 3 typical users: 1 researcher, 2 GSRs • 7 typical tasks • Observation, “think aloud” techniques • Recorded time, task completion, error rate • Post-test questionnaire with Likert Scale followed by interview

13. Quotes “Easy to use” “Very useful” “Yahoo! When can I use it?” “Everything is where I expect it to be” “Powerful!”

14. Pilot Usability Study Results • All participants completed 5 of 7 tasks in ~ 2 min or less • Overall: Easy to use, powerful, and intuitive interaction flow

15. Pilot Usability Study Results

16. Pilot Usability Study Results

17. Future Work v1.0 • Export • Permissions • Performance • Reporting tool integration

18. Future Work v2.0 • Undo • More chart types • Saving views • Freeze panes, show/hide rows • Preferences

19. Acknowledgements • Dr. Marti Hearst • TAs Maggie Law and Kaichi Sung • Research Specialist Charlie Huizenga • Center for the Built Environment 213 teammates Myra Liu and Anita Wilhelm

20. More Information • ArchMinerhttp://dream.berkeley.edu/CBEdatamining • Center for the Built Environmenthttp://www.cbe.berkeley.edu • Occupant Satisfaction Surveyhttp://www.cbesurvey.org