2022-02 Workshop: Sales Reporting with Pandas

$399

2022-02 Workshop: Sales Reporting with Pandas

Course
9 Lessons

Throw out Excel. Leverage Pandas (and the Python ecosystem) to automate reporting and forecasting. Runs Feb 7,8,9,10 from 2-4pm MST.

Buy now

Throw out Excel....

Well you don't need to get rid of Excel quite yet. But you might consider it. 😉

Create programmatic reports that are quick, customizable, and automated.

Python is quickly becoming the tool of choice for data scientists, analysts, quants, hobbyists, and professionals.

Learn how to create sales reports just like you did in Excel. Except, you can automate them, re-use them, productize them, and apply powerful Python libraries to them.

Learn the techniques I have used on my own projects, consulting engagements, and start automating reporting now.

An investment in learning Pandas and the Python computing stack is an investment in the future. Create win-win reports with ease. (And export to Excel if you really need it to keep your boss happy.)

The Contents of "Sales Reporting with Pandas"

Ingesting Data
1. Anonymizing sensitive data
2. Processing data for reporting
Basics
1. Aggregations
2. Sales Reports with Pandas
3. Comparing to Prior Periods
Deliverables
1. Slapping lipstick on that pig... Formatting!
2. Making the boss happy... exporting to Excel
3. Baseline Visualizations
Forecasting
1. Simple Forecasting
2. Correlations
3. Autocorrelation
4. Prediction with Moving Averages
5. Prediction with Exponential Smoothing
6. Prediction with Linear Regression
Fine Tuning
1. Model Evaluation
2. Optimizing Predictions
3. De-trending
Where to now?

Feedback from Workshops

I've taught hundreds of courses to large companies, audiences, universities, and more. My goal is to make my students successful. Here are some happy students from recent workshops.

Tomás L

Having done half of

@__mharrison__

‘s Intermediate #Python Workshop I can say it is one of the best I have ever taken.
Habiendo hecho la mitad del curso puedo decir que es uno de los mejores que jamás he realizado.

Oscar P

Excellent class - outstanding teacher

Bachir B.

Great class! Very satisfied.

Course Takeaways

After this workshop you will be able to:

Create Reports with Pandas

Use pandas to generate useful sales reports.

Visualize and Export to Excel

Take your output and throw it in Excel to make your boss happy. Or visualize it in Jupyter or Excel to grok what is happening.

Create Simple Forecasts

An introduction to forecasting techniques commonly done in Excel. Let's see what will happen next month or quarter!

FAQ

You’ve got questions. We’ve got answers.

How does the course work?

We will meet 4 times for two hours. About 60% of the course will be teaching and demonstration. The remaining portion will be dedicated to lab work.

How do the labs work?

The point of this course is to apply it to your data. I encourage you to bring your data and work on it during lab time. If it is proprietary you can work on a demo dataset.

Can I just listen?

Yes, you can, but I really encourage participation. This course will be 100x more valuable to you (and your business) if you apply the learnings to your data.

Can I get you to write Pandas code for me?

During labtime I'm happy to help. If you need additional help, I'm available to consult with your company.

How much Python do I need?

You should know how to create functions, loop, and use dictionaries and lists.
If you can do that, I will provide an intro to lambdas and comprehensions.

What do I need to install?

You can follow these instructions or use Google Colab if you don't want to install anything.

Have another question?

Drop me a line in the chat below.

About

calendar.ics

414 Bytes

Zoom Connection

Files

SalesReportingWorkshop.ipynb

60.2 KB

sale_reporting.csv

203 KB

Day 1

GMT20220207-205959_Recording_3840x2160.mp4

(2h 28m 39s)
730 MB

Day 2

GMT20220208-205935_Recording_3840x2160.mp4

(1h 59m 27s)
821 MB

Day 3

GMT20220209-210006_Recording_3840x2160.mp4

(2h 41m 10s)
1.41 GB

Day 4

SalesReportingWorkshop.ipynb

1.22 MB

GMT20220210-205947_Recording_3840x2160.mp4

(2h 01m 24s)
628 MB