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 […]
Category: Education
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 post, I’ll share some tips on how to create a visually impactful bar chart, rather bars within a bar in Excel that does not come out of the box, that can convey much information in an uncluttered way. There are several steps we need to take in order to take Excel’s built-in charts […]
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 […]
Using Stock Price Charts On Humans
Using the same dataset, I’ve shown in my earlier blog: Scattered Data To A Butterfly, Or A Tornado! https://flyingsalmon.net/blog/?p=2194 on how to present similar information visually and add interactivity, in this post, I’ll show other ways to present the information visually and walk through the pros and cons of each. I won’t be using any […]
Organizing raw dataset to creating impactful, interactive visualizations (Excel, PowerBI)
In this post, I’ll walk through the steps starting with a raw dataset that’s organized differently from what I need, to reshaping the data using Excel formulas, and creating an interactive visualization using PowerBI, to publishing it online using PowerBI. Excel and PowerBI work hand-in-hand to solve such problems effectively, and efficiently. First, I’ll start […]
How to find the most occurring words in a document?
Every now and then I see in technical forums questions such as this: How do I find the most occurring word in my Word document? Or PDF document? Or Emails? etc. The question is a valid one if that’s something you’re curious about or need to find out in your professional role. In this blog, […]