The S&P 500 dataset includes a list of companies in the S&P 500 (Standard and Poor’s 500) updated in the year 2020. The S&P 500 is a free-float, capitalization-weighted index of the top 500 publicly listed stocks in the US (top 500 by market cap). It includes a list of all the stocks contained therein and associated key financials such […]
It is common knowledge that information is power. Organizations across industries are constantly seeking ways to harness the wealth of data at their disposal to make informed decisions, streamline operations, and improve overall efficiency. I delved deep into this dataset, providing valuable insights into client transactions and payments. In this article, I will take you through this fascinating journey of […]
In this project, I utilized SQL to analyze sample sales data. This product sales data was downloaded from Kaggle and contains information related to sales orders, order details, customer information, shipping details, and more. This data can be used for various purposes, such as segmentation, customer analytics, clustering, and sales simulation training. At the time of this analysis, this sales […]