Welcome to an exciting and educational view of the skies above us. In this blog, we’ll look at various altitudes where some of the most interesting objects and phenomena can be found. From the gentle drift of hot air balloons and the majestic flight of vultures to the high-speed travel of jet planes and the […]
Tag: analytics
Interesting Facts at Ocean Depths
Exploring the depths of the ocean reveals a fascinating world teeming with diverse marine life and remarkable human achievements and adventures.In this chart, we look at some of the usual depths inhabited by various marine creatures, from the shallow waters to the abyssal plains and down to the deepest seabed on Earth.Additionally, I highlight some […]
Identifying double-bookings, scheduling conflicts
You’ve created a week’s schedule for your restaurant staff by day and shift (AM or PM). Next, you want a way fool-proof method to check if anyone is double-booked on any given day, and if so, who. Surely you can manually double-check and triple-check to make sure the schedule is exactly as planned but there […]
Venn Diagrams (Python)
Venn diagrams are versatile and useful for a variety of purposes. Some common uses are: Visualizing Relationships: They illustrate the logical relationships between different sets. For example, they can show how different groups overlap and share common elements, and which don’t.Comparing and Contrasting: They are great for comparing and contrasting different items, ideas, or groups. […]
Penalty Shootout Data and Presentation
One of the most thrilling games in the Euro 2024 was one of the quarterfinals between France and Portugal that was tied at 0-0 after the regular + extra time resulting in a penalty shootout. France won 5-3 in pks. I wanted to create a couple of dynamic charts based on some basic data from […]
Paris Summer Olympics 2024 Stats
As the world eagerly watched the Paris Olympics 2024 from start to conclusion, I was fascinated by the amazing feats of the athletes from around the world. In this post, I present analysis of the performance of some nations and their athletes. You’ll find a collection of statistics, charts, and visualizations that highlight some key […]
How to create Overlapping Charts in Excel
Sometimes a seemingly simple visual can be difficult to convey with a built-in Excel chart. I present here such an example. For instance, I will describe how and why to create an Overlapping Column Chart, aka 100% Overlapping Column Chart in Excel. It can also be turned into an Overlapping Bar chart. Say, we have […]
How To Pick Rows Or Columns, And Combine Them With Other Functions For Powerful Uses. Part 2
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: DROP(). In another blog, I discuss […]
How to pick rows or columns, and combine them with other functions for powerful uses
In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: TAKE(). In the next blog, […]
Euro 2024 Analyzed with Visuals
Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]