In this post, I’m sharing a method to create various types of TTM reports including visualization using Excel. While there are various methods I have discovered, I believe my method presented here is fool-proof and also intuitive. It uses EOMONTH function for error-free calculation of each month’s end, and FILTER function to filter and fetch […]
Tag: analytics
Cartoon strip to a data-driven, interactive chart
Recently, I saw this cartoon strip on my Facebook feed from an account called “Homes”. It was sort of funny and true. But beyond that, I couldn’t help but think how much effort would it take to make this into a completely data-driven visualization? Don’t get me wrong, I’m a hobby artist (which you probably […]
When do we peak?
Recently, I came across an article stating how humans peak at different ages in different aspects. Surprisingly, and even perhaps amusingly it turns out that humans peak at different things throughout life from about 6 years of age all the way into the 80s according to the article based on scientific research. I captured the […]
Big Tech Layoffs…Causes, Trend, Outlook
Recent dynamics in the high-tech sector, especially in the software domain, show that the halcyon days of boundless innovation and exponential growth seem to have given way to a more somber era of widespread layoffs and uncertainty. Reflecting on the tempestuous years spanning from 2022 to early 2025, the industry’s stalwarts, once revered as invincible […]
Private Boats Ownership: Stats And Visuals
Step aboard as we sail through private boat and yacht ownership stats. This blog post touches on maritime luxury, dissecting ownership stats across selected regions. From the shores of the Mediterranean to the marinas of Florida and California, I’ll share some basic facts, interesting facts, and insightful visuals. Whether you’re a seasoned sailor or a […]
Planes, Trains, and Automobiles: Selected Stats
Let me present some stats on planes, trains, and automobiles in selected countries from around the globe. Specifically, I present metrics on trips by each mode of transportation, reported accidents, and finally, scores for each mode for each of the countries in list. I also explain the data sources, my methodology, and caveats. Sit back, […]
Textual Responses To Metrics and Visuals
It’s common for surveys to take in text responses in various forms, but in the end, to get insights, they need to be quantified for measurements. The process of converting textual responses into quantifiable units is commonly referred to as quantification or scaling. In survey research, this approach is often part of Likert scaling or […]
Control charts: when, how and why
Control charts are essential for statistical quality control purposes, such as for monitoring performance and defects measurements. Control charts are also known as Shewhart charts or process-behavior charts as they are tools used to monitor and analyze the behavior of a process over time. They help identify variations in the process and determine whether those […]
Creating Word Clouds from Google Trends
Google Trends platform provides interesting view into what the world is searching online. In our age of digital information, it has become a critical tool for understanding the world’s curiosities and behaviors. It allows us to explore the popularity of search queries across many regions and languages over time. Marketers looking to gauge consumer interests, […]
Optimization Problems with Diminishing Returns
Optimization problems are a cornerstone of decision-making processes across various fields, from economics to engineering. However, they often encounter the phenomenon of diminishing returns, where the incremental benefit of a decision decreases as the level of investment or input increases. This concept can complicate optimization efforts, as it requires finding the right balance between resource […]