Python for Business Analysis and Excel

In this course we’ll use Python to:

Read data from Excel and CSV files into Python

Clean and analyze the data in Python going way beyond the functionality that Excel is capable of

Create reusable Python code which can make analyzing data in Python quick and easy

Write data back to Excel for final touches and creating charts

This course uses real world business cases to demonstrate practical applications of Python. By the end of the course you will have a portfolio of business analysis examples that will prove your mastery over Python. This includes:

Customer segmentation analysis – we’ll look at a large set of customer data and tease out different customer segments which are more profitable. This will allow the marketing department to determine which groups to target. We’ll focus on parents with babies and analyze how much money they spend and what their demographic characteristics look like.

Production bottleneck analysis – we’ll look at the production line of a car factory to understand which machines are causing delays in completing the final cars. Using this analysis, we’ll make recommendations on which new machines to invest in. Additionally, we’ll look at how often machines break down and how this contributes to delays.