none
KPI- Dashboard design- beginner RRS feed

  • Question

  • Hi All,

    I am new in Dashboard design. 

    Q1: How would I design the following dashboard with these requirements?

    Metrics with sample data:

    Sales by Month

    SalesMonth

    Sales

    Dec. 1, 2008

    $100,000.00

    Jan. 1, 2009

    $150,000.00

    Feb. 1, 2009

    $180,000.00

     

    Target Sales by Month

    SalesMonth

    Sales Target

    Dec. 1, 2008

    $90,000.00

    Jan. 1, 2009

    $170,000.00

    Feb. 1, 2009

    $150,000.00

     

    Rep Sales Performance

    Rep

    Revenue

    John

    $30,000.00

    Harry

    $50,000.00

    Anna

    $90,000.00

     

    Sales by US region (NorthEast, NorthWest, SouthEast, SouthWest)

    Region

    Revenue

    NorthEast

    $130,000.00

    NorthWest

    $190,000.00

    SouthEast

    $220,000.00

    SouthWest

    $320,000.00

     

    2. What other metrics do you think would be relevant with this dashboard?


    • Edited by Abdul Afrad Friday, October 5, 2012 4:16 PM
    Friday, October 5, 2012 4:15 PM

Answers

  • Hi Abdul,

    A key performance indicator (KPI) is any measurable value in a report that has business significance, for example, Total Sales. If we want to display the current state of a KPI on a report, we can use one of three different approaches:

    • Highlight cell values using a background color that shows the state of the KPI.
    • Replace cell values with an image that shows the state of the KPI.
    • Insert a gauge.

    Since you didn't provide the structure of the sample dashboard you want to design, I suggest that you refer to the following articles to obtain more information about how to add KPIs to a report:

    For the relevant KPIs, I suggest that you expand and check the "KPIs" item in the "Metedata" area of the MDX Query Designer.

    Hope this helps.

    Regards,
    Mike Yin


    Mike Yin

    TechNet Community Support

    Friday, October 12, 2012 2:48 PM
    Moderator