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 […]
Category: STEM
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 […]
Scattered Data to a Butterfly, or a Tornado!
What do butterflies and tornadoes have in common? 🙂 Butterfly charts aka Tornado charts are a special type of Bar chart where the data categories are listed vertically instead of the usual horizontal layout. It’s suitable for comparing different variables between two groups (e.g. male/female, apartment/house, car/boat, etc. etc.) and what variables you measure is […]
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 […]
Speech Recognition and back (using AI/Python)
In one of my earlier blogs, I shared tips on how to build a Text-To-Speech application in Python, which you can read in the post: Interactive Text-To-Speech App… In this post, I’ll show you the reverse…where we can take our voice, and even an audio-recording, and transcript them into English text. Once I do that, […]
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, […]
Interactive Text-To-Speech App with Presidents of USA (Python)
In this blog, I’ll discuss how to build an interactive lookup of data and have the results spoken back to you in human language. Specifically, I have a list of all POTUS to-date in a file (Excel, CSV, Text…they’ll work without any code design change). I want to be able to lookup the very first […]
Turning visual map results into a database/dataset
I often get questions such as: “How do I export Google business data into a database?” or “How do I import Google locations data into an Excel sheet?” They’re both pointing to the same need. The scenario is that we can search on Google Maps or Bing Maps or just on any online Search engine […]
Morse code translator (Python)
In one of my earlier posts, I described how to take text and generate Morse code. For details on that, see Text to Morse: codes and sound generation (Python). In this post, I’ll do the reverse. The application will take Morse code symbols and translate into English text. First, let’s start with a fun fact. […]
Extracting phone numbers from any document/file
Imagine you have documents of various types: email, Word documents, PDF, text, HTML, Excel, etc. And you want to extract phone numbers, and phone numbers only from those documents as you try to build a list of contact information or a database. In this post, I show a quick and effective way to do just […]