Gearing up for the Microsoft Data Insights Summit, Microsoft hosted a Power BI Data Analytics Challenge. We participated by entering in the “Just For Fun” category, submitting a quickly thrown together dashboard with analytics about The Simpsons. The data was sourced from Kaggle – The Simpsons by the Data. The data is driven by script lines. In addition, we supplemented the data with images and bios from The Simpsons Data Analysis dashboard allows users to explore character profiles, season appearances, and dialog sentiment. The Character Report tab assess who’s talking and where they are talking by word count. Images

In the spirit of exploring new visualizations, I wanted to learn how to create a Sankey diagram within MicroStrategy Desktop (also known as Visual Insight in web). A Sankey diagram is used to visually explain flow or many to many relationships with respective proportions. The visualization needs a source attribute, target attribute, and measure to size the path or flow. In order to support the visualization, I grabbed data off of The databank also had images I could leverage as a twist on the visual format. Cross referencing IMDB, I created a list of popular characters by Star Wars

Star ratings have become a staple for assessing review sentiment online. We see them all the time when we shop and can quickly associate whether a review is worth reading based on the 1 star vs 5 stars attached to the review. Given the popularity, I recently included star ratings by product in a dashboard designed for an executive audience. The visualization is intuitive and straight to the point. However, I started thinking why stars and not other shapes? To test out using other shapes, I kept it simple and fun. Star ratings, or in this case custom shape ratings