Press "Enter" to skip to content

Category: Visualization

Data Visualization and Microsoft Fabric Notebooks

Meagan Longoria thinks about notebooks:

Lots of people have created Power BI reports, using interactive data visualizations to explore and communicate data. When Power BI was first created, it was used in situations that weren’t ideal because that was all we had as far as cloud-based tools in the Microsoft data stack. Now, in addition to interactive reports, we have paginated reports and notebooks. In this post, I’ll discuss when notebooks might be an appropriate visualization tool.

Click through for Meagan’s thoughts.

Leave a Comment

Using the OKVIZ Synoptic Panel for Ticket Sales Data

Victor Rivas visualizes some sales data:

This use case demonstrates the powerful capability of Synoptic Panel to analyze and visualize spatial data at large venues like The Sphere in Las Vegas, which seats 9,205 people. The study addresses the challenge of visualizing over 1 million ticket sales records from 200 events, including concerts and conferences, to gain insights into revenue and average occupancy percentage across different seating categories, sectors, and individual seats.

The objective is to demonstrate how spatial data visualization helps stakeholders understand revenue distribution and audience behavior related to seating arrangements, enabling more informed decision-making.

Click through for the case study. H/T Marco Russo.

Leave a Comment

Representing Partial Data in a Series

Amy Esselman explains how to signify that a point in a time series is incomplete:

When we’re reporting the latest information, it can be challenging to know how to handle data that is still in progress. For example, if we’re reporting annual performance trends with only three quarters completed in the latest year, the numbers can appear misleadingly low. If you exclude the latest data points, it could hide crucial details from stakeholders. Audiences often want timely updates, but partial data can cause confusion if not clearly communicated. 

Amy includes several tactics that can clarify the situation.

Leave a Comment

Creating Your Own ggplot2 Geom

Isabella Velasquez is feeling creative:

If you use ggplot2, you are probably used to creating plots with geom_line() and geom_point(). You may also have ventured into to the broader ggplot2 ecosystem to use geoms like geom_density_ridges() from ggridges or geom_signif() from ggsignif. But have you ever wondered how these extensions were created? Where did the authors figure out how to create a new geom? And, if the plot of your dreams doesn’t exist, how would you make your own?

Enter the exciting world of creating your own ggplot2 extensions.

The post looks a lot like a series of slides, and it takes you through the process of creating a new geom. H/T R-Bloggers.

Comments closed

Building a Pyramid in R

Tomaz Kastrun has fun generating a triangle:

What motivates human behaviour can be captured in the Maslow’s hierarchy of needs (source: Wiki). Maslow and psychologists have articulated these needs in a form of a Pyramid, and ever since the concept had been widely adopted (also criticised), and yet, another adaptation is the Pyramid of R needs

Read on for Tomaz’s take, as well as how to generate such a pyramid.

Comments closed

Reviewing Power BI Report Interactions via Semantic Link Labs

Meagan Longoria wants to know about visual interactions:

It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important. If you do this manually, you have to turn on Edit Interactions and select each visual to see what interactions it is emitting to the other visuals on the page.

But there is a better way!

Click through for that better way.

Comments closed

Bars vs Lines in Visuals

Cole Nussbaumer Knaflic contrasts a pair of visual options:

Bringing clarity to your data storytelling doesn’t usually mean you need to learn and use more chart types. It does mean choosing visuals that are appropriate for your data and what you’re trying to communicate. Two of the most useful tools in our graphing toolkit—bar charts and line graphs—often do the heavy lifting. Knowing when to use which (and when to switch) can make all the difference.

This lesson came up recently as I revisited our new book, storytelling with data: before & after. I’ll share two scenarios where the choice between bars and lines matters. They are both from Chapter 2, which is titled “embrace basic graphs.”

Read on for an initial chart that is using the wrong type of visual, and then how we can tell different stories using the same data based on our choice of visual.

Comments closed

Using Dygraphs in R

Thomas Williams builds a chart:

I also wanted to get a little interactive with my analysis, and came across Dygraphs for R https://rstudio.github.io/dygraphs/ which wraps the “venerable” (according to creator Dan Vanderkam https://github.com/danvk) javascript charting library of the same name, first released in 2006.

I used Dygraphs in an R script file (it can work equally well in R Markdown) to quickly chart my time series data, loaded from the CSV file. Dygraphs were simple to use, are a solid pick among other charting libraries and very functional for being free and open source.

Read on for a few examples of charts, as well as the entirety of Thomas’s code.

Comments closed

Toggling Light and Dark Modes in Power BI

Elena Drakulevska builds a switch:

We learned in the last post that while dark UI feels sleek, it’s not automatically accessible and it shouldn’t be your default strategy (hello, contrast + glare). In most cases, light mode is the more accessible baseline (just imagine trying to work on a sunny beach or on your balcony with dark mode… nightmare).

But UX is also about choice. Some users love light, some swear by dark. So let’s give them control.

Read on to see how, without sacrificing much accessibility.

Comments closed

Using Field Parameters in Power BI for Dynamic Views

Annamarie Van Wyk demonstrates how to use field parameters to slice data in Power BI:

If you’ve ever built a Power BI report and found yourself duplicating charts for daily, weekly, monthly, or yearly views — you’re not alone. It’s one of the most common (and frustrating) dashboard challenges: “Can we see this by day? Actually, make it by week. No wait — what about monthly?”

Instead of building five versions of the same visual, you can do it all with one — thanks to Field Parameters.

Read on to see how it all works.

Comments closed