partial views or parse data mvc

I am fairly new to MVC, and web programming in general. I spent most of my career on Microsoft desktop applications. I have a MVC dashboard project I am working on where we want to display chunks of data in several locations on one main page. Right now I have this set up to use partial views in MVC, and have separate sql views for each partial view. My question is one of performance. Is it better to set up a view in sql for each partial view in MVC, or is it better to have one view in sql, and use linq expressions in code to parse out the needed data. The data changes frequently, so I'm not sure which route to go. Or maybe there is a totally different way??? Thanks in advance.