Blog

Analytics Education 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 […]

Read More
Analytics Coding STEM

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 […]

Read More
Analytics Education STEM

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 […]

Read More
Back To Top