How close were my initial models? Let’s compare with today’s data. Take a look back on my educated-guess-but-not-official models that I created back in March 22, 2020: What-If Models (COVID-19): Results Today’s numbers for USA from WHO are (on 4/1/2020): # of confirmed cases (infected): 163,199 and confirmed deaths: 2,850 My four models were agnostic […]
Tag: coding
Selected movies: searchable, sort-able for utility and fun
Today, I present a web application with a list of selected movies (about 3,000 titles) I extracted using developer APIs from IMDB and OMDB databases using my Python app. After extraction in the app, I reshape the data according to my needs and then export programmatically to XLSX format (for Excel). Which is then wrapped […]
COVID-19 Trends Update: 3-30-20
GLOBAL VIEW CHARTS & ANALYTICS The charts will work on any device including phones with smaller screens. To see specific metrics, click on the desired legends one or more, in any combination. Direct shareable links: Day-by-day cases & deaths To-date Key trends and comparisons Data retrieved from official WHO daily publications and worldOmeter.
COVID-19 Trends Update: 3-27-20
GLOBAL VIEW CHARTS & ANALYTICS The charts will work on any device including phones with smaller screens. To see specific metrics, click on the desired legends one or more, in any combination. Direct shareable links: Day-by-day cases & deaths To-date Key trends and comparisons Data retrieved from official WHO daily publications and worldOmeter.
What-if Models (COVID-19): Results
Here are the results of the four models that I had created to get results of What-If scenarios around COVID-19 (“corona”) virus using the data on hand as published officially as of 3/20/2020. Since we don’t have all the answers or even data for many variables, I hypothesized in such instances. For explanation of my […]
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 […]
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 […]
Understanding buckets, bins, categorization (3/3)
In this multi-series of blog, I’ll touch on different ways to categorize data in buckets, or bins, and summarize in meaningful ways. Some will use Pivot Tables, some will not. But we’ll cover 3 common scenarios. Let’s do the third and final one here… The Scenario We have about 2,000 rows of data on sales […]
Understanding buckets, bins, categorization (2/3)
In this multi-series of blog, I’ll touch on different ways to categorize data in buckets, or bins, and summarize in meaningful ways. Some will use Pivot Tables, some will not. But we’ll cover 3 common scenarios. Let’s do the second one here… The Scenario We have data on employees’ join-dates (TABLE 1). Objective: We want […]