Can you explain Snowflaking Schema ?

Snowflake Schema: An extension of the star schema by means of applying additional dimensions to the Dimensions of a star schema in a relational environment. Snowflaking is a form of dimensional modeling; dimensions are stored in multiple relational dimension tables. A snowflake schema is a variation of the star schema. Snowflaking is used to improve the performance of specific queries. The schema is diagramed with each fact surrounded by its associated dimensions as in a star schema, and those dimensions are further related to other dimensions, branching out into a snowflake pattern.

What is Distribution Plot in Qliksense?

What is Distribution Plot in Qliksense?

It  is great for displaying dimensional data points distributed along a horizontal line by the expression. So, for example, several low values will be bunched at the left while the high-value outliers will be spread out along the right side of the chart. Rather than seeing only a total, the distribution plot charts individual values spread across a plane, like mayo spread across a slice of bread. You can add a secondary dimension to create multiple horizontal planes.

What is QVD file? What are the pros of QVD files?

What is QVD file?
A QVD file stores data for one QlikView document and it is created using the script editor available in the QlikView document.

Pros of  QVD Files:
The advantages of using QVD files in QlikView are as follows −

• Faster Loading of Data
• Gracefully support scaling up as the data volume grows
• Used in incremental load
• Data from multiple sources can be clubbed to one data set
• Extract data in parallel

What are the important features of Qlik Sense?

What are the important features of Qlik Sense?

• Drag-and-drop visualizations
• Scalability and Manageability
• Powerful Open and Standard APIs
• Smart Search feature
• Fast and reliable connections to multiple data sources
• Access to real-time analytics anytime, anywhere
• Data storytelling functionality
• Shared Object Library
• Self-service simplicity
• Progressive Creation
• Managed Data Connections
• Rapid Development Environment
• Multi-source data integration including big data
• Enterprise-level security

What is Qlik sense?

Self-provider records conception utility that enables you to look and determine vast amounts of facts to find out visions of the employer. It uses analytics and Discovery of facts. With Qlik experience, an organization can create elastic, interactive visualizations and make significant decisions.

• It is fast and easy
• Redefines how you access, create and share insight
• Faster time to insight anyone, anytime, anywhere on any device.

Explain Aggr function?

Returns a set of values of expression calculated over dimension 
Ex: Aggr(sum(sales), country)

What is the use of Load statement?

The load statement loads fields from a typed ASCII file from data defined in the script from previously loaded input table, from previously loaded field. From the result of the following select statements or by generating automatically

What is Concatenation?

Concatenation: 

If the two tables have different fields concatenation of the two tables can be forced with concatenation prefix.

What is Keep?

Keep: it will not join two tables and they will be stored in QlikView as two separate named tables. Keep will always preceded by one of the prefix

• Inner
• Left
• Right 

Ex. Right Keep.

How do you optimize QlikView Application?

For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization I believe not use any tools we can manually remove unwanted fields form data model or comment it, remove most complex logics from the load script or create it with the simple way because it will take long time for loading. If using large data base file try to create the incremental load for the QVD or load latest data only.

Briefly explain how does QlikView storage the data internally?

QlikView store data in to QVD. QVD have data compression capability. QlikView have better performance compared to other BI because of in memory analytics approach, in built ETL handling capability.

Explain 3 tier architecture implementation while deploying QlikView application?

1st Tier - Raw data is getting loaded and QVD is creating.

2nd Tier - QVD is transform in the business login and requirement of the business and data model is created.

3rd Tier - Reading the all QVD from 2nd tier and make a single QVW or may be any binary load.