Data cleansing/Automation and upload to DB

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. Once that’s done, we’ll be able to generate a full Sql file and all we’ll have to do is import that into a MySql database and all our data will load perfectly. I’ve worked on many similar projects before and I’d love to work on this one too, lets discuss this further. Looking forward to hearing from you, Mario Ada

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 file from where you want to import data? - Can you please explain how you want to upload data within database? If that data will be added manually or you want to create any dashboard like admin panel to import excel files as well as to add data by using forms? - Can you please explain if you also need to display that imported data? If yes then please provide complete features list and more detailed requirements. ++++++++++++ You may ignore the bid & once you answer above questions, I can then estimate it precisely. Look forward to hearing from you. Thank you, LEADconcept

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 done. Lets start the chat so we can discuss this job more in detail then we will discuss the final budget, Right now I am placing default bid. We will discuss the final budget after detailed discussion and going through detailed requirements. Thanks.

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 able to implement it in MySQL on AWS as required and also create the methods to allow for easy upload the data in future. I would also be able to connect your PowerBI instance to that database as required. Please send a message to me over the chat window and we may get going right away. Look forward to hear from you. Best Regards, Rishi Mehta (Automyze Consulting)

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. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

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*

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

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 and I'm highly interested in working with you to clean and format your current data into a standard format, using an Excel sheet database, and then I will create a MySQL database with this data set with the proper architecture and table relationships/joins, taking into consideration different methods to be able to update data once in the database, and finally connect this MySQL database to PowerBI, creating an dashboard if it's required. Let's chat so we can talk about the details of this project. Looking forward to hearing from you.

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 applies rules in sequential order (if you need to update the rules). If the rules will not change I can insert them directly in the app code. Regards, Ionut Rosca

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 project on time and you will experience great satisfaction with me. I have rich experienced in Database Programming, Google Analytics, MySQL, PHP, Software Architecture. For more information about me, please refer to my portfolios. I'm ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks

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 schema (creating tables, constraints) - Writing simple and complex SQL queries including subqueries. I have the following experience: I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, SQL, stored procedures for the following projects: -Oracle Financials (Oracle EBS) Project -Oracle Transportation Management (OTM) Project -Siber Logistics Software Project(MSSQL) -Cognos BI Project(PostgreSQL) -I wrote stored procedures to send automatic invoices, arrival notices, cargo specs and reconciliation letters to customers. I am sure that I am a good fit for your project. Hope to hear from you soon. Best Regards Huseyin Aygun

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

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 either in MySql or when loading data through Excel to MySql. There are certain clarifications needed as below: 1. Where will be Excel file placed like on an OnPremise Server or Some Storage Account. 2. Will format be fixed or it will change over time period. Mesage me to discuss so that I can start working on this immediately. Thanks, Jitesh Parwal

Hi. I am a freelancer working in 24/7 service. I have much experience for 6+ years in Python. I think this project is for me and I can finish it for a short time with a quality result. you can also see my profile reviews as my only goal is the client satisfaction, Please son't hesitate to contact me about any question, Kindly initiate chat and let's have a talk. we can start immediately Best Regards.

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 easier. Update process will depend heavily on the size of the database and type of changes (new rows only or updates to existing), but having done complex operations of this sort, I am confident to be able to solve it. I am also an experienced systems engineer over 15 years with a heavy focus on cloud infrastructure and data engineering now. I use any tool that is right for the job. Message me when you are free to discuss details of this project, i am available any time. Thanks.

Hi, I am able to complete your work within specified time and budget parameters. Please feel free to contact me with further details. Best Regards, Tinashe

Respected sir, I have read your post. Based on experience I am confident that I would be able to do your project I have 6+ years experience in web development. I have 4 years experience in WordPress, i have working experience in excel, MySql. Can i get some row data to test for db artitecture. Waiting for your reply. Thank you

Hi, I am confident to take up this task. If your are interested in me, can we have connect once and we will go through the requirements and discuss in detail. Thanks.

Hello! I'm Slavik Balydin. I've just checked the project details and it seems very interesting. Creating and normalizing databases is an interesting process by itself. Under "normalizing" i mean finding table relationships/joins. Note, i'm rather a fresher in this subject, so You can accept another freelancer if you doubt in my experience, or accept me and wait for 14 days or less when all will be done. But it's likely it would be done within less period of time. To answer certainly i need to have a look at the data sheets. A bit about me. I'm an experienced graphic/web designer and full-stack developer/software engineer, so please check out my profile page and reviews here: https://www.freelancer.com/u/imdespro There are some reasons to hire me such as: 1) Lower cost in my region 2) High quality of work 3) Project delivery on time 4) Refunding if something goes wrong 5) Good reviews about me from my previous clients My goal is to bring your project into life. So, please, feel free to contact me for more discussing. Trust me, it's going to be interesting. My regards, Slavik

Having 4 years of experience as Oracle DBA (with RAC) in a team environment. Provided 24x7 supports for critical databases (10g, 11g) in heterogeneous platforms Good knowledge on Oracle Architecture and maintenance of single instance NOIDA Monitoring the table spaces usage, increasing the size of table spaces by adding data files to the table spaces Creating Users and Providing Quotas, Roles, Privileges and Profiles to users. Resolving listener and network issues Taking the schema level backups based on user requirements and schema refreshes from prod to non- prod databases Data transferring with export/import utilities and Data pump Having good working knowledge on Cloning Database. Good knowledge in the area of database backups and recovery strategies, scheduling backup scripts and procedures with RMAN Monitoring alert log, listener log and share with the Application team Working knowledge on ASM databases (checking free space on disk groups, communication of database instances with disk groups etc.) Working knowledge on Data guard issues and also knowledge on configurations Rebuilding the indexes and gathering the statistics for better performance Experience on installing RAC(10g, 11g) andknowledge on RAC architecture Converting a non RAC database to 10g RAC database using rconfig tool Backup & Restore Cluster ware file (OCR & Voting) in RAC. Managing RAC instances using SRVCTL. Troubleshooting day to day issues in RAC environment

Project Worked: Financial - ( Stock Market ) – Wealth Management -- Caliber systems provide user-wise dashboards for a wide-ranging asset coverage. This includes solutions for Equity, Derivatives, Commodities, Currencies, Mutual Fund, Debt PMS, VCF, Real Estate, Insurance, Loans and others. Health insurance -- Vidal health insurance and TPA (Domestic) Automobiles Dealership -- Mahindra and Mahindra ltd I have Worked on Different Projects -Finance / Automobiles Dealership Etc, on full time bases , Basic skill is Oracle PL/Sql Database Dvelopment and MySql Contact me for further details Contact me : melviholy gmail com