Blog
2024
- Don’t Play the Hyperparameter Lotteryblog post about Sliding and Expanding Windows in SQL and Pandas.
- Ranking and Row Numbering in Pandas and SQL: A Comprehensive Guideblog post about SQL and Pandas ranking and row numbering.
- Sliding and Expanding Windows in SQL and Pandas: A Comprehensive Guideblog post about Sliding and Expanding Windows in SQL and Pandas.
- Solving the Gaps and Islands Problem Using Python PandasLearn how to solve the classic gaps and islands problem using Python Pandas, a powerful tool for data manipulation and analysis.
- Conquering the SQL Islands Problem: Finding Continuous Ranges in Date DataMaster the classic SQL challenge of identifying 'islands' of continuous data within overlapping date ranges. Learn practical techniques with clear examples.
- First-In, First-Out (FIFO) cost basis in Snowflake SQLthe First-In, First-Out (FIFO) cost basis within a Snowflake table involves assigning shares sold to the earliest purchases, thereby determining the cost basis for each sale transaction.
- My Favorite SQL Interview Question: Analyzing Movie Viewing SequencesDive into a practical SQL interview question that assesses both technical skills and analytical thinking, focusing on user behavior in a streaming service.
- Updating Machine Learning Models in the Face of Feedback LoopsExplore strategies for responsibly updating machine learning models when feedback loops influence the data used for retraining, ensuring stability and fairness.
- Predicting Litigation Risk: A Data-Driven Approach for Insurance ClaimsThis post explores a data-driven methodology for predicting litigation risk in insurance claims using machine learning, enabling optimized resource allocation and proactive risk management.
- Data Science for Smarter MVR Ordering: Optimizing Auto Insurance Costs and Risk AssessmentThis blog post explores how data science techniques can optimize Motor Vehicle Report (MVR) ordering for auto insurers, leading to cost savings and improved risk assessment.
- Correcting Biased Gene Maps with Mixed Effects Random ForestsA simpler explanation of how Mixed Effects Random Forests can improve accuracy in genomic studies.
- Understanding the Cancer Genome: How Mutations Drive CancerA look at how changes in our genes can lead to cancer and what this means for diagnosis and treatment.
2023