This content has been marked as final. Show 1 reply
This is sort of an open question, very difficult to answer in a brief forum post... Some scattered thoughts:
- This is perhaps the wrong forum for the question "Is QlikView a good tool for this type of application?" We do everything in QlikView here...
- Detailed POS data tends to be very heavy, especially in its detailed raw format. You should be ready with some good hardware - 64 bit server, with lots of RAM and CPUs. Hard to estimate without knowing your data size.
- Set Analysis, from the performance perspective, is actually a big help - it's the best performing technique there is, because it works via reducing the data set that is going to be aggregated (as opposed to testing every row for a specific condition).
- I think you need to separate visualization questions from the conditions, at least in your thinking process. Whatever your conditions are, visualization will depend on the type of analysis that you need to perform. When you say "Companies that purchased ...", what are you after - the number of such companies? The list of them? The comparison between their Sales numbers? % of total? Each one of those questions and answers calls for a different type of a visualization.
- I could see a screen with the number of charts, showing a "standard" set of visual pictures - perhaps a pie with the market share based on a certain Dimension, and a scatter chart with the "Magic Quadrant" of all Companies plotted over 2 major KPIs, and a histogram showing how many Companies fall into certain buckets, and a chart showing % of total. Along that, I'd offer a dynamic selection of "Filters" - Companies that "bought" or "not bought" within certain period etc... For each"filter" option, you'd define the Set Analysis condition that needs to be used in all Chart Expressions. You could even develop "smart" formulas that could combine multiple filter conditions into a single Set Analysis expression.
- So, bottom line - yes, I think QlikView IS the right tool for the job. No other tool (that I know) can do Set Analysis as well as QlikView does...