Python Foundations for Data Analysis and Business Intelligence

Categories: Python

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.

Show More

What Will You 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 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

1. Why Python for Analytics?

2. Jupyter Notebooks

3. Python Data Types

4. Variables

5. Numeric Data

6. Strings

7. Conditional Logic

8. Sequence Data Types

9. Loops

10. Dictionaries & Sets

11. Functions

12. Manipulating Excel Sheets

13. Final Project

Certification of Completion

Student Ratings & Reviews

No Review Yet
No Review Yet