jahawley

[jahawley]

My 36 Day Python Data Analyst Curriculum

Python Programming

• [x] Welcome to Data Maverick. An orientation email by David Venturi. 5 minutes.
• [x] Thinking of Becoming a Data Analyst? You're One Already! A Medium article by Cassie Kozyrkov. 5 minutes. Free.
• [x] Chapter 1 of Programming for Everybody (Getting Started with Python). 4 hours. Part of a Specialization by Dr. Charles Severance on Coursera. Sign up for a Python for Everybody Specialization subscription, for access to this entire course as well as for access to the next course.
• [x] Chapter 2 of Programming for Everybody (Getting Started with Python). 4 hours.
• [x] Chapters 3 & 4 of Programming for Everybody (Getting Started with Python). 5 hours.
• [x] Chapter 5 of Programming for Everybody (Getting Started with Python). 3 hours.
• [x] Chapter 6 of Python Data Structures. 4 hours. Part of a Specialization by Dr. Charles Severance on Coursera. Continue using your Python for Everybody Specialization subscription for access to the entire course.
• [x] Chapter 7 of Python Data Structures. 3 hours.
• [x] Chapter 8 of Python Data Structures. 3 hours.
• [x] Chapter 9 & 10 of Python Data Structures. 5 hours.
• [x] Introduction to Data Science in Python. A course by Hillary Green-Lerman on DataCamp. 4 hours.
• [x] Introduction to ChatGPT. A course by James Chapman on DataCamp. 1 hour.
• [x] Becoming a "real" data analyst. A Medium article by Cassie Kozyrkov. 7 minutes. Free.
• [ ] Python Programming. A DataCamp skill assessment. 10 minutes.
• [x] How to Create An Engaging Python Project. A PDF guide by David Venturi. 5 minutes.
• [ ] Project: Python Programming. Your first project. Completed on DataCamp Workspace using the livestream above as a guide. 8 hours.
• [x] How to Create a Data Analyst Portfolio That Gets You Noticed. A PDF by David Venturi. 10 minutes.
• [ ] Project: Start Building Your Online Presence. Completed using the PDF above as a guide. 20 minutes.

Exploratory Data Analysis

• [ ] Chapters 1, 2 & 4 of Streamlined Data Ingestion with pandas. A course by Amany Mahfouz on DataCamp. 3 hours.
• [ ] Web Scraping in Python. A course by Thomas Laetsch on DataCamp. 4 hours.
• [ ] Data Manipulation with pandas. A course by Richie Cotton and Maggie Matsui on DataCamp. 4 hours.
• [ ] Joining Data with pandas. A course by Aaren Stubberfield on DataCamp. 4 hours.
• [ ] Introduction to Statistics in Python. A course by Maggie Matsui on DataCamp. 4 hours.
• [ ] Exploring and Analyzing Data in Python. A course by Izzy Weber and George Boorman on DataCamp. 4 hours.
• [x] What's the difference between analytics and statistics? A Medium article by Cassie Kozyrkov. 6 minutes. Free.
• [ ] Shifting your mindset from amateur to professional analyst. A Medium article by Cassie Kozyrkov. 8 minutes. Free.
• [ ] How to form realistic expectations about data. A Medium article by Cassie Kozyrkov. 6 minutes. Free.
• [ ] Importing & Cleaning Data with Python. A DataCamp skill assessment. 10 minutes.
• [ ] Data Manipulation with Python. A DataCamp skill assessment. 10 minutes.
• [ ] How to Create Engaging Data Analysis Projects. A livestream with Q&A with me (David Venturi) in the Data Maverick Discord community. 1 hour.
• [ ] Project: Exploratory Data Analysis. Your second project. Completed on DataCamp Workspace using the livestream from the Python Programming section as a guide. 8 hours.

Data Visualization & Statistics

• [x] Understanding Data Visualization. A course by Richie Cotton on DataCamp. 2 hours.
• [ ] Introduction to Data Visualization with Seaborn. A course by Erin Case on DataCamp. 4 hours.
• [ ] Intermediate Data Visualization with Seaborn. A course by Chris Moffitt on DataCamp. 4 hours.
• [ ] Sampling in Python. A course by James Chapman on DataCamp. 4 hours.
• [ ] Hypothesis Testing in Python. A course by James Chapman on DataCamp. 4 hours.
• [ ] Statistics for people in a hurry. A Medium article by Cassie Kozyrkov. 8 minutes. Free.
• [ ] How to spot a data charlatan. A Medium article by Cassie Kozyrkov. 9 minutes. Free.
• [ ] How to Add Value as a Data Analyst. A Medium article by Cassie Kozyrkov. 7 minutes. Free.
• [ ] Data Visualization Theory. A DataCamp skill assessment. 10 minutes.
• [ ] Data Visualization with Python. A DataCamp skill assessment. 10 minutes.
• [ ] Statistics Fundamentals with Python. A DataCamp skill assessment. 10 minutes.
• [ ] Analytic Fundamentals. A DataCamp skill assessment. 10 minutes.
• [ ] Project: Data Visualization & Statistics. Your third project. Completed on DataCamp Workspace using the livestream from the Introduction to Data Analysis section as a guide. 8 hours.

SQL Data Analysis

• [x] Introduction to SQL. A course by Izzy Weber on DataCamp. 2 hours.
• [x] Intermediate SQL. A course by Jasmin Ludolf on DataCamp. 4 hours.
• [ ] Joining Data in SQL. A course by Maham Khan on DataCamp. 4 hours.
• [ ] Data Manipulation in SQL. A course by Mona Khalil on DataCamp. 4 hours.
• [ ] PostgreSQL Summary Stats and Window Functions. A course by Michel Semaan, and Fernando Gonzalez Prada on DataCamp. 4 hours.
• [ ] Functions for Manipulating Data in PostgreSQL. A course by Brian Piccolo on DataCamp. 4 hours.
• [ ] Exploratory Data Analysis in SQL. A course by Christina Maimone on DataCamp. 4 hours.
• [ ] Data-Driven Decision Making in SQL. A course by Irene Ortner, Tim Verdonck, and Bart Baesens on DataCamp. 4 hours.
• [ ] How expert analysts think about time. A Medium article by Cassie Kozyrkov. 4 minutes. Free.
• [ ] Analytical Excellence Is All about Speed. A Medium article by Cassie Kozyrkov. 6 minutes. Free.
• [ ] Data Analysis in SQL (PostgreSQL). A DataCamp skill assessment. 10 minutes.
• [ ] Project: SQL Data Analysis. Your fourth and final project. Completed on DataCamp Workspace using the livestream from the Python Programming section as a guide. 6 hours.
• [ ] 10 Differences Between Amateurs and Professional Analysts. A Medium article by Cassie Kozyrkov. 8 minutes. Free.

Certification

• [ ] DataCamp Professional Data Analyst Certification. A certification on DataCamp. 2 hours.