As winter continues here in Washington, D.C., we’re spending our free time inside catching up on of our favorite movies—and it seems like some of our community members are too! Pairing her interest in Star Wars with her desire to learn how to use a Sankey diagram in MicroStrategy, community member Stephanie Fisher built a dashboard that identifies the Star Wars characters that appear most frequently from movie to movie.
By using data from the official Star Wars Databank and IMDB, Stephanie created dataset of character names, movie titles, and appearance counts. In order to make the dashboard more interactive and visually appealing, she also leveraged the databank’s available images to act as filters for the dashboard. She created two visualizations built on this data—a Sankey diagram that connects characters to the movies they appear in, and a circle graph that represents how often each character appeared in the series.
In both cases, the thickness of the lines or sections represent the character appearance count. Stephanie found, unsurprisingly, that R2-D2 and C-3PO have the most appearances—they’re in every movie—as opposed to smaller characters like BB-8 or K-2SO. After completing the visualization and analyzing the data, Stephanie uncovered a few things she wasn’t expecting. First, because of the high volume of characters in the Star Wars series, there was a much more narrow discrepancy in the frequency of appearances than expected. Her favorite discovery was that Leia appears in more movies than Luke, thanks to her appearance in “Rogue One”.
When building dashboards, Stephanie believes that the user experience should always be at the forefront. In this case, she says she “could have easily built the dashboard with only movies and characters,” but that “adding the images shifted the entire user experience.” By making a dashboard that incorporates images as filters, Stephanie made it interactive, allowing viewers to quickly navigate the dashboard and discover new information. Check out Stephanie’s dashboard in the cloud or download the .MSTR file to play with the data yourself.
Want to have your own dashboard featured on the MicroStrategy blog and in our community? Click here to share your work with us. If you aren’t using MicroStrategy Desktop yet, download it for free and get started with easy-to-use data discovery.