# Python

> Selected Engineer ApS work demonstrating Python — the achievements that prove it.

- [Delivered 8 Power BI projects with comprehensive manuals, integrating Microsoft Power BI tools with NodeJS API and Python FastAPI for effective data analytics and visualization.](https://advisory.engineer.company/portfolio/delivered-8-power-bi-projects-with-comprehensive-manuals-10/)
- [Led the development, deployment, and support of over 30 GIS projects, demonstrating expertise in PostgreSQL, Bash, Python, JavaScript, GDAL, ArcGIS, PostGIS, and Mapbox technologies.](https://advisory.engineer.company/portfolio/led-the-development-deployment-and-support-of-over-35/)
- [Developed a Data Analytics reporting system, increasing quarterly software revenue by 400% through Python‑based PDF reports.](https://advisory.engineer.company/portfolio/developed-a-data-analytics-reporting-system-increasing-quarterly-44/)
- [Built a commit gate of 22 one‑line linters plus five that earn a paragraph, with no warning tier and no inline suppressions permitted, covering HTML, CSS, JavaScript, Python, YAML, Markdown, shell, links, spelling, secrets and typography.](https://advisory.engineer.company/portfolio/built-a-22-linter-commit-gate-127/)
- [Cut the site's browser‑driven quality gate from 1,636 seconds to 615 by scheduling its checks longest‑first through a worker pool bounded to four lanes, after measuring that alphabetical order cost 320 seconds against 224.](https://advisory.engineer.company/portfolio/cut-the-visual-quality-gate-to-ten-minutes-128/)
- [Put the documentation under its own linter — a per‑file line budget that only ratchets down, an index requirement and a real‑path check — which found six of nine plans marked done while carrying unchecked boxes, and fourteen commit‑gating tasks named in no document.](https://advisory.engineer.company/portfolio/put-the-documentation-under-its-own-linter-142/)
- [Brought 10,242 lines of quality‑gate JavaScript under a formatter and a linter after establishing it was the largest body of code in the repository and the only one nothing read, fixing 13 findings and suppressing none.](https://advisory.engineer.company/portfolio/brought-the-quality-gate-code-under-a-linter-143/)
- [Held the generator to 981 test cases at a 92% branch‑coverage floor with warnings treated as failures, and asserted idempotence by running the whole build pipeline twice from an empty file and requiring the second pass to change nothing.](https://advisory.engineer.company/portfolio/held-the-generator-to-964-tests-and-a-coverage-floor-145/)
- [Established PDF/UA‑1 conformance across nine documents at 106 of 106 rules, and found the archival variant failing one rule of 146 — a near‑miss that reads as a pass to anyone not running the validator.](https://advisory.engineer.company/portfolio/established-pdf-ua-1-conformance-across-nine-documents-146/)
- [Selected every rule the Python linter has as an error, working through 1,815 findings to reach zero, with each of the few exemptions carrying a written reason and two of them backed by a checker instead of a comment.](https://advisory.engineer.company/portfolio/enabled-every-python-linter-rule-as-an-error-147/)
- [Wrote tests for the checkers themselves after establishing that a checker fed only clean input will one day report clean because it read nothing — planting a misspelling to confirm the spell‑check finds it, and taking an id range from the database rather than from a number in the test.](https://advisory.engineer.company/portfolio/wrote-tests-for-the-checkers-themselves-149/)
- [Found the commit hooks and the quality gate running different checks while a document promised they were the same, by comparing the two lists in a test — the five that only ever ran by hand were the ones reading the CV prose.](https://advisory.engineer.company/portfolio/found-the-commit-hooks-and-the-gate-disagreeing-150/)
- [Built a cross‑language content check that fails when a translation drops a figure the English states, and when a language uses notation it does not use — finding two Danish descriptions missing a metric and sixteen Ukrainian spans quoting in the English style.](https://advisory.engineer.company/portfolio/built-a-cross-language-figure-and-notation-check-153/)

<https://advisory.engineer.company/categories/python/>
