Raghav RamaSQL Series Part 5: Comparing day on day revenue during a SaleA sale in any company is an exciting time to see the clock ticking and experience the sale unfold. In businesses which sell products in…3 min read·Jan 31, 2023----
Raghav RamaSQL Puzzle Series 4: Which product should appear in the buy box?If you are ever trying to build an e-commerce platform, then you are definitely in for a wild ride when it comes to selling products…4 min read·Jan 25, 2023----
Raghav RamaSQL Puzzle Series 3: LinkedIn’s “top applicant” featureWhile scrolling through LinkedIn you will notice this feature that lets you know if you are a top applicant or not. How is this judged…3 min read·Jan 17, 2023----
Raghav RamaSQL Puzzle Series 2: Rearranging contact informationIn case you have ever filled out a registration form, you would have been asked to provide a home, cellular and work contact. How is this…3 min read·Jan 10, 2023----
Raghav RamaDeriving the Golden Ratio in SQLRecently I gave my SQL final and realized despite having experience working on it, there are still things I can do better. To bridge that…3 min read·Jan 2, 2023----
Raghav RamaParsing ARRAYS in Big QueryWhile writing long SQL queries I always wished I could parse a list of items instead of repeating the list in my WHERE clause again and…2 min read·Aug 8, 2022--1--1
Raghav RamainAnalytics VidhyaExcel tips and tricks Part IIThese are a few tips and tricks in excel which I figured I should share. Some are more obvious and others not so and could potentially help…4 min read·Jun 7, 2021--2--2
Raghav RamainNerd For TechRunning SQL queries on local excel filesWhile working I used to wonder if there is a way we can create databases out of flat files or local excel files and perform query…4 min read·Jun 3, 2021----
Raghav RamainAnalytics VidhyaExcel tips and tricks Part IThese are a few tips and tricks in excel which I figured I should share. Some are more obvious and others not so and could potentially help…4 min read·May 17, 2021--3--3