How to query a cube using sql jobs
I need an experienced Laravel developer who can identify and solve issues with the efficiency...developer who can identify and solve issues with the efficiency of specific database queries and faulty job queues in my Laravel 5.8 project. Key Areas of Concern: - Fixing slow queries: The database query that retrieves user information is running slower than it should. I am looking for a solution to speed up this process. - Resolving queue issues: Job queues are failing to run, causing an operational bottleneck. Your task also includes finding and implementing a fix for this issue. Ideal Skills: - Proven expertise in Laravel, particularly version 5.8 - Good understanding of database query optimization - Familiarity with queue and job execution in La...
...elements concerning a small foundation. Adherence to the SMM7 standards is vital. It is also required for it to be done on the traditional dimension paper. Your key tasks will include: - Accurately determining the area, volume, and depth of the foundation - Assessing the excavation of top soil for preservation - Moving on to the excavation of foundation trenches starting at Reduced level - Accounting for the volume of the plain concrete foundation (1:3:6) mix - Considering the 225mm cavity brickwork wall up to and including the (dpc) damp proof course - Evaluating concrete cavity filling (1:6) mix - Analyzing requirements for site protection from water from any source - Evaluating a 200 mm thick hardcore filling and any treatment required - S...
I am looking for a skilled developer to create a mobile application suitable for both Android and iOS platforms. The app is envisioned to have a corporate and professional user interface. Key Features: - The application should interface with a locally hosted SQL Server 2005 database. - It should allow the user to perform CRUD (Create, Read, Update, Delete) operations on price, cost and inventory quantity. - Despite the sensitive nature of this data, there should be no login required for data access. This means the app should be accessible to anyone without restrictions. Skills and Experience: - Proficiency in a cross-platform mobile development tool or language, such as React Native, Flutter, Xamarin, etc. - Experien...
As part of my project, I am in need of a skilled professional with hands-on experience in utilizing the mySQL Workbench R Package to perform statistical analysis. -Core Tasks: R program financial analysis and metrics -Expected Output: My SQL Workbench CSV Format -Priority Stats: I'm particularly interested in an expert interpretation of these statistics: 1. Rate of Return (ROR) 2. Correlation (CORR) 3. Standard Deviation (ST DEV) 4. Money Flow Index (MFI) The ideal candidate is proficient in using mySQL Workbench R package and knowledgeable in these areas of statistical analysis. Only serious and committed freelancers with a knack for accurate data interpretation are requested to respond.
Note : Accepting ad managers who bids less than 5000. I run a small startup business named veggieexpress where we deliver farm fresh vegetables and healthy drinks. I'm in need of an experienced professional to handle my metaads, with the primary goal of scaling B2C sales for my physical product line. I'm interested in boosting engagement, reaching out to a broader consumer base, and, most importantly, driving up sales. since it's an early startup the budget for managing is less. As the sales grows we want to work with them for longer period of time.. Here is what I'm looking for: - Expertise in Facebook Ads Manager - Strong background in consumer marketing - Experience in advertising physical products - Proven track record of improvi...
Note : accepting ad managers who bids less than 5000. I run a small startup business named veggieexpress where we deliver farm fresh vegetables and healthy drinks. I'm in need of an experienced professional to handle my metaads, with the primary goal of scaling B2C sales for my physical product line. I'm interested in boosting engagement, reaching out to a broader consumer base, and, most importantly, driving up sales. since it's an early startup the budget for managing is less. As the sales grows we want to work with them for longer period of time.. Here is what I'm looking for: - Expertise in Facebook Ads Manager - Strong background in consumer marketing - Experience in advertising physical products - Proven track record of improvi...
My website is currently experiencing issues due to the deletion of the original PHP admin, and though a new one was created in its place, complications have arisen. At this point, I'm uncertain whether I have a backup for the website. What I require is a professional who can effectively handle: 1. Recovery of Lost PHP Admin Data: - I need you to recover the lost data from the previous PHP admin. Knowledge in PHP, SQL, and database recovery will be crucial in this phase of the project. 2. Review and Optimization: - Once the data has been successfully retrieved, I would appreciate if you could review the current PHP admin, identifying any potential issues and optimizing it if necessary. A strong background in PHP development a...
I need complete 2 small projects done. The data needs to be pulled from API using python. The pulled data needs to be unnested, then transformed to answer some insights with medallion architecture. Here, you need to showcase SCD-type 2 ingestions, incremental joins, managing PII information, aggregation. Final deliverable needed for 1st project (databricks): Data model designed and architecture overview Notebooks of transformations in Python and PySpark/Spark Scala Final deliverable needed for 2nd project (dbt): Data model designed and architecture overview dbt sql and yaml files
I am looking for a talented designer who is very good using AI photo/video creator. I want to make a video clip for my new song called the "The first and the last one". I attached couple of files: 1.) a slovak to english translation of lyrics, so you can understand the meaning of the song more closely. 2.) slovak (original) lyrics to match the text lyrics with the voice, like in this song: 3.) a graphic idea that I generated from some AI tool. 4.) logo of my band - feel free to change the letters to fit the collors of the videoklip, just keep the cherries in the color that they are. 5.) Song in mp3. --> I can send it to you later in wav. The song is about realizing after some time after a...
Learn us how to rank a Website, will be a project for several months 1-5 hours per week. Teach us SEO und how we can rank our website.
...require your expertise in Natural Language Processing and Machine Learning specifically for Biomedical Named Entity Recognition (BioNER) using Language Model (LLM). Your tasks will be: 1. Comparing and Evaluating Two LLM Models * Should have an understanding of various LLMs and their working principles. * Will need to implement two LLM models. * Evaluate, compare, and select the most effective one. As the evaluation criteria have not been provided, your professional judgement through your past experiences and industry knowledge will be expected. 2. Integration with UI * Post evaluation, integrate the best-performing LLM model with a user interface. * Although programming languages or frameworks for implementation and integration were not...
I need a proficient and reliable SQL, PHP, and WordPress specialist to solve an issue I'm currently facing. My primary requirement is for assistance with my WordPress admin login. Despite having the correct credentials, I am unable to access the admin page. This issue is impacting my ability to manage my website and needs an urgent solution. The chosen freelancer should be able to: - Diagnose the potential reasons why I'm unable to access the admin page - Determine the most efficient fix for this problem - Apply said solution and, if necessary, guide me through the steps - Perform necessary adjustments in the SQL database if required - Ensure similar problems do not occur in the future The ideal candidate will have: - P...
...seeking a highly skilled PostgreSQL Database Administrator (DBA) with particular expertise in performance optimization. The focus of this job will be to revamp and optimize our database schema. Roles & Responsibilities: - Specifically, this task involves enhancing the performance of our highly complex queries such as stored procedures, functions, and logical conditions. - You should be able to ensure data integrity and the highest levels of performance and security for the databases. Ideal Skills & Experience: - Strong DBA experience, especially within PostgreSQL. - Proven skills in managing complex SQL queries. - Deep understanding of Database schema optimization. - Familiarity with data backup processes and security management. - Strong problem...
I am looking to take an exisiting Github Project and bring it up to date with a Web App Gui that can be self hosted. Current project is here : This project was originally written in Go and I want the new version to be self hostable. Functionality needed 1. Query DB for latest titles 2. User Can specify location of files 3. Using DB App will sort files / updates int sub folders etc. 4. Further functionality to be added later on.
I am seeking an instructor who can provide beginner-level classes in Data Analytics - SQL, R, and Power BI. I'm looking for a commitment of 8 hours per week. Ideally, the candidate should have: - Previous experience in teaching or tutoring, particularly with beginner students - Proficiency in SQL, R, and Power BI - The ability to tailor lessons to my progress while also following a structured curriculum I speak Spanish and basic English ( So preferably someone who speaks spanish)
I'm seeking a skilled Python programmer to turn my code into an application. Key Specifications: - The purpose of this coding task is to create a software application specifically tailored for data management. - Applicants should have comprehensive knowledge and applied experience with Python programming. - As the main objective is to develop a software application, freelancers should also possess a strong background in software development to ensure an efficient and robust system design. Ideal Skills and Experience: - Python Programming - Software Development - Data Management Systems - SQL - Building Robust Secure Systems - User Management - API knowledge Interested freelancers should explain their experience wi...
...Custom Software solutions. I need you to generate a thorough report documenting the findings. Key Tasks: - Perform penetration tests on my Windows VPS - Conduct vulnerability tests on installed Database systems and Custom software solutions - Compile a comprehensive report explaining test results Ideal Skills - Excellent knowledge and experience with Windows VPS - Proficiency in penetration and vulnerability testing - Proficient understanding of SQL Server - Proficiency with compiled ms access applications I'm open to working with professionals who have a methodical yet efficient approach to accomplishing these tasks. An ideal candidate would be receptive to my inputs, and meticulous in explaining complicated security j...
In the capacity of an experienced ERP developer, your task will be to create an engaging and user-friendly ERP system that meets our specifications. Key Features to Implement: - Accounting - Payroll management - Stock maintenance - POS system - Manufacturing management - Customer tracking - Employee tracking As the backbone of our business operations, the ERP system you create must resonate with our desire for a user-centric interface. Your prowess in transforming complex processes into fluid and intuitive experiences will be integral to the success of the project. Moderate customization of the ERP system will be necessary, as we need our platform to have a mix of standard and custom features. This will ensure it aligns with our operation'...
...HTML, CSS, C# and SQL for a web development project. The primary purpose of this project is to create a fully-functional, dynamic website that requires: - User authentication to control access to certain pages or features, - API integration to streamline functionalities and work with other applications, - Dynamic content update capabilities; changes to the web contents should be easy and efficient. The ideal candidate would be someone with a significant amount of experience navigating both back-end (Xamarin, Blazor, C#, SQL) and front-end (HTML, CSS) development in .NET environment. I need someone who can transform complex functionality needs into practical, efficient web solutions. Your understanding of user inte...
...box is a component, equipped at the front end of a car, and is one of the most important devices for crash energy absorption. For example, we would like to investigate the following shock absorbing materials. ・Crash box made of high strength steel plate of 780MPa class or higher ・Structure in which a steel crash box is equipped with an aluminum front integrally cast part. <<NOTICE>> The target car brands in this search are limited to US, Japan, European, Chinese, and South Korean brands. <Requirements for Payment> ・Submit documentary evidence that clearly states the details of the subject product, the name of the company selling the product, and the company that plans to sell the
I need support for a task converting Crystal Reports into Telerik Reports in ASP.NET. I have all necessary Crystal Reports files (.rpt) on hand. Need atleast 2 years of experience in Telerik Reporting Key Components: - The original Crystal Reports contain complex formulas that must be fully incorporated during conversion. - The current data source for these reports is MS SQL Server and this needs to remain consistent. Ideal Experience and Skills: • Expertise in ASP.NET • Advanced knowledge of Crystal Reports and Telerik Reports • Understanding of complex report formulas(a must) • Experience with MS SQL Server. For a successful deliverable, all converted Telerik Reports should function identically to original Crystal ...
I'm seeking a freelancer skilled in Power Query for some targeted tasks. These tasks include: 1. Data Cleaning and Transformation: I need assistance to clean and transform my data ensuring its integrity, relevant, and useful for further analysis. 2. Data Merging and Consolidation: I have different datasets that need to be merged and consolidated. The goal is to improve data accessibility and usability in analysis. 3. Data Modeling and Analysis: After cleaning and consolidating, I would like the freelancer to insights from the data through data modeling and analysis. 4. Custom Functions: Alongside the tasks above, I require help in creating custom functions in Power Query to make the process more streamlined and ef...
I'm in need of a tech-savvy freelancer to manage my blog website, utilizing the AI tools I subscribe to including Reword, Jasper, Tailwind and Blaze. Your tasks will involve the following: - Proofreading posts: Ensure each post is error-free using the AI proofreading tools. Ensure they sound less robotic and more humanized - SEO Optimization: Improve the visibility of each blog post by boosting its SEO. Experience with AI-based SEO optimizer tools will be a strong advantage. - SEO inputs: input targeted keywords, SEO titles, meta descriptions (using yoast SEO) alt descriptions (using bitalty) & back links (reword suggestions in “statistics reader may be interested in”) to improve search engine optimization - Sch...
...issues with my SQL database and Windows-Based POS system which resulted in a loss of connection between the two. Your main task would be to restore this essential connection, thereby enabling the smooth functioning of the system. • Identify and fix connection issues: My POS system and SQL database are not communicating as they should. Your priority will be to identify what's causing this and to implement a solution. • Handling pertinent data: The SQL database in question manages both customer purchase information and Inventory records. Possessing experience with or knowledge of these data types will significantly aid in this task. The ideal candidate for this project should be proficient with Windows-based POS s...
I am looking for a proficient WordPress developer to create web pages for a new website, the theme of the website brand is American cyber security. Ask for the website for review. Key Responsibilities: - Design and build an attractive, user-friendly website page on WordPress with a 90+ Rank Math Score - Establish more than 30 unique pages, ensuring each is SEO friendly using Rank Math. Each Page must: 1. Use the main focus keywords that we will give you. 2. Review competitor links for recreating a new page, which we will give you. 3.1100 words copyscape free per page, have content created in ChatGpt using Rank Math feature. Must have experience in SEO prompts and have your own ChatGPt account to work with us. 4. Two CTAs with ...
I need an experienced developer to implement MySQL database management using Python. The selected professional will utilize the python connector 'mysql-connector-python' to establish a connection with the database and do two tasks of a project. The database management includes: - Creating an efficient system design - load, extract and manipulate the data Key skills required for the job include: - Strong Python programming skills - expertise in SQL and specifically working with MySQL databases - Experience with 'mysql-connector-python' - Knowledge of data management best practices Previous work with user data management would be a plus.
...experienced SQL Server DBA to perform several critical tasks for us: I'm a database designer with 20+ years experience, but we need a dba to compliment my skills. - Security and Access Control: We have a user creation bug I cannot solve. - Troubleshooting and Performance Tuning: We have intermittent record locking which we need to fix. - XML Parsing: We have a 10 year old xml parsing codebase, which causes serious performance issues when there are hundreds of fields, we need a way to speed this up. - Converting SQL Server to MySQL: We also need to convert the entire codebase to mysql so we can run on both database engines and keep them syncronised. This is a nice to have...
I need a capable and experienced PHP/MySQL developer to create an interactive historical results report for me. The report will be generated based on user-selected parameters in a web page. Data to be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturede...
I'm in desperate need of assistance with a database management assignment. The tool of choice for this project is MySQL, necessitating an expert familiar with the specifics of this particular database system. With an urgent closure time frame of 2 hours, you will need to hit the ground running. The assignment centers on two key areas: 2. Understanding Database Concepts - In addition to query writing, a solid understanding of core database concepts is necessary. Part of the task may involve explaining these database concepts to me, so clear communication is important.
I need to setup latest mysql (v8.x) on C++ on my windows 64. The C++ is installed using Msys64 (not visual studio). I need you to figure out how set up the mysql for this c++ for me on my computer. Before I hire you, you must provide a video demonstrating the installation steps successfully on your own computer, and showcase a test by writing c++ code to run a basic mysql query. If the video convinces me that you can do the job correctly, then I will hire you so that you do it on my computer. I will give you control thru anydesk, and you will have to repeat the installation steps on my computer too. And after that, I will do the steps from scratch once again while you watch me, and you troubleshoot me if I get stuck...
I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name
I want to insert a DYNAMIC logo and text into my header bar just now all i have is 1 static logo however i want the logo to be dynamic (Store Logo) which will depend on the stores_id of the user then next to the logo will be the Store Name the stores_id is in the session and has been declared after login as $manager_stores_id = stores_id so we will need a query like $stores_query = tep_db_query("select stores_name, stores_image from `stores` where stores_id = $manager_stores_id); Then we load the logo top left which is stores_image and the name in plain white text (same styling as on the page) stores_name stores_image stores_name
...seeking an experienced Simulink HDL coder to assist with a project focused on generating and optimizing HDL code from Simulink models. The models primarily consist of mixed-signal systems such as memory array and ADC, so previous experience working with these is crucial. The objective is to target this code to Field Programmable Gate Arrays. Ideal Skills and Experience: • Extensive experience with Simulink HDL coder • Understands how to optimize HDL code • Previous work with mixed-signal systems • Experience with FPGA and ASIC implementation This is an excellent opportunity for an experienced coder who is familiar with Simulink Model and has a solid understanding of HDL code and mixed-signal systems. Your expertise ...
I require a diligent and detail-oriented professional to help me convert US addresses from the National Address Database into a useable form for an API. This important task aims to strengthen my marketing strategies by enhancing the quality of data I use for these efforts. This is where the addresses are: I want you to place them into a database so that we can build and API around it and query the addresses for validation. Specifically, you will: - Retrieve and convert a vast number of US addresses from the source, which is currently in an online database format - Ensure the converted data is compatible and easily integrated with APIs for seamless utilization - Handle the entire range of addresses from the National Address Datab...
I need some help building a little C++ project which displays 2 tabs controls. I want this built using from VS2017 developer cli.
I require a tech-savvy freelancer to create a Wordpress website for my course offerings and Razorpay for payments. As I'm planning to offer a range of courses, I prefer a platform that is highly flexible, user-friendly, and easy for me to learn and modify in future. The website must have: - Course catalogue showing a broad spectrum of offerings - Integrated payment system with Razorpay Ideal qualifications: - Extensive experience with Wordpress - Knowledge of Razorpay and how to integrate it with websites You should walk me through the details so that I can maintain and enhance the website in future. I'm open to any design styles, and would welcome any design proposals along with your ap...
I'm looking for an expert to create a prototype of a software system in Python, capable of simulating the handling or processing of a large volume of user requests, while maintaining efficient throughput and response time. Taking into account the following priorities: • System performance: Your work should principally aim to exhibit high-level performance concerning query response time and system throughput. Load balancing efficiency and resource utilization are as crucial. • Scalability: I'm anticipating the system to be able to handle normal user requests from 100 - 1000 per second and sustain its performance, with an elasticity for peak loads. • Development environment: You should be comfortable working ...
I'm in need of a proficient web developer to construct a modern and visually appealing website for the purpose of sharing personal IT blogs. The aesthetic needs to be contemporary and engaging, while being easy on the eye. Key Requirements: - Expertise in modern web design - Ability to implement easy-to-navigate functionality As I'm focused in sharing personal experiences, the site has to encourage reader engagement and discussion. However, please note: I skipped the query regarding the main website functionalities for now, this will be discussed in further detail once initiated on the project. Please provide examples of your prior work in this sector. Your creativity and innovation are much appreciable.
I require a data analyst with proficiency in PowerBI to create a dashboard focused on analyzing compensation rates based on demographic details. I've attached a rough markup and source data. Will need this completed in a short timeframe due March 7th by 8am PT. The data source will probably need some cleaning in Power Query to be able to be presented accurately. You don’t need to recreate exactly, so feel free to add anything that you think would be worthwhile to look at. Thanks!!
I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ...
I'm looking for an experienced freelancer to help with the deployment of a .NET Framework 4.7.2 code on a Plesk panel Windows hosting. Key Responsibilities: - Configure the SQL database settings - Adjust config file settings for database connections Given the specialized nature of this project, I need someone proficient in .NET Framework 4.7.2 and Plesk panel configuration. Familiarity with database connectivity and MSSQL is also a must. I expect a quick and efficient deployment without any loss of data or functionality. Let's get this done right the first time!
I'm in need of a skilled Selenium developer with significant experience in enhancing internet security. You'll need to perform three key tasks: 1. Adjusting proxy settings 2. Enabling developer tools 3. Configuring privacy settings accordingly Ideal candidates should have a solid understanding of Selenium and browser security configurations. Experience in Chrome user agent configuration, cybersecurity, and expertise in dealing with SQL injection attacks and data encryption are a must.
I require a website for my courier business with a primary focus on service description and pricing. The website should prominently feature: - Detailed service descriptions - Transparent pricing models Additional Requirements: - An integrated live chat support for immediate customer query resolution. Ideal candidates for this project must prominently highlight their past work related to website development in their applications. Previous experience with logistics/courier service websites will be a plus.
...need is to develop a Proof of Concept (PoC) to validate these technologies for potential larger-scale use. Here's what you will be doing: 1. **Entity Extraction**: You will identify and extract entities from a text dataset. These entities will then need to be categorized into pre-defined categories. 2. **PoC Creation**: All these will culminate in the creation of a PoC to validate the feasibility of using an Entity Extractor and Vision technology. Please note, This project related to query over doctor Presciption. Ideal Skills: - Experience in Entity Extraction technology - Experience in Vision technology - Proficiency in sentiment analysis - Proven track record in PoC development - Ability to work...
...can create a customized Chrome extension for me aimed at my webmail client - webmail.free.fr. (ROUND CUBE) This extension needs to be capable of automating email sending processes by pulling recipient's data from Excel files on my desktop. Rather than a predefined email template, the extension should allow for dynamic content from these Excel files to be sent as the email body. Successful freelancers interested in this job should definitely mention their experience and extend their portfolio that highlights their skills ideally in the following areas: * Chrome Extension development * Automation processes * Experience in coding for webmail service – in this case, '' * Advanced knowledge of Excel and data handling Please also s...
I'm in need of a highly skilled software developer to build a website for an engineering project. The professional I am seeking should have extensive experience in: - Python - HTML - CSS - SQL - Javascript - Node.js The main goal of this project is to deliver a user-friendly, practical and efficient website that can facilitate project management and monitoring for engineering tasks. The end-users of this website will be individuals working on an engineering project. Your expert touch on this will help to streamline their work, enhancing productivity and communication. Please, only apply if you have a proven track record in these programming languages and the capacity to meet strict deadlines. Your portfolio showing com...
i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live
