Data analysis and Reading are two of my key interest areas. I used to keep a track of the books that I read on Goodreads and would check the stats page every time I finished a book just to see the graph change.… Continue Reading
Author Archive | anshul
How To Calculate Financial Year From Date In Excel & Google Spreadsheet?
A lot of times you might want to calculate Financial Year (also known as Fiscal Year) and Assessment Year based on the date.… Continue Reading
7 Tips to Optimize SQL Queries
Have you ever stared at your computer screen wondering why it is taking so long for your SQL query to run?… Continue Reading
Why Exit Polls Lie?
Yesterday (19th May 2016) assembly election results for 4 states in India were announced. In Tamil Nadu, Jayalalithaa’s party AIADMK proved the exit polls wrong by coming to power second term in a row.… Continue Reading
WHERE Clause Conditions with OUTER Joins
This post first appeared on my personal website anshuldixit.com.
One common mistake that people make while writing Outer Joins is incorrectly specifying a condition in the query.… Continue Reading