You can download an e-book “SQL Server Analysis Services Succinctly” in the link below:
Here is a link to learn ASP.Net MVC.
Here is the link to SSIS training material from SQLServerCentral:
I found a good simple article on designing aggregations and checking the performance gain in sqlcircuit.com.
Here is the link to that article: