Tien NguyenData Analytics Project Pitfalls: Navigating Common Mistakes and Achieving SuccessData analytics has become an indispensable tool for businesses across industries, providing valuable insights that drive informed…·2 min read·Jan 25, 2024----
Tien NguyenRecursive Tree Traversal and While Loops in SQL Server: A Performance ComparisonNavigating hierarchical data in databases is a common challenge in software development. In SQL Server, two popular methods for traversing…·3 min read·Dec 19, 2023----
Tien NguyenPDF Data Extraction with Python: A No-Cost Adobe AlternativeIn the digital era, PDFs are the lingua franca for official reports, invoices, and data sheets. However, extracting tabular data from PDFs…·3 min read·Nov 14, 2023----
Tien NguyenUnderstanding Machine Learning Predictions with SHAP: A Case Study on Taxi Cancellation PredictionUnderstanding how Machine Learning make predictions can be challenging sometimes due to model complexity. This is where SHAP (SHapley…·3 min read·Nov 7, 2023----
Tien NguyenFine-Tuning Machine Learning Models for Time Series Forecasting in Retail SalesTime series forecasting is a vital component in sales . Accurate forecasts enable businesses to make informed decisions and allocate…·4 min read·Oct 18, 2023----
Tien NguyenSearch Smarter, Not Harder: Language Models in Dense Retrieval and Re-rankingIn today’s data-driven world, the ability to sift through massive amounts of text to find exactly what you’re looking for is nothing short…·5 min read·Oct 11, 2023----
Tien NguyenTackling a Hard-Level SQL Problem on HackerRank: A Deep Dive into Hackers’ Daily SubmissionsIntroduction·4 min read·Oct 5, 2023----
Tien NguyenSQL for Data Transformation — Generating Monthly Price Data from Date RangesWhen working with time-series data in business analytics, it’s common to encounter scenarios where the data needs to be transformed for…·3 min read·Oct 2, 2023--1--1
Tien NguyenUtilize ChatGPT’s Prompt Engineering for Non-Engineer RolesIn the ever-evolving landscape of data science, the spotlight has unmistakably fallen on the prowess of Large Language Models (LLMs), with…·2 min read·Aug 11, 2023----
Tien NguyenUnveiling Hidden Patterns: Supermarket Secrets Uncovered with Python’s Association Rules MiningHave you ever wondered how supermarkets can uncover hidden patterns in their customer purchase data? In this blog, I dive into the…·3 min read·Jul 6, 2023----