Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Excel invoice files
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
But the next stage of the analysis, we want to look in more detail at the individual transaction level so we can see
0:08
what products the companies air purchasing. So we're going to use to files.
0:13
The first file is the customer rep data file that we reviewed in the previous videos
0:18
So as a refresher, this includes the company information as well as the sales rep, and it's aggregated at the total company.
0:27
And this is the other file. This is invoice level data for each customer that shows what they purchased which invoice,
0:35
invoice date and what the total amount. Waas. So now we're gonna have to pull this detail together with the customer information
0:43
in the sales rep information to come up with some more scenarios for our commission report