Sunday, October 24, 2021
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 (part1/2)

In this blog, I’ll show you some very effective and efficient ways to get vital information about all states of the USA, and eventually create visuals, then interactive visuals, then an interactive application online. All from starting with the basic names of states. I wish every kid and adults would have this type of application […]

Read More
Back To Top