Mô tả

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.


COURSE OUTLINE:


  • Why Python for 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 an Analyst, Data Scientist, or Business Intelligence professional looking to build a strong Python foundation and add powerful 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.

Bạn sẽ học được gì

Yêu cầu

Nội dung khoá học

15 sections

Getting Started

5 lectures
Course Structure & Outline
01:42
READ ME: Important Notes for New Students
02:13
DOWNLOAD: Course Resources
00:08
Introducing the Course Project
00:48
Setting Expectations
01:50

1. Why Python for Analytics?

4 lectures
What is Python?
01:12
Python for Data Analysis
02:46
The Python Analytics Ecosystem
02:33
Data Roles that use Python
02:19

2. Jupyter Notebooks

10 lectures
Jupyter Notebooks Intro & Install
02:12
Launching Jupyter & Creating a Notebook
03:17
The Jupyter Interface
05:56
The Code Cell
05:38
Comments & Markdown
07:04
The Print Function & Function Help
05:11
ALTERNATIVE: Google Colab
01:02
Printing Practice
1 question
Helpful Resources & Key Takeaways
03:17
QUIZ: Jupyter Notebooks
5 questions

3. Python Data Types

6 lectures
Python Data Types
04:11
The Type Function & Type Conversion
03:35
DEMO: Type Function & Conversion
03:14
Type Function Practice
1 question
Iterables & Mutability
04:37
QUIZ: Python Data Types
5 questions

4. Variables

16 lectures
Intro to Variables
03:26
DEMO: Variable Assignment
02:29
Variable Assignment
1 question
ASSIGNMENT: Assigning Variables
01:12
SOLUTION: Assigning Variables
00:58
Overwriting Variables
05:59
Deleting Variables
01:41
DEMO: Overwriting & Deleting Variables
04:54
Overwriting & Deleting Variables
1 question
Variable Naming Rules
04:47
Keeping Track of Variables
01:42
DEMO: Naming & Tracking Variables
04:22
ASSIGNMENT: Variable Naming Rules
01:11
SOLUTION: Variable Naming Rules
07:31
Key Takeaways
00:59
QUIZ: Variables
5 questions

5. Numeric Data

15 lectures
Intro to Numeric Data
00:26
Numeric Data Types
01:05
Numeric Type Conversion
02:39
Arithmetic Operators & Order of Operations
05:02
DEMO: Numeric Data
05:14
Arithmetic Practice
1 question
ASSIGNMENT: Arithemetic Operators
01:30
SOLUTION: Arithmetic Operators
06:01
Numeric Functions
03:22
DEMO: Numeric Functions
03:29
Numeric Function Practice
1 question
ASSIGNMENT: Numeric Functions
00:50
SOLUTION: Numeric Functions
02:33
Key Takeaways
00:49
QUIZ: Numeric Data
5 questions

6. Strings

29 lectures
Intro to Strings
03:02
String Arithmetic
02:07
DEMO: String Creation & Arithmetic
05:58
String Creation & Arithmetic
1 question
String Indexing
04:13
DEMO: String Indexing
01:22
String Indexing
1 question
ASSIGNMENT: String Indexing
01:22
SOLUTION: String Indexing
01:45
String Slicing
06:37
DEMO: String Slicing
02:42
String Slicing
1 question
ASSIGNMENT: String Slicing
01:33
SOLUTION: String Slicing
02:38
The Length Function
01:10
ASSIGNMENT: The Length Function
01:45
SOLUTION: The Length Function
02:45
String Methods
10:28
DEMO: String Methods
04:47
String Methods
1 question
ASSIGNMENT: String Methods
01:20
SOLUTION: String Methods
03:09
F-Strings
01:26
DEMO: F-Strings
01:42
F-Strings
1 question
ASSIGNMENT: F-Strings
01:18
SOLUTION: F-Strings
00:51
Key Takeaways
01:31
QUIZ: Strings
5 questions

7. Conditional Logic

18 lectures
The Boolean Data Type
01:33
Comparison Operators & Membership Tests
03:15
Boolean Operators
03:53
DEMO: Boolean Data Types & Operators
07:24
Boolean Tests
1 question
ASSIGNMENT: Boolean Operators
01:39
SOLUTION: Boolean Operators
06:17
The IF Statement & Control Flow
03:11
Else & Elif Statements
04:47
DEMO: If, Else, Elif
05:42
If, Else, Elif
1 question
ASSIGNMENT: Control Flow
00:41
SOLUTION: Control Flow
02:39
Nested If Statements
01:46
ASSIGNMENT: Nested If Statements
01:30
SOLUTION: Nested If Statements
03:39
Key Takeaways
01:07
QUIZ: Conditional Logic
5 questions

8. Sequence Data Types

34 lectures
Sequence & List Basics
01:56
List Operations
03:02
DEMO: List Operations
02:48
List Operations
1 question
ASSIGNMENT: List Operations
01:37
SOLUTION: List Operations
04:34
Modifying Lists
03:50
ASSIGNMENT: Adding List Elements
01:13
SOLUTION: Adding List Elements
02:56
ASSIGNMENT: Removing List Elements
00:50
SOLUTION: Removing List Elements
03:05
DEMO: Modifying Lists
05:41
Modifying Lists
1 question
List Methods & Functions
04:29
DEMO: List Methods & Functions
06:39
List_Methods & Functions
1 question
ASSIGNMENT: List Methods & Functions
02:33
SOLUTION: List Methods & Functions
03:19
Nesting & Copying Lists
04:50
DEMO: Nested Lists & Copying Lists
07:26
ASSIGNMENT: Nested Lists & Copying Lists
01:14
SOLUTION: Nested Lists & Copying Lists
04:36
Tuples
03:46
DEMO: Tuples
04:00
Tuples
1 question
ASSIGNMENT: Tuples
00:58
SOLUTION: Tuples
02:11
Ranges
02:07
DEMO: Ranges
02:09
Ranges
1 question
ASSIGNMENT: Ranges
01:01
SOLUTION: Ranges
02:36
Key Takeaways
01:02
QUIZ: Sequence Data Types
5 questions

9. Loops

33 lectures
Loop Basics
03:06
For Loops & Looping Over Items
04:31
DEMO: For Loops
04:50
For Loops
1 question
Looping Over Indices & Multiple Iterables
02:30
DEMO: Looping Over Indices
03:59
Looping over indices
1 question
PRO TIP: Enumerate
01:58
DEMO: Enumerate
05:40
Enumerate
1 question
ASSIGNMENT: For Loops
01:45
SOLUTION: For Loops
02:19
ASSIGNMENT: Enumerate
00:58
SOLUTION: Enumerate
02:57
While Loops
04:18
DEMO: While Loops
03:32
While Loops
1 question
ASSIGNMENT: While Loops
00:59
SOLUTION: While Loops
02:04
Nested Loops
02:20
DEMO: Nested Loops
04:25
Nested Loops
1 question
ASSIGNMENT: Nested Loops
01:38
SOLUTION: Nested Loops
03:55
Loop Control
00:47
Break, Continue & Pass
03:20
Loop Control
1 question
Try-Except
03:15
DEMO: Loop Control
05:27
ASSIGNMENT: Loop Control
01:49
SOLUTION: Loop Control
02:43
Key Takeaways
00:39
QUIZ: Loops
5 questions

10. Dictionaries & Sets

36 lectures
Intro to Dictionaries
01:24
Dictionary Overview
02:28
Accessing & Modifying Dictionary Values
01:08
DEMO: Dictionary Operations
06:10
Dictionary Operations
1 question
ASSIGNMENT: Dictionary Basics
00:59
SOLUTION: Dictionary Basics
01:40
ASSIGNMENT: Dictionary Creation
01:09
SOLUTION: Dictionary Creation
02:50
Keys & Values Methods
01:39
Get, Items & Update Methods
03:00
DEMO: Dictionary Methods
06:30
ASSIGNMENT: Dictionary Methods
01:33
SOLUTION: Dictionary Methods
05:00
The Zip Function
02:18
The Zip Function
1 question
ASSIGNMENT: The Zip Function
01:00
SOLUTION: The Zip Function
02:28
Nested Dictionaries
01:07
DEMO: Nested Dictionaries
04:40
Nested Dictionaries
1 question
ASSIGNMENT: Nested Dictionaries
01:42
SOLUTION: Nested Dictionaries
05:02
Intro to Sets
01:45
DEMO: Sets
01:54
Sets
1 question
ASSIGNMENT: Sets
01:03
SOLUTION:Sets
03:41
Set Operations
03:22
Set Use Cases
02:08
DEMO: Set Operations
03:04
Set Operations
1 question
ASSIGNMENT: Set Operations
01:09
SOLUTION: Set Operations
02:24
Key Takeaways
01:06
QUIZ: Dictionaries & Sets
7 questions

11. Functions

49 lectures
Intro to Functions
02:11
Anatomy of a Function
01:31
Defining Functions
03:25
The Docstring
01:13
DEMO: Defining a Function
04:18
Defining A Function
1 question
ASSIGNMENT: Defining a Function
01:06
SOLUTION: Defining a Function
03:04
Argument Types
06:12
DEMO: Argument Types
06:47
Argument Types
1 question
Return Values
02:52
DEMO: Return Values
02:48
Return Values
1 question
Variable Scope
02:38
DEMO: Variable Scope
02:54
Creating Modules
01:27
Importing Modules
02:04
DEMO: Creating & Importing Modules
04:33
ASSIGNMENT: Creating a Module
01:18
SOLUTION: Creating a Module
03:11
ASSIGNMENT: Importing a Function
01:34
SOLUTION: Importing a Function
03:34
Importing External Functions
03:24
PRO TIP: Naming Conflicts
01:35
Installing & Managing Packages
03:27
DEMO: Installing Packages
03:10
The Map Function
01:12
The Map Function
1 question
ASSIGNMENT: The Map Function
00:37
SOLUTION: The Map Function
01:33
Lambda Functions
02:47
DEMO: Lambda Functions
01:51
Lambda Functions
1 question
ASSIGNMENT: Lambda Functions
01:00
SOLUTION: Lambda Functions
03:47
PRO TIP: Comprehensions
02:11
DEMO: List Comprehensions
03:50
List Comprehensions
1 question
ASSIGNMENT: List Comprehensions
01:17
SOLUTION: List Comprehensions
01:35
PRO TIP: Dictionary Comprehensions
03:54
DEMO: Dictionary Comprehensions
02:36
Dictionary Comprehensions
1 question
ASSIGNMENT: Dictionary Comprehensions
02:08
SOLUTION: Dictionary Comprehensions
05:48
PRO TIP: Comprehensions vs. Map()
03:43
Key Takeaways
01:26
QUIZ: Functions
6 questions

12. Manipulating Excel Sheets

14 lectures
The Openpyxl Package
03:00
Navigating Excel Workbooks, Worksheets & Cells
04:32
DEMO: Navigating Excel Workbooks With Python
03:46
ASSIGNMENT: Missing Sales Tax
01:41
SOLUTION: Missing Sales Tax
04:11
Determining Ranges & Writing to Cells
05:57
DEMO: Writing To Excel From Python
04:25
ASSIGNMENT: Pound & Yen Columns
02:10
SOLUTION: Pound & Yen Columns
06:15
Inserting & Deleting Columns
01:41
Saving Workbooks
01:48
Bringing it All Together
01:04
Key Takeaways
02:00
QUIZ: Manipulating Excel Sheets
5 questions

13. Final Course Project

3 lectures
Welcome to the Final Project!
03:16
SOLUTION: Final Project (Part 1)
13:23
SOLUTION: Final Project (Part 2)
16:07

BONUS LESSON

1 lectures
BONUS LESSON
01:42

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.