| Query | What to look for... |
| |
| How would you describe a: a) Dashboard b) MI solution | Basic BI / MI knowledge |
| |
| What is it that drew you to working with QlikView | Response around solutions that can be delivered / end user satisfaction - rather than a feature list |
| |
| Describe some of the solutions you have built in QlikView | Applicacations around finance / insurance |
| |
| What parts of QlikView project life cycles have you been involved in | Comfortable in dealing with people as well as software |
| |
| What feature of QlikView would you like best, and why | This one is subjective - but may draw an interesting response |
| |
| What would you say the limitations / flaws with QlikView are | Again very subjective |
| |
| What presentation object would best suit...... | Holds an opinion on basic data presentataion |
| |
| What is a QVD file and why might you use one | It's a data repository file, can aid a robust / quick reload strategy, essential for incremental loads of data |
| |
| What is the difference between optimized and non optimized QVD load | When retreiving from QVD optimized mode is up to 100x quicker - only works if you follow a set of rules |
| |
| Describe the use of the ApplyMap statement | Used for mapping data from one source onto another at load time, very flexible in how it does this |
| |
| How might you seek to decrease memory usage by a document | Drop redundant items, remove granularity (eg. drop time from datetime fields), split fields (eg. post codes) |
| |
| What kind of optimisations can be done to data models | Merge tables to reduce joins at run time - create a flatter structure at load time |
| |
| Describe the crosstab directive; how and why would you use it | Transforms columns into rows by dimensions (eg. in Excel where have cols for description then one col per month) |
| |
| What is a calculation condition and why would you use one | Stops a potentially costly calculation / display taking place by checking a more efficient expression first |
| |
| What is a show condition and how does it differ from calculation condition | Similar to calculation condition but the object is removed from the screen rather than displaying a message |
| |
| What are the advantages of using a theme | Contains all UI attributes in a single file, when new objects are created they can pick up from the theme |
| |
| Why might you make use of variables | Can keep re-useable code snippets, calculate values for global use, maintaining state of objects
|
0 comments: