En cours

Data cleansing/Automation and upload to DB

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.

Compétences : MySQL, Programmation de bases de données, Architecture Logicielle, Data Cleansing, Data Governance, Relational Databases

en voir plus : problems data cleansing excel, upload page php update, mro data cleansing, data cleansing bangalore, data cleansing companys bangalore, receive data file nightly upload database, data entry automation powerbuilder, fake data cleansing, australian data cleansing standardization, data cleansing jobs saint vincent and the grenadines, online data cleansing jobs saint vincent and the grenadines, data cleansing work saint vincent and the grenadines, freelance data cleansing jobs saint vincent and the grenadines, data cleansing jobs south georgia and the south sandwich islands, online data cleansing jobs south georgia and the south sandwich islands, data cleansing work south georgia and the south sandwich islands, freelance data cleansing jobs south georgia and the south sandwich islands, in r what is the result for 0 0 data cleansing

Concernant l'employeur :
( 0 commentaires ) Seattle, United States

Nº du projet : #22402962

Décerné à:

marioada

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 18 jours
(11 Commentaires)
6.0

35 freelance font une offre moyenne de $532 pour ce travail

leadconcept

Hi there, As per my understanding you want to format data from excel and then need to import data within database and that database should be connected with PowerBI. Questions: - Can you please provide example excel Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(58 Commentaires)
8.6
OutsourceMan

Hello, Thank you so much for positing for your requirements. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. Surely, We are ready to help you with Data Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(170 Commentaires)
7.6
shikhamehta

Hey, Can you share the spreadsheet with some sample data please? That will help me in recommending the appropriate database structure. Once we have agreed that the suggested structure caters to your needs, I would be Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(232 Commentaires)
7.0
AwaisChaudhry

Hi,. I have gone through the brief details mentioned on the job. I have done multiple jobs with Database Programming, Google Analytics, MySQL, PHP, Software Architecture which are the skills required to get this job do Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 8 jours
(49 Commentaires)
7.3
A2Design

Hello! We are A2 Design, a Russian-Canadian web development company. Having the required skills, we will be glad to help you with your project. We have some questions for you to clear up before we start. Please m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(34 Commentaires)
7.3
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 15 years of experience in software development and am a Microsoft certified professional. I have strong work experience in Nopcom Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(51 Commentaires)
7.0
wonwon424

Hi, employer. I've read your proposals carefully. I am a web full stack developer. I am strong in web development and database programming Live websites [login to view URL] [login to view URL] htt Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(41 Commentaires)
6.4
zekovicm

Hi there,I can clean the data ,Import to Database and connect to PowerBI. Please contact me to discuss further details . Best regards Miljan

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)
6.2
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 18 jours
(53 Commentaires)
6.3
bindmission

Hello Hope you are doing well. I have 7 years of experience in AWS and MySQL DB management. I can handle this project. Regards VishnuLal*

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(98 Commentaires)
5.8
adeelpirzada

Hi it feels good to talk to you, i have done scrapping almost on Half of Worldwide web including eCommerce giants (Amazon, eBay, craigslist) News Feed, Social media websites, API's. I develop my own scrapers an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(23 Commentaires)
5.8
python55

Hi there, If selected, I will write my own app for taking data from excel, cleaning it and saving in mysql. The app will be written in Visual Studio based on your requirements. I can develop a cleaning engine that app Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 21 jours
(6 Commentaires)
4.4
coronajames

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(10 Commentaires)
4.1
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 16 jours
(8 Commentaires)
4.0
sc33313n

Greeting I just came across your job request and noticed that what you are looking for is something I specialize in. I am good in AWS , along with other all system. Also, I have good feeling you can help with fix amd Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
3.6
jiteshparwal93

Hello, I am a full stack BI developer having 5+ years experience and can deliver you this solution within deadline. I will suggest to go with Google cloud over AWS due to costing. Also, we can transform whole data eit Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 20 jours
(1 Évaluation)
3.1
hassanafzal6

Hello. I am a Data Scientist with complete knowledge of mysql. I can do your task very quickly. Hit me up.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
3.1
shoguna2m

Hi there, My name is Mauricio I'm the data analyst expert from Trascender Global Team, with 4 years of experience in data handling with MySQL and data visualization with PBI. I've read the details of your project an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(4 Commentaires)
4.3
jarrodm

Hello, I have worked extensively with MySQL over the past 10 years, and Aurora over the last 4, so I'm very familiar with your requirements. In fact Aurora has a CSV file import option, which makes excel conversion e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 14 jours
(1 Évaluation)
2.6
onmkang

Hello, I am the expert of having 10+ years of experience with Mysql, MSSQL, and other Relational Database. I am available to create DB from excel file. I am familiar with database join, select, relationship, and other Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
2.6