fbpx
Search
Close this search box.

May the POWER BI with you [Star Wars Day Viz]

Share

Facebook
Twitter
LinkedIn

It is star wars day. Let’s celebrate the ultimate nerd day of known universe in a way that resonates with us. Let’s dress up as storm troopers and make exploding 3d pie charts.

Just kidding. Let’s just make a cool visualization in Power BI instead.

Star Wars Infographic – Made in Power BI

Here is my visualization embedded below. You can also see it online here. You can switch between Dark Side and Light Side.

How is it made?

I wanted to create something cool and easy for this star wars day. But getting organized data about the movies is rather tricky. Thankfully Power Query can process a hodge-podge of web data in less than 12 parsecs. As the file is clumsy under the hood, I am not sharing it yet. But here is the process.

Gathering the data

  • Started with Wikipedia pages on star wars.
  • After cleaning the data, I ended up with a table that has film name, date of release, revenue, ratings, director, writer details in it.
  • Then I created individual movie page links and navigated them to find out the poster URL (this is the first IMG tag on the page after the TABLE tag with class=”infobox vevent”)
  • I did the same for writers to get their mug shots from wikipedia
  • Finally, I copied some star wars trivia from mentalfloss and loaded this as a 50 row table

Setting up the visuals

  • Initially I wanted to create the visual as a computer console in death star or millennium falcon. But quick google search proved that there are few images of this and most of them are non-rectangular. That would waste too much space on screen.
  • I then though of making two layouts – dark side and light side. So I downloaded some wall papers along both lines and started by creating dark side first.
  • I set up a slicer on movie poster to enable selection of a film.
  • For the film, I wanted to show details along these lines:
    • Box office performance: how much money it made, what rank it had on all time world wide box office and budget
    • Reception: ratings from rotten tomatoes and meta critic
    • Writers: Their faces and names
    • Trivia: Not directly related to the film, but a random trivia that would change everytime you interact with the report.
  • I set the dark side page background to my dark side wall paper.
  • I added a few images to identify the sections of the infographic.
  • I duplicated this page, changed the background and visual formatting.
  • Finally I added navigation buttons to the other side on each page (using bookmarks, of course)

Quick demo of the Power BI Viz

In case you could not see the embed above, here is a quick demo. (See it on YouTube)

That is all for now. See you later. I have been way too long in front of computer now. Gotta go.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

4 Responses to “May the POWER BI with you [Star Wars Day Viz]”

  1. Charley says:

    Nice visualization.

    1 Error I spotted: The posters for Rogue One and The Last Jedi should be the other way around. When you click The Last Jedi, you get info about Rogue One and when you click Rogue One you get info about the Last Jedi.

    • Chandoo says:

      Good Catch. Fixed it now. Thanks for letting me know.
      This happened because the order in which these movies are listed is different in each wikipedia page (and there is no primary key to link as some would spell the name as "Star Wars" while others as "Star Wars - A New Hope".

  2. NC says:

    Hi Chandoo, Community,

    Do you have any good recommendations on a textbook for power bi? I like to have a read through and a reference book handy when I work. something that's forgiving for someone new to power bi, but has all the good detail and tips and tricks an analyst and skilled excel user would look for... So sort of intermediate and expert resources.

    Who's the respected author on power bi?

    Regards,
    NC

  3. Hisham Ghulam says:

    Can you please share the file. I am learning Power BI and I find this very informative and I can learn a lot from it

Leave a Reply