For my first unguided SQL project I wanted to combine it with something of my personal interest and try to apply all the syntaxes I learnt so far. In this project, we will dive into cryptocurrency data and transform this data into knowledge and data-driven answers.
Technique: Data cleaning, data aggregation, data exploration, statistical analysis and data visualization.
Tools: SQL, Tableau.
Since the p-value is <0,0001 we consider the correlation between Cardano and Bitcoin statistically significant. Due to the difference in magnitudes, probably Bitcoin is the one that affects the price of Cardano and not vice versa.
The biggest challenge during this project was the fact that I spent a lot of time analyzing a dataset that seemed very reliable but ultimately contained erroneous information. However, this serves as a lesson in not always trusting datasets with your eyes closed. From now on, I will be more critical and careful when selecting a dataset.
SELECT
bitcoin_cardano.date_,
bitcoin_cardano.close_price_bitcoin,
top_23_crypto.Close AS close_price_cardano
FROM
bitcoin_cardano
LEFT JOIN top_23_crypto
ON bitcoin_cardano.date_ = top_23_crypto.date
WHERE
top_23_crypto.Name = 'Cardano'
