Designing an advanced analytic solution