Love Data Week is back, and this year’s theme is Data: Agent of Change. Data can help make changes that matter, shaping conversations about policy, the environment and pressing social issues, but only when you know how to use it effectively.
Whether you’re just getting started or looking to refine skills that you’ve honed for years, Love Data Week is the perfect time to develop your data skills. Join the University Libraries’ Research Hubs for virtual workshops about data management and policy so that you can make a difference with data!
Cleaning Data with OpenRefine Part. 1
Tuesday, February 14, 2023 | 3–4:30 p.m. | Virtual (Zoom)
Data sets often have problematic content such as formatting inconsistencies and incomplete elements that are beyond the capabilities of spreadsheet programs like Excel to deal with easily. OpenRefine is a powerful tool for working with messy data. It will help you do things like standardize date formatting; split up cells with multiple authors into separate cells; match local data up to other data sets; and enhance a data set with data from other sources. Part 1 of this workshop will focus on the basic functions of OpenRefine. Part 2 will focus on advanced features like fetching data from APIs, reconciling data by comparing it to external data sets, and looking at extensions to OpenRefine to perform other tasks.
Register for Cleaning Data with OpenRefine Part. 1New NIH Data Management and Sharing Policy Requirements
Wednesday, February 15, 2023 | 10–11 a.m. |Virtual (Zoom)
This session will cover the scope and requirements of NIH’s new Data Management and Sharing (DMS) Policy that went into effect January 25, 2023. Supplementary NIH guidance on the DMS plans required in proposals, data repository selection and allowable costs in proposal budgets will also be reviewed. Selected resources and tools to help researchers navigate the new requirements will be covered, including hands-on tour of selected UNC resources as time allows.
Register for New NIH Data Management and Sharing Policy RequirementsManage Your Research with Tropy
Wednesday, February 15, 2023 | 2–3 p.m. |Virtual (Zoom)
Conducting research with lots of images and not sure how to organize them? This workshop will walk participants through using a tool called Tropy to manage such research materials. Participants will learn about features like subject/theme tagging, adding metadata, and merging separate photos, say, of multiple pages of a letter, into one object, among others. Tropy even lets you add tags or metadata to many files at once.
Register for Manage Your Research with TropyTableau I
Wednesday, February 15, 2023 | 2–3:30 p.m. |Virtual (Zoom)
Tableau is a user-friendly software application used to create static or interactive visualizations and dashboards. Examples can be found here.
Tableau’s drag-and-drop interface provides tools to build a variety of visualizations with no coding required, and visualizations can be embedded in websites by copying and pasting embed code. Attendees will get started with Tableau in this hands on workshop by learning how to import data, create basic charts and maps, make and publish dashboards, and more!
Register for Tableau IBeginR
Thursday, February 16 2023 | 1–2 p.m. | Virtual (Zoom)
Learning R on your own? Want some help along the way? beginR is a series of virtual meetings organized by the University Libraries and the Odum Institute that provides support to students, faculty and staff who are learning the R programming language. The first week, the instructors will introduce attendees to R, help them install the software, and share the materials that will be covered in subsequent meetings. In the following weeks, beginR attendees will learn R by following the lessons on the R Open Labs website at their own pace. Each week, staff will be available via Zoom to answer questions, solve problems and provide the solutions to exercises.
Register for BeginRExcel I
Thursday, February 16, 2023 | 2–3:30 p.m. |Virtual (Zoom)
Interested in improving your Excel skills? This workshop will cover some basics on how to use spreadsheets, shortcuts, formulas, and more. After attending, participants will be able to effectively navigate, manipulate and summarize data in Excel.
Register for Excel IRestrictions or delay in sharing data from NIH-funded research: When is it justified?
Friday, February 17, 2023 | 10–11 a.m. |Virtual (Zoom)
Starting with January 25, 2023 grant applications, the National Institutes of Health (NIH) will require the creation and implementation of a plan to openly share data resulting from the research it funds .
The NIH will make few exceptions to this rule and require explicit justifications for an exemption from open sharing. Learn more about when the NIH will allow restrictions and embargos on data under this new policy.
Register for Restrictions or delay in sharing data from NIH-funded researchTableau II
Friday, February 17, 2023 | 2–3:30 p.m. |Virtual (Zoom)
This workshop continues to explore methods used in creating interactive visualizations and dashboards as introduced in Tableau I. Topics covered in the hands-on course will include: merging data sources, groups and sets, advanced maps and interactive menus, dashboard actions, and more!
Register for Tableau II
