# Tag: Statsbot (12)

**Loading Terabytes of Data from Postgres into BigQuery**- Apr 9, 2018.

Despite the fact that an ETL task is pretty challenging when it comes to loading Big Data, there’s still the scenario in which you can load terabytes of data from Postgres into BigQuery relatively easy and very efficiently.**Scalable Select of Random Rows in SQL**- Apr 5, 2018.

Performance boosts are achieved by selecting random rows or the sampling technique. Let’s learn how to select random rows in SQL.**Calculating Customer Lifetime Value: SQL Example**- Feb 15, 2018.

In order to understand how to estimate LTV, it is useful to first think about evaluating a customer’s lifetime value at the end of their relationship with us.**Data Structures Related to Machine Learning Algorithms**- Jan 30, 2018.

If you want to solve some real-world problems and design a cool product or algorithm, then having machine learning skills is not enough. You would need good working knowledge of data structures.**SQL Window Functions Tutorial for Business Analysis**- Dec 27, 2017.

In this SQL window functions tutorial, we will describe how these functions work in general, what is behind their syntax, and show how to answer these questions with pure SQL.**A Guide for Customer Retention Analysis with SQL**- Dec 19, 2017.

Customer retention curves are essential to any business looking to understand its clients, and will go a long way towards explaining other things like sales figures or the impact of marketing initiatives. They are an easy way to visualize a key interaction between customers and the business.**Machine Learning Algorithms: Which One to Choose for Your Problem**- Nov 14, 2017.

This article will try to explain basic concepts and give some intuition of using different kinds of machine learning algorithms in different tasks. At the end of the article, you’ll find the structured overview of the main features of described algorithms.**A Guide For Time Series Prediction Using Recurrent Neural Networks (LSTMs)**- Oct 5, 2017.

Looking at the strengths of a neural network, especially a recurrent neural network, I came up with the idea of predicting the exchange rate between the USD and the INR.**Ensemble Learning to Improve Machine Learning Results**- Sep 22, 2017.

Ensemble methods are meta-algorithms that combine several machine learning techniques into one predictive model in order to decrease variance (bagging), bias (boosting), or improve predictions (stacking).**Machine Learning Translation and the Google Translate Algorithm**- Sep 14, 2017.

Today, we’ve decided to explore machine translators and explain how the Google Translate algorithm works.**Support Vector Machine (SVM) Tutorial: Learning SVMs From Examples**- Aug 28, 2017.

In this post, we will try to gain a high-level understanding of how SVMs work. I’ll focus on developing intuition rather than rigor. What that essentially means is we will skip as much of the math as possible and develop a strong intuition of the working principle.**Recommendation System Algorithms: An Overview**- Aug 22, 2017.

This post presents an overview of the main existing recommendation system algorithms, in order for data scientists to choose the best one according a business’s limitations and requirements.