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 […]
Blog
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 […]
Generating Polygon Data With Mouse (Python)
In one of my previous posts, related to this topic, I shared the code and concept of reading polygon data and how to render them on screen with additional user-interaction. The post is linked below: Working with Polygon Data (Python) In this post, I share how to generate the data points for a polygon easily […]
Working with Polygon Data (Python)
In this post, I’ll show how to write a program that reads x,y coordinates for a complex shape (Polygon) from an external source. Then recreate the shape on a canvas with some interactivity. The application’s action clip is below: In the above clip, I’m reading datafiles that contain the coordinates as a series of contiguous […]
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 […]
Bars within bars: Creating an Effectual Custom Chart
In this blog, I’ll share some tips on how to create a visually impactful bar chart in Excel that does not come out of the box. There are several steps we need to take in order to take Excel’s built-in charts and make it look like this: This is bar charts within bar charts! The […]
Company and stock information in Excel
Excel makes it really simple to pull in latest stock information including its one-year price history, company description, even number of employees and more. In this post, I share a sample table with the latest data at the time of writing. The table below shows some of the information that are dynamic, real-time: It shows […]
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 […]
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 […]
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 […]