Data Analysis: Moving From Excel to SQL
10

Thursday, 10 October

6 8 pm CDT

GA Chicago @ Rent 24

444 N Wabash Avenue, 5th Floor
Chicago, IL 60611
$40 USD
Regular Ticket
$40 USD
Total
`

Questions? Read our FAQs

Data Analysis: Moving From Excel to SQL | October 10

Bianca Mounce Photo


Senior Data and Technology Strategist, The Movement Cooperative

10

Thursday, 10 October

6 8 pm CDT

GA Chicago @ Rent 24

444 N Wabash Avenue, 5th Floor
Chicago, IL 60611
$40 USD
Regular Ticket
$40 USD
Total
`

Questions? Read our FAQs

About This Class

Are you using Excel for analysis? Spreadsheets are useful for analyzing and visualizing data, but become cumbersome and unwieldy with large datasets.

Relational databases address many of Excel's limitations by simplify repetitive tasks and enabling analysis over much larger datasets. The only catch is that you need to know SQL to fully harness the power of these technologies.

This class will introduce participants to the world of databases and analysis in SQL. Participants will be shown how to setup a SQL environment on their laptops, so that they can practice writing queries on a real dataset. After this class, participants will understand the fundamentals of SQL syntax, and be able to write queries using PGAdmin (one of the world's most popular database design tools).

Takeaways

  • Install PGAdmin enabling participants to write SQL queries directly from their laptops
  • Learn introductory database concepts and data structures
  • Understand the fundamentals of SQL, including how to filter, aggregate and summarize large datasets
  • Gain enough SQL foundation to begin analysis beyond simple spreadsheets

Preparation

  • Familiarity with spreadsheet analysis tools, or interest in databases and SQL
  • Installation of PGA Admin

About the Instructor

Bianca Mounce Photo

Senior Data and Technology Strategist,
The Movement Cooperative

Since 2013, Bianca has empowered for-profit companies, electoral campaigns and non-profit organizations to strategically use data. She is currently the Data and Analytics Strategist at Forward Together, a non-profit that works nationally to ensure that all families have the rights, recognition and resources they need to thrive.
After working on President Obama's re-election campaign as a Field Organizer in Tampa, Florida, Bianca continued immersing herself in data-driven campaigns and non-profit work. She was the National Data Manager at Organizing for Action where she oversaw reporting, training and data for Grassroots staff and volunteers. She then worked at Civis Analytics as a Client Success Analyst working with a diverse portfolio of clients on how to leverage the Civis Platform.
A native Oregonian, Bianca lived in the United Kingdom for five years, and has traveled to 21 countries. She likes to think she is equal parts coffee expert, yogi and proud Portlander.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.