BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Springshare//LibCal//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-TIMEZONE:America/New_York
X-PUBLISHED-TTL:PT15M
BEGIN:VEVENT
DTSTART:20260916T140000Z
DTEND:20260916T150000Z
DTSTAMP:20260916T000000Z
SUMMARY:Excel Power Query to transform and aggregate data
DESCRIPTION:[Online] When I need to convert a table from wide format into 
 tall (unpivot) or combine two spreadsheets by matching rows based on a key 
 column (JOIN/merge)\, I used to turn to Python\, R\, or OpenRefine. It 
 turns out you can do both of these operations right in Excel using Power 
 Query! In this workshop I'll lead you through a quick example using survey 
 data\, where I unpivot and merge both the text and numeric versions of 
 responses into a single table that's ready for analysis and visualization. 
 Plus\, I will show you how to summarize data in a way that surmounts a 
 limitation of pivot tables for visualization. This event is open to 
 non-Duke participants.\n\nSoftware: You'll need fairly recent version of 
 Microsoft Excel installed if you're going to play along with the exercise. 
 Check the Data tab in Excel for Get Data on Windows or Get Data (Power 
 Query) on Mac (which I'll be using for teaching).\n\nA zoom link will be 
 sent via email to registered participants to join the workshop.\n\nThe 
 content of the workshop may be recorded. If you are uncomfortable with a 
 recording being published\, please contact the instructor at anytime prior 
 to the conclusion of the workshop.\n\nData Visualization\, Data Science
LOCATION:n/a
ORGANIZER;CN="Center for Data and Visualization Sciences":MAILTO:askdata@duke.edu
CATEGORIES:Data and Visualization
CONTACT;CN="Center for Data and Visualization Sciences":MAILTO:askdata@duke.edu
STATUS:CONFIRMED
UID:LibCal-17235065
URL:https://duke.libcal.com/event/17235065
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT

END:VCALENDAR