Course Overview
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 Python 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 data analytics skills.
COURSE OUTLINE:
Why Python for Data Analytics?
Introduce the Python analytics ecosystem and why it’s the programming tool of choice for many data analysts
Jupyter Notebooks
Install Anaconda and create your first Jupyter Notebook, a user-friendly Python coding environment designed for data analysis
Python Data Types
Introduce native Python data types, common use cases, type conversion methods, and key concepts like iteration and mutability
Variables
Learn how to name and store values in memory using variables, as well as how to overwrite, delete and track them
Numeric Data
Learn how to work with numeric data, and use numeric functions to perform a range of arithmetic operations
Strings
Learn how to manipulate text via indexing and slicing, calculate string lengths, apply various string methods, and print f-strings to include variables
Conditional Logic
Learn how to use IF statements and Boolean operators to establish conditional logic and control the flow of your programs
Sequence Data Types
Learn how to create, modify, and nest lists, tuples, and ranges, all of which allow you to store many values within a single variable
Loops
Understand the logic behind For and While loops and learn how to refine loop logic and handle common errors
Dictionaries & Sets
Address the limitations of working with lists and explore common scenarios for using dictionaries and sets in their place
Functions
Learn how to create custom functions in Python to boost productivity, and how to import external functions stored in modules or packages
Manipulating Excel Sheets
Import the openpyxl package and manipulate data from an Excel worksheet using the Python skills you’ve learned throughout the course
Final Project
Import and manipulate data from an Excel workbook
Join today and get immediate, lifetime access to the following:
11+ hours of high-quality video
Python Foundations PDF ebook (300+ pages)
Downloadable project files & solutions
Expert support and Q&A forum
30-day money-back guarantee
If you're a data analyst, data scientist, or business intelligence professional looking to build a strong Python foundation and add powerful data analytics skills to your resume, this is the course for you!
Happy learning!
-Chris Bruehl (Python Expert & Lead Instructor, Maven Analytics)
__________
Looking for our full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau and Machine Learning courses!
See why our courses are among the TOP-RATED on Udemy:
"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.
"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.
"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.
FAQ
FAQ area empty
Course curriculum
Chương 1 Getting Started 6 bài · 4 phút
- Course Structure & Outline Học thử 1:42
- READ ME: Important Notes for New Students Học thử
- DOWNLOAD: Course Resources Học thử
-
Introducing the Course Project 0:48
-
Setting Expectations 1:50
- A Note On Udemy Coding Exercises Học thử
Chương 2 1. Why Python for Analytics? 4 bài · 9 phút
- What is Python? Học thử 1:12
-
Python for Data Analysis 2:46
- The Python Analytics Ecosystem Học thử 2:33
- Data Roles that use Python Học thử 2:19
Chương 3 2. Jupyter Notebooks 10 bài · 35 phút
-
Jupyter Notebooks Intro & Install 2:22
-
Launching Jupyter & Creating a Notebook 3:17
-
The Jupyter Interface 5:55
-
The Code Cell 7:10
-
Comments & Markdown 7:04
-
The Print Function & Function Help 5:11
-
ALTERNATIVE: Google Colab 1:02
-
Printing Practice
-
Helpful Resources & Key Takeaways 3:17
-
QUIZ: Jupyter Notebooks
Chương 4 3. Python Data Types 6 bài · 16 phút
-
Python Data Types 4:11
-
The Type Function & Type Conversion 3:35
-
DEMO: Type Function & Conversion 3:14
-
Type Function Practice
-
Iterables & Mutability 4:37
-
QUIZ: Python Data Types
Chương 5 4. Variables 16 bài · 41 phút
-
Intro to Variables 3:26
-
DEMO: Variable Assignment 2:29
-
Variable Assignment
-
ASSIGNMENT: Assigning Variables 1:12
-
SOLUTION: Assigning Variables 0:58
-
Overwriting Variables 5:59
-
Deleting Variables 1:41
-
DEMO: Overwriting & Deleting Variables 4:54
-
Overwriting & Deleting Variables
-
Variable Naming Rules 4:47
-
Keeping Track of Variables 1:42
-
DEMO: Naming & Tracking Variables 4:22
-
ASSIGNMENT: Variable Naming Rules 1:11
-
SOLUTION: Variable Naming Rules 7:31
-
Key Takeaways 0:59
-
QUIZ: Variables
Chương 6 5. Numeric Data 15 bài · 33 phút
-
Intro to Numeric Data 0:26
-
Numeric Data Types 1:05
-
Numeric Type Conversion 2:39
-
Arithmetic Operators & Order of Operations 5:02
-
DEMO: Numeric Data 5:14
-
Arithmetic Practice
-
ASSIGNMENT: Arithemetic Operators 1:30
-
SOLUTION: Arithmetic Operators 6:01
-
Numeric Functions 3:22
-
DEMO: Numeric Functions 3:29
-
Numeric Function Practice
-
ASSIGNMENT: Numeric Functions 0:50
-
SOLUTION: Numeric Functions 2:33
-
Key Takeaways 0:49
-
QUIZ: Numeric Data
Chương 7 6. Strings 29 bài · 1 giờ 6 phút
-
Intro to Strings 3:02
-
String Arithmetic 2:07
-
DEMO: String Creation & Arithmetic 5:58
-
String Creation & Arithmetic
-
String Indexing 4:13
-
DEMO: String Indexing 1:22
-
String Indexing
-
ASSIGNMENT: String Indexing 1:22
-
SOLUTION: String Indexing 1:45
-
String Slicing 6:37
-
DEMO: String Slicing 2:42
-
String Slicing
-
ASSIGNMENT: String Slicing 1:33
-
SOLUTION: String Slicing 2:38
-
The Length Function 1:10
-
ASSIGNMENT: The Length Function 1:45
-
SOLUTION: The Length Function 2:45
-
String Methods 10:28
-
DEMO: String Methods 4:47
-
String Methods
-
ASSIGNMENT: String Methods 1:20
-
SOLUTION: String Methods 3:09
-
F-Strings 1:26
-
DEMO: F-Strings 1:42
-
F-Strings
-
ASSIGNMENT: F-Strings 1:18
-
SOLUTION: F-Strings 0:51
-
Key Takeaways 1:31
-
QUIZ: Strings
Chương 8 7. Conditional Logic 18 bài · 49 phút
-
The Boolean Data Type 1:33
-
Comparison Operators & Membership Tests 3:15
-
Boolean Operators 3:53
-
DEMO: Boolean Data Types & Operators 7:24
-
Boolean Tests
-
ASSIGNMENT: Boolean Operators 1:39
-
SOLUTION: Boolean Operators 6:17
-
The IF Statement & Control Flow 3:11
-
Else & Elif Statements 4:47
-
DEMO: If, Else, Elif 5:42
-
If, Else, Elif
-
ASSIGNMENT: Control Flow 0:41
-
SOLUTION: Control Flow 2:39
-
Nested If Statements 1:46
-
ASSIGNMENT: Nested If Statements 1:30
-
SOLUTION: Nested If Statements 3:39
-
Key Takeaways 1:07
-
QUIZ: Conditional Logic
Chương 9 8. Sequence Data Types 34 bài · 1 giờ 26 phút
-
Sequence & List Basics 1:56
-
List Operations 3:02
-
DEMO: List Operations 2:48
-
List Operations
-
ASSIGNMENT: List Operations 1:37
-
SOLUTION: List Operations 4:34
-
Modifying Lists 3:50
-
ASSIGNMENT: Adding List Elements 1:13
-
SOLUTION: Adding List Elements 2:56
-
ASSIGNMENT: Removing List Elements 0:49
-
SOLUTION: Removing List Elements 3:05
-
DEMO: Modifying Lists 5:41
-
Modifying Lists
-
List Methods & Functions 4:29
-
DEMO: List Methods & Functions 6:39
-
List_Methods & Functions
-
ASSIGNMENT: List Methods & Functions 2:33
-
SOLUTION: List Methods & Functions 3:19
-
Nesting & Copying Lists 4:50
-
DEMO: Nested Lists & Copying Lists 7:26
-
ASSIGNMENT: Nested Lists & Copying Lists 1:14
-
SOLUTION: Nested Lists & Copying Lists 4:36
-
Tuples 3:46
-
DEMO: Tuples 4:00
-
Tuples
-
ASSIGNMENT: Tuples 0:58
-
SOLUTION: Tuples 2:11
-
Ranges 2:07
-
DEMO: Ranges 2:09
-
Ranges
-
ASSIGNMENT: Ranges 1:01
-
SOLUTION: Ranges 2:36
-
Key Takeaways 1:02
-
QUIZ: Sequence Data Types
Chương 10 9. Loops 33 bài · 1 giờ 16 phút
-
Loop Basics 3:06
-
For Loops & Looping Over Items 4:31
-
DEMO: For Loops 4:50
-
For Loops
-
Looping Over Indices & Multiple Iterables 2:30
-
DEMO: Looping Over Indices 3:59
-
Looping over indices
-
PRO TIP: Enumerate 1:58
-
DEMO: Enumerate 5:40
-
Enumerate
-
ASSIGNMENT: For Loops 1:44
-
SOLUTION: For Loops 2:19
-
ASSIGNMENT: Enumerate 0:58
-
SOLUTION: Enumerate 2:57
-
While Loops 4:18
-
DEMO: While Loops 3:32
-
While Loops
-
ASSIGNMENT: While Loops 0:59
-
SOLUTION: While Loops 2:04
-
Nested Loops 2:20
-
DEMO: Nested Loops 4:25
-
Nested Loops
-
ASSIGNMENT: Nested Loops 1:38
-
SOLUTION: Nested Loops 3:55
-
Loop Control 0:47
-
Break, Continue & Pass 3:20
-
Loop Control
-
Try-Except 3:15
-
DEMO: Loop Control 5:27
-
ASSIGNMENT: Loop Control 1:49
-
SOLUTION: Loop Control 2:43
-
Key Takeaways 0:39
-
QUIZ: Loops
Chương 11 10. Dictionaries & Sets 36 bài · 1 giờ 15 phút
-
Intro to Dictionaries 1:24
-
Dictionary Overview 2:28
-
Accessing & Modifying Dictionary Values 1:08
-
DEMO: Dictionary Operations 6:10
-
Dictionary Operations
-
ASSIGNMENT: Dictionary Basics 0:59
-
SOLUTION: Dictionary Basics 1:40
-
ASSIGNMENT: Dictionary Creation 1:09
-
SOLUTION: Dictionary Creation 2:50
-
Keys & Values Methods 1:39
-
Get, Items & Update Methods 2:59
-
DEMO: Dictionary Methods 6:30
-
ASSIGNMENT: Dictionary Methods 1:33
-
SOLUTION: Dictionary Methods 5:00
-
The Zip Function 2:18
-
The Zip Function
-
ASSIGNMENT: The Zip Function 1:00
-
SOLUTION: The Zip Function 2:28
-
Nested Dictionaries 1:07
-
DEMO: Nested Dictionaries 4:40
-
Nested Dictionaries
-
ASSIGNMENT: Nested Dictionaries 1:42
-
SOLUTION: Nested Dictionaries 5:02
-
Intro to Sets 1:45
-
DEMO: Sets 1:54
-
Sets
-
ASSIGNMENT: Sets 1:03
-
SOLUTION:Sets 3:41
-
Set Operations 3:22
-
Set Use Cases 2:08
-
DEMO: Set Operations 3:04
-
Set Operations
-
ASSIGNMENT: Set Operations 1:09
-
SOLUTION: Set Operations 2:24
-
Key Takeaways 1:06
-
QUIZ: Dictionaries & Sets
Chương 12 11. Functions 49 bài · 1 giờ 51 phút
-
Intro to Functions 2:11
-
Anatomy of a Function 1:31
-
Defining Functions 3:25
-
The Docstring 1:12
-
DEMO: Defining a Function 4:18
-
Defining A Function
-
ASSIGNMENT: Defining a Function 1:06
-
SOLUTION: Defining a Function 3:04
-
Argument Types 6:12
-
DEMO: Argument Types 6:47
-
Argument Types
-
Return Values 2:52
-
DEMO: Return Values 2:48
-
Return Values
-
Variable Scope 2:38
-
DEMO: Variable Scope 2:54
-
Creating Modules 1:27
-
Importing Modules 2:04
-
DEMO: Creating & Importing Modules 4:33
-
ASSIGNMENT: Creating a Module 1:18
-
SOLUTION: Creating a Module 3:11
-
ASSIGNMENT: Importing a Function 1:33
-
SOLUTION: Importing a Function 3:34
-
Importing External Functions 3:24
-
PRO TIP: Naming Conflicts 1:35
-
Installing & Managing Packages 3:27
-
DEMO: Installing Packages 3:10
-
The Map Function 1:12
-
The Map Function
-
ASSIGNMENT: The Map Function 0:37
-
SOLUTION: The Map Function 1:33
-
Lambda Functions 2:47
-
DEMO: Lambda Functions 1:51
-
Lambda Functions
-
ASSIGNMENT: Lambda Functions 1:00
-
SOLUTION: Lambda Functions 3:47
-
PRO TIP: Comprehensions 2:11
-
DEMO: List Comprehensions 3:50
-
List Comprehensions
-
ASSIGNMENT: List Comprehensions 1:17
-
SOLUTION: List Comprehensions 1:35
-
PRO TIP: Dictionary Comprehensions 3:54
-
DEMO: Dictionary Comprehensions 2:36
-
Dictionary Comprehensions
-
ASSIGNMENT: Dictionary Comprehensions 2:08
-
SOLUTION: Dictionary Comprehensions 5:48
-
PRO TIP: Comprehensions vs. Map() 3:43
-
Key Takeaways 1:26
-
QUIZ: Functions
Chương 13 12. Manipulating Excel Sheets 14 bài · 42 phút
-
The Openpyxl Package 3:00
-
Navigating Excel Workbooks, Worksheets & Cells 4:32
-
DEMO: Navigating Excel Workbooks With Python 3:46
-
ASSIGNMENT: Missing Sales Tax 1:41
-
SOLUTION: Missing Sales Tax 4:11
-
Determining Ranges & Writing to Cells 5:57
-
DEMO: Writing To Excel From Python 4:25
-
ASSIGNMENT: Pound & Yen Columns 2:09
-
SOLUTION: Pound & Yen Columns 6:15
-
Inserting & Deleting Columns 1:41
-
Saving Workbooks 1:48
-
Bringing it All Together 1:04
-
Key Takeaways 1:59
-
QUIZ: Manipulating Excel Sheets
Chương 14 13. Final Course Project 3 bài · 33 phút
-
Welcome to the Final Project! 3:15
-
SOLUTION: Final Project (Part 1) 13:23
-
SOLUTION: Final Project (Part 2) 16:07
Chương 15 BONUS LESSON 1 bài
-
BONUS LESSON
Requirment
-
No Python or programming experience required (we'll cover everything you need to know!)
-
We'll use Anaconda & Jupyter Notebooks (a free, user-friendly coding environment)
Outcomes
-
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 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
0 Student
9 Courses
0 review