Category: Data Analysis
-
Building a DevSecOps-Ready GCP ETL Pipeline for Multi-Year Google Sheet Survey Analysis
A behind-the-scenes look at how I engineered a secure, reproducible, analytics-ready GCP ETL pipeline that automates the ingestion and transformation of multi-language Google Sheet survey data; blending YAML preprocessing, Google API integration, data auditing, and DevSecOps principles into one cohesive system.
-
Automating NYC InfoHub Data Collection with an Intelligent Excel Web Scraper
A look at how intelligent web scraping, concurrency, and security checks turn NYC InfoHub’s sprawling maze of Excel datasets into a fast, verifiable, and human-accessible data repository.
-
Why Microsoft VBA Still Matters: Automating Data Workflows in Excel with Visual Basic
Discover why Microsoft VBA still matters in 2025. Learn how simple Excel macros can automate data workflows, streamline reports, and empower nonprofits and education teams with real-world Visual Basic examples.
Dylan K. Picart 