Sunday, October 24, 2021
Education STEM

Predicting missing/unknown information

Analysts often need to fill in the blanks in order to make longer-term decisions, or just to model different scenarios by making credulous predictions. In this post, I share just one of such scenarios and demonstrate how to make predictions using both statistical formulas manually and Excel’s feature. Lastly, we’ll see the difference between the […]

Read More
Education STEM

A Very Simple Etch A Sketch Type Program (Python)

Here’s a fun, little application using Python. In this post, I demonstrate drawing lines using just the arrow keys on the keyboard (up/down/left/right). The drawing direction is determined by the arrow key pressed as shown in the clip below: With each keypress a line is drawn in the direction of the arrow head, which is […]

Read More
Education STEM

Color Codes Datafile and Dynamic, Interactive Patterns-Making (Python)

UPDATE: BONUS animation added at end of this post. In this post, I’ll demonstrate how to read color values (stored as Hex) from a data file and create dynamic patterns using those colors. Additionally, user can interact with it to choose different patterns, and even shuffle the same colors in different orders as they were […]

Read More
Analytics Education STEM

How to treat Excel like a database to do complex SQL-like queries

One of the most under-utilized, most powerful query features come from Excel’s database functions. While primary usage of Excel is more as a traditional spreadsheet, and it myriad of formulas (and VBA macros), the database functions allow us to treat it like a database and query from its dataset much like SQL statements would from […]

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

Measuring and visualizing performance from raw transactions

Scenario We have transactional data for 3 months. We want to compare any month’s sales performance with our goals by category of products sold. The following information is available in one dataset: OrderID, Product, qty, price, date of order as they occurred. As we see below, they’re not tallied or grouped or sorted in any […]

Read More
Back To Top