Effective Data Presentation

Instructor: Professor Galit Shmueli, Indian School of Business

Venue : Rigsum Institute, Thimphu

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