Lukket

Cleanse excel data to be useable in a data base format

I have c120 excel financial data books for airlines around the globe. Each template is set up the same and I am looking to move them into a more database friendly (rows and columns) format so that it can be easily ingested by PowerBI. It wold be a one off project that would cleanse all the existing data and would allow users to update the data manually in the same cleansed format going forward. I have attached 1 example of the financial data book. All are the same although there may be one or two that are very slightly different. The excel includes several rows and complete tabs that are calculation based. The data in these cells is not needed as the calculations will be cover by DAX formula. Only the input data, like yellow cells is what is required.

Evner: Excel, Visual Basic, Dataindførsel, Databehandling, Power BI

Se mere: sample supplier data base format excel format, excel vba format data series, excel macro paste clipboard data format, excel code vbs vba data base, write macro format data excel, excel product price list data base, excel google base data, excel macro cell format data, format data output excel, upload data feed excel amazon base, card format data excel, format data entry excel spreadsheet, excel format data cleaning, excel format data, format data series pane excel

Om arbejdsgiveren:
( 0 bedømmelser ) Dublin, Ireland

Projekt ID: #32229453

19 freelancere byder i gennemsnit €937 timen for dette job

P0L

(491 bedømmelser)
8.0
(130 bedømmelser)
7.3
(322 bedømmelser)
7.4
(38 bedømmelser)
7.0
(68 bedømmelser)
6.9
(227 bedømmelser)
7.0
(28 bedømmelser)
6.4
(166 bedømmelser)
6.3
(29 bedømmelser)
5.9
(133 bedømmelser)
6.1
(26 bedømmelser)
5.0
(24 bedømmelser)
5.1
(34 bedømmelser)
4.7
(11 bedømmelser)
4.4
(16 bedømmelser)
3.9
(4 bedømmelser)
3.5
(3 bedømmelser)
3.3
(1 bedømmelse)
1.6
(0 bedømmelser)
0.0