Implementing the control panel in the existing application

We are trying to create a scorecard and implement BI in the existing application, which is built using the MEAN stack and hosted in AWS. I observed some of the integrated BI tools, but they are quite expensive and we do not want to provide our data to third parties. We have our data in MS SQL, DynamoDB and AWS S3. I am thinking about the redshift of AWS on the backend and the merge graphics or D3.js on the frontend for data visualization and the creation of graphics.
I will be in front-end in Angular 6. I want to know what back-end technology would be useful for this, either Redshift or any other alternative.