One skill common across all data professions is SQL. You can never go wrong in learning it. Whether you handle structured data or unstructured data, you would need to SQL at some point in the process. In my recent interviews at FAANG, SQL was one of the first skills to…

In so many years as a data analyst, there has been one thing that was common in all my requirement discussions. I have always had at least one person in the room to request a detail tab in the dashboard with a table containing all possible fields. …

Excel is one of the most versatile tools when it comes to data. You can do all things data in Excel, starting from data entry to data manipulation to data analysis to data reporting to data automation. No wonder it features as a pre-requisite to Data Analyst roles at almost…

I recently interviewed and cracked the interviews for Business Intelligence Engineer at Amazon — There is much hype about the interviewing at FAANG and therefore people panic just before the interviews. I remember scouring over internet looking for any help or guidance on what to expect during the interviews. So, I am sharing my experience, hoping it will help you on your journey. If…

Date functions are one of the most under-talked areas in SQL programming — As a data analyst, I build dashboards and reports with different time grains like weekly, monthly, quarterly, annually. For time series analysis, I need the timestamps in my data to be aggregated. That’s where the date functions come in. These built-in functions make an analyst’s tasks so much easier. …

Did you know you can map out anything in Tableau? — Yes, you read that right. You can use any image as a background and add data points all over it. In this article, I will walk you through the steps to create your very own customized map. Recently, I tried mapping the timeline for the Olympic Games. …

Consumerism makes me nervous. — According to Investopedia.com, Consumerism is the idea that increasing the consumption of goods and services purchased in the market is always a desirable goal and that a person’s wellbeing and happiness depend fundamentally on obtaining consumer goods and material possessions. Everywhere around me, I see that people are accumulating things just because they…

5 ways to get creative with bar charts — Bar charts are one of the most used chart forms I use when presenting data insights at work. But I often feel like it gets a bit monotonous and repetitive especially when you need to present a lot of KPI’s on the same dashboard. Here are five different variations you…

All you will ever need to understand data densification in Tableau — Let’s start with a few important questions. Why will I ever need to know data densification in Tableau? Well, if you ever build a dashboard where you want to show any type of curved path like flight paths on a map, Sankey diagrams, radial charts, etc. you would need data densification. Tableau does not support any type of curved charts out-of-the-box…