A small-business data warehouse rebuilt from three messy Excel workbooks (18 sheets) used by a rental agency to run tenancies, rent collection, utility and water bills, inspections, parking and moving ...
A medallion pipeline in PySpark and Delta Lake over five years of CMS Medicare Part D Prescribers by Provider and Drug files (2019 to 2023, 128.5 million rows), with gold marts tracking GLP-1 claims, ...