Python Foundations for Data Analysis and Business Intelligence

About Course

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

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

From there we’ll dive into foundational tools like variables, numeric and string operators, loops, custom 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 your Python skills.

Master the building blocks of base Python, including data types, variables, loops, functions, and more
Learn how to use Jupyter Notebooks to write, manage, and comment on your Python code
Analyze and manipulate numeric data, text strings, lists, tuples, dictionaries and sets
Explore raw data using conditional logic, nested loops, custom functions, and comprehensions
Use Python's Openpyxl package to read & write data to Excel worksheets
Build solid, foundational Python skills for data analysis & business intelligence

Course Content

Getting Started

Course Structure & Outline

01:29
Introducing the Course Project

00:49
Setting Expectations

01:51
Download: Course Resources

1. Why Python for Analytics?

2. Jupyter Notebooks

3. Python Data Types

4. Variables

Intro to Variables

03:27
DEMO – Variable Assignment

02:30
ASSIGNMENT – Variable Assignment

01:13
SOLUTION – Variable Assignment

00:58
Overwriting Variables

06:00
Deleting Variables

01:42
DEMO – Overwriting & Deleting Variables

04:55
Variable Naming Rules

04:48
Keeping Track of Variables

01:43
DEMO – Naming & Tracking Variables

04:23
ASSIGNMENT – Variable Naming Rules

01:12
SOLUTION – Variable Naming Rules

07:32
Key Takeaways

01:00

5. Numeric Data

Intro to Numeric Data

00:27
Numeric Data Types

01:06
Numeric Type Conversion

02:40
Arithmetic Operators & Order of Operations

05:03
DEMO – Numeric Data

05:15
ASSIGNMENT – Arithemetic Operators

01:31
SOLUTION – Arithmetic Operators

06:02
Numeric Functions

03:23
DEMO – Numeric Functions

03:30
ASSIGNMENT – Numeric Functions

00:51
SOLUTION – Numeric Functions

02:34
Key Takeaways

00:50

6. Strings

Intro to Strings

03:03
String Arithmetic

02:08
DEMO – String Creation & Arithmetic

05:59
String Indexing

04:13
DEMO – String Indexing

01:23
ASSIGNMENT – String Indexing

01:23
SOLUTION – String Indexing

01:46
String Slicing

06:38
DEMO – String Slicing

02:43
ASSIGNMENT – String Slicing

01:34
SOLUTION – String Slicing

02:39
The Length Function

01:11
ASSIGNMENT – The Length Function

01:46
SOLUTION – The Length Function

02:46
String Methods

10:28
DEMO – String Methods

04:48
ASSIGNMENT – String Methods

01:21
SOLUTION – String Methods

03:10
F_Strings

01:27
DEMO – F-Strings

01:43
ASSIGNMENT – F-Strings

01:19
SOLUTION – F-Strings

00:52
Key Takeaways

01:32

7. Conditional Logic

The Boolean Data Type

01:34
Comparison Operators & Membership Tests

03:16
Boolean Operators

03:54
DEMO – Boolean Data Types & Operators

07:25
ASSIGNMENT – Boolean Operators

01:40
SOLUTION – Boolean Operatorsv

06:18
The IF Statement & Control Flow

03:12
Else & Elif Statements

04:48
DEMO – If, Else, Elif

05:43
ASSIGNMENT – Control Flow

00:42
SOLUTION – Control Flow

02:40
Nested If Statements

01:47
ASSIGNMENT – Nested If Statements

01:31
SOLUTION – Nested If Statements

03:40
Key Takeaways

01:07

8. Sequence Data Types

Sequence & List Basics

01:57
List Operations

03:03
DEMO – List Operations

02:49
ASSIGNMENT – List Operations

01:38
SOLUTION – List Operations

04:35
Modifying Lists

03:51
DEMO – Modifying Lists

05:42
ASSIGNMENT- Adding List Elements

01:14
SOLUTION – Adding List Elements

02:57
ASSIGNMENT – Removing List Elements

00:50
SOLUTION – Removing List Elements

03:06
List Methods & Functions

04:30
DEMO – List Methods & Functions

06:40
ASSIGNMENT – List Methods & Functions

02:34
SOLUTION – List Methods & Functions

03:20
Nesting & Copying Lists

04:51
DEMO – Nested Lists & Copying Lists

07:27
ASSIGNMENT – Nested Lists & Copying Lists

01:15
SOLUTION – Nested Lists & Copying Lists

04:37
Tuples

03:47
DEMO – Tuples

04:01
ASSIGNMENT – Tuples

00:59
SOLUTION – Tuples

02:12
Ranges

02:07
DEMO – Ranges

02:10
ASSIGNMENT – Ranges

01:02
SOLUTION – Ranges

02:37
Key Takeaways

01:03

9. Loops

Loop Basics

03:07
For Loops & Looping Over Items

04:32
DEMO – For Loops

04:51
Looping Over Indices & Multiple Iterables

02:31
DEMO – Looping Over Indices

04:00
PRO TIP – Enumerate

01:59
DEMO – Enumerate

05:41
ASSIGNMENT – For Loops

01:45
SOLUTION – For Loops

02:20
ASSIGNMENT – Enumerate

00:59
SOLUTION – Enumerate

02:58
While Loops

04:19
DEMO – While Loops

03:33
ASSIGNMENT – While Loops

01:00
SOLUTION – While Loops

02:25
Nested Loops

02:21
DEMO – Nested Loops

04:26
ASSIGNMENT – Nested Loops

01:29
SOLUTION – Nested Loops

03:56
Loop Control

00:48
Break, Continue & Pass

03:21
Try-Except

03:16
DEMO – Loop Control

05:28
ASSIGNMENT – Loop Control

01:50
SOLUTION – Loop Control

02:44
Key Takeaways

00:40

10. Dictionaries & Sets

Intro to Dictionaries

01:25
Dictionary Overview

02:29
Accessing & Modifying Dictionary Values

01:09
DEMO – Dictionary Operations

06:11
ASSIGNMENT – Dictionary Basics

01:00
SOLUTION – Dictionary Basics

01:40
ASSIGNMENT – Dictionary Creation

01:10
SOLUTION – Dictionary Creation

02:51
Keys & Values Methods

01:40
Get, Items & Update Methods

03:00
DEMO – Dictionary Methods

06:31
ASSIGNMENT – Dictionary Methods

01:34
SOLUTION – Dictionary Methods

05:01
The Zip Function

02:19
ASSIGNMENT – The Zip Function

01:01
SOLUTION – The Zip Function

02:29
Nested Dictionaries

01:08
DEMO – Nested Dictionaries

04:41
ASSIGNMENT – Nested Dictionaries

01:43
SOLUTION – Nested Dictionaries

05:03
Intro to Sets

01:46
DEMO – Sets

01:55
ASSIGNMENT – Sets

01:04
SOLUTION – Sets

03:42
Set Operations

03:23
Set Use Cases

02:03
DEMO – Set Operations

03:04
ASSIGNMENT – Set Operations

01:10
SOLUTION – Set Operations

02:25
Key Takeaways

01:07

11. Functions

Intro to Functions

02:12
Anatomy of a Function

01:32
Defining Functions

03:26
The Docstring

01:13
DEMO – Defining a Function

04:19
ASSIGNMENT – Defining a Function

01:07
SOLUTION – Defining a Function

03:05
Argument Types

06:13
DEMO – Argument Types

06:48
Return Values

02:53
DEMO – Return Values

02:49
Variable Scope

02:39
DEMO – Variable Scope

02:55
Creating Modules

01:28
Importing Modules

02:05
DEMO – Creating & Importing Modules

04:34
ASSIGNMENT – Creating a Module

01:19
SOLUTION – Creating A Module

03:12
ASSIGNMENT – Importing a Function

01:34
SOLUTION – Importing a Function

03:28
Importing External Functions

03:25
PRO TIP – Naming Conflicts

01:36
Installing & Managing Packages

03:28
DEMO – Installing Packages

03:11
The Map Function

01:13
ASSIGNMENT – The Map Function

00:38
SOLUTION – The Map Function

01:34
Lambda Functions

02:48
DEMO – Lambda Functions

01:52
ASSIGNMENT – Lambda Functions

01:01
SOLUTION – Lambda Functions

03:48
PRO TIP – Comprehensions

02:12
DEMO – List Comprehensions

03:51
ASSIGNMENT – List Comprehensions

01:18
SOLUTION – List Comprehensions

01:36
PRO TIP – Dictionary Comprehensions

03:55
DEMO – Dictionary Comprehensions

02:37
ASSIGNMENT – Dictionary Comprehensions

02:09
SOLUTION – Dictionary Comprehensions

05:49
PRO TIP – Comprehensions vs. Map()

03:44
Key Takeaways

01:27

12. Manipulating Excel Sheets

The Openpyxl Package

03:01
Navigating Excel Workbooks, Worksheets & Cells

04:33
DEMO – Navigating Excel Workbooks With Python

03:47
ASSIGNMENT – Missing Sales Tax

01:42
SOLUTION – Missing Sales Tax

04:12
Determining Ranges & Writing to Cells

05:58
DEMO – Writing To Excel From Python

04:26
ASSIGNMENT – Pound & Yen Columns

02:10
SOLUTION – Pound & Yen Columns

06:16
Inserting & Deleting Columns

01:42
Saving Workbooks

01:49
Bringing it All Together

01:05
Key Takeaways

02:00

13. Final Project

Certification of Completion

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

Getting Started

Download: Course Resources

1. Why Python for Analytics?

Python for Data Analysis

The Python Analytics Ecosystem

Data Roles that use Python

2. Jupyter Notebooks

Launching Jupyter & Creating a Notebook

The Jupyter Interface

The Code Cell

Comments & Markdown

The Print Function & Function Help

ALTERNATIVE – Google Colab

Helpful Resources & Key Takeaways

3. Python Data Types

Python Data Types

The Type Function & Type Conversion

DEMO – Type Function & Conversion

Iterables & Mutability

4. Variables

DEMO – Variable Assignment

ASSIGNMENT – Variable Assignment

SOLUTION – Variable Assignment

Overwriting Variables

Deleting Variables

DEMO – Overwriting & Deleting Variables

Variable Naming Rules

Keeping Track of Variables

DEMO – Naming & Tracking Variables

ASSIGNMENT – Variable Naming Rules

SOLUTION – Variable Naming Rules

Key Takeaways

5. Numeric Data

Numeric Data Types

Numeric Type Conversion

Arithmetic Operators & Order of Operations

DEMO – Numeric Data

ASSIGNMENT – Arithemetic Operators

SOLUTION – Arithmetic Operators

Numeric Functions

DEMO – Numeric Functions

ASSIGNMENT – Numeric Functions

SOLUTION – Numeric Functions

Key Takeaways

6. Strings

String Arithmetic

DEMO – String Creation & Arithmetic

String Indexing

DEMO – String Indexing

ASSIGNMENT – String Indexing

SOLUTION – String Indexing

String Slicing

DEMO – String Slicing

ASSIGNMENT – String Slicing

SOLUTION – String Slicing

The Length Function

ASSIGNMENT – The Length Function

SOLUTION – The Length Function

String Methods

DEMO – String Methods

ASSIGNMENT – String Methods

SOLUTION – String Methods

F_Strings

DEMO – F-Strings

ASSIGNMENT – F-Strings

SOLUTION – F-Strings

Key Takeaways

7. Conditional Logic

The Boolean Data Type

Comparison Operators & Membership Tests

Boolean Operators

DEMO – Boolean Data Types & Operators

ASSIGNMENT – Boolean Operators

SOLUTION – Boolean Operatorsv

The IF Statement & Control Flow

Else & Elif Statements

DEMO – If, Else, Elif