Which Azure tools should I use to create a subscribable data project for Stock market indicators?

Don Sinclair 21 Reputation points
2021-04-16T01:11:02.837+00:00

I am trying to figure out whether to use Azure or AWS. I currently pull daily stock price data and perform analysis of technical indicators and candles using a Python module and a .NET library in Visual Studio and I store the results in SQL server. I ultimately want to build an OLAP multi-dimensional analysis solution, but before I get to that, I would like to sell the calculated indicators and candlesticks and Fibonacci ratios for about 15 stock exchanges to subscribers who can pull the raw data, via API-call or other method each day. Ideally, they would have their own API-key or some other identifier which they would append to an API call via URL to pull the data in JSON or CSV format. They would be billed based on the amount of data they pull, or they would pay a flat rate and be limited to a certain amount of API calls.
Which Azure products could I use to facilitate this? I will probably ask this same question in an AWS forum.
Thanks

Azure SQL Database
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,006 questions
No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,796 Reputation points
    2021-04-16T07:57:59.733+00:00

    Multi-dimensional OLAP is not supported in Azure. You could only use it in a VM.

    I think your need could be quite satisfied by Power BI Service, along with Power BI reporting service.

    Take a look into their ability you may find what you need.


0 additional answers

Sort by: Most helpful