Data Analysis: Moving from Excel to SQL
Tuesday, December 11th from 6:00 - 7:30 pm
Gordon Agress, Developer
Are you using Excel for data analysis? Spreadsheets provide quick and intuitive tools for data analysis, but users can begin to find them cumbersone and unwieldy. SQL and databases can simplify repetitive tasks and enable much more involved analysis, but users may worry they must first master a complex database language to do anything.
We will introduce students to the use of SQL queries for data analysis, keeping the focus on analysis by using a graphic SQL program (MySQL workbench). We will learn enough query syntax to perform basic analysis and get students started on problems too unwieldy for spreadsheets.
Student Takeaways:
Ability to move data from a spreadsheet to a SQL database, analyze it with SQL queries, and output results back to spreadsheet. Students can begin using SQL without entirely abandoning a trusted spreadsheet workflow.
Write basic SQL queries replicating filtering, aggregation and summary functions performed by spreadsheet tools like autofilters and pivot tables.
Gain enough SQL foundation to begin analysis beyond spreadsheets' abilities.
Pre-requisites:
Familiarity with spreadsheet analysis tools, or interest in databases or SQL
Installation of MySQL Community Server and MySQL Workbench (mysql.com/products/downloads/), and a sample database (yyrrll.wordpress.com)
Installation instructions and the sample database are available at yyrrll.wordress.com.
Gordon Agress is self-taught on LAMP stack (mostly Python, but some PHP). He has worked in the President's Budget Office and on Wall Street, and has an MBA from the University of Chicago.
___
Can't make it? Sign up at http://generalassemb.ly to stay in the loop on future events and classes.
Our Refund Policy: Plans change? We get it. But if you can't make it to a class/workshop, please email us at classes@generalassemb.ly at least 7 days before the scheduled event date. No refunds will be given after this timeframe.
