Here’s an interactive data visualization of some key stats about each state (and DC) such as: state capital, size in square miles, largest city (by population), state population, year of statehood, population density (taking into account land size), population change in percentage over the years, highest peak in state and median household income. Population change […]
Tag: Powerbi
Animating Charts in Excel and beyond
Some time ago I demonstrated how to create Time-lapse animations in Excel in my post here. Part of that procedure utilized a short-lived but cool feature called ‘PowerView’. Unfortunately, as of late 2021, Microsoft has removed support for PowerView in Excel (that made this time-lapse animation possible) and instead is encouraging users to use PowerBI […]
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 […]
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 […]
COVID-19. PowerBI Embedded Reports
(To open the chart on a full, separate window, click here.) Tips on how to best use the interface…
Creating Beautiful Violin Plots
A violin plot is a visual that traditionally combines a box plot and a kernel density plot. This is typically created in R, Python languages using MATPLOTLIB and other applications/modules. However, I show here how to get it done using only PowerBI. About Violin Plots Before I go into how to plot it, let’s understand […]
Creating a GEO learning app in Excel and PowerBI (part2/2)
This is a two-part blog series. To follow along, see part 1 followed by part 2 (this). If you haven’t see a quick animation of the interface, it’s available in part 1. Previously, I demonstrated how to get the dataset ready and create some basic charts in Excel about the states of USA. Now, we […]
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 […]
Analytics From Text?
Yes. From simple text “dump” of data, we can do some amazing things. Well, that’s what they’re already doing…the data scientists and other variants. I only present a simple example of the possibilities here 🙂 First, you should read my post about XML here. Then, I take that to another level here in this post. […]