Python for Data Analysis & Business Intelligence

Learn Python for data analysis & business intelligence, w/ real-world projects from a top Python data science instructor

  • 0.0 (0 Reviews)
  • 0 Students
  • 274 Lessons
  • Maven Analytics (2,000,000+ Learners)

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.

See more

FAQ

FAQ area empty

Course curriculum

15 chương 274 bài học 11 giờ 17 phút 7 bài học thử miễn phí
Chương 1 Getting Started
Chương 2 1. Why Python for Analytics?
Chương 3 2. Jupyter Notebooks
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

Instructor

...
Maven Analytics (2,000,000+ Learners)

0.0

  • ... 0 Student
  • ... 9 Courses
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all