We have a retail business, we sell Mobile accessories in different stores
I need to download an SQL Database (10 related tables) daily, from a Server exposed to internet. Then process the data with R or maybe DAX, make some calculation and present the data in a specific format in Excel and PowerBi daily.
I will give the type of report I want in Power BI. It would be good to be able to send the excel report on daily basis automatically.
The max deadline for this project is1 month (we think it can be done in 10 days by someone really good). In the future we also can discuss some maintenance of the project results
We're open to suggestions on how to improve the logic. Would prefer someone in the same time zone , but not necessarily
I can provide a sample of data base SQL. Please check the Excel uploaded.