Data Analytics
Using SQL and Python to model data and extract insights, creating robust data warehouse solutions and reports.
Using SQL and Python to model data and extract insights, creating robust data warehouse solutions and reports.
Building intuitive and actionable dashboards that make data meaningful at a glance.
Designing automated and reliable data pipelines that simplifies ETL processes and maintain data quality.
Deploying and maintaining secure and scalable infrastructure to support all parts of the data system.
A step-by-step guide to understanding window functions with examples to apply in at your job.
Three real-world SQL patterns that can be applied to many problems.
A rabbit hole of exploring an insecure S3 bucket and finding random files.
Learn how to easily find your underperforming lambda functions.
Tips and tricks picked up from years of using SQL for business reports, helping you to extract meaningful results effectively.
An exploration of cool nginx settings for deploying static websites.