Let me first qualify, I am not an IT guy.
We are looking to implement a reporting tool that will help us better run our business. I have had some say use SSRS, SSAS, QlikView, Domo, Informer, etc...... Some say build a warehouse, or at least stratify the data into another server / additional tables to have easier data to report on.
Our goals is to have a better understanding of the data. The current system has NO report writer. Everything is adhoc and there is no trending which is extremely important in our industry which is insurance.
The database is a Sql2012.
I need a tool or system where I can create, run, schedule, email (.xslx / pdf) results. Create data report, drill reports, BI dashboards. Data must be mobile.