Move from Excel to Python with Pandas Transcripts
Chapter: Case study walk through: Sales commissions
Lecture: Wrapping up
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
well, he did a lot of work to get here,
0:02
and the final report was received very well by your commercial leadership.
0:07
Let's walk through what we pulled together.
0:09
So we have this nice summary by sales rep by channel what their commission would be
0:15
Then we come up with our commission rate,
0:19
and finally we made some tweaks to the alignment so that the sales reps cover different
0:24
states, and we included the account number and the sales total associated with each of
0:29
these new alignments. And what's really nice about this is now we have documented steps
0:35
for future use. You can always go back to your notebook and see what you
0:39
did to develop this report. If you need to make changes,
0:42
for instance, we want to change our commission rate because we have a higher budget
0:47
or were bringing in some additional sales people we can modify in one place and rerun
0:53
all of our analysis. The other thing is,
0:55
this data set was relatively small and easy demands with excel.
0:59
But if you had tens of thousands or hundreds of thousands of transactions,
1:03
this process would run at virtually the same speed as it did with the smaller data
1:08
set. And then we just touched the surface of what you can do with Python
1:12
Amanda's so we could start to use all this data to do enhance visualization,
1:17
machine learning or much more complex analysis.
1:21
So I hope you really enjoyed this exercise and are able to apply this to some