Sunday, October 24, 2021
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
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
Education STEM Work

Creating a GEO learning app in Excel and PowerBI (part1/2)

In this blog, I’ll show you some very effective and efficient ways to get vital information about all states of the USA, and eventually create visuals, then interactive visuals, then an interactive application online. All from starting with the basic names of states. I wish every kid and adults would have this type of application […]

Read More
Back To Top