has 800 million rows and several full text indexes. We need to add more indexes, partitions and such efficiently so that we can get the results we need instantly. Currently the queries can take up to 10 minutes. People might be typing in different queries too and I need someone to monitor and optimize them If you are good for this job, explain to me how you... has 800 million rows and several full text indexes. We need to add more indexes, partitions and such efficiently so that we can get the results we need instantly. Currently the queries can take up to 10 minutes. People might be typing in different queries too and I need someone to monitor and optimize them If you are good for this job, explain to me how you to optimize and log the database so
I am looking for a freelance developer to create a web-based app that connects to an access database. The app should have CRUD options and the ability to create CSV files based on filters set within the app. Platform: WordPress - The web-based app should be developed on the WordPress platform. CRUD Operations: No, standard CRUD operations will suffice - The app should have basic create, read, update, and delete functionalities. User Interaction: Moderate, with some user input - The app should allow users to input data and interact with the app to some extent. Ideal Skills and Experience: - Experience in developing web-based apps on the WordPress platform - Proficiency in working with databases, specifically Access databases - Knowledge of CRUD operations and the ability to imple...
I am in need of an administrative assistant to assist with various tasks. The ideal candidate should be familiar with FINRA registration and possess general computer skills. Specific tasks include: - FINRA registration: The assistant should be knowledgeable and experienced in registering individuals with FINRA. The assistant should have general compute...The ideal candidate should be familiar with FINRA registration and possess general computer skills. Specific tasks include: - FINRA registration: The assistant should be knowledgeable and experienced in registering individuals with FINRA. The assistant should have general computer skills and be comfortable with using various software and online platforms. The number of email addresses and database registrations required is be...
...Flight and Hotel Searches: Affiliate API Integration: Research and select an affiliate program that offers APIs for flight and hotel searches (like Skyscanner, , Expedia, etc.). Obtain API Credentials: Sign up for the affiliate program, obtain API keys or credentials required to access their services. Implement API Calls: Develop a dedicated page where users can search for flights and hotels. Integrate the affiliate API into this page to perform real-time searches based on user input. Display Search Results: Retrieve and display search results (flight options, hotel listings) from the API in a user-friendly format on your website. WhiteLabel Integration: Optionally, if available through the affiliate program, consider implementing a WhiteLabel solution that allows you to cus...
I am looking for a skilled freelancer to create a property management database/software for me. We have a download of the program that we would like duplicated similar to. Contact us for details - should be able to mirror the program we currently have. The project requires the following functionalities: - Rent tracking: The software should be able to track rent payments and send payment reminders to an Unlimited Number of Properties Track Buildings & Units Track Residential, Commercial and Industrial Properties Track Tenant Rent Rolls,Tenant Charges Track Contacts, Vendors & Contractors Track Phone Messages Track To Do's Track Family Members and Roommates Track unlimited Parking Spaces Track Property Loans Maintain Contacts and Addresses Track unpaid Ten...
Database for Processing Transactions Skills and Experience: - Experience in designing and implementing transaction processing databases - Familiarity with various database types and their advantages/disadvantages - Strong knowledge of relational databases and NoSQL databases - Ability to advise on the best database type based on project requirements Project Details: - I am in need of a database for my business that will primarily be used for processing transactions. - As I am not sure about the type of database that would be most suitable for my needs, I am seeking advice from an expert in this field. - The database should be able to handle a large amount of data, as the estimated amount of data to be processed is more than 1TB. - The ideal candi...
...freelancer to help me create a database in either Excel or Access that will allow me to efficiently manage and analyze the real estate listings I receive on a daily basis. The goal is to easily identify investment opportunities based on specific criteria. Key Requirements: - Expertise in creating databases using Excel or Access - Ability to create a user-friendly interface for inputting and managing listings - Experience in data analysis and filtering to identify relevant information - Proficiency in organizing and structuring data for efficient retrieval Specific Features: 1. Database Input: - Develop a system that allows for easy input of real estate listings received in digital format - Implement an automated process to import the listings into the database on ...
I have a Microsoft Access Database (.mdb) on my laptop that contains a table called InstallerReqDocumentsTbl that has 3 fields, namely InstallerRequiredDocID, InstallerRequiredDocName and InstallerRequiredDocExpiryDate. The InstallerRequiredDocID field type is AutoNumber, the InstallerRequiredDocName field type is Short Text, and the InstallerRequiredDocExpiryDate field type is Date/Time. Without any intervention, or any inputs from the database user the database must automatically send an email from my IMAP/SMTP email account to another email account 120 days and 90 days and 60 days and again 30 days before the expiry date contained in the InstallerRequiredDocExpiryDate field. The email Subject Heading must contain the value entered in the InstallerRequiredDocName fie...
I'm in need of a skilled architect or designer capable of creating a multiplex design. While I haven't yet decided on the specific types of properties for the multiplex, I'm inclined towards a mix of different properties and so flexible expertise is preferred, with potential elements including apartments, condos and retail spaces. Key Points: • Prior experience is highly valuable - Please include any relevant experiences in your application, specifically in relation to multiplex property design. • Strong architectural drawing capabilities - Your skills and proficiency in architectural drawing will play a pivotal role in this project's success. Hence, I'm particularly seeking freelancers with a proven track record in this area. the land size is...
To make a Crawler to retrieve data from various websites. The application is to take crawl addresses from a .csv file retrieve the designated data and save to a database. Requirements: - Application running on a server (AWS, OVH, Digitalocean etc...). - Ability to configure and add more pages - Saving the results to the database (updating the records when downloading again) - Proxy and other methods of detection mechanisms - Statistics and logs - Possibility of downloading data as logged-in users, storing cookies - Ability to set a schedule for starting downloads Example of operation: - I add or change a list of URLs in a .csv file - I enter the items to be downloaded in the application - I set the download schedule - The application starts according to the schedule ( hou...
Title: Android Application Development using KOTLIN classes, XML layout, and database I am looking for an experienced Android developer to develop an application using a set of KOTLIN classes, XML layout, and a database. The application should be developed specifically for the Android platform. Functionalities: - User Authentication: The application should have a user authentication feature to ensure secure access. - Data Management: The application should be able to manage and store data efficiently. - API Integration: The application should be able to integrate with external APIs to fetch and display relevant data. Screens/Pages: - The number of screens/pages for the application is not specified. Ideal Skills and Experience: - Strong knowledge and experience in Andro...
...focus will be on creating a photorealistic rendering with lighting effects. Renderings of each room, and outside in the wood terrace looking into the front of apartment. I will prefer proposals with a combination of good price and mid-level rendering quality. This is a test I will show to a friend to see if he likes this, and he would be ordering a lot more renderings since he works renovating apartments for rent. PREFERENCE WILL BE GIVEN TO THOSE THAT CAN FINISH THE WORK TODAY. PLEASE PROVIDE PRICE OFFER. Skills and Experience: - Proficiency in Sketchup and rendering software - Experience in creating photorealistic renderings with lighting effects The ideal candidate will be able to bring the apartment design to life, paying attention to detail and creating a realistic and im...
I need to create a schema to manage data about shipments and packages. See details in the following file. Skills and Experience: - Strong experience in building database schemas using MySQL - Familiarity with database design principles and best practices - Ability to suggest and implement a suitable structure for the database schema based on the client's requirements - Proficiency in writing efficient and optimized SQL queries - Attention to detail to ensure data integrity and security measures are implemented - Excellent communication skills to understand and clarify the client's needs and provide regular updates on the progress of the project.
I'm in need of an analytic mind to create a comprehensive list of European secondhand marketplaces, predominantly in Germany, France, the United Kingdom, Italy, Holland, Sweden, Denmark, Finland, and Spain. The focus of this project will not only be to create the list but also to provide a detailed traffic analysis for each marketplace. Who should bid: - Freelancers who can provide a detailed project proposal outlining their approach to the task. - Those with a background in market research and data analytics skills. Key Outputs required: - A detailed namelist of secondhand marketplaces across the mentioned locations. - Thorough traffic analysis of each marketplace. - Presented in a manner that is easily understandable. The output from this research will play a crucial pa...
...essential for successful collaboration. Inclusion of an image and video in the advertisement is mandatory. Additionally, all fields must be filled. Each marketer must enter advertisements related to their own country. Marketing experience and the presence of a marketing team are preferred. It is also emphasized that advertisements should exclusively focus on the tour and travel industry, including hotels, restaurants, entertainment centers, travel agencies, tour leaders, and similar domains. If you and your team possess the necessary skills and are interested in this opportunity, please submit your proposal detailing your relevant experience and approach to handling this task. Thank you for considering this opportunity. We are enthusiastic about the prospect of working with talen...
I am looking for a skilled translator who can help me with a diverse language translation project. The task requires translating from English to the following languages: Spanish (Spain) French German Portuguese (Portugal) Ukrainian Indonesian Italian Japanese Arabic (Standard) Korean Romanian Vietnamese Polish Thai Turkish Greek Russian Requirements: - Fluent in English and at least one of the target languages (Spanish, French, or German) - Strong command of grammar, spelling, and punctuation in both English and the target language - Experience in translating texts of 1000-5000 words - Ability to accurately convey the meaning and tone of the original text - Attention to detail and commitment to delivering high-quality translations within the specified timeframe If you are a profe...
...Flight and Hotel Searches: Affiliate API Integration: Research and select an affiliate program that offers APIs for flight and hotel searches (like Skyscanner, , Expedia, etc.). Obtain API Credentials: Sign up for the affiliate program, obtain API keys or credentials required to access their services. Implement API Calls: Develop a dedicated page where users can search for flights and hotels. Integrate the affiliate API into this page to perform real-time searches based on user input. Display Search Results: Retrieve and display search results (flight options, hotel listings) from the API in a user-friendly format on your website. WhiteLabel Integration: Optionally, if available through the affiliate program, consider implementing a WhiteLabel solution that allows you to cus...
I'm in urgent need of a specialist well-versed in Microsoft Access Database for process automation. Ideally, the focus is on: - Data Entry - Report Generation - Query Execution The database will predominantly deal with: - Numeric Data - Text Data - Date and Time Data - Medication Record Data Your expertise should encompass seamless data storage and retrieval, as well as reporting and analysis. With proficiency in Microsoft Access, you should be capable of automating these tasks to improve overall efficiency. Preferably, you'll have a background in handling similar projects in the health or medical field due to the inclusion of medication records.
I am seeking an interior designer for a boutique hotel project in Portugal. We are a start-up that develops boutique hotels and coliving projects in Portugal. The desired aesthetic for the hotel's interior design is bohemian and eclectic. Specific elements and features for the design are not set in stone, as I have some ideas but am open to suggestions. We don't usually work with custom made furniture so we need someone that works as interior designer and procurement of furniture. Ideal skills and experience for this job include: - Capacity to work with furniture shops to create unique designs but with standard furniture - Strong communication skills to understand and translate my ideas into the final design - Budget-consciousness to ensure the project stays within ...
I'm looking for a qualified web developer to create a user-friendly website for my real estate business. The site will exclusively showcase residential apartments. Key features should include: - An intuitive property search function with advanced filter options to assist potential buyers in easily finding apartments that match their preferences. - Seamless integration of virtual tours and 360-degree photos, giving an immersive inside view of the apartments to visitors. The ideal freelancer should have: - Proficiency in website design and development - Proven experience in creating real estate websites - A solid understanding of housing market trends and buyer needs in making a real-estate site successful - Experience integrating virtual tours and 360-degree pho...
...Encrypted Database on Azure SQL Managed Instance - I am looking for a skilled professional who can help me restore an encrypted database on Azure SQL Managed Instance. The database has been encrypted using TDE (Transparent Data Encryption). - The client is not sure if they have the necessary decryption keys for the database, so the ideal candidate should have experience in handling TDE encryption and should be able to assist in verifying the availability of decryption keys. - The restoration of the database is not urgent, so there is no immediate deadline. However, the candidate should be able to complete the task within a reasonable timeframe. - The ideal candidate should have experience working with Azure SQL Managed Instance and should be familiar ...
...responsible for the configuration and maintenance of the SQL Server Warehouse and performing data backups and supporting issues of multiple development teams. Must be capable of working independently and collaboratively. Responsibilities - Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. - Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. - Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations - Independently analyze, solve, and correct issues in real time, providing problem resolution end...
I'm seeking a seasoned Java backend developer to join my project. Your primary responsibilities will include: - Database Management: You should be proficient in database management, particularly MySQL. Experience in maintaining, troubleshooting, and optimizing databases is required. - API Integration: You'll be expected to handle API integrations smoothly, ensuring that the various elements of the project work seamlessly together. - Code Optimization: You should be capable of optimizing code to increase efficiency and performance. As for technical competencies, I'm specifically looking for someone well-versed in Spring Boot. This expertise will come in handy when developing applications. Prior experience with similar projects would be an added advantage.
...manage all appointments, ensuring no conflicts. 6. Financial Management: Handle banking operations and investments with precision, maintaining confidentiality. Key Responsibilities: 1. Efficient Time Management: Ensure optimal organization of the CEO's professional and personal schedules. 2. Seamless Travel Arrangements: Organize travel logistics, commuting arrangements, and reservations for hotels and restaurants. 3. Personal Life Coordination: Manage personal shopping, and errands, and coordinate with tradespeople and household staff. 4. Communication Management: Handle telephone exchanges with various administrations and banks. 5. Appointment Coordination: Manage and schedule both professional and personal appointments. 6. Financial Oversight: Oversee banking op...
Looking for a developer who can work with react and node.js to create a dashboard area with flight and hotel APIs integrated with CRM integration and payment gateway integration as well. The dashboard needs to have OAuth based authentication for user login and connected another website
I am looking for an Arduino expert who can develop the code for liquid level monitoring and send the data to a MySQL database for visualization on Grafana. Liquid Type: - The liquid being monitored is water. Arduino Model: - I am using an Arduino uno that I would like to be used for this project. Data Updating Frequency: - The data should be updated to the MySQL database every few hours. Data will be sent to the cloud using a botletics sim7000 module. The liquid level is measured using a 4-20ma sensor which is running through a voltage converter giving a voltage input signal to the arduino The arduino and sensors will be running from a battery and solar panel - power management is important. I will want the arduino to turn on a relay which will power up the sensors...
I'm looking for a knowledgeable expert to develop a custom product label design using Bartender software, directly interacting with an Oracle database where all necessary information is stored. Experience of working on Bartender Software is must for this. Key Responsibilities: - Create product label designs using Bartender software. - Ensure accurate extraction and integration of data from an existing Oracle database. - Adhere to my company's branding guidelines during the design process. Ideal Skills: - Experience of working on Bartender Software is must for this. - Proven experience in label designing using Bartender software. - Proficiency working with Oracle databases. - Clear understanding and application of corporate branding guidelines. - Strong attention ...
I am looking for a freelancer who can help me scrape a real estate website (written in Spanish) and gather the results into a CSV file. I need it to be done in python and have the ability to go down the different pages. I will focus first on houses for sale, but in the future will adapt to include rentals and also apartments and other properties. Real Estate Website: - I would like to scrape the data from Data Fields: - I have a specific list of data fields that I would like to scrape. But includes price, total surface, useful surface, bedrooms, bathrooms, address. Deadline: - There is no specific deadline for this project. Skills and Experience: - Proficient in web scraping and data extraction techniques - Experience working with real estate websites
...merchandise for guests and needs to be both functional and aesthetically pleasing. Combining the images attached. Not including the “BB” that is shown above the fish. The fish I envision a design that compliments the elegance and sophistication of our boutique hotel. Appropriate skills and experience for this project would include graphic design, branding, and experience working with boutique hotels or luxury brands....
...developer to build a document management UI on a Sql database. The ideal candidate should have experience in creating user-friendly interfaces for document management systems. Features: - File upload and storage: The UI should allow users to easily upload and store documents in the database. - Document search and retrieval: Users should be able to search and retrieve documents based on specific criteria. Design preferences: - Minimalist: The UI should have a clean and simple design, focusing on functionality and ease of use. User count: - More than 50: The UI should be able to handle a large number of users, ensuring smooth performance and efficient document management. Skills and experience: - Strong knowledge of Sql database management - Experien...
I am looking for a skilled database designer who can design and optimize the database schema and tables for my MySQL project. Here are the details of the project: This is an old schema that is no longer suitable for the upcoming business model. Database Schema Requirements: - I am open to suggestions for the database schema and tables design - No specific requirements are provided, so I am looking for guidance and expertise in this area Performance Requirements: - The database needs to have fast response times Ideal Skills and Experience: - Strong expertise in database design and optimization for MySQL - Experience in handling databases with fast response times - Knowledge of best practices and optimization techniques for
...development of an app that can take photos and reference them in a Excel spreadsheet, which is not visible to users, but used for reference only. Key requirements include: - Ability to take photos - Referencing the photos in an invisible excel spreadsheet - Detailed project proposal The ideal freelancer should possess an exceptional command of app development and have experience in creating similar database apps, with an emphasis on both photographing and data referencing capabilities. A detailed project proposal is expected from all freelancers interested in this job. This should include: - An overview of how you intend to tackle this project - A thorough understanding of the project's requirements - Relevant examples of past work Your innovative ideas and expertise w...
I need someone physically located in Bali, Indonesia to do some market research towards beach hotels. You will need to visit the hotels, and get in contact witht the management. You will demontrate our QR order and pay system that can be used from the sun-beds at the beach, for the guest to order drinks with their phones.
2 tables and 1 index is corrupted. DDL & DML is slow. tried DMS_Repair but didn't work. We are facing ORA-1578 and ORA -1110 These are two oracle errors. We are unable to write to the tables. We need someone with expertise in recovering Oracle Database and not mysql or any other databases. No trial and error but the expert please. And we need someone quickly! DB Size : 1.5 TB Table size for the tables which are corrupted is , 1st one 350 GB and 2nd one is 12GB, One index corrupted is around 4GB 12:15 PM just to correct myself total databse size 2.5 TB
I am seeking a seasoned database designer to create a modern, well-structured database tailored to my business needs. This project will focus on the creation of a unique database design according to my specifications, with particular emphasis on incorporating search data type. While the exact requirements for the database model and the structure aren't strictly defined, a clear understanding of both structured data formats and document-based NoSQL databases could be beneficial in delivering a comprehensive solution. Ideal Skills and Experience: - Extensive experience in database design & creation - Insight into various database models, including relational and NoSQL structures - Proficient in incorporating search data types Project Requ...
...create a FileMaker Pro property and mortgage database for me. Specific Features and Functionalities: - The database should have the capability to track property, mortgage, and payment information. - It should be accessible online, allowing me to access and update the database from anywhere. - Custom reporting features are required, allowing me to generate reports based on my specific needs. Ideal Skills and Experience: - Proficiency in FileMaker Pro and database design. - Experience in creating databases that track property and mortgage information. - Knowledge of online database accessibility and custom reporting features. If you have the necessary skills and experience, and can deliver a user-friendly and efficient property and mortgage databa...
I'm in need of a professional with specific experience in BLS Spain Algeria scripts. The project involves troubleshooting and fixing scripts that have developed issues over time. The ideal candidate for this project would: - Possess strong JavaScript and automation skills. - Have previous experience specifically with BLS Spain Algeria scripts. In your application, please focus on sharing your experience with BLS Spain Algeria scripts. Your ability to solve complex scripting issues will be critical to your success on this project.
I'm in need of an experienced PHP developer to tackle backend development for my project. Here are some specifics: - The key task for this role involves backend development. - Proficiency in CodeIgniter, Laravel, Bootstrap frameworks is mandatory, as these will be the primary tools used for the backend development. - Despite not specifying any particular features or functionalities, an ability to handle user authentication, data handling, and third-party integrations is highly advantageous. - Website design experience would be plus. Applicants should have previous experience in similar roles and provide examples of past work where possible. I look forward to finding the perfect match for this project.
Online database for mail management We need to manage physical mails (letters and packages) for our clients and report them online. In short: 1/ We receive letters and packages every day for our clients 2/ We picture them (outside picture) 3/ Each incoming mail is marked with a unique ID (label) 4/ We allocate each picture to a mailing box online 5/ Client of the mailing box is informed by email that a new mail is arrived for him 6/ Client can instruct us through his online account with the following options (see images with charts) : a/ Scan content (after scan shipment is still be available for forwarding) b/ Forward -> select forwarder • Priority mail postal service (no tracking number) • Priority mail postal service (with tracking number) • FedEx (...
I am looking for a developer to create a database for my project. Database Type: - MS Access Preferred Programming Language: - No preference Number of Tables: - This question was skipped Skills and Experience: - Experience in developing databases using MS Access - Proficiency in SQL and database design - Ability to work independently and meet project deadlines
We are currently seeking skilled and creative logo designers to join our team for various projects. We invite designers who can bring innovation and excellence to our brand identities. Successful candidate...identities. Successful candidates will be tasked with creating distinctive and memorable logos that reflect the essence of our clients' businesses. Designers are expected to demonstrate versatility, ensuring that logos are suitable for various platforms. We encourage creativity while emphasizing the importance of a timeless design that aligns with the clients' values and missions. USAS,Spanish (Spain), French,Czech,German,Portuguese, (Portugal),Hungarian,Ukrainian,Indonesian,Italian,Japanese,A rabic, (Standard) ,Korean, Romanian, Vietnamese, Polish, Thai,Turkish, Gree...
As an event organizer, I am exploring opportunities for direct communication by engaging with legitimate contacts. I need help with data extraction from specific websites. Primarily, these will be websites belonging to fairs and hotels. The core information required is contact details and e-mail addresses of relevant individuals, which is crucial for building my targeted mailing list. Additional to the contact details, I need the role or position of the contact extracted. Understanding their position within their organization will help tailor our communications effectively. For this project, ideal skills would include: 1. Experience in data extraction 2. Familiarity with the hotel and event industry, or a willingness to research 3. Ability to accurately categorize data into re...
Film City Plan: Creating a Thriving Hub for Tourism and Film Production Overview: We are seeking a skilled and experienced team to help us develop a comprehensive Film City plan that caters to both tourism and film production. Our vision is to create a vibrant destination that offers state-of-the-art facil...park offers a mix of entertainment, education, and interactive elements to cater to a diverse audience. 3. Restaurants and Accommodations: - Include a variety of dining options that cater to different tastes and preferences, ranging from casual eateries to upscale dining experiences. - Establish accommodations that cater to the needs of both filmmakers and tourists, including hotels, resorts, and serviced apartments. Budget will be decided after my idea is put into the...
I am looking for a freelancer who can provide me with an email list of doctors in the UK, Germany, Austria, Spain, and Italy, who have at least 15+ years of experience. The ideal candidate for this project should have experience in data collection and email list generation. Target Audience: - Consultants,Professors,Assistant Professors Total leads: 15000 leads in 20 specialities Information Required For every lead: First name Last name Country Speciality Hospital Business email Personal email Linkedin if present Years of experience Verification: - Yes, the email list needs to be verified Skills and Experience: - Experience in data collection and email list generation - Familiarity with the medical field and different specializations - Ability to verify email addresses accurate...
I am looking for a freelancer to help me create a worldwide hotel contact database for my new enterprise. The ideal candidate should have experience in data collection and be able to provide accurate and up-to-date information. Specific requirements for the project include: - Collecting hotel names, addresses, phone numbers, and email addresses from around the world - Ensuring the database is comprehensive and includes hotels from various countries - Verifying the accuracy of the information and updating it regularly - Organizing the data in a clear and structured manner for easy access Skills and experience required for this project: - Proficiency in data collection and research - Attention to detail and accuracy in data entry - Knowledge of the hotel industry an...
Need machine production and job report. data available in SQL database
2 tables and 1 index is corrupted. DDL & DML is slow. tried DMS_Repair but didn't work. We are facing ORA-1578 and ORA -1110 These are two oracle errors. We are unable to write to the tables. We need someone with expertise in recovering Oracle Database and not mysql or any other databases. No trial and error but the expert please. And we need someone quickly! DB Size : 1.5 TB Table size for the tables which are corrupted is , 1st one 350 GB and 2nd one is 12GB, One index corrupted is around 4GB 12:15 PM just to correct myself total databse size 2.5 TB
I am looking for a freelancer to help with a project for my existing business. The main task is to extract information from a spreadsheet that contains 5000 rows of data. We would like the freelancer to provide us with formulas and templates that will allow us to reproduce this information every week. The output file should be in XLSX format. We do not require additional assistance in interpreting the extracted data; we only need the data extraction itself. Ideal skills and experience for this job include: - Advanced knowledge of Excel and experience with creating formulas and templates - Attention to detail to ensure accurate data extraction
...have a query that performs a calculation that pulls data from my api. I need that query put into a new table, for faster access. 1. So task is put query into db and have a schedule to be done daily More Detailed for 1) a. when query is ready to be put in table, use an optimized query to reduce the no. of calculations and data that needs to be pulled from the API b. Create the Table in the Database c. Map out the columns according to the data fields your query will be returning d. Create a Stored Procedures of the query that is going into your table e. Configure the Stored Procedure to run on a daily schedule programmatically f. Monitor the query's performance to ensure it's pulling the data as expected 2. Diagnosing and fixing the profit and loss calculations...
I need an experienced freelancer to help me consolidate and optimize several Google Sheets databases for personal use. This task will involve the analytical merging and organizing of data, ensuring its accuracy. Key tasks and responsibilities: - Analyze multiple Google Sheets databases - Use my specific criteria to merge and organize this data - Ensure accuracy at all times The ideal freelancer for this job will have: - Solid experience with Google Sheets - Strong data management skills - Excellent attention to detail - Experience meeting strict deadlines. It is essential that you know how to navigate Google Sheets and are comfortable working with databases. This project is integral to my personal organization and data management, so it is crucial that everything is accurate and ...
