I’ve pulled in some data to understand the speed of spread and immensity of the “corona” virus. The data is based solely on daily situation report data from WHO’s site starting from January 20, 2020 to the time of this writing (March 18, 2020). NOTE: These are totals reported on that day (NOT new cases/day) […]
Tag: education
Why Pareto? Using 80/20 rule in the real-world.
The Pareto principle states that about 80% of the effects come from 20% of the causes in many real-world events. You can use this to, say, identify 80% of your best-selling categories, or conversely the worst performing categories/items. The uses are limitless, really. And they don’t have to be only about $$$. Graphically, it’s a […]
Virus Wiping Away Toilet Papers in 2020!
Amazed (at the stupidity) and fascinated (by idiocy) by binge and panic shopper, I was compelled to ponder specifically about the toilet paper shortage in light of the recent pandemic (“corona virus”). This blog is will reflect on the reasoning provided by shoppers, and psychologists, a look at the economic statistics and realities of the […]
Creating Beautiful Violin Plots
A violin plot is a visual that traditionally combines a box plot and a kernel density plot. This is typically created in R, Python languages using MATPLOTLIB and other applications/modules. However, I show here how to get it done using only PowerBI. About Violin Plots Before I go into how to plot it, let’s understand […]
How many cats and dogs are there in your city? (method and cool charts)
In this seemingly simple couple of charts, I demonstrate a few nifty tricks that are fun and effective. First, we want to find out how many cats and dogs in a few selected cities (around me) and come with an educated estimate based on data. Then, we will use some cool, free add-in to create […]
Usages of OFFSET
OFFSET() is a nifty function that when used in conjunction with other formulas beĀ very useful at times. Here are some examples of how it can be used to optimize some tasks. In one of my earlier blogs, I demonstrated a formula to transform a matrix of data into a single, continuous column of data. […]
Simulating coin-toss in Excel
Most of us know that theoretically, there’s a 50-50 chance of getting a “head” from an unbiased coin-toss. There are numerous implementations and simulations done in virtually all programming languages around this age-old ‘riddle’. In this blog, I share a simple but very effective simulation in Excel. Here’s the simulation: As you can see, I’m […]
Compare and understand: Spread and Consistency
Imagine you have a product line with an average price of $20, and another product line where the average is $100. Which has more spread? Imagine you have 3 players whose bowling scores you have (which are all over the place by the way) and you want to know which player is more consistent? Or, […]
Most Common Last Names Around the World
Interesting site that shows most common last names around the world: https://mymodernmet.com/most-common-surnames-map/
NFL 2019 regular season is done. What have we learned?
Now that the 2019 NFL regular season is in the books, we have complete data available about the teams’ performances. What can we glean from them? In this blog, I share some findings, answers, and the process of analytics behind discovery of the answers. I will focus on overall team performance data, not individual positions, […]