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.

WHO SHOULD TAKE THIS COURSE?

• 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

WHAT ARE THE COURSE REQUIREMENTS?

• 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)