Articles
Page 2 of 5Practical guides on automation, ecommerce optimisation, and data engineering by Fawad Hussain Syed.
Build a Python AI Agent for Automated Data Analysis
Build an AI agent in Python that analyses datasets autonomously — writing and executing its own pandas code, generating summaries, and producing reports — with tool-use patterns, sandboxed execution, and guardrails to keep it from going off the rails.
Build a Price Monitoring Bot with Python and Playwright
Build a price monitoring bot that tracks competitor prices on any website — using Playwright for JavaScript-rendered pages, structured extraction with fallback selectors, change detection, and scheduled alerts when prices move.
Bun Rewrites in Rust: What It Means for the JavaScript Runtime
Bun merged a million-line PR rewriting its core from Zig to Rust. This post covers the technical motivations, what changed in the codebase, measured performance impact, and what it signals for the JavaScript runtime ecosystem.
Python Polars vs Pandas: Performance Benchmarks with Real Data
Benchmark Polars against Pandas on real-world data tasks — CSV loading, group aggregations, joins, window functions, and memory usage — with actual numbers so you can decide when switching is worth it.
Build an LLM-Powered Data Pipeline with Python and OpenAI
Build a production data pipeline that uses OpenAI's API to classify, extract, and enrich unstructured text — with structured output parsing, cost controls, rate limiting, and fallback logic so it actually works at scale.
Shopify Performance Monitoring: Automated Alerts for Store Speed
Build an automated monitoring system that tracks Shopify store performance, detects speed regressions, and sends alerts before customers notice — using Lighthouse CI, synthetic checks, and threshold-based notifications.
Ecommerce Data Pipeline: Reporting Architecture That Scales
Design a data pipeline architecture for ecommerce reporting that handles multi-platform ingestion, incremental loads, dimension modelling, and automated report generation — from raw API data to business-ready dashboards.
Python Secrets Management for Automation Pipelines
Manage API keys, database credentials, and tokens across Python automation pipelines — from environment variables to vault integration, with patterns that scale from solo scripts to team deployments.
How to Build Dashboards Without BI Tools: Python + HTML
Build interactive data dashboards using Python and HTML templates instead of expensive BI tools — from data processing to chart rendering to automated deployment, with no licence fees.
Prefect Reusable Task Blocks: Build Composable Workflow Components
Build reusable task blocks in Prefect that snap together into different workflows — shared extractors, validators, loaders, and notification tasks that eliminate duplication across pipelines.
Prefect IntervalSchedule Migration: From Legacy Schedules to Prefect 3
Migrate from deprecated prefect.server.schemas.schedules IntervalSchedule to Prefect 3 scheduling patterns — with side-by-side code comparisons, common errors, and a step-by-step upgrade path.
Build a Self-Updating Shopify Analytics Dashboard with Python
Build a self-updating Shopify analytics dashboard that tracks sales, inventory levels, and customer metrics — scheduled data pulls, trend comparisons, and alert thresholds, all automated.