Data Analysis | Anshul Dixit

My Year In Books – 2021

January 27, 2022January 2, 2022 by Anshul Dixit

For the past 2 years, I have been doing a short analysis of my reading activity at the end of the year. I do that with the help of a spreadsheet that I have created to track my reading activity, and I have been recording the data since mid-2018. Along with this, I also share … Read more

My Year In Books – 2020

January 7, 2022January 4, 2021 by Anshul Dixit

As some of you know, I maintain a Google sheet to keep a track of the books I read, and at the end of the year, I analyze the data collected over the year. 2020 was no different in that aspect. But what was new though in 2020 was the concept of ‘comfort books’ that … Read more

How I Use Google Sheets To Track And Analyze The Books I Read

January 7, 2022October 28, 2020 by Anshul Dixit

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. But, I was not very pleased with the limited data points that … Read more

My Books In Review – 2019

January 7, 2022January 22, 2020 by Anshul Dixit

One of my personal goals in 2019 was to spend more time in the company of books. Though I could not reach the number I had in mind, but given how eventful this year was, with switching jobs and moving cities, I’m going to cut myself some slack. I have created a template in Google … Read more

7 Tips to Optimize SQL Queries

January 7, 2022May 28, 2016 by Anshul Dixit

Have you ever stared at your computer screen wondering why it is taking so long for your SQL query to run? You are not alone in this universe, we all have been through such situations quite often. Of those, a few have been lucky to get help from their colleagues and seniors in understanding the … Read more

Why Exit Polls Lie?

January 7, 2022May 20, 2016 by Anshul Dixit

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. This is not a first, various elections in the past have revealed the inaccuracies in the exit polls. Who can forget … Read more

Analysing my Uber Cab Usage

January 7, 2022May 5, 2016 by Anshul Dixit

A conversation with a friend about Uber prompted me to analyze my Uber usage pattern. While doing that, I thought of sharing the results here along with a few tips on analyzing and visualizing the data. So, here we are.

WHERE Clause Conditions with OUTER Joins

January 7, 2022July 28, 2015 by Anshul Dixit

SQL Error One common mistake that people make while writing Outer Joins is incorrectly specifying a condition in the query. It’s such an innocent mistake that unless you have an idea of the expected result you won’t even realize that you made a mistake.