| 7 |
4257 |
Advanced SQL: Working with dates, sub-queries and more |
If you feel comfortable with the Structured Query Language basics that IRE teaches in its boot camps — SELECT, FROM, WHERE, GROUP BY — but are ready to see what else SQL can do, this session is for you. We will cover more advanced ways of manipulating and questioning data, such as date functions, writing sub-queries and other neat tricks. We will use SQLite in the class. This session will be most helpful if: You are comfortable with counting and summing in SQL. |
5 |
2019-03-08 |
2019-03-08 10:15:00 |
2019-03-08 11:15:00 |
0 |
0 |
0 |
Jennifer Peebles, The Atlanta Constitution |
3 |
|
3 |
Advanced SQL: Working with dates, sub-queries and more |
| 60 |
4249 |
Excel 1: Getting started with spreadsheets |
In this introduction to spreadsheets, you'll begin analyzing data with Excel, a simple but powerful tool. You'll learn how to enter data, navigate spreadsheets and conduct simple calculations like sum, average and median. This session is good for: Data beginners. |
5 |
2019-03-07 |
2019-03-07 09:00:00 |
2019-03-07 10:00:00 |
0 |
0 |
0 |
Stephanie Lamm, Dallas Morning News |
3 |
|
4 |
Excel 1: Getting started with spreadsheets |
| 62 |
4251 |
Excel 2: Formulas & sorting |
Much of Excel's power comes in the form of formulas. In this class, you'll learn how to use them to analyze data with the eye of a journalist. Yes, math will be involved, but it's totally worth it! This class will show you how calculations like change, percent change, rates and ratios can beef up your reporting. This session is good for: Anyone who is comfortable navigating Excel. |
5 |
2019-03-07 |
2019-03-07 10:15:00 |
2019-03-07 11:15:00 |
0 |
0 |
0 |
Sean Mussenden, University of Maryland |
3 |
|
4 |
Excel 2: Formulas & sorting |
| 64 |
4252 |
Excel 3: Filtering & pivot tables |
A look at the awesome power of pivot — and how to use it to analyze your dataset in minutes rather than hours. We'll work up to using a pivot table by first sorting and filtering a dataset, learning how to find story ideas along the way. This session is good for: Anyone familiar with formulas, sorting and filtering in Excel or another spreadsheet program. |
5 |
2019-03-07 |
2019-03-07 11:30:00 |
2019-03-07 12:30:00 |
0 |
0 |
0 |
Crina Boros, independent journalist |
3 |
|
2 |
Excel 3: Filtering & pivot tables |
| 68 |
4253 |
Excel: Advanced pivot tables |
You've done a few pivot tables and are getting curious what more you could do with them. What happens if you aggregate by more than one column? What are those "column" and "filter" boxes for? Come unlock the full potential of pivot tables in this intermediate spreadsheet class. This session is good for: People familiar with spreadsheets and aggregating data with pivot tables, or anyone who has taken Excel 1-3. |
5 |
2019-03-08 |
2019-03-08 09:00:00 |
2019-03-08 10:00:00 |
0 |
0 |
0 |
Kimbriell Kelly, The Washington Post |
3 |
|
2 |
Excel: Advanced pivot tables |
| 95 |
4237 |
Google Sheets: Scraping without coding (repeat) |
Yes, you can scrape data without using code -- in fact, all you need is Google Sheets! We'll be using Excel-type formulas (don't worry if you don't know what those are, either) to make simple scrapers that automatically pull data into Google Sheets. It’s the best way to get around clunky websites and unhelpful PIOs! **You must have a Google account for this session. This session is good for: Beginners who want to start using data for their stories. |
5 |
2019-03-08 |
2019-03-08 11:30:00 |
2019-03-08 12:30:00 |
0 |
0 |
0 |
Samantha Sunne, independent journalist |
3 |
|
2 |
Google Sheets: Scraping without coding (repeat) |
| 127 |
4394 |
Intro to R (Friday) *pre-registered attendees only |
Skill level: Intermediate Charles Minshew, IRE/NICAR will introduce you to R, a free, powerful open-source programming language, that will add statistical heft to your reporting. By the end of this three-hour session, you will be able to take raw data, import it into R, and start your analysis. Topics will include basic data importing, working with directories, reading in data, installing packages, creating simple visualizations, and how to clean, explore and sort your data. We'll also talk about how to find help when you're stuck. Preregistration is required and seating is limited. Laptops will be provided for the training.? ? Workshop prerequisites: This session will be most helpful if you’re comfortable working with data and you’re ready to take your skills to the next level. |
5 |
2019-03-08 |
2019-03-08 14:15:00 |
2019-03-08 17:45:00 |
1 |
1 |
0 |
|
5 |
|
|
|
| 128 |
4091 |
Intro to R (Thursday) *pre-registered attendees only |
Skill level: Intermediate Hannah Fresques and Sandhya Kambhampati of ProPublica, along with MaryJo Webster of the Minneapolis Star Tribune, will introduce you to R, a free, powerful open-source programming language, that will add statistical heft to your reporting. By the end of this three-hour session, you will be able to take raw data, import it into R, and start your analysis. Topics will include basic data importing, working with directories, reading in data, installing packages, creating simple visualizations, and how to clean, explore and sort your data. We'll also talk about how to find help when you're stuck. Preregistration is required and seating is limited. Laptops will be provided for the training.? ? Workshop prerequisites: This session will be most helpful if you’re comfortable working with data and you’re ready to take your skills to the next level. |
5 |
2019-03-07 |
2019-03-07 14:15:00 |
2019-03-07 17:45:00 |
1 |
1 |
0 |
|
5 |
|
|
|
| 239 |
4088 |
Upping your Excel game *pre-registered attendees only |
Skill level: Intermediate If you've found yourself struggling in a spreadsheet, thinking that whatever you were trying to achieve seemed harder than it should've been, then this is the class for you. We’ll learn about various tools and functions in Excel that come in handy when you need to re-structure or otherwise get your data ready for analysis. We'll cover string functions, logical functions, date functions, reshaping data, merging data using lookup functions and perhaps a few other nifty tricks if time allows. This is an intermediate Excel class intended for those who have mastered the basics, such as sorting, filtering, pivot tables and using functions. It is a fast-paced class intended to introduce you to these tools. You'll walk out with practice data and a 20-page tipsheet that covers in detail everything we do in class, plus other great Excel tips. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: You should have prior experience using Excel or Google Sheets, and be comfortable with introductory-level spreadsheet skills, such as sorting, filtering, SUM and AVERAGE functions, calculations such as percentage change or percent of total, and how to use Pivot Tables. |
5 |
2019-03-09 |
2019-03-09 09:00:00 |
2019-03-09 12:30:00 |
1 |
1 |
0 |
MaryJo Webster, Star Tribune |
3 |
|
2 |
Upping your Excel game *pre-registered attendees only |
| 243 |
4395 |
Web scraping with Python (Saturday) *pre-registered attendees only |
Skill level: Beginner/intermediate If you need data that's trapped on a website, writing some code to scrape the page could be your solution. This entry-level class will show you how to use the Python programming language to harvest information from websites into a data file. We'll introduce you to the command line and show you how to write enough code to fetch, parse and analyze web content. Preregistration is required and seating is limited. Laptops will be provided for the training. Workshop prerequisites: This class is programming for beginners. Some basic familiarity with HTML and Python is helpful but not required. |
5 |
2019-03-09 |
2019-03-09 14:15:00 |
2019-03-09 17:45:00 |
1 |
1 |
0 |
|
5 |
|
|
|