The project will be to develop a proof of concept multi-tenant web analytics portal for one of our clients. Proof of concept is only needed as we are limited on budget, so just a minimum viable product is required in the shortest time frame. Each user is part of a network with a shared client who sends out a spreadsheet report every week. The current data does not capture any history or charts, we aim to solve this gap by providing historical trends and interactive visual analysis, coupled with added meta data. Since all users receive the same spreadsheet they will need to forward that email to the specified email address, from which we will parse the data and push it into our database. We are okay with the parsing of this data as we have already done this with a sample, however any advise will be appreciated. Our main concern is with the creation of a multi-tenant full stack web app with a semantic layer and interactive charts. Functional Requirements (If highlighted in blue = Internal resource can handle this, if yellow then needs to be developer by developer) • Data collection Need advice o Currently have a python script that reads and parses data from emails (is there better way?) • ETL Azure • Semantic Layer o Current option discovered: Please advise Azure Analysis Services • Abstraction Layer between AAS + Web App - o https://endjin.com/blog/2020/02/azure-analysis-services-how-to-open-a-connection-from-net o https://www.sanjaybhagia.com/2018/11/12/accessing-azure-analysis-services-models-using-net-core Cube.Js Apache Superset • Front End – Multi-Tenant App o Initial thoughts to have a react web app however please advise best option o Predefined dashboard with possibility of self service charts (not metrics) • PDF reports (emailed) Currently developed using weasyprint, however need to be able to use a scheduler on the web app , if better option please advise.
