In this quiz, we are asked to give some differences between a common table expression and a subquery and what are some advantages of using one over the other in OLAP vs OLTP systems. This question is loaded so let’s break it down and explain each component. A common table expression (CTE) can be thought […]
Hi guys, I am starting a new series around sql interview prep which will have sql interview like questions and how to approach solving them. People have different approaches to solving problems so whatever approach l provide is just one of the ways of solving a problem and there could be other approaches that may […]
I am performing analysis on some top crypto currencies to see the trend and how they move together. Will Bitcoin reach $100,000 in 2022? Lets see how that goes lol. I am getting the data for the analysis from Coinbase pro API. Coinbase is a cryptocurrency exchange and anyone can reproduce the below analysis using […]
Below is a team work by my team and I at Georgia Tech for our Data Analytics for Business summer 2022 Project. The data for the project is fictional and all information provided is for our project purpose only and not to be used for any decision making. Authors of the project are : Vincent […]
