Writings
Sharing what I'm learning — let's learn together.
Exploratory Data Analysis — Python
Unveiling Matplotlib: Visualizing Betting Strategies and Monte Carlo Simulations
Exploring Matplotlib's visualization capabilities through the Martingale strategy
Gathering Data You Don't Have — How to Effectively Webscrape Anything
External data collection strategies for analysts, engineers, and scientists
Exploratory Data Analysis — SQL
Efficient Querying — Distribution Keys, Sort Keys, Explain and Analyze Queries
Redshift optimization techniques for BI engineers managing billions of rows
Nifty Redshift SQL Techniques
Lesser-known but useful Redshift SQL functions and techniques
Dashboarding
Tableau vs QuickSight — What Should My Company Choose?
A practical comparison of two major BI platforms
Machine Learning Models
Classical Supervised ML (Classification) — Decision Trees, Boosting, Neural Networks, KNN, SVM
Comparative analysis of five classical algorithms on Wine and Apple Quality datasets
Classical Unsupervised ML — Dimensionality Reduction and Clustering
Exploring clustering and dimensionality reduction on Wine and Apple Quality datasets
Exploring Random Optimization Algorithms on Machine Learning Models
Comparing random optimization with backpropagation for neural network weight optimization
Reinforcement Learning Algorithms in Blackjack and Frozen Lake
Exploring Value Iteration, Policy Iteration, and Q-Learning in two contrasting environments
ML Application: Predicting Stock Market Using Random Forests
Using technical indicators and Random Forests to forecast JPM stock price movements
Large Language Models
Large Language Model Application — Text2SQL (Part 1)
How LLMs and generative AI can address internal data team challenges
Large Language Model Application — Text2SQL (Part 2)
Technical architecture and design decisions for operationalizing Text2SQL
Large Language Model Application — Text2SQL (Part 3)
Hyperparameter tuning, knowledge base construction, testing, and deployment
Improving LLM Accuracy is Hard
Strategies for enhancing LLM application accuracy, with Text2SQL as a case study
Exploring Multimodal RAG: Unlocking New Frontiers
How multimodal embeddings enable RAG systems that work across text, images, and video