topic Re: Requirements Gathering template for Qlikview Dashboards in QlikView

Requirements Gathering template for Qlikview Dashboards

Wed, 07 Aug 2013 09:07:05 GMT

Hi everyone,

It would be very helpful if someone could help me with the following: Does anyone have a Requirements Gathering template for Qlikview Dashboards?

Regards,

Harsha

Re: Requirements Gathering template for Qlikview Dashboards

richard_pearce6 — Wed, 07 Aug 2013 10:41:14 GMT

Hi Harsha,

I don't have a template I can offer, key things to consider would be:

Measure (expression) Definitions

Key Dimensions required for selections / charts

Data Sources

Perhaps Views / Objects required (if you're expecting granular requirements).

Complete requirements are not something I usually get before beginning an app design and I tend to develop requirements (in preparation for testing) as I go in an iterative way.

I'm guessing you're new to QV so I would advise keeping the data structure simple (Single fact table, star schema) so you don't get too many design issues as your requirements increase.

Hope this is of some help

Re: Requirements Gathering template for Qlikview Dashboards

Wed, 07 Aug 2013 10:43:40 GMT

This is helpful Richard, thank you.

Harsha

Re: Requirements Gathering template for Qlikview Dashboards

raviityou — Sun, 12 Oct 2014 17:32:46 GMT

Thanks

It really helpful for all project these are really basic step but make more effect.

Ravindra..

Re: Requirements Gathering template for Qlikview Dashboards

ashfaq_haseeb — Sun, 12 Oct 2014 19:42:15 GMT

Hi,

Check if this helps.

Steps to understand already build application

Regards

ASHFAQ

Re: Requirements Gathering template for Qlikview Dashboards

its_anandrjs — Sun, 12 Oct 2014 20:19:08 GMT

Hi,

You have to ask the user about the Business Rules that are available in the Business that you are working on and you have to go for few of the major steps.

1. Finding Major Tables available in the data model.

2. Find main fields on the tables with measures and dimension.

3. Identify the different dimensions like Dates, Customer Names, Country, Regions, SBUs etc

4. Work on the KPIs to find out if it is formula than you need to find different fields also.

5. Work on Major data sources and its types.

This are not fixed and main rules but that are few nice steps to work on the requirement gathering process. Also always try to create simple and good Data model and this will help you for creating the Charts, Reports, Dashboards and Qlikview application.

Regards,

Anand

Re: Requirements Gathering template for Qlikview Dashboards

jagan — Mon, 13 Oct 2014 02:23:16 GMT

Hi Harsha,

Hope below steps helps you.

1) DataSources

2) Identifying Fact Tables

3) Identifying Dimension tables and their relation with Fact tables(Key fields) or get Data Dictionary

4) KPIs to be shown in Dashboard like Sales, Profit, Profit %, Discount, Gross Margin etc.

5) Filters to be displayed

6) List of Charts to be displyed

7) Getting the Cyclic and Drilldown groups

😎 Any rule based display of data (using Section Access)

9) Additional features like Export to Excel, Email etc.

10) Getting Mapping data in Flat files if not available in Databases

Hope this helps you.

Regards,

Jagan.

Re: Requirements Gathering template for Qlikview Dashboards

richard_pearce6 — Mon, 13 Oct 2014 09:23:33 GMT

Hi Harsha,

Appretiate this question is quite old now although Jagan's reply pushed it back into my view.

Since we last spoke I've create two blog posts on my site QlikCentral.com. The first talks through in more detail around requirement gathering http://qlikcentral.com/2014/06/11/requirements-gathering/ and the second is a checklist http://qlikcentral.com/2014/07/14/requirements-checklist/

I hope these may help people searching for a simalar thing.

Regards

Richard