Analytics Open Learning

Learning Resources

Python Foundation

Introduction to Analytics

Introduction to Python

Data Types and Variables

Operators, Booleans, and Conditionals

Lists and Loops

Collections and Strings

Strings and String Methods

Functions

Pandas

Introduction to Jupyter and Pandas

Series, DataFrame, CSV

Pandas Filtering and Sorting

Pandas Column Operations and Missing Values

Missing Values, Datetime, Aggregation, and Merging

More Aggregations, Intro to Merges

Cell Operations, Advanced Exercises

SQL

Introduction to SQL

More SQL Queries and Aggregations

Data Visualization

Introduction to DataViz

Line, Scatter, and Bar Plots

Advanced Visualizations

The University of Illinois-Deloitte Foundation Center for Business Analytics