Closed

Retail Report Celex

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.

Skills: SQL, R Programming Language, Power BI, Data Analysis, Data Visualization, Excel, Python

About the Client:
( 0 reviews ) Mexico

Project ID: #34394697

32 freelancers are bidding on average $3871 for this job

(1139 Reviews)
8.4
(601 Reviews)
8.5
(308 Reviews)
8.2
(201 Reviews)
8.0
(55 Reviews)
7.0
(43 Reviews)
7.0
(43 Reviews)
7.2
(12 Reviews)
7.0
(30 Reviews)
6.0
(22 Reviews)
5.8
(6 Reviews)
5.8
(77 Reviews)
5.7
(8 Reviews)
5.5
(41 Reviews)
5.4
(18 Reviews)
5.5
(30 Reviews)
5.5
(28 Reviews)
5.2
(4 Reviews)
4.7
(11 Reviews)
4.8
(22 Reviews)
4.6