In this post I walk you through all the steps needed to create an amazing Fishbone diagram in Excel, without having to manually draw or paint anything. The steps presented here can be used to create any Fishbone diagram suited for your specific situation. What is a Fishbone Diagram? A fishbone diagram is a commonly […]
Tag: analytics
Creating a data-driven, dynamic cause-and-effect chart
In this post, I share my method of creating a chart to show how events impact another variable such as sales and prices in a data-driven, easy-to-read, and dynamic way. Think of it as a cause-and-effect visualization. Let’s look at an example scenario where this type of chart can be very useful. This is done […]
Understanding Step Charts (and creating them in Excel, Python)
Step charts are suitable for showing fluctuating or irregular values over time. There’s no built-in Step chart type in Excel, so most people use a Line chart instead, which is not really ideal or sometimes accurate (I’ll explain that below). With proper data shaping, it’s possible to create Step charts in Excel. In this post, […]
Present Value and Future Need with Inflation
Ugh…Inflation! No one seems to like it but what does it mean? How can we measure how much purchasing power we’re losing due to inflation? Questions such as these and more are answered in this post. Inflation is the rate at which the general level of prices for goods and services rises, eroding the purchasing […]
Calculating Playoff Chances
With the NFL regular season winding down after week 15, we have a pretty good idea of which teams are definitely out of the playoff hunt, which teams have clinched a playoff berth, but the rest are still up in the air. In this blog post, I calculate the chances of making the playoff for […]
Vehicles: Number of cars, density and more from around the world
In this post, I’m sharing some data on number of vehicles, their density taking into account the population, and other interesting metrics for a selected number of countries around the world. The visualizations and analysis will take you on a journey of telling the stories and takeaways from the numbers. The selected countries presented here […]
Plotting ranges of values – Cat metrics
In this purr-fectly delightful blog post, I’ll guide you through steps to meaningfully depict ranges of values in Excel, all the while crafting irresistibly cute charts—no graphic skills needed! You’ll discover a few charts showcasing upper and lower values, Means, and custom markers. Using data such as the lifespans, weights, and prices of different cat […]
Funnel charts
In today’s data-driven world, visualizing complex information is crucial for making informed decisions. Among the myriad of chart types available, funnel charts stand out for their ability to represent the progressive stages of a process. Picture this: you’re diving into the analytics of a killer marketing campaign, tracking the journey of potential leads, or deciphering […]
Violin Plot in Python
In this post, I present a use-case for the beautiful Violin plots. We have a sample of n drivers about which gender drives which type of vehicles (Sedan, Van, SUV, Pickup), how many of the sample, and their ages. The data is fictional and was generated by me using formulas in Excel, then saved as […]
Box and Whisker Plot (seaborn example)
In a previous post, I shared an example of Box and Whisker plot with a small sample dataset. In this post, I’m using a larger dataset from Seaborn library of Python and go a little deeper with more examples using Python. We have a dataset in the Seaborn library called ‘tips’ that’s perfect for exemplifying […]