Movie Rating Dashboard

Share Now

Hello Friends,

Let’s talk about dashboard designing today.

Last weekend I was planning to watch “Mission: Impossible – Rouge Nation” and I started searching for the movie reviews on google as you all do 🙂 . And while reviewing, thought came into my mind to create the dashboard for the same.

3 Star Conditional Formatting

So here we go with our movie rating dashboard.

Dashboard have “5 Star Reviews” column and other details like star cast, release date and critics/readers rating.

PS: Movie is super kool, I liked it.

Here you can download the Dashboard Template.

You can use the same template to design other dashboards like Sales Dashboard for Customer Satisfaction Ratings.

What is Dashboard?

Dashboard is a graphically representation in the form of charts and tables which initiate us to take action.

How to make it?

I have used below functionality in the dashboard.

  •  Database created with fields(Movie Posters(Image), Release date, Critics/Readers rating and Star Cast)
  •  Icon Sets Conditional Formatting (3 Star Rating)
  • Updated movie poster ranges in the dashboard as Name Range
  • “Worksheet_SelectionChange” Event.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error Resume Next
If Not Intersect(Target, Sheet1.Range("B7:B37")) Is Nothing Then

    Sheet1.Range("O8").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 2, 0)
    Sheet1.Range("M8").Value = Target.Value
    Sheet1.Range("M10").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 4, 0)
    Sheet1.Range("M12").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 5, 0)
    Sheet1.Range("M14").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 6, 0)
    Sheet1.Range("M16").Value = Application.WorksheetFunction.VLookup(Target.Value, Sheet3.Range("B:I"), 7, 0)

End If

End Sub

Share Now
May 24, 2016

0 responses on "Movie Rating Dashboard"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

    Drop us a Query

    Call Us: +91 8826547882

    Drop us a Query