Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm looking for some advice on a new set of dashboards I need to build to analyze buying patterns. The companies will belong to (or not belong to) various sets. For example:
1. Companies that have bought (or not bought) within the past month/3 months/6 months/12 months (or 2/3/4 quarters). This would be driven by filters. For example, the company may have bought ProductLineX, but not ProductLineY. Also, there will be a minimum purchase amount. For example, if a company only bought $100 or $1k, we may want to ignore them.
2. Companies that have consistently made (or not made) purchases in 5 of the past 6 months.
3. Companies that are growing (or shrinking) relative to themselves or the rest of the market. For example, the company may be growing in general, but shrinking in ProductLineX.
I've been racking my brain on the best way to visualize this. I've viewed the various example QVW's out there, but haven't found anything close. Is there an example of a dashboard that is similar to this?
The other concern is performance. You can see that this application will rely heavily on set analysis. I expect about 2 years of historical POS data to drive these dashboards, so the transaction set will likely be in the millions. Is QlikView a good tool for this type of application?
Any pointers you can give would be greatly appreciated!
This is sort of an open question, very difficult to answer in a brief forum post... Some scattered thoughts:
good luck!