Your browser is not supported. Please download another browser to be able to use all of the Maven features.

Self-Paced Course

Python Foundations for Data Analysis

Master the core building blocks of Python for data analysis, including data types, variables, conditional logic, loops, functions and more.

Course Hours19 hours
Skills Learned
Data Prep
Data Analysis
Course Level

Course Description

This is a hands-on, project-based course designed to help you master the core building blocks of Python for data analysis.

We'll start by introducing the Python language and ecosystem, installing Jupyter Notebooks where we'll write our first lines of code, and reviewing some key Python data types and properties.

From there we'll dive into foundational tools like variables, numeric and string operators, conditional logic, loops, functions and more. You'll learn how to create and manipulate raw data, define conditional logic, loop through iterables or indices, and extract values stored in a wide variety of data types including dictionaries, lists, tuples, and more.

Throughout the course you'll play the role of a Data Analytics Intern for Maven Ski Shop, the world's #1 store for skis, snowboards and winter gear. Using the skills you learn throughout the course, you'll help the Maven team track inventory, pricing, and sales performance using Python.

Last but not least, we'll practice importing and manipulating data from an Excel workbook using the openpyxl package, and bring it all together with a final course project.

If you're a data analyst or business intelligence professional looking to add Python to your skill set, this is the course for you.



  • 11.5 hours on-demand video (19.0 CPE credits)

  • 40 homework assignments (plus 1 final project)

  • 10 quizzes

  • 2 skills assessments (1 benchmark, 1 final)



  • Analysts or BI professionals looking for a deep introduction to basic Python
  • Aspiring data scientists who want to build foundational Python skills
  • Anyone interested in learning one of the most popular open source programming languages in the world


  • Jupyter Notebooks (free download, we'll walk through the install)
  • No advance preparation is required (basic familiarity with programming is a plus, but not a prerequisite)


  • Identify Jupyter Notebook tools and best practices, including the notebook server, menu options, edit & command modes, comments, and markdown

  • Identify Python's data types and their properties, including type conversion, mutability, and iterability

  • Identify examples of variable assignment in Python, including naming, tracking, overwriting, and deleting variables

  • Identify and interpret base Python syntax for working with numeric data using arithmetic operators, order of operations, and numeric functions

  • Identify and interpret base Python syntax for manipulating text data via string arithmetic, indexing & slicing, string methods, and f-strings

  • Identify and interpret control flow using Boolean operators and conditional statements, including if, else, and elif

  • Identify and interpret examples of looping through iterable data types using for & while loops, including the enumerate function, nested loops, and control statements

  • Identify and interpret base Python syntax for creating, modifying, and nesting sequence & map data types, including lists, tuples, ranges, dictionaries, and sets

  • Identify the proper syntax for defining custom Python functions, including variable scope, external modules & packages, lambda functions, and comprehensions

  • Identify basic openpyxl functions and use cases for manipulating Excel sheets using Python, including reading & writing data, navigating workbooks, and looping through cells


  • CPE Credits: 19.0

  • Field of Study: Information Technology

  • Delivery Method: QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: April 14, 2022

Start learning for FREE, no credit card required!

Every subscription includes access to the following course materials

  • Interactive Project files
  • Downloadable e-books
  • Graded quizzes and assessments
  • 1-on-1 Expert support
  • 100% satisfaction guarantee
  • Verified credentials & accredited badges
Sign Up Today

Ready to become a

data rockstar?

Start learning for free, no credit card required!

Sign Up for Free