My teaching portfolio reflects and reinforces my research applying data and analytics to design and innovation. For more than a decade, I have taught MBA electives in product design and the core undergraduate course in business analytics. More recently, I am helping to design the business analytics curriculum at Berkeley Haas. In that context, I specified and helped deploy a multi-node, open-source analytics platform that enables all faculty and students to teach, learn, and conduct analytics related research on a common platform. Finally, I lead executive education sessions on opportunity screening, problem solving and design, and on innovation analytics.
Designing Digital Products and Services
(MBA247 | OPIM652 | OPIM654 | OPIM415)
This MBA elective course applies the basic principles of product design drawn from the mechanical engineering discipline and adapts them to digital products and services with a heavy emphasis on user experience (UX) and interaction design. As a interdisciplinary, project-based course, MBA students team with engineering students and those from the School of Information to identify problems and apply a tournament process to screen and select from among the opportunities. Over the course of the semester teams apply a lean, agile process to generate, prototype, and test creative solutions to one target problem.
(MBA247 | OPIM652 | OPIM654 | OPIM415)
This MBA elective course applies the basic principles of product design drawn from the mechanical engineering discipline and adapts them to digital products and services with a heavy emphasis on user experience (UX) and interaction design. As a interdisciplinary, project-based course, MBA students team with engineering students and those from the School of Information to identify problems and apply a tournament process to screen and select from among the opportunities. Over the course of the semester teams apply a lean, agile process to generate, prototype, and test creative solutions to one target problem.
Introduction to Business Analytics
(UGBA104 | OPIM101)
This core undergraduate course introduces students to descriptive, predictive, and prescriptive models in decision-making. Basic principles of unsupervised and supervised machine learning, constrained optimization, and Monte Carlo simulation are all covered.
Student testimonials:
In the two years since I took OPIM ... I have used Excel and VBA extensively in my internships and for small entrepreneurial projects. The data-mining capabilities of VBA have proven to be immeasurably useful. In one instance, I was able to use VBA to pull data on thousands of public schools in my home state to facilitate a marketing campaign. In other situations, I calculated the driving distance from my residence to thousands of potential clients to decide whether it was feasible to transact with them. - OPIM101
Over the summer I worked for a small real estate start-up. One of my tasks was to compute the percentage of off market transactions (Non-MLS sales) in various [regional] counties. In order to do this I had to compile two lists of overlapping data, reconcile the data to avoid double entries and then calculate the percentage of off market sales in comparison to all transactions. I was able to accomplish this very quickly by developing a Macro that would take my spreadsheets of compiled data, erase double entries, calculate off-market percentage and transfer that percentage onto a master list. - UGBA104
I am writing macros that are taking QuickBooks files in csv format, downloading MySQL database tables from our servers, scrubbing the data and
linking corresponding entries to their SQL Database Unique ID code, and then formatting the data for quick upload into our CRM software.... I’ll be improving many times over our ability to transfer information between QuickBooks and our CRM platform. - UGBA104
(UGBA104 | OPIM101)
This core undergraduate course introduces students to descriptive, predictive, and prescriptive models in decision-making. Basic principles of unsupervised and supervised machine learning, constrained optimization, and Monte Carlo simulation are all covered.
Student testimonials:
In the two years since I took OPIM ... I have used Excel and VBA extensively in my internships and for small entrepreneurial projects. The data-mining capabilities of VBA have proven to be immeasurably useful. In one instance, I was able to use VBA to pull data on thousands of public schools in my home state to facilitate a marketing campaign. In other situations, I calculated the driving distance from my residence to thousands of potential clients to decide whether it was feasible to transact with them. - OPIM101
Over the summer I worked for a small real estate start-up. One of my tasks was to compute the percentage of off market transactions (Non-MLS sales) in various [regional] counties. In order to do this I had to compile two lists of overlapping data, reconcile the data to avoid double entries and then calculate the percentage of off market sales in comparison to all transactions. I was able to accomplish this very quickly by developing a Macro that would take my spreadsheets of compiled data, erase double entries, calculate off-market percentage and transfer that percentage onto a master list. - UGBA104
I am writing macros that are taking QuickBooks files in csv format, downloading MySQL database tables from our servers, scrubbing the data and
linking corresponding entries to their SQL Database Unique ID code, and then formatting the data for quick upload into our CRM software.... I’ll be improving many times over our ability to transfer information between QuickBooks and our CRM platform. - UGBA104
