Database + Webapp development
The project implies development of PostgreSQL database and the Back-end part in Python. Important task is handling of MS Excel data and integration of it into SQL database.
The base of the Application will be a SQL database containing all the above mentioned data. The web front-end will allow following functions:
- data upload – the source data (such as new units, load scenarios etc.) will be uploaded to the Application from their respective sources,
- data consolidation and aggregation – the uploaded data will be checked, consolidated and aggregated by using pre-defined rules
- data download – upon request, a specified subset of the data will be downloaded by users to get the source data for their simulations,
- format conversions – the uploaded or downloaded data will be converted between the user-convenient format (usually Excel XLSX format, XML or CSV formats etc.) and structured format of the SQL data
- status indication – database contents reports, number of input/output tasks, errors, logs.
-
88 1 0 1 Hello, i'm from lviv. I study at Lviv Franko University. I can create this web-application for you. I prefer use Django2 for creation. I have some question: do you have template for yout site or i must create this?
-
Если мы можем начать работать удаленно (а там посмотрим), то можем пообщаться.
-
Current freelance projects in the category Databases & SQL
Потрібен Power BI спеціаліст для побудови управлінської звітності на базі BAS Бухгалтерія КОРППро компаніюМи є дистриб’ютором міжнародних спортивних брендів в Україні. Облік ведеться в BAS Бухгалтерія КОРП.Шукаємо спеціаліста, який допоможе побудувати систему управлінської звітності для керівництва компанії на базі Power BI.Важливо: нас цікавить не просто візуалізація… Databases & SQL, Accounting Services ∙ 1 minute back |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 1 hour 53 minutes back ∙ 17 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 2 hours 59 minutes back ∙ 11 proposals |
1C database for the enterpriseA database is needed for managing the auto dismantling inventory, controlling finances, and generating orders. It is necessary to add a car as an object and attach parts to it. I will explain the full structure of how it should look and work during the conversation. Databases & SQL ∙ 12 hours 33 minutes back ∙ 6 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 1 day 18 hours back ∙ 9 proposals |