The ease to set up rules for customizing results as per business requirements/logic in combination with its flexibility make it very strong product from my point-of view! We are using this software since last 3 years without any issue at all which makes us feel confident while recommending others too use this tool.
Nothing much yet but we have started facing issues when running queries across multiple indexes or databases (we're not sure if that's due to our system configuration). Since I am newbie into data analytics realm, please do refer me more about other tools available out there so i can better understand their features before moving ahead! Data warehousing & Reporting needs customization work done by experts who knows database concepts well otherwise you'll endup doing lotsa mistakes resulting slow performance etc..