Database queries mysql jobs

Here is a small NASDAQ project: 1) Recover data faster 7000 stocks => 3h for 1h30 / 90 min => 3500 stocks 9 min => 350 stocks. Maybe we could do multiple queries of 350 stocks? Because what is in place stops after 1800 files out of 7000. And obviously it starts again each time at the beginning when we restart... so it is always the same stocks which are updated. It would be better if the already downloaded data was not deleted, but kept and downloaded only the missing delta. This would allow us to have large data If we downloaded 1 year of data 7 days ago and we select 1 year, then only the last 7 days are downloaded, which goes faster. The data is then aggregated and deduplicated if necessary. 2) In the "indicator" section, be able to add, modify, delete existi...

...default settings, pushing the boundaries of the platform. Here's what we need: Shopify Expertise: In-depth understanding of Shopify's file structure, directories, and templating system (Liquid). Experience manipulating orders, grabbing data from the database, and crafting custom views using Liquid shortcodes. Proven ability to develop custom Shopify plugins to achieve complex functionalities. Technical Skills: Proficiency in Shopify development languages (Liquid, JavaScript, HTML, CSS). Experience with database manipulation (likely MySQL). Communication & Collaboration: Excellent written and verbal communication skills in English. Ability to clearly explain technical concepts to non-technical stakeholders. Comfortable participating in regular vide...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few sec...The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The databa...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shi...

...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through database creation. This project i...

...a flexible and scalable backend infrastructure that can handle high volumes of bookings while ensuring a smooth user experience. I need a skilled Core PHP Developer to build a custom web application with database management capabilities, using MySQL as the preferred database management system. The application should be well-structured and efficient with an emphasis on data handling. Key Requirements: - Extensive experience working with Core PHP. - Proven track record of developing dynamic, secure, and efficient web applications. - Strong understanding and experience with MySQL database management. - Ability to ensure the application is well-structured and follows best practices for data handling. - Strong problem-solving skills and the ability to wo...

I have an existing Laravel-based ecommerce application that requires a series of modifications and additions. Key Tasks: - **New Tables & Conditions**: I'm looking to add several new tables and conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm s...conditions to the application. Skills & Experience: - **Laravel Proficiency**: I'm seeking a seasoned Laravel programmer who has extensive experience with ecommerce applications. The ideal candidate should be highly proficient in Laravel framework and comfortable creating new tables and conditions within the application. - **Database Management**: A solid grasp on database management is crucial to successfully add and integrate these new tables. Experience with My...

I'm looking for an experienced PHP developer who is well-versed with MySQL to help me with editing the search module of my website. The primary focus of this project is on modifying the way images are retrieved then displayed in the search results. Key Requirements: - Modify the retrieval of images in the search results to use URLs for specific sizes as opposed to the current methodology of storing images locally and then displaying. - No specific enhancements are needed for the image thumbnails, just an adjustment in the retrieval and subsequent display methodology. Ideal Skills: - Proficiency in PHP and MySQL - Experience with implementing search modules in web development - Familiarity with retrieving and displaying images in various sizes - Strong problem-solving ...

I'm in need of a skilled Python developer with knowledge of RAG and Chainlit to create an AI-powered chatbot. - Specific Tasks: - Develop an interactive chatbot to be used by customers - Implement RAG and Chainlit concepts to enhance the chatbot's capabilities - Ensure the chatbot can handle a variety of interactions and provide accurate information - Integrate the chatbot seamlessly ...in relation to chatbot development - Expertise in RAG and Chainlit - Experience in creating chatbots with strong interactive capabilities The primary functionality for this chatbot will be answering frequently asked questions. The successful developer will need to be able to create a user-friendly interface and ensure the bot is able to provide clear, concise answers to a variet...

Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of

...integrated with artificial intelligence (AI) features. • The website aims to leverage AI technologies to enhance user experience, improve job matching accuracy, and streamline the recruitment process for both job seekers and employers. • Development should be based on modern web technologies, such as HTML5, CSS3, JavaScript, and server-side scripting languages like PHP or Python. • Database management system (e.g., MySQL, PostgreSQL) for storing user data and job listings. • Integration with third-party APIs for features like job search, location services, and social media. • The recruitment website will incorporate AI-powered features such as natural language processing (NLP), machine learning (ML), and data analytics to deliver advanced function...

I am in need...Access specialist to create a straightforward database. The main aim of this project is the production of a simple database with a focus on data reporting. Key Points: - The database is intended for data reporting purposes. - There will be 1-5 different types of data entries (tables) in this database. - The final database should be equipped for generating various types of reports from the data it contains. - I am looking for a freelancer who can also document the database effectively. Ideal Skills and Experience: - Experience in designing and building Microsoft Access databases, specifically with a focus on reporting. - Strong knowledge of structuring databases for efficient reporting. - Ability to provide clear and concise docume...

We are seeking an experienced custom web developer to create a unique web application tailored to our specific needs. The ideal candidate will have expertise in the following areas: Recommended applications and Technology: HTML, CSS, JavaScript, React/Vue/Angular) Laravel, CodeIgniter, Node.js, Python, Ruby on Rails, PHP, or similar - Database management (MySQL, PostgreSQL, MongoDB, etc.) - API integration - Responsive design **Responsibilities:** - Develop and maintain the web application according to the project specifications. - Collaborate with our team to refine and improve features. - Ensure the application is secure, efficient, and scalable. **Requirements:** - Proven experience in custom web development. - Strong portfolio showcasing relevant projects. - Excellent...

Hello! I'm [UJJWAL KUMAR], a dedicated and skilled content writer with experience in creating engaging...content SEO-optimized writing Tailored content to suit your brand voice Unlimited revisions until you are 100% satisfied Professional communication and a collaborative approach Let’s work together to create content that not only informs and entertains but also drives results for your business. I am committed to delivering excellence and exceeding your expectations. Feel free to contact me for any queries or to discuss your project in detail. I look forward to collaborating with you! Best regards, [UJJWAL KUMAR] Make sure to customize the description with your name, years of experience, and specific details relevant to your skills and expertise. Good luck with your f...

I'm looking for an experienced SEO professional to optimize my hotel's website for search engines and ultimately increase the ranking of my site. The primary goal of this project is to ensure that my site is easily discoverable by potential guests, especially business travelers, through search engine queries. Key Deliverables: - Conduct a comprehensive SEO audit, identify areas for improvement - Implement SEO best practices to enhance my site's search engine visibility - Optimize site content, tags, images, and meta descriptions to align with SEO standards - Incorporate a blog feature with SEO-driven content to attract more online traffic Ideal Skills and Experience: - Proven track record in SEO optimization with hospitality or travel-related websites -

...Function to an Azure MySQL database. The function is being used as a Web API, and I need it to be able to both read and write data to the MySQL database. Key Requirements: - Development: You will need to establish a secure, reliable connection between the Azure Function and the Azure MySQL database. - Data Handling: The API should be able to retrieve data from the database as well as input new data into it. - Security and Optimization: Ensure proper security measures are in place to protect the data, and optimize the API for performance. Skills and Experience: - Proficient in C#: You should have strong experience working with C# and Azure Functions. - Azure Services: A solid understanding of Azure services and how they interact. - My...

Hello, I need a reliable, fast, and affordable installation of the Stripe payment processor for my website, from someone who keeps their commitments. This person must have knowledge of HTML, PHP, and MySQL. Regards

You will need to visit and search for the following categories. Drainage Glazing repair Appliance repair Plumber Electrician Roofer Use the postcode W2 4DP After you have the search results You will need to open a google sheet and have the following categories Name of Business Website (you will need to find this either from checkatrade or google if you use google do not put LTD on the end) Companies house link for each business use this link The task is to complete 500 companies - please bid knowing this and only bid if you read the brief and understand it

...the WordPress site on the chosen hosting platform. Ensure HTTPS is enabled for secure data transmission. Provide documentation and a brief training session on managing the site and handling common issues. Technical Requirements: Frontend: HTML, CSS, JavaScript (with jQuery or a framework like React/Vue if necessary). Backend: PHP, WordPress, Google Cloud Text-to-Speech API, FFMPEG. Database: MySQL or equivalent (if needed). Hosting: Recommendations for hosting solutions that support WordPress and required processing capabilities. Deliverables: Fully functional WordPress website with the described features. Custom WordPress plugin for handling audio generation and integration. Documentation for setup, maintenance, and troubleshooting. Brief training session ...

... addressing inquiries, and maintaining a positive and engaging online presence. Ideal candidates for this role should have: - Proven experience in growing Instagram accounts through content creation and engagement strategies. - Excellent communication skills. You will be the voice of my brand on Instagram and should be able to maintain a consistent, engaging tone while addressing followers' queries. - Strong organizational skills to ensure content is posted consistently and interactions are managed effectively. - A good understanding of the Instagram platform and its features, including the use of engagement tools like polls and questions. If you have prior experience working as a Virtual Assistant for social media accounts, have helped grow Instagram profiles, and unders...

...need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in ...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm currently experiencing database connection errors on my Wordpress website. Key Requirements: - Fix database connection errors causing website load problems - Ensure the website is running smoothly and all features are fully functional - Full access to the website's hosting account and database for troubleshooting - Clear and timely communication using instant messaging for updates and feedback Ideal Skills and Experience: - Proven experience in resolving database connection errors on Wordpress websites - Strong understanding of database management and troubleshooting in Wordpress - Excellent problem-solving skills and ability to work efficiently - Previous experience in instant messaging for client communication is a plus Had issues lik...

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I'm looking for a professional Flask and Python developer to help me implement a user management system for my website. The user management system should have Social Media login integration. Additionally, I would like the selected developer to set up a payment gateway and a MySQL database. Ideal Skills: - Proficient in Flask and Python - Experience in implementing user management systems with social media login integration - Proficient in setting up payment gateways - Proficient in working with MySQL databases

...Tailored Solutions: We create custom web applications that meet your specific business needs, enhancing productivity and operational efficiency. ● Versatile Applications: Our solutions range from customer portals to complex inventory management systems, each built to address unique business challenges. ● Technology Stack: Node.js, , Ruby on Rails, Django, Laravel, MongoDB, PostgreSQL, MySQL, AWS, Docker....

I am in need of a technophile with expertise in Microsoft Access databases. Your task will involve: - Populating my database with customer data which includes names, addresses, phone numbers, organisation affiliations, and details of last interactions. - Inputting sales transactions data which include dates, product names, and prices. The ideal freelancer should demonstrate an adept understanding of database management, particularly Microsoft Access, and be able to accurately input data with keen attention to details. Efficiency, accuracy and attention to detail will be paramount for this project.

...Description: I am seeking an experienced freelancer to develop a directory listing website, similar in design and functionality to the following template: The design will be provided by me. Requirements: 1. Technical Specifications: - Framework/Technology: Please suggest suitable technologies. - Database: MySQL, PostgreSQL, or another relational database. - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and be highly performant

I've been facing issues with a MySQL table that seems to be taking up too much space in my database, despite there being no data in it. The table is almost 2MB in size while it has no rows at all. The database was originally like 50kb a few weeks ago. Recently we made some minor changes, like adding index. Then it suddenly become so huge. Key points: - Table size issue: The MySQL table is bloated despite having no data, and it's causing performance problems. - Insertion operations: The table is mainly used for inserts, which are what I need it to be optimized for. The work needs to be done remotely using anydesk. If you know how to do it, it should be just a few min fix.

I'm looking for an intermediate SAP administrator to assist with the basic administration of our SAP system. Key Task...Tasks: - Basic user management, including creating and deleting users, assigning roles, and setting up authorizations - Monitoring system performance and taking necessary actions to ensure it runs smoothly - Troubleshooting and resolving basic configuration and authorization issues - Assisting with system backups and ensuring data integrity - Providing general support to the team on SAP-related queries It's important that you're comfortable working with the SAP system and have a good understanding of its basic functions and administration. A background in SAP Administration or similar roles is preferred. I will provide access to the SAP system, ...

I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices i...

...user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building Complex Queries: You will need to ensure that the relationships between Artists, Styles, and Portfolio Items are established correctly. While there are already queries and relations built, some of them might need updated as not everything imported in a way that shows the right things on the Elementor templates (e.g. since Elementor Listing Items have different page IDs since importing, those need to be selected in some cases). Similarly, while queries are built and imported, you should still have ability to build complex queries within JetEngine, so you understand the setup and can ideally in the future help refine and exp...

...Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building Complex Queries: You will need to ensure that the relationships between Artists, Styles, and Portfolio Items are established correctly. While there are already queries and relations built, some of them might need updated as not everything imported in a way that shows the right things on the Elementor templates. Similarly, while queries are built and imported, you should still have ability to build complex queries within JetEngine, so you understand the setup and can ideally in the future help refine and expand on it. - Visual and Functionality Fidelity: You will nee...

I'm looking f...marketing for customer engagement, and a content creation tool to assist in generating compelling product information. - Discount Code Integration: Having a discount code on my store's front page is a key priority for me. Experience in integrating this specific feature into Shopify is highly valued. - Chatbot Functionality: The primary goal of the chatbot I want to implement is to answer customer queries. It's crucial that the chatbot is efficient and helpful in addressing customer needs. The ideal candidate should have a strong background in AI, with previous experience in integrating these tools into Shopify. A deep understanding of e-commerce and customer service is essential. In particular, past experience in developing chatbots for customer suppo...

...experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I have to transfer data and tables from oracle to postgres.

...searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the int...

My existing React Native application, which is supported by NodeJS and backed by a MYSQL database, needs immediate attention. Here's what needs to be done: User Interface Updates: The component related to photos in the application requires significant changes. I also need a feature that shows the GPS route to the specified delivery point. This functionality was not implemented in the initial version of the application. Additionally, changing screen configuration doesn't display corresponding states with their color (only changes upon updating the application). Functionality Improvements: On top of the UI changes, the app needs general functionality improvements to enhance user experience and the app's efficiency. Also, create a button for downloading PDF file...

Website Designer , Php , E Commerce having knowledge of MySQL

I'm looking for someone to work with me on an automated crypto trading bot. It will use Tradingview alerts, (which uses Webhook URL) to ping a script on a server, which then uses an exchange API to execute crypto trades. I will integrate the script into MySQL using php to track the amount traded and set a e.g. a sell price for the crypto just purchased after the alert... I can do that... But I need help with the integration of alerts from Tradingview and the API code to the exchange.

I have a significant amount of text data from physical documents which I need entered into a database. The ideal candidate will have experience with both data entry and database management. Key Project Requirements: - Data Entry: You will be responsible for accurately transcribing text data from physical documents into a digital format. - Database Management: The entered data needs to be organized correctly in the database. Prior experience in managing databases is essential. Ideal Skills and Experience: - Proficiency in data entry - Strong attention to detail - Experience in database management - Familiarity with data organization techniques I'm looking for someone who can complete this efficiently and accurately.

Project Overview: We are in need of a skilled backend developer to implement the necessary functions for our financial services website. The primary goal is to ensure smooth operation and functionality across various sections of the site. Project Details: Functionality Scope: Implement backend functions to support the frontend int...APIs. Budget: To be discussed based on project scope. Timeline: Fastest to complete. Preferred Communication Channel: Freelancer platform messaging system. Additional Notes: Collaborate closely with frontend developers to ensure seamless integration. Prioritize security and data integrity in backend implementation. Skills Required: Node.js RESTful API Development Database Management (e.g., MongoDB, MySQL) Authentication and Authorization ...

I'm seeking a skilled system administrator to replace my current MariaDB with MySQL 8.0 on a CentOS server. The ideal candidate will be able to: - Completely remove MariaDB ensuring no data loss - Install and configure MySQL 8.0, adhering to: * Default configuration * Custom storage engine Security is a key concern. Remote access to the MySQL installation must be restricted. This is crucial to maintain the integrity and security of the server and its data.

I'm in need of an advanced level M3 ERP trainer with specific experience in the retail industry. Your expertise and knowledge will be pivotal in aidin...in need of an advanced level M3 ERP trainer with specific experience in the retail industry. Your expertise and knowledge will be pivotal in aiding the efficient use of our ERP system. - Key Responsibilities - Training users on the functions of M3 ERP - Providing advanced learning techniques for M3 ERP retail applications - Helping in troubleshooting issues and solving complex M3 ERP queries Exposure to a retail environment and advanced understanding of M3 ERP will be key to provide the level of training required. The ability to adapt training to different learners and level of understanding will also be beneficia...

...an experienced AWS DevOps specialist to host my business management tool which consists of a React-based front-end, an ASP.NET API and a MySQL database on AWS, specifically using Elastic Compute Cloud (EC2). Key requirements: - Hosting: Set up and manage the hosting environment on AWS EC2, ensuring the site is stable and accessible. - Scalability: Implement strategies to accommodate low traffic, up to 100 users per day. - Security: Ensure the highest level of security and integrity of the data. Ideal candidates should have: - Proven experience in DevOps and cloud hosting, particularly with AWS EC2. - Background or familiarity with React, ASP.NET, and MySQL. - An understanding of best practices for hosting and optimizing web applications. This project is crucial f...

I need a professional to create an ER diagram for a moderately complex database I'm designing. - This is specifically for database design purposes, using Chen notation. - The database structure I have in mind falls between 10-20 entities, so the ER diagram will need to reflect this level of complexity. - You should have in-depth experience with database design and ER diagramming, particularly using Chen notation. - The ER diagram should be clear, well-structured and accurately represent the relationships and entities within the database. - Previous experience with similar projects is a plus.

I'm seeking a FileMaker Pro expert to modify the existing project database for our small architecture firm. Your main tasks include: - Rectifying existing bugs - Enhancing reporting capacity - Introducing new mapping features, if possible. Some issues have been detected in the current system with features not working properly, particularly in the reporting capacity. A new mapping feature is optional and can be discussed further. There isn't a strict time frame for project completion, but I'm hoping to get it done as soon as possible. Ideally, the applicant should have a strong background in FileMaker, bug fixing and data mapping.

I am in need of a Laravel Developer to work on my website. The changes involve backend functionality and database modifications. Ideal Skills: - Strong experience with Laravel - Expertise in backend development - Proven track record of database modifications Tasks Include: - Implementing API integration, specifically e-commerce APIs - Database modification to accommodate new functionalities I need someone with a high level of expertise in Laravel and backend development. Your ability to integrate e-commerce APIs and modify the database accordingly is crucial for the success of this project. Your focus will be on enhancing the backend functionality, ensuring it's robust and efficient. Your attention to detail and ability to work independently will be high...

...can help me create a movie database website that is connected to a Telegram bot. Key Features: - Movie Database Website: The core of the project is to build a movie database that's user-friendly and comprehensive. - Telegram Bot Integration: I need a Telegram bot that can seamlessly connect to my movie database. The bot should be able to handle user queries and provide relevant movie recommendations. Telegram Bot Functionalities: - Movie Search & Recommendation: Users should be able to search for movies based on different criteria and receive tailored recommendations. - URL Shortener: The bot should be able to generate a shortened URL for the movie being recommended. Ideal Skills and Experience: - Proficiency in web development, particula...

??? ?????: ????? ?????? ????????? (????-????, ??????) Salary: up to 4000$ USD/month The ideal candidate will have a passion for algorithmic trading and extensive experience with the NinjaTrader platform software. This is a fully remote position with a flexible schedule, but the candida...Experience with version control and continuous integration tools such as GitHub/GitLab • Knowledge of third-party libraries and APIs • Proficiency in building enterprise web solutions using the MERN stack • Strong proficiency in HTML, CSS, JavaScript, and JavaScript frameworks like Dart, React, and Node • Experience with server-side languages such as Python, PHP, and C# • Knowledge of databases such as MySQL, NoSQL, and GraphQL Ability to accurately forecast and communicate ...