Hello, I consider myself a junior developer hoping to be a confident fullstack .NET dev in the future. I am currently working on a personal project to demonstrate and test my skills in .NET.

Right now, I am at a point where I need to pull data from 3-4 tables and aggregate the data and do other math operations. For better or worse, my experience with this in the past has been creating SQL views of this information but as I start to get more experience I see many projects use a separate backend language or app to make these calculations.

So I want to calculate game data from Riot Games League of Legends API and that involves downloading thousands of players match data and then aggregating it all into an overall average (or whatever metric I want)

edit: I should note that I want to eventually display this data into chart.js elements on my pages so whatever I can use to load that reliably (using DB objects maybe?) would be great.

Is there a preferred method of handling this sort of problem? Currently my app is just an ASP.NET MVC 5 project using Entity and an AWS RDS for my db server. I am interested in learning different ways to solve this.

Thanks!