Effective Data Presentation

Instructor: Professor Galit Shmueli, Indian School of Business

Dates : Mar 28-29, 2013

Registration: Closed

Fee: Nu 4,100 (inclusive of handout, daily lunch, morning and afternoon tea).

Seats: Limited

Overview

More and more data and statistics are being collected in Bhutan. They are communicated to the public through reports, presentations, newspaper articles and other media. Yet, current practices are lacking in effectiveness. In this hands-on crash course, participants will learn about best practices for communicating data. We will use data from Bhutan and software that is accessible to many. The course is a must for those who collect, analyze or present data or statistics.

Topics

- Basics of effective visualization and human cognition
- Data entry in Excel: Good practices and dangers
- Interactive Pivot Tables in Excel
- Basic charts in Excel (bar charts, line graphs, histograms, scatter plots)
- Good practices and the difference between effective and creative presentation
- Charts versus tables
- Interactive visualization software
- Combining data from multiple sources
- Advanced charts: map charts, heat maps, and more
- Interactive dashboards and online publishing
- Communicating numbers in presentations and reports

Software

We will make extensive use of Microsoft Excel for interactive tables and charts. Participants will also get introduced to free advanced data visualization software called Tableau Public.

Required knowledge and resources

Participants are expected to have basic knowledge of Microsoft Excel 2003 or later.

Participants are expected to bring a laptop with Microsoft Excel and Wi-Fi connectivity.

Daily Schedule

09:30 - 11:00 Session I

11:00 - 11:30 Tea Break (tea & snacks provided)

11:30 - 13:00 Session II

13:00 - 13:30 Lunch Break (lunch provided)

13:30 - 15:00 Session III

15:00 - 15:30 Tea Break (tea & snacks provided)

15:30 - 16:30 Session IV

Testimonials

"The workshop is well structured, giving hands-on training with lots of examples"

"Professor Shmueli is an excellent and dynamic teacher. Her comprehensive knowledge about data presentation as well as her exuberant character made it extremely valuable and fun to attend this workshop."

"Very knowledgeable and highly qualified trainer... useful practical sessions with real data... very interactive and lively training with Professor Galit."

Instructor Biography: Galit Shmueli is the SRITNE Chaired Professor of Data Analytics and Associate Professor of Statistics and Information Systems at the Indian School of Business. She teaches data analysis, data mining, forecasting and related courses at the MBA and PhD programs. She also teaches online courses at Statistics.com. Prof Shmueli authors several books including the popular textbook Data Mining for Business Intelligence and Risk Analysis for Project Planning: A Hands-On Guide Using Excel.