Innovation Skills Workshops: Applying Digital Tools in Telling Stories with DATA (Workshop 2 on 25-26 May 2018)

24/04/2018 to 26/05/2018

Workshop 2: Preparing and Exploring Your Data in Python of the Innovation Skills Workshops: Applying Digital Tools in Telling Stories with DATA Series collaborated with Center for Entrepreneurship will be held on 25-26 May.  Welcome CUHK Faculty members, researchers and all students to join this workshop to equip yourself to tell impactful stories with data.  Workshop 3 will be held in around mid-Sept to early Oct.  Certificate of Attendance will be issued for participants who have attended ALL THREE workshops.

Workshop 2: Preparing and Exploring Your Data in Python (9 hrs) (25 - 26 May 2018) 

a. Preparing (pre-processing) your data for growth (3 hrs)

  1. Know your sources: interviews, field studies, open data, API, websites, IoT, and digital archives
  2. ETL (extraction, transformation, and loading) in CSV, XML, and JSON formats for data preparation
  3. Finding a home for your data - cloud computing and its infrastructure for growth and support
  4. Popular tools for data preparation (e.g. Knime, Open Refine, Google Sheet/Xpath, Scrapinghub, Beautiful Soap, and Scrapy)

Date & Time: 25 May 2018 (Fri), 6:30 p.m. - 9:30 p.m.

b. Exploring your data in Python (6 hrs)

  1. Using Anaconda Jupyter Notebook for data exploration in Python
  2. Introduction to Python operations (operator and operand), control structure, data structure, and function
  3. Useful Python modules for data exploration, analysis and mining (Mathpotlib, Numpy, Pandas, etc.)
  4. Free online resources for self-paced learning in Python (,,,, etc.)

Date & Time: 26 May 2018 (Sat), 10:00 a.m. - 1:00 p.m. & 2:30 p.m. - 5:30 p.m.

Workshop 3: Visualizing and Publishing Your Data in Python (9 hrs) (tentatively in mid-September to early October 2018) 
a. Growing your data in the cloud: From Google Sheet to Airtable (3 hrs)

  1. Beyond Google Sheet — Building relational database in Airtable for storing and managing your data
  2. The power of views — Displaying and filtering data in form, grid, calendar, kanban, and gallery views
  3. Functions and API for more advanced data modelling and application development
  4. Integration with other web applications for team collaboration and project management

b. Data Visualisation in JavaScript (3 hrs)

  1. Front-end vs. back-end programming: interface with the user and interface with the data using the Python Flask framework
  2. Useful JavaScript libraries (jQuery, D3, Mpld3, Leaflet, etc.) for data visualization and front-end interactions
  3. Create your first interactive chart in Matpotlib and Mpld3 
  4. Create your first interactive map in Leaflet

c. Publishing Your Project on the Web (3 hrs)

  1. The elements of user experience in web design
  2. The narrative components in user journey within a web design
  3. Combining Airtable and Bootstrap library for web publishing
  4. Use of Google Optimize and Google Analytics to track your web project

Venue: Digital Scholarship Lab, G/F, University Library
Registration: Click to register (Workshop 2 ONLY)
Remarks: Users are required to bring their own devices to the workshop.

Innovation Skills Workshop 2: Preparing and Exploring Your Data in Python