People familiar with Machine Learning and AI in general understand the underlying mechanics of how AI chat works. But to many non-techies, it can seem fantastic, magical, even eerie with their converstational abilities and responses blurring the lines between humans and machines. In this quick and simple converstation log, folks who are mystified with AI, […]
Tag: analytics
Password strength and cracking
In our digital age, the importance of having strong, secure passwords cannot be overstated. With cyber threats on the rise, ensuring that our online accounts are protected is more crucial than ever. In this blog post, I share the core mechanics of measuring a password strength and share a practical approach to estimate how long […]
Creating a Fishbone Diagram Like a Pro in Excel
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 […]
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 […]