Create a database for analysis
269 USD
attentive specialist. patience and quality recommendations are the main traits of a specialist. Thank you for your work!
36
0
Budget: 12000 UAH Deadline: 7 days
Good day.
I can help with this task. To be honest, I wouldn't consolidate everything into one "big Excel" file, because with 20+ files of 200+ thousand rows each, it starts to feel more like a punishment than a tool for analysis.
I would suggest a slightly more proper solution:
- consolidation of all Excel files into a single structure
- loading data into a database
- building pivot tables / selections based on the required parameters
- the ability to add new files without involving a developer
- preparing a foundation for further analysis, filtering, BI, or modeling
What I can propose for implementation:
- PostgreSQL as the main database
- import from Excel through a separate understandable script or simple interface
- normalization and cleaning of data during loading
- formation of pivot tables / views for analysis
- instructions so you can update the data yourself later
In the end, you will receive not just "one file," but a working tool that does not break under the volume of data and allows you to work calmly with analytics.
If needed, I can also help separately:
- think through the database structure
- create automatic updates
- connect Power BI / Excel / Python analytics on top of this database
For an accurate estimate of timelines and costs, it would be good to look at 1-2 sample files and understand:
- whether they have the same structure
- which fields are important for analysis
- which pivot tables / selections are needed as output
100
0
Budget: 10000 UAH Deadline: 1 day
Good day
20+ files have the same column structure?
I can offer you to do everything based on a database + Django admin panel.
I completed a similar project a couple of days ago. It required processing and calculating data on 2,500,000 records. I will quickly adapt it to your files.
Feel free to reach out.
117
0
Budget: 5000 UAH Deadline: 2 days
Hello.
I have experience with PostgreSQL. I can load your data into the database. Write to me, we will discuss.
1 298
1
Budget: 5000 UAH Deadline: 2 days
Hello. I have extensive experience with Python. I am ready to collaborate. Please contact me.
42
0
Budget: 3000 UAH Deadline: 2 days
Good day. I have been working with databases for over 10 years, I guarantee the efficiency and quality of building a structured database (for example, in Access).
17
1
Budget: 6000 UAH Deadline: 7 days
Good day. I specialize in CRM, dashboards, databases, and web services for processing, accounting, and analytics. Convenient and modern design. Development is fully turnkey.
Integration with artificial intelligence and other automations can be implemented. CRM is my main focus, so I can offer many interesting options.
Feel free to reach out.
200
2
Budget: 4000 UAH Deadline: 3 days
There is experience in creating scalable solutions for working with large volumes of data (over 4 million rows), using MySQL/PostgreSQL and effective aggregation. A process can be prepared to consolidate these Excel files into a single database with a convenient structure for quick construction of pivot tables or custom filtering.
I propose to create a database on PostgreSQL with carefully thought-out indexes and schema, as well as to develop an interface (possibly on Laravel/Vue) that will allow easy updating/adding of new files through a web form without involving a developer. If necessary, the import can be automated through scripts or even set up an ETL process.
I am ready to discuss the details of parameters and data formats to choose the most optimal solution for your needs.
Budget: 4800 UAH Deadline: 2 days
Hello!
I have experience in processing large datasets and I am ready to create a system for you based on SQL and Python. I will set up automatic loading of new files so that you can update the database yourself with one click without my assistance. In the end, you will receive a fast tool for analysis and instructions for it.
Please let me know if all 20+ files have the same column structure or if they differ depending on the period? Thank you!
5
0
Budget: 5000 UAH Deadline: 4 days
Hello!
I have experience in building similar pipelines and analytical dashboards. I can propose an optimal architecture where new files are added without the involvement of a developer, as you want, and the data is automatically consolidated and updates the dashboards. I will immediately lay the groundwork for scalability for further modeling.
Feel free to reach out!
2
0
Budget: 4000 UAH Deadline: 6 days
Hello
I have completed a similar task, 2 daily reports with over 200,000 rows, imported into a database (a convenient uploader, just upload the file from the PC and that's it, without complicated actions), the backend combines these 2 reports. We display all of this in the Metabase dashboard for analysis.
What I propose
Data consolidation
Combining all Excel files into a single structure (essentially — a centralized database, not a "heavy" Excel).
Cleaning and unifying fields: date formats, column names, data types, duplicates, gaps.
Building a database for analysis
Creating an analytical model (tables + relationships) for quick slices and filtering by parameters.
Preparing "pivot" tables/views for modeling and further analysis.
Analytics in Metabase
Connecting Metabase to the database.
Setting up ready-made dashboards, filters, segments, drill-down analysis.
Query templates for data selection "in 2 clicks."
Updates without a developer
A simple process for adding new files (through a folder/import) is set up.
Automatic or semi-automatic data updates according to instructions for your team.
Documentation + brief user training.
Result for you
A single source of truthful data instead of dozens of Excels.
Quick analytics of large volumes without "file crashes."
A ready tool for modeling, reporting, and decision-making.
27
0
Budget: 4000 UAH Deadline: 1 day
Hello, Denis.
I have done similar projects - I know the nuances and will do exactly what is described. There are a few clarifications before starting.
Final price/timeframe after all clarifications.
6
1
Budget: 4000 UAH Deadline: 3 days
Good day
I can implement a similar solution. Let's discuss the details such as the data format, what analyses are needed, and who will be using the system.
5
0
Budget: 14000 UAH Deadline: 14 days
Hello!
For 10 years, I have specialized in complex projects that require high qualifications.
I have extensive experience with similar projects.
I can professionally create a database for analysis.
The exact price will be determined after clarifying the technical specifications.
Work plan:
Analysis of the structure of incoming files and identification of key parameters for analysis
Selection of a technological solution that supports data updates without involving a developer
Consolidation of all tables into a single structured array
Cleaning, integrity checking, and unification of record formats
Deployment of the database or analytical environment
Creation of pivot tables and tools for filtering and modeling
Setting up a simple mechanism for self-uploading new data
Testing processing speed and accuracy of results
Preparation of instructions and final handover of the solution
1
0
Budget: 5000 UAH Deadline: 2 days
Hello! I am ready to develop such a system. I have experience working with various databases. I offer quality and fast work without loss of quality. Write to me)
21
0
Budget: 2497 UAH Deadline: 3 days
11:54 AM
Good day. I am free now, I can start immediately.
20 files × 200k+ rows. I suggest transferring the data to PostgreSQL and creating a simple web interface: uploading new files with a button, filters, and pivot tables — to work with the data without a developer. If needed — backups and replication.
Clarification: is the structure of all files the same? Which analysis parameters are the most important?
Budget: 5000 UAH Deadline: 2 days
Good day.
My name is Oleksiy.
I am a Full-Stack developer, specializing in the development of websites, bots, scripts, and automation systems.
I am ready to offer a stable and professional solution and implement it in a short time.
I would be happy to discuss all the details in private messages, including price and deadlines, and start working.
3
0
Budget: 2500 UAH Deadline: 5 days
Hello! I have extensive experience working with large datasets (Big Data) in Python.
Your volume (4 million+ rows) is too heavy for regular Excel, so I propose an automated solution based on Python + PostgreSQL:
1. A script will automatically gather all your Excel files into a single fast database.
2. You will be able to add new files to the folder and update the database with the press of a button, no developer needed for this.
3. I will set up a convenient tool for querying and pivot tables (Power BI or a simple web interface in Python), where the data will fly.
I am ready to discuss the structure of your tables and suggest the optimal architecture option!
8
0
Budget: 3000 UAH Deadline: 30 days
I can create a database, or rather process files using Borland Delphi. It will be a practical and convenient program for viewing and analyzing file searches. The program will only be in gray color, as the focus is on practicality and performance rather than design.
4
0
Budget: 16000 UAH Deadline: 5 days
Good day
My name is Dmytro, I represent the company King Kong Lab
I can build a convenient database and a tool for analyzing large Excel files without "crashes" and manual work
What I will do
I will combine all files (20+ with 200k rows each) into a single structure
I will clean and normalize the data
I will build a database (PostgreSQL / BigQuery or another optimal option)
I will create a convenient tool for analysis (dashboards / filters / pivot tables)
Most importantly
I will set up simple data updates
so you can add new files yourself (via Excel / Google Sheets / import) without involving a developer
I can also
set up automatic updates
add quick filters and selections for your tasks
prepare data for further modeling
Timeline
3–7 days
I am ready to look at sample files and suggest an optimal solution
I would be happy to collaborate
Budget: 1000 UAH Deadline: 1 day
Good day. I can implement a solution for you to consolidate 20+ Excel files with over 200,000 rows, build a single database, and create an analytical tool for selection, modeling, and working with pivot tables. For such a volume of data, I would recommend not just one large Excel file, but a more stable solution based on a database + a user-friendly interface for updating and analysis, so that the system works quickly and without Excel limitations.
35
3
Budget: 15000 UAH Deadline: 30 days
Good day. With such a volume of data, it is definitely necessary to use an industrial database. I would choose MSSQL. The database should process data in seconds. Excel will not handle it. Moreover, MSSQL already has an MS SQL Report Server. Reports can already be built. It is also necessary to implement automatic (semi-automatic) data loading. I can create such a utility; the programming language does not matter (1C, Delphi, C#...). At the same time, PowerBI can be used. However, it is slower than MS SQL Report Server. Everything depends on the requirements. Just digital reports, or visualization in the form of graphs.
11
0
Budget: 2000 UAH Deadline: 1 day
Good day!
I am developing in Python.
I have been designing databases since 2017.
I have designed a large number of databases for large corporations in various teams' SCADAs.
Let's discuss your project, I am confident that I can help you with automation for your business.
44
0
Budget: 5000 UAH Deadline: 5 days
Good day, from your files it is possible to create a single database and a website for adding new types of data. The database and website can be hosted on paid services - Supabase and Vercel. This will be a plus as it will be accessible from any device and location.
41
4
Budget: 1000 UAH Deadline: 3 days
Good day!
I have experience in creating databases and working with large volumes of data. I am ready to consolidate your Excel files, develop an effective solution for analysis (including pivot tables or another system), and ensure the ability to easily update data without involving a developer.
Write to me, and we will discuss the details.
Budget: 700 UAH Deadline: 1 day
I will gladly complete the project! I have experience in creating databases, specifically Excel!
11
0
Budget: 15000 UAH Deadline: 10 days
Hello! We have experience in consolidating large arrays of Excel data and building analytical databases. We implement this through automated loading, cleaning, normalization, and structuring of 20+ files into a single analytical model. We will provide access to the database with support for further modeling.
The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules
