Today marks another special day in my humble life’s timeline. Today, my first ever book went live worldwide on Amazon.com (+ .uk, .de, .fr, .es, .it, .nl, .jp, .br, .ca, .mx, .au, .in as per different markets) in both eBook and paperback formats. The book titled “Hello Arduino!” is a fun book for anyone (12 […]
Category: Work
Degrees, Diplomas, Certs, and more…
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 […]
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 […]
A Risk Assessment Map—my approach
I’ve seen many pretty risk assessment maps over time. The issue I see with most of them is that they’re more of an illustration than a method meaning, they’re customized visuals with manual graphics that don’t scale well for different projects. In the post, I’ll share my approach…it’s based on applying basic statistical concept, development […]
Creating Word Cloud accurately and easily in Excel
There are plenty of designers, templates, and online services that let you create Word Clouds (aka Tag Cloud), but do you know how to create one yourself in a short notice, without paying anyone anything? If you have Excel and some creativity, then you can create a Word Cloud just as good as any! It’s […]
There’s no formula for that! Grab a snippet of data-set.
Often I find myself working with a subset of the full dataset for experimentation, trials, and exemplification. For instance, my dataset may have 33,000 records but I want to work with about 100 records first in a separate sheet. Sure, I could (as most do) select the desired columns and continue to scroll down to […]
In-cell character-based charts
We all know about the extensive charting capabilities in Excel. In this blog, I show a quick and easy way to create charts within-cells (not on a separate canvas!), next to data. Much like sparklines but without using that feature. It’s simple, fun, and effective. Let’s try 2 examples. First, we’ll use some movie ratings […]
Clean & glean from raw transaction data
You’ve just been delivered some raw transactional data from a new salon owner, who’s very optimistic about her new business but also cautious. She wants to understand her customers, patterns during the day and week so she can adjust her prices, staffing, scheduling, stocking, and more. Your objective: Based on the raw transaction records dump, […]
Forecasting for your team
Here I touch on a quick but effective way to do forecasting based on historical data…this without the help of any chart. Scenario You have data on your customers’ spends at your shopping mall based on how many miles they drive to get there. The dataset is below. Your objective is to find out how […]
Creating a GEO learning app in Excel and PowerBI (part2/2)
This is a two-part blog series. To follow along, see part 1 followed by part 2 (this). If you haven’t see a quick animation of the interface, it’s available in part 1. Previously, I demonstrated how to get the dataset ready and create some basic charts in Excel about the states of USA. Now, we […]