Coding Education Life STEM Work

An important personal milestone: Hello Arduino!

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 […]

Read More
Analytics Education STEM Work

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 […]

Read More
Analytics Education STEM Work

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 […]

Read More
STEM Work

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 […]

Read More
Education STEM Work

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, […]

Read More
Education STEM Work

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 […]

Read More
Back To Top