Excel Trick: Import Data From a Picture!
Have you ever looked at a table in a PDF file (or a picture) and wanted to import it into Excel? This video tells you how! As shown in the short video, this function is not...
Category
visulization
EV in 2022 and Beyond: More Good News, but Uncertainties Too
Recently I was asked to reflect a little on the recent EV movement, so I dug a bit on the latest statistics. 2022 is not over yet, so the latest number we have is from 2021. I...
What will happen to Zoom?
This is just a reflection of evaluating the long-term prospect of a company. As we all know, Zoom has been a huge successful company, boosted by the good timing of the covid...
If Facebook (Meta) disappeared 3 years from today (in 2025), I will not be surprised
Warren Buffet famously said that “Forecasts may tell you a great deal about the forecaster; they tell you nothing about the future.” So, do not treat this as a forecast. Just...
Clustered bar chart and stacked barcharts, switch rows/columns, overlap and customize shapes
Bar charts are one of the most frequently used charts. To use them effectively to generate on-the-point graphs that deliver exactly the right message, however, requires some...
Are we still ignoring data in making covid-related decisions?
From the early days of Covid, I have been questioning the wisdom of lockdown. In a post I wrote in December 2020, I said the following: “For one, I question the wisdom...
Zillow’s Failure in Housing Flipping is a Classic Example of Ignoring Bottlenecks and Variabilities
By now, we have all heard the story of Zillow losing more than $550 million doing house-flipping. Its CEO blamed it on its forecasting model that produced house-buying prices...
Port of LA: Storage Space is the culprit?
Recently I read about the saga at the Port of LA. According to Ryan Petersen, the chief executive of logistics company Flexport, the real bottleneck at the Port of LA was...
Why Supply Chain Delays are Multi-faceted: A Mathematical Explanations (Without the Heavy Math)
Paul Krugman recently penned an excellent article explaining why we see the supply chain snarls in New York Times. It mentioned a number of factors: The US consumers are...
Understanding CO2 Emissions for different freight transport modes (renewable as well as non-renewable)
One of the most important questions to ask in transitioning to renewable modes of transport is simply: How much less CO2 are we going to emit by switching to renewables? The...