SQL 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…Jan 31, 2023Jan 31, 2023
SQL 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…Jan 25, 2023Jan 25, 2023
SQL 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…Jan 17, 2023Jan 17, 2023
SQL 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…Jan 10, 2023Jan 10, 2023
Deriving 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…Jan 2, 2023Jan 2, 2023
Parsing 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…Aug 8, 20221Aug 8, 20221
Published inAnalytics 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…Jun 7, 20212Jun 7, 20212
Published inNerd 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…Jun 3, 2021Jun 3, 2021
Published inAnalytics 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…May 17, 20213May 17, 20213
