The project outline includes a few major steps.
1) Clean and format data into standard format (from Excel sheet)
2) Upload data to a MySQL database, AWS Aurora is preferred but not required
This requires the creation of the MySQL database including architecture of the database & table relationships/joins and upload methods
Please also think through methods for being able to update data once in the database
3) Connect MySQL database to PowerBI (show basic connectivity)
Deadline: 3 weeks
There will be more work to follow this after successfully completing these steps.
Hello there, We can use Python with the Pandas library to read those excel files and turn them into Insert Sql Queries. We’ll be doing that right after we create the DB structure so we’ll know where to insert the data Daha Fazla
Bu iş için 35 freelancer ortalamada $532 teklif veriyor
Hi , I've carefully checked your decription(Data cleansing/Automation and upload to DB) and really interested in this job. I'm full stack developer working at large-scale projects as a developer . I can complete your p Daha Fazla