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.
21 Responses to “Make a Pivot Table in Excel [15 Second Tutorial]”
[...] First step is to create Pivot Table. Here is a video tutorial on making pivot tables. [...]
Dear Sir,
I would like to study pivot table from basics detailed.Pls send me the tips of that
merccccccccccccccccccccccccccccccccccccc
[...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]
it is very useful
hello sir
please send me some information of pivotable. and how to use it
because I am beginer so how can i learn it the pivotable.
and sir will you send me pivotable data because i have no data and i don't
know how to applyed for the pivotable. give some videos so I learn quikely.
thank you
and my best
anticipation
Hi,
This tutorail was helpful. If possible can you please email me some data, so I can create another pivot table? I am trying to learn ASAP and need some info.
Thank you
@Keri
Have a look at FakeNameGenerator.com
Top of the day to you. can you pls send me a detailed tutorial on the pivot table tutorial? Thanks.
Hi,
please tell me how to use Pivot table.
@Karthick, Yemi
Have a read of: http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/
Dear Sir,
I visited this website of urs for the very first time and trust me this is fabulous.i learnt pivot table through this.Thanks a lot.In corporate world nobody gonna make u learn these things.m very grateful to u.This is a great initiative from ur side.Commendable job done.Hats off to u.For beginners also this is very helpful.The way this website makes u learn excel is very good.
Pooja
Can you please email me information to put into a pivot table and possibly a complete set of instructions? I am a beginner to pivot tables and am possibly interested in obtaining a position that requires pivot tables. thank you.
[...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]
It's simply great..!!
Cool!
Fast but not furious.
Pls email me details of pivot table. I want to learn it asap because I just got a job that requires this. Thanks
it is very useful..............thanks
Sir please can u send me the complete explanation of pivot tables from basics
hello,
I wanted to know how to put pivot with emp id, emp name, emp position in one row.
Ex:-
cel A4 should have Emp id
Cell B4 should have Emp Name
Call C4 should have Emp Position
many thanks in advance
Nice information, thanx my dear.