We have a banking database containing branches, account and account holder, facility, and collateral.
We need someone to work with us to design a OLAP cube, and implement SSIS packages to load the above database to the cube. We have a set of reports with fixed structures that we want to pull from the cube. The reports should be able to drill down into more details.
Aside from these reports, a separate module to allow dynamic report from dimensions and fact. Perhaps this is done using Power BI.
We want above to be within our ASP.NET program.