CHARTLOOKUP

While browsing through some SQL puzzles, I came across one where it asked to create a bar chart inside SQL server. Initial thought - It will require some sort of text manipulation. But before that I need to structure the data in proper format. Input Table:- The problem is divided into 3 parts:- Get regions and their total quantities. Because total quantities would be huge, it will not be possible to plot them as bars. Therefore, convert those quantities into percentage of total value. Create bars for percentage of total value against each region. SQL script with cte as ( select Region, sum(Order_Quantity) as Quantity, sum(SUM(Order_Quantity)) over () as [Total Quantity], round( ( CAST( sum(Order_Quantity) as float ) / cast (sum(sum(Order_Quantity)) over () as float ) ) * 100 ,0) as [% Total] from superstore group by Region ) select Region, [% Total], REPLICATE('|',[% Total]) as [Bars] from cte Output Table:- It was a fun little exercise to think outside the box and how you ca...

Ever wonder which movie should I watch this weekend?  You login to your favorite streaming service just to find yourself struck in vicious loop of  checking it's rating on IMDB and then searching for some more before deciding on that one movie which you might find interesting. I thought wouldn't it be great to have a dashboard with movies rated and you can apply some criteria to find what movie you are looking for. I searched for IMDB data and found it on kaggle website. This data is used to create and train recommendation systems, but for me a simple dashboard was enough to find movies I might enjoy on my weekend.  

 India has 9 of the 10 most polluted cities in the world.  As per a study based on 2016 data, at least 140 million people in India breathe air that is 10 times or more over the WHO safe limit. Air pollution contributes to the premature deaths of 2 million Indians every year.  Emissions come from vehicles and industry, whereas in rural areas, much of the pollution stems from biomass burning for cooking and keeping warm. In autumn and spring months, large scale crop residue burning in agriculture fields – a cheaper alternative to mechanical tilling – is a major source of smoke, smog and particulate pollution. Click on graph below which shows monthly average Air Quality Index (AQI) across various Indian cities from 2015 - 2020. It also shows month with highest average AQI for that city. Tool Used:- Power BI Data:- kaggle.com

  Thinking about investing in share market? The graph shows annual growth of NIFTY 50 since 2000. The NIFTY 50 is a benchmark Indian stock market index that represents the weighted average of 50 of the largest Indian companies listed on the National Stock Exchange. Tool Used:- Tableau Data:- https://en.wikipedia.org/wiki/NIFTY_50

 Rise in price of essential commodities have hit common people in India as inflation rate skyrocketed in recent times. Rise in fuel prices and their ripple effects on transport and logistics costs are expected to intensify the issue. If you wondered what historical inflation rate in India looked, here's a quick summary

 Time is an amazing thing. On a clock it's a steady and measurable phenomenon. But in mind it depends on different factors. According to some researchers your perception of time can depend on factors such as your age, activities you are involved in or even your mood. There are some days when you look back and wonder if time seems to go by faster as you grow older. You think of all the things you have achieved big or small. And just then a sudden realization hits you. How much time you have left? I thought it would be cool to visualize this idea of how much time do I have left (assuming average human lifespan of 70 yrs.) I used Power BI to compare number of weeks I have lived and number of weeks left. Also, the chart and numbers are dynamically updated since the calculation for weeks I have lived is compared with current date. Almost reaching half of my lifespan. Time flies. Tool Used:- Power BI

Imagine this. You are in a meeting and someone is presenting a chart to the group. You look at the chart and try to grasp the information. But there are several elements on the chart distracting you to consume the information right away. You ask yourself, are all the elements on this chart necessary? Can some elements be removed without taking away the core information from this chart? Is there any guideline or principle that can be applied to make this chart more consumable?   Well you are in luck. There is a principle created just to achieve this and it's called  Data Ink Ratio . It was introduced by Edward Tufte who is considered one of the major figures in the field of data visualization. Tufte argues that a chart should only contain those elements which if removed, the chart will lose it's core information. Data Ink Ratio can be calculated as:- Let look at an example. Below is a chart with low data ink ratio . When you carefully examine the chart, you can find some...