While working on a practice interview question, we came upon a problem that requires CTE. But what is CTE? CTE, also known as Common Table Expression is used for SQL(Structured Query Language). CTE is a temporary result set that you can reference within a SELECT, INSERT, UPDATE, DELETE, or MERGE…

What is A/B testing? A/B testing is the process of comparing two or more variants to see which one performs the best. …

What is a RANK function? While practicing technical interview questions from Data Interview Q’s, I came upon SQL questions involving rank functions. Below is an example of a technical question that utilize rank function. You might ask, how do you use a RANK() function? Here we go in detail on…

What are some technical interview questions that applicants will see in an interview? Below is an example of a SQL technical interview question. Due to our small data set, we can solve this problem by hand before we move onto getting the SQL query. To get the revenue growth for…

How is the air quality in Beijing? We hear stories about the air quality, but is the air quality in Beijing really that bad? Through my capstone project, we investigated the air quality and created a predictive model to predict the air quality in Beijing. …

How to perform a train test split on images? While working on Flatiron School Module 4 Project — Image Classification, I came upon this issue. If you look at the data set, you will see that there are 5216 images in training folder, 16 images in validation folder and 624…

Can you predict if a patient has heart disease? Let’s give it a try. I will be using the data set from Kaggle for the extent of my Mod 3 Project from Flatiron School. …

How do you make visualizations for features that involve location or zip codes? What happen if you want to display average house prices of different neighborhoods? In this tutorial I will be showing you how to gather the necessary tools and to generate the data visualization below. To develop the…

How do you deal with categorical data? What should you do to be able to examine categorical data? While working on the Movie Project for Flatiron School, I came upon this problem when wanting to analyze the genres column. …