Data aggregation from MS SQL in conjunction with Sharepoint

Question

SharePoint

Good day!
Given: a database on MS SQL Server 2012. It contains data on persons and departments. The data from the database is available through a site deployed on Sharepoint 2010.
Question: by what means (as close as possible to the Sharepoint platform) can you implement the issuance of aggregated (summary, combining several tables. Generalized indicator) data? Something in the manner of ratings for a unit or a particular person. For example, when creating an application for some work, according to the data from the database, he pulled out people who were engaged in these works.
As options, I see a self-written web part in c #, using Analysis Services (SSAS-> OLAP cube) or Reporting Services (tables). Interested in additional options. Any third party solutions based on Sharepoint. For example, Nintex implements workflow.
I will be glad to any name related to the case. So that you can google.