chefpaz2023

[chefpaz2023]

My Initiation

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.
• [ ] Chapter 2 of Python for Everybody, then Chapter 1 after. A course by Dr. Charles Severance on his own website. Sign up for free with a Google account. You can also take the course on Coursera and get a Coursera certificate (paid). 4 hours.
• [ ] Chapter 3 of Python for Everybody. 4 hours.
• [ ] Chapters 4 & 5 of Python for Everybody. 5 hours.
• [ ] Chapter 6 of Python for Everybody. 3 hours.
• [ ] Chapter 7 of Python for Everybody. 4 hours.
• [ ] Chapter 8 of Python for Everybody. 3 hours.
• [ ] Chapter 9 of Python for Everybody. 3 hours.
• [ ] Chapter 10 & 11 of Python for Everybody. 5 hours.
• [ ] Introduction to Data Science in Python. A course by Hillary Green-Lerman on DataCamp. Sign up for a DataCamp subscription for access to DataCamp's entire catalogue, which you'll use throughout this curriculum. 4 hours.
• [ ] Introduction to ChatGPT. A course by James Chapman on DataCamp. 1 hour.
• [ ] Becoming a "real" data analyst. A Medium article by Cassie Kozyrkov. 7 minutes. Free.
• [ ] Python Programming. 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: Python Programming. Your second project. Completed on DataCamp Workspace using the livestream above as a guide. 8 hours.
• [ ] 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.
• [ ] 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.
• [ ] Project: Exploratory Data Analysis. Your third project. Completed on DataCamp Workspace using the livestream from the Python Programming section as a guide. 8 hours.

Data Visualization & Statistics

• [ ] 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

• [ ] Introduction to SQL. A course by Izzy Weber on DataCamp. 2 hours.
• [ ] 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.