sardamit.com

This time, I hope I know what I am doing! :)

[sardamit]

Sunsets at home. https://www.instagram.com/p/ByK68bTFiTH/?igshid=1w00gkfhjv5rj

[sardamit]

Build Your FREE Personal Stock Portfolio Tracker

Build Your FREE Personal Stock Portfolio Tracker

Stock Portfolio Tracker Overview

Editing Details of an Investment

(more…)

View On WordPress

[sardamit]

Treating myself for absolutely no reason whatsoever. https://www.instagram.com/p/BxAraIAFpL-/?utm_source=ig_tumblr_share&igshid=m2lcsx1lw2cz

[sardamit]

How to use Filter Views in Google Sheets

How to use Filter Views in Google Sheets to Collaborate Seamlessly #googlesheets #analytics #productivity #tipsandtricks #collaboration #poweruser

I considered myself a Power User of Google Sheets, until I found that this feature has existed in Google Sheets for more than a year now.

How to use Filter Views in Google Sheets to Collaborate (more…)

View On WordPress

[sardamit]

Freeze panes in Google Sheets the easy way

Freeze panes in Google Sheets the easy way

After using Microsoft Excel for over 6 years, transitioning to Google Sheets was extremely challenging for me.

The lack of support for keyboard shortcuts was the biggest challenge and I learned to live with it. The fact that Google Sheets now supports many such shortcuts is a story for another day, but a bigger pain point was dealing with features that would work differently in MS Excel and…

View On WordPress

[sardamit]

Unifying data in multiple columns into a single column in Google Sheets

Unifying data in multiple columns into a single column in Google Sheets

Here’s a nifty and handy trick to unify data in multiple columns into a single column in Google Sheets.

A common application is when you’re trying to create a list of all values that a data point can have, but when the data is entered across multiple columns. For e.g., imagine color variants of a product split across columns named Color 1, Color 2, Color 3, and so on. This formula will help…

View On WordPress

[sardamit]

When you love your work and your work loves you back! #TheMostComfortableChairsInTheWorld (at London, United Kingdom) https://www.instagram.com/p/Bs8GhezBrCk/?utm_source=ig_tumblr_share&igshid=acnxd855v97n

[sardamit]

Like a ‘color’ in the sky! (at Ichalkaranji) https://www.instagram.com/p/Brfbdx6hQH6/?utm_source=ig_tumblr_share&igshid=vbf73yddtjhx

[sardamit]

Smiles to die for! (at Hotel Dreamland) https://www.instagram.com/p/BrcEEpJhHFB/?utm_source=ig_tumblr_share&igshid=10wd5mlhvzyd2

[sardamit]

When colors are everything! (at Hotel Dreamland) https://www.instagram.com/p/BrcC93yhuys/?utm_source=ig_tumblr_share&igshid=19ny73xvaa876

[sardamit]

Little-known place. And glad about that. (at Tapola) https://www.instagram.com/p/BqobOy7BTNy/?utm_source=ig_tumblr_share&igshid=ogrnvloa7nns

[sardamit]

In the middle of nowhere. (at Tapola) https://www.instagram.com/p/BqnBoXIhaXV/?utm_source=ig_tumblr_share&igshid=cqaoasn5rhgt

[badvisualisations]

The bar graph on top is extremely weird. The two bars are supposed to show ranges, as the data labels indicate, but the bars themselves are of a precise length. 

To repeat - the information in a bar graph is in the length of the bar, so it’s not an appropriate measure here since they’re trying to show ranges.

Moreover, since data from 2016 and 2018 is being compared, it’s basically a time series. So the way I would show this is by inverting axes, and then showing how the range moves. 

Actually - this one is not to scale (I quickly made it using Paintbrush), but this is possibly how I would show this information - using two lines for the upper and lower limits. 

Source: https://the-ken.com/story/delivery-personnel/ (Paywalled) 

[sardamit]

Perhaps they should’ve focused less on showing an illustration of a delivery boy, and more on the insights through charts.

[sardamit]

Data Transformation using Excel and Tableau

Data Transformation using Excel and Tableau

Data transformation is fun! More so when you’re doing it using tools like Microsoft Excel and Tableau. While programming languages like Python and R facilitate this very easily, it’s not everybody’s cup of tea. Excel and Tableau are relatively easier to understand.

Problem Statement

A client shared an Excel spreadsheet consisting of responses to a survey. The survey consisted of some 40+…

View On WordPress

[sardamit]

Another sunset tale from the terrace. . . . #chasinglight #chasingsunsets #sunsets #color

[sardamit]

Twins. . . . #chasinglight #chasingsunsets #sunsets

[sardamit]

The charm of a good old filter coffee. . . . #coffee #breakfast (at Anna Idli)