topic Re: Dashboard and Scorecard in QlikView

Dashboard and Scorecard

v_iyyappan — Mon, 07 Oct 2013 07:10:16 GMT

Hi,

1. Can you anyone explain the definition and difference of Dashboard and Scorecard ? And also give me sample link also.

2. I want to know technical term list like LFY, LTM, TTM.

Please anyone give some details?

regards,

Iyyappan.

Re: Dashboard and Scorecard

jagan — Mon, 07 Oct 2013 07:50:36 GMT

Hi Iyyappan,

Please find below URLs

http://office.microsoft.com/en-sg/sharepoint-server-help/what-is-the-difference-between-a-dashboard-and-a-scorecard-HA101772797.aspx

http://www.klipfolio.com/satellite/dashboards-scorecards

and

TTM - Trailing 12 months (or) LTM - Last 12 months both are same.

http://www.investinganswers.com/financial-dictionary/financial-statement-analysis/trailing-twelve-months-ttm-3478

LFY - Last Fiscal Year (Last Year (2012))

http://www.investinganswers.com/financial-dictionary/financial-statement-analysis/last-fiscal-year-lfy-3474

Hope this helps you.

Regards,

Jagan.

Re: Dashboard and Scorecard

ngulliver — Mon, 07 Oct 2013 08:36:49 GMT

Hi, lyyappan

A dashboard is essentially a display of business data done in way that enables the user to gain more information from the data. It can cover any business data from detailed production line output to high level strategic data. A scorecard is a specific type of dashboard designed to measure key performance indicators (KPI) of a business and is often used by the executive body to look at macro trends and compare them with how they think the business should be performing.

Have a look at

What is a Balanced Scorecard.mov - YouTube

Cheers,

Neil

Re: Dashboard and Scorecard

Mon, 07 Oct 2013 08:54:54 GMT

Hi Iyyappan,

I think this might be helpful.

http://community.qlik.com/blogs/theqlikviewblog/2010/06/06/dashboards-versus-scorecards

Crux of this post is:

Dashboards display information about a company at a given point in time that can be used to make better business decisions whereas scorecards tend to measure and compare actual performance results over a given time period versus desired results or benchmarks in that time period or results from a previous time period.

Hope this helps!

Re: Dashboard and Scorecard

israrkhan — Mon, 07 Oct 2013 08:56:40 GMT

Hi,

"dashboard" and "scorecard" interchangeably, but there is a significant difference between them. A scorecard is a type of report that displays a collection of key performance indicators (KPIs) together with performance targets for each KPI. A dashboard, on the other hand, is a container for a related group of scorecard and report views that are organized together. In other words, a dashboard contains a collection of other items such as scorecards, reports, and filters.

Score Card :

Dash board:

Hope it Clear:

Khan

Re: Dashboard and Scorecard

v_iyyappan — Mon, 07 Oct 2013 09:28:02 GMT

Thanks for all Experts.

Its really helpful for me.

regards,

Re: Dashboard and Scorecard

Sat, 26 Oct 2013 04:20:45 GMT

I want to create a drill down dashboard in QlikView. The data is lying in SQL server and for each level a separate SQL table is available. For example, for the first level which is WW there is a SQL table which contains WW level data and so on.

The dashboard should drill down to the lowest level as per user requirement. Please share some QV dashboard. Any help will be appreciated.

WW
1. AMS
  1. Canada
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
  2. USA
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
  3. LATAM
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
2. APJ
  1. ASEAN
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
  2. India
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
  3. Japan
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
3. EMEA
  1. CEE
    1. Sales Manager
      1. Sales Rep
        Transaction1
        Transaction2
  2. Germany
  3. Iberia
  4. Italy