Webinar series: getting data, storing data, manipulating data
All projects need data. You either generate it yourself via surveys or the like, you get some from the UK Data Service<https://www.ukdataservice.ac.uk/>, or you find some means to beg, borrow or steal it. If you didn't generate it yourself, the chances are it is not quite what you wanted but you can adapt it to your needs. You adapt the data by a variety of means; cleaning the data, extracting parts of the data (and ignoring the rest) and trickiest of all joining data from different sources.
This series of three webinars, organised by the UK Data Service, will cover some ways of dealing with these data issues using both familiar software tools such as Excel and others that you be aware of but haven't had any direct experience of.
Webinar one: Introduction to SQL and Databases<https://ukdataservice.ac.uk/news-and-events/eventsitem/?id=5591>
26 March 2020, 15.00 - 16.00 GMT
This free webinar will explain various different database environments and storage regimes and show you how easy it can be to start retrieving data using standard SQL queries.
Webinar two: Getting Data from the Internet<https://ukdataservice.ac.uk/news-and-events/eventsitem/?id=5593>
16 April 2020, 15.00 - 16.00 BST
This free webinar will illustrate techniques for automating the download of files from the Internet, using APIs to download data and demonstrating how you might store the data, and finally, if the data is on web pages, how you can systematically identify it, scrape it and store the data in a dataset.
Webinar three: Power Pivot and Dynamic Arrays in Excel<https://ukdataservice.ac.uk/news-and-events/eventsitem/?id=5594>
19 May 2020, 15.00 - 16.00 BST
We will look at the new functionality available in the later versions of Excel: Power Pivot to break the 1M rows problem and making dataset joins much easier and the latest dynamic array functions which can simplify many common tasks.
View all UK Data Service events<https://www.ukdataservice.ac.uk/news-and-events/events.aspx>
___________________________________________
Gill Meadows
Administrator, User Support and Training
___________________________________________
E [log in to unmask]<mailto:[log in to unmask]>
W ukdataservice.ac.uk
___________________________________________
UK Data Service
Cathie Marsh Institute for Social Research
University of Manchester
W http://www.socialsciences.manchester.ac.uk/
___________________________________________
Legal Disclaimer: Any views expressed by the sender of this
message are not necessarily those of the UK Data Service.
This email and any files with it are confidential and intended solely for
the use of the individual(s) or entity to whom they are addressed.
You may leave the list at any time by sending the command
SIGNOFF allstat
to [log in to unmask], leaving the subject line blank.
|