We excel in the use of the tried and true Microsoft SQL Server BI stack. Anyone can mention all the buzzwords;
SSIS, SSRS, SSAS, SharePoint, Dynamics CRM, PerformancePoint, Excel services, PowerView, PowerPivot...
So many acronymns, and [sadly] normally so little knowledge and even less experience.
We can hand-on-heart say we have delivered, time and time again, business changing solutions. We have cutting-edge experience in delivering data migration and centralisation projects. Purely analytical jobs are common, as are static and ad-hoc reporting ones.
Having transactional systems integrated in some way with SharePoint (2010 or 2013) and/or CRM (2011 or 2013) is becoming all the rage. Why not use SharePoint as a data entry mechanism - have the data reside outside SharePoint in a SQL Server database? So many options.
You need to be able to access base data, manipultate that data, store it cleverly and transparently, and then be able to report on that data. Define static, drill through reports... but also give your executive team the ability to pull your data apart as they see fit, through dashboarding and score cards.
You may have hundreds of ways a hundred employees work with the same sets of data. Wouldn't it be nice to have that centralised? A single source of truth? This need not be a myth.