loading…
If you like building the dashboards and reports a business runs on, and making sure the numbers behind them are right, this role is for you.
Builds the reports and dashboards leaders use to track the business. Python and SQL prepare and check the data behind dashboards; the dashboards themselves are usually built in BI tools.
Take the lessons top to bottom. Each one opens with code you run, and ends with graded exercises that check your answer.
16 lessons every path shares. Skip the ones you already know.
Write your first Python program and print to the screen.
Numbers, strings, booleans — the building blocks.
Arithmetic, powers, the math module — Python as a calculator.
Slicing, methods, and f-strings — text manipulation done right.
Make decisions and repeat yourself — but only on purpose.
Loop until a condition fails. Bail out or skip with break/continue.
Collections of things, and how to walk through them.
Carve up lists and strings with [start:stop:step].
Two more collections: tuples are fixed, sets are unique.
Key → value pairs. The most important data structure in Python.
Empty things are False. `is` vs `==`. The infamous None.
The Pythonic ways to iterate — count, pair, sequence.
Bundle up logic so you can reuse it.
Lists of dicts, dicts of lists — modelling real-world data.
Filter and transform in one line — the Pythonic way.
Catch what could go wrong, recover gracefully.
9 lessons specific to this role.
Today, deltas, parsing, formatting — without losing your mind.
DataFrames in your browser. Auto-installs pandas on first run.
Real datasets arrive dirty: missing cells, wrong dtypes, duplicate rows. Fix them with isna/fillna/dropna, to_numeric, rename and drop_duplicates.
Split rows into groups, aggregate each with sum/mean/count, compute several stats at once with named agg, and sort the summary.
Split-apply-combine — the pattern behind every real data analysis.
Pandas time series tutorial: use DatetimeIndex, resampling, rolling windows, and grouped time-based analysis.
A real database in a single file. Perfect for learning SQL end-to-end.
INNER, LEFT, RIGHT, FULL — with a concrete users-and-orders example.
Real charts that ship — line, bar, distribution, heatmap.
Projects and workspace templates that fit this role. Publish the result to your portfolio page.
Finishing this path gives you the Python part of the job, with graded exercises and projects you can show. It is not, by itself, a qualification for the role.