QC ?

[#1]

Hi All,

I have to do Quality Check of an application.

What are the Steps to follow ?

Regards,

Helen

[ashfaq_haseeb]

Hi,

Look at QPM or SAFE methodology of qlik.

In-order to get this kit you may contact your Partner.

Regards

ASHFAQ

[ngulliver]

Hi, Thomas and Helen.

Helen describes QC is Quality Check but more often than not QC is described as Quality Control which I believe it is an element of the Six Sigma process.

Helen - There isn't a specific QlikView answer for this as often Quality Checks are driven by the internal standards the product or service must meet within your organisation.

You will need to consider:

1) levels of security - are the right people seeing the right amount of data ?

2) maintainability

3) is code reusable ?

4) is the QlikView app 'optimized' and efficient ?

5) is any manual intervention required ?

6) Stability of hardware/software

7) Dependencies on third parties.

Basically, anything that could jeopardise service quality and delivery to your users/customers.

Corrective action must be decided upon and taken.

If too many elements fail your criteria, a plan must be made to improve the applications and then be put into action. This process must be monitored regularly to ensure that any remedial efforts have improved the situation and to immediately detect recurrences or new instances of failures in quality.

Regards,

Neil

[its_anandrjs]

What are the quality parameters do you have or may be it a list of the QC test.

Basic steps:-

Step1:-

When you create the data model cross check the table rows and field values with the Raw source data and use Count or Sum of the KPI values and check this in the raw source also which will be same and checked with all dimensions that are available into the QV Data model.

Step2:-

UAT test is the test which provide the user accessibility test result and which is test by the user with all KPI and main business rules applied to the model.

Step3:-

UI and reports test this can be done by users and developers also with check to the manual reports also and cehck the user accessibility and usefulness of the dashboard with charts.

Basically i say it is not specific that may be depend on the application and varies from QV application and the basic QC test may varies.

Hope this helps

[#5]

Can you brief this 7 Points  ?

So that I can Understand Clearly..

Thanks,

Helen

[ngulliver · Accepted solution]

Hi, Helen.

1) levels of security

Who is viewing the app ? Is section access in place to restrict access ?

2) maintainability

Is there knowledge and skills present to understand the app and keep the app up-to-date ? Also, has the app been designed and built with a lifespan in mind - often QV apps can be thrown together quickly for a quick win but lack the foresight to see what will happen if it is continued use. Obvious things are whether there is enough space on the dashboard to display several years of data properly. 

3) is code reusable ?

Common data sources should have QVD generators  to pull data from source and create a .qvd to read into the front end. Then, if other apps require the same data, you already have the .qvd rather than pulling the data from source again in another app.

4) is the QlikView app 'optimized' and efficient ?

Changes to field structure, layout and validation checks should be done in QVD generator rather than front-end app. This will make front end app quicker and more efficient ('optimized').

5) is any manual intervention required ?

Where possible, schedule reloads automatically an minimise spreadsheets updated manually by users. You really want to avoid human involvement as this leads to human error.

6) Stability of hardware/software

Are there any weaknesses/causes of system failure. Do you have sufficient CPU. memory, network to provide the service ?

7) Dependencies on third parties.

Are response times sufficient ? Is there a service level agreement with the third party for support. Is all expertise outsourced ? What is the risk of 3rd party failing to deliver ?

Hope this helps.

Neil

[#7]

Thanks Neil.

While we are Developing an QlikView Application we have to follow Some Steps,

Some Functions must be used in the application like AutoNumber & So On...

I Need the Steps that are involved in developing an app.

So that I Can Perform Quality Check for that application ?

..................

and also Explain Some more Points about 4 th point ?

[ngulliver]

Hi, Helen.

I'm not quite sure what level of detail you need.

In terms of the steps required for developing an app, it depends on your design methodology - JAD, RAD, Waterfall etc.

For any long term solution I would recommend any data transformation takes place in a QVD prior to the data being used in the front end.

Regarding optimization of applications, I recommend having a look at this blog

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

My apologies, Helen - if I had more time, I could answer more fully.

Regards,

Neil