RSS Events Feeds

Data Analysis From Excel to SQL

3/12/2013 9:00 PM - 11:00 PM

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

ABOUT THIS CLASS

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.

PREREQS & PREPARATION

Familiarity with spreadsheet analysis tools, or interest in databases or SQL

Installation of MySQL Community Server and MySQL Workbench, and a sample database

ABOUT THE INSTRUCTOR(S)

Gordon Agrees

Developer

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.

REFUND POLICY

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Learn More: Data Analysis From Excel to SQL

Events Map

Email Newsletters

Want to be up-to-date with the latest news and updates from Entrepreneurship.org? To subscribe, just give us your email address below; you'll choose which e-newsletters you'd like to receive on the next screen.