Interview demo preview

The Demo That Lands Data Jobs

This is the kind of live demo I used in a Zoom interview to land a data analytics job.

run_demo.py · course-3-land-the-job

Explorer

course-3-land-the-job

example-output

images

checklist.html

dashboard_template.html

messy_raw_data.csv

requirements.txt

run_demo.py

START-HERE.html

run_demo.py

1def main():

2 args = read_options()

3 log = RunLog(source=args.data.name, pause=args.pause, wait_for_enter=args.step)

4 log.say(f"Operations pipeline: {args.data.name}", kind="header")

5 log.say()

7 raw = load_raw_data(args.data, log)

8 df, duplicates = remove_duplicates(raw, log)

9 df = fix_dates(df, log)

10 df = fix_categories(df, log)

11 df, restored, dropped = fill_missing_values(df, log)

12 totals = validate_totals(raw, duplicates, restored, dropped, df, log)

13 if not totals["ok"]:

14 log.say()

15 log.say("FAILED. The dashboard was not built. Fix the problems above and run again.")

16 sys.exit(1)

18 page = build_dashboard(df, totals, log, open_page=not args.no_open)

19 finish(page, len(df), log, open_page=not args.no_open)

TerminalProblemsOutput

$ python run_demo.py

Operations pipeline: messy_raw_data.csv

[1/6] Loading raw data...1,240 rows

[2/6] Cleaning...removed 18 duplicates

[3/6] Fixing dates...477 dates in 3 formats -> YYYY-MM-DD

[4/6] Fixing category typos...37 corrected

[5/6] Filling missing values...38 filled, 6 dropped

[6/6] Validating totals...OK

Building dashboard...demo_dashboard.html

Opening in your browser...

demo_dashboard.html

Operations pipeline · demo

Orders dashboard

Built by run_demo.py from messy_raw_data.csv.

Dashboard

Revenue

$267,150

Orders

381

Units

10,052

Average order

$220

Revenue by month

SepOctNovDecJanFebMarAprMayJunJulAug

Preview paused

Unlock the full demo, $5

Your $5 comes off the full course.

What you get

The whole run, and why it works.

01The full demo, start to finish: the pipeline completes and the finished dashboard renders.
02A plain-language breakdown of every step, and why interviewers react to it.
03A code worth $5 off Land the Job, so your $5 comes back when you buy the course.

Access lasts 30 days, on any device.

Want the whole course instead? Land the Job: The Interview Demo, $25