Python Foundations for Data Analysis & Business Intelligence

Preview this Course - GET COUPON CODE

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.

Who this course is for:

• Analysts or BI professionals looking for a deep introduction to basic Python
• Aspiring data scientists who want to build foundational Python programming skills
• Anyone interested in learning one of the most popular open source programming languages in the world
• Students looking to learn powerful, practical skills with hands-on projects and course demos

What you'll learn

• 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