Every now and then I’m asked: “What certifications do you have?”…and honestly, I often forget to list all of them and since I’m a voracious learner, the list keeps on growing and growing. At any rate, I finally decided to catalog them (most of them, admittedly not all) and create a less-boring list (visual!) for […]
Category: STEM
Project Management Mind Map
Here’s a ‘simple’ e2e SW Project Management Mind Map I created for a quick checklist of major items to keep in mind. Enjoy! Click on See the board button below to access the chart. Then you can use left mouse button to drag, wheel to zoom, or use the controls in the UI to see […]
Last 12 POTUS and infographic
This is an infographic based on data I pulled together into a spreadsheet and through formulas, present a whole bunch of information in a concise form. In the middle column, you see their portraits, immediately to left is the column denoting their parties, and the number of terms of they served. The right-most two columns […]
Raw Data to Machine Learning to Decision-Tree: Excel
Machine Learning in Excel? Isn’t ML the new thing, new algorithm that’s only done in the Cloud using R and Python? Nope! We’ve been doing in Excel for many years!! It’s only recently getting a lot of attention with Cloud and large datasets and made much, much simpler to use for today’s Data Scientists— but […]
Did your promotion work?
In an earlier blog How Well Are Your Incentives Working? I shared methods on how to calculate the various chances of success based on some campaign data (e.g. new sign-ups for membership) from various trials using Binomial distribution. In this post, I show how to determine if events occurred due to random chance or affected […]
Estimating reading time for any content (Python)
We occasionally see reading time estimates in online news, blog sites, and even in promotional contents. This estimate is important because it tells the reader upfront how much the content may take to read. There are several extensive studies done internationally (in English speaking countries) that demonstrate that people tend to read messages/contents up to […]
Waffle Charts (3 methods + bonus)
Certainly! Here’s a revised version of your paragraph: Waffle charts might be familiar to you. These charts are characterized by small squares within a grid, providing a straightforward representation of ratios. This concept is akin to that of pie charts, area charts, or treemaps—the choice ultimately hinges on the target audience and personal taste. Waffle […]
Counting words/elements correctly in Excel
In some of my previous posts, you’ve already seen my Python examples on how to count words accurately in a document or in blocks of text (search for: Wordcloud). It’s also possible to count the words in Excel, but we have some gotchas there to be aware of. In this blog, I demonstrate some of […]
User Stories and Wireframes
User stories or scenarios are the suggested and preferred way for most agile development teams to capture software features in bite-sized morsels. It helps to continuously focus on the feature from end-user perspective (targets user-experience, persona) and the situation (i.e. the need for that feature) and expected behavior (i.e. what the user is trying to […]
Analyses of Critical Words & Speeches!
In one of my earlier blogs, I shared the techniques and code to create Word Cloud using Python and Excel together in this article: Word Cloud III – Python & Excel Together Today, building on that, I’ll analyze some of the most historic speeches and/or documents that every kid should read and even memorize part […]