Automate Excel Data Flow to Power BI
Budget: £250 – £750 GBP
I'm seeking a skilled professional who can streamline my data processing. The project involves extracting financial data from Excel files downloaded from monday.com, and populating a Power BI report that consists of multiple tabs - the initial PowerBI reports already exist but need to be improved upon.
Key Requirements:
- The specific data points to be extracted are related to financial reporting, including timesheets, sales data, and income statements.
- The automation needs to be end-to-end and trigger whenever new files are downloaded into a designated folder.
- The final report should be able to refresh automatically.
Ideal Skills:
- Proficiency in Power BI and Excel is crucial.
- Experience with automating data extraction and report generation.
- Understanding of financial metrics and reporting.
Please note that the reports generated will also include balance sheets and cash flow statements. I'm looking for someone with the expertise to handle this task efficiently and accurately.
Key Requirements:
- The specific data points to be extracted are related to financial reporting, including timesheets, sales data, and income statements.
- The automation needs to be end-to-end and trigger whenever new files are downloaded into a designated folder.
- The final report should be able to refresh automatically.
Ideal Skills:
- Proficiency in Power BI and Excel is crucial.
- Experience with automating data extraction and report generation.
- Understanding of financial metrics and reporting.
Please note that the reports generated will also include balance sheets and cash flow statements. I'm looking for someone with the expertise to handle this task efficiently and accurately.