How to query a cube using sql jobs
I'm looking for a proficient developer with a strong background in Yii2 and React.js to bring my project to life. The core of this project involves fetching selective columns from more than seven different tables and displaying these records, which include text and various types of files, on a React-based frontend. The backend is in Yii2. **Key Requirements:** - **Expertise in Yii2:** Must be capable of efficient backend development, specifically with experience in working with multiple tables and extracting specific columns. - **React.js Proficiency:** Should have a strong grip on React.js to create a dynamic and responsive frontend display for the data fetched from the backend. - **Database Skills:** Deep understanding of dat...
We are designing a new salon space. We need someone familiar with design software. We have already designed, we need someone to finetune and make our vision a reality.
Seeking Excel proficient in SQL, R, Excel VBA, and Google Spreadsheets for data analysis, complex formula building, and reporting on a large dataset. If skilled in SQL, R, Excel VBA, and Google Spreadsheets with experience in handling large datasets, eager to see your solutions for complex problems at scale!
I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - *Resolve the current error*: To continue our operations without disruptions. - *Enable new data analysis capabilities*: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers.
...found at I'm seeking a proficient freelancer to develop this software, designed for Windows operating system. The crux of it should revolve around the following features and attributes: 1) Desktop Media with DMX Control: Foobar2000 must be updated to provide basic DMX control function via USB output of Windows lap top. 2) The user should be able to choose/change a colour for any music track on Foobar 2000. 3) The same colour should be outputed to the DMX control. 4) The colour stays the same until changed The ideal candidate for this project should be highly skilled in software development, particularly for Windows. Prior experience in creating music software, and knowledge in DMX control will be a huge plus. Mas...
We are looking to add a Senior Digital Analytics Consultant to our team! The work location is in Atlanta, GA and we are looking for candidates who are local to Atlanta or someone who can relocate. Skill Set: • Strong Digital Analytics / Marketing Analytics skills. • Expert level experience in Adobe Analytics is mandatory. • Strong Ecommerce/Travel and Digital Marketing background. • Experience with Analytics Reporting and Deeper Dive Analysis. • B2C direct channel Measurement and Optimization. • Ecommerce product development experience a plus. • Advanced Analytics Skills (SQL / Python) a nice to have. • Experience with Adobe Target a plus. • Experience working with senior management...
scrape data from site and export it into excel using python
Launch WhatsApp Desktop app on windows without GUI. That means hide the GUI of whatsapp. Then control it using programming languages such as Nodejs, Python etc.
I am looking for expert youtube video creators who meet the following criteria: - What you have to do: Video making + Voice over (male or female voice with decent accent) + Short edit + Thumbnail + Seo - Pay per video - Length of video: between 1 and 3 minutes. - Workload: 15 videos per week - Example channel: @GaugingGadgets You are expected to work with android phone, iPhone, Mac, Chromebook and Windows PC. I'd love to hear if you have done a similar work before. And would appreciate if you can send me a sample of your work. Are you okay with the price from the description? (if not don't apply) Do you have over 80% job success? (if not don't apply) Have earned more than 50$? (if not don't apply) Do you have Windows 11?
I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - **Resolve the current error**: To continue our operations without disruptions. - **Enable new data analysis capabilities**: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers. **Required Skills and Experience**: - Proficiency in Google BigQ...
I am seeking a skilled Oracle and SQL database specialist who can efficiently assist me with database management tasks. This will include database design, data modeling, and query optimization. Ideal skills and experience you should bring include: - Expertise in Oracle and SQL database - Knowledge in data modeling and database design - Troubleshooting and performance optimization skills - Proven ability to deliver high-quality work under deadlines The main purpose of the project is to enhance database proficiency that encompasses data storage and management, application development, and optimization of performance. The end goal will be to achieve a streamlined, fully-optimized, user-friendly database system. Deadline: 2 days Fix...
Looking for a proficient SQL expert to contribute to our ongoing project. The successful freelancer will be experienced in database programming and will exhibit a deep understanding of SQL-based platforms. - Ideal Skills: Extensive SQL knowledge. - Experience: Oracle Database 2 days deadline
I'm embarking on an ambitious project aiming to leverage the power of machine learning for outcome prediction, specifically utilizing image data. My goal is to create a system capable of analyzing visual information and predicting future outcomes based on this data. The project is at a planning stage, and I'm exploring potential processes - whether real-time processing is a necessity or if batch processing can achieve the desired results. Project- Liver Segmentation and disease detection in liver using pytorch and Monai I want all the files including datasets and code files. And a video about how to download source code and run the project on my laptop. **Key Requirements:** - **Expertise in Machine Learning:** ...
I'm in need of a database expect with a particular expertise in Oracle. The main purpose of this project involves SQL and oracel. The professional should be ready for a flexible project scope that may require various Oracle-based data analytical techniques. Ideally, the hired specialist will have experience in a range of data analysis strategies. Deadline: 2 days I would like to make it fix price
I need assistance with a SysML homework assignment centered on the CATiA program. - Task: Your main task will be creating basic BDD diagrams. This shouldn't entail anything too complex, just a few elements are required to do components reliability - Skills and Experience: You should be proficient in CATiA, with a solid understanding of SysML and activity diagrams specifically. Your expertise will be used to interpret the homework requirements into the diagram. The end result should be a well-structured, clear, and concise activity diagram that meets the parameters of the assignment.
My primary aim is to have an easy-to-navigate Android home screen. The design should include the following elements: • Icons and illustrations • Typography and color schemes • Layout and navigation I attached the reference, Which i need to design Ideally, you will have Figma proficiency and experience designing Android home screens. Your portfolio should show your ability to work efficiently with these elements and excel in creating practical, user-friendly designs.
We are looking for a skilled SAP S/4HANA Developer with expertise in creating Core Data Services (CDS) views for analytics consumption in Power BI. The role involves developing and optimizing CDS views to facilitate effective data extraction and visualization, supporting informed decision-making processes. Prior experience with Retail S/4HANA modules is mandatory. 1. Experience with SAP GUI and navigating SAP systems for data 2. Experience with handling Transport Requests 3. Experience in developing Calculation Views 4. SAP certification in relevant domains. 5. Experience handling large datasets and complex data structures. 6. Knowledge of other BI tools and technologies. Key Responsibilities: Design and develop CDS views in SAP S/4HANA for effective analytics and reporting....
Project Overview: We are seeking a skilled and meticulous freelancer to undertake the translation of a set of user instructions into 11 different languages. This project demands high precision and a deep understanding of context, which is why we have chosen to use ChatGPT for translations instead of Google Translate. The nature of our instructions requires that each translation accurately captures the intended meaning, nuances, and technicalities of the original text. Key Responsibilities: Translation Execution: Translate the provided user instructions paragraph by paragraph using ChatGPT. This method ensures a better grasp of context and maintains the coherence and accuracy of the content across multiple languages. Languages Required: T...
I'm currently looking for an experienced database administrator or a SQL expert who can convert my raw SQL files, originally from MariaDB 10.6, into a standard .SQL format. The primary reason for this conversion is to facilitate a smooth migration to MySQL. As this project forms a crucial part of my migration strategy, it's imperative that we adhere to a stringent timeline. **Why the Conversion?** - The conversion is essential for migrating my database from MariaDB 10.6 to MySQL. It's critical for ensuring compatibility and efficiency in the new environment. **Expected Deliverables:** - Convert raw SQL files from MariaDB 10.6 format to .SQL files - Ensure that the conve...
...When we start the application it runs for a few seconds and then crashes. We need someone to access our server (anydesk access will be given) to see if there are configuration errors and fix them. Our server administrator (has no experience with ) changed something on our server because previously we would start the application with "npm run start" and after changes we start app with "service nextjswebfc2 start". It might be a coincidence but it appears that after this modification the error began and the app crashes a few seconds (1-2 minutes) after being started. IF YOU ARE AWARDED THE PROJECT WE EXPECT YOU TO ACCEPT THE JOB IMMEDIATELY AND ACCESS OUR SERVERS TO EXECUTE THE FIX. If job is not accepted immediatel...
...looking for a skilled Power BI developer to create an interactive and visually appealing dashboard. This dashboard is aimed at simplifying data analysis and enhancing decision-making processes. **Primary Goal:** - The main purpose is to design a dashboard that not only represents data graphically but also allows for comprehensive data analysis and report generation. **Data Sources:** - The dashboard will need to assimilate data from diverse sources: - Excel spreadsheets for historical data. - SQL databases for real-time data analysis. - Integration with various cloud services to ensure a broad data spectrum. **Visualization Requirements:** - Special emphasis on creating detailed pie charts. These charts should not only be ...
I'm seeking an experienced Python developer knowledgeable in Javascript for the development of a versatile chatbot via the Chatgpt API. Features: - Real-time chat, and optimise our scripts for NLP and NLTK analysis ( utilising github repos) - Customizable responses ( for backend scripts to create perfect SEO optimised articles) The design and implementation should be processed via the Flask, Django and FastAPI frameworks. It is vital that the freelancer have prior experience in these areas and can demonstrate a high level of understanding for each framework. The final product must be efficient, stable, and easily maintainable. It's a plus if you have experience developing chatbots or similar APIs.
...When we start the application it runs for a few seconds and then crashes. We need someone to access our server (anydesk access will be given) to see if there are configuration errors and fix them. Our server administrator (has no experience with ) changed something on our server because previously we would start the application with "npm run start" and after changes we start app with "service nextjswebfc2 start". It might be a coincidence but it appears that after this modification the error began and the app crashes a few seconds (1-2 minutes) after being started. IF YOU ARE AWARDED THE PROJECT WE EXPECT YOU TO ACCEPT THE JOB IMMEDIATELY AND ACCESS OUR SERVERS TO EXECUTE THE FIX. If job is not accepted immediatel...
...hour task => review our deploy on Ubuntu to identify and fix problem that is causing app to CRASH. When we start our app, it runs for a few seconds (or minutes) and then it crashes. It was working fine and we're not sure if another application or component that we installed caused the problem. We need for the developer to access our server (anydesk access will be given) and review the installation to identify and eliminate the error that is causing this crash. After this task is concluded we have long term work on our project as well as our .NET C# project 1) Administer Ubuntu OS where we run our project 2) Transform/migrate our current angular.js to (we have already transfered about 60-70% to ) Prerequisites: 1) Accep...
I have an issue with my enfold theme is creating a query tag behind the videos hence the vidoes are not getting cached as i would like to be. I need someone who knows exactly what this issue is and fix it. I dont want a generic expert. I am looking for specifically this issue only when u bid, write "yes i know how to fix query issue in video enfold theme" so i know u know
I'm looking for an experienced researcher specialising in Natural Language Processing (NLP). The focus of the project is to conduct sentiment analysis using data from Twitter posts. Key Requirements: -Expertise in NLP, particularly sentiment analysis. -Experience with data collection from social media platforms, specifically Twitter. -Ability to translate collected data into valuable and understandable insights. -Proven track record on similar projects. Please submit your proposal detailing your approach towards this project accompanied by previous work samples in the NLP space, especially sentiment analysis conducted on social media data.
I want you to use Elementor and Woocommerce on the Blocksy theme to recreate the following pages from the Woodmart theme (): Shop Home Product Category Product Cart Basket Checkout You will need to recreate these pages and make sure they have my look and feel, including my fonts, colours, logos, etc.
I'm in need of an individual skilled in file conversion and data management to convert a SAS report to an SQL report, specifically for Tableau. The final output should be able to be utilized efficiently in Tableau. Your bids should reflect: - Your expertise in SAS, SQL, and particularly, Tableau. - Proven experience managing data conversions effectively. - Detail-oriented approach to ensure accurate conversion. - Ability to work within a timeline. Your primary task will involve: - Converting my SAS report to SQL. - Ensuring the SQL report is compatible with Tableau. - Troubleshoot any issues during the conversion. Speed and accuracy are essential for this task, and evidence of previous similar wor...
I'm seeking a developer proficient in PHP to create an API that interfaces with Google Drive to perform a variety of operations. This project requires a robust understanding of Google Drive's API and exceptional PHP coding skills. **Required Operations:** - Uploading files with support for multiple file formats. - Creating folders within the Google Drive structure. - Renaming existing files to maintain organization. - Generating new files within Google Drive. **Ideal Skills and Experience:** - Extensive experience with PHP programming. - Prior work with Google Drive API or similar cloud storage services. - Ability to support multiple file formats in upload functionality. - Strong understanding of file management and manipulation...
I'm in need of a skilled programmer who is proficient in both Python and Javascript to assist with a project that revolves around data analysis and web scraping, with the primary goal being data extraction. **Key Responsibilities**: - **Data Analysis**: Analyzing extracted data to identify patterns, trends, and insights. - **Web Scraping**: Developing scripts to extract data from specified websites efficiently and accurately. **Ideal Skills and Experience**: - Proficiency in Python and Javascript. - Proven experience with web scraping tools and libraries (e.g., Beautiful Soup, Scrapy for Python). - Strong background in data analysis. - Familiarity with databases and data storage (SQL, NoSQL). - Ability to clean, organize, and interpr...
...for a professional who can help me reshape my SQL database into Excel report form, enabling me to manage and run these reports independently in the future. The ideal freelancer should: - Be proficient in SQL and Excel - Have a firm grasp of database reporting and transformations - Understand how to tease out meaningful metrics and data details for presentation The resultant report should include: Access our Autotask backend database using Data Warehouse. (Link Below) I want to be able to take that database and convert it into a nice report that I can send to our customers on tickets. Whats the common issues and similar. I have a Simliar report currently through Bright Guage but Im looking ...
SQL Query Optimization Expert Needed ASAP Skills: - Strong knowledge and expertise in SQL - Proficient in query optimization techniques - Advanced understanding of SQL database complexity Project Requirements: - Immediate assistance required for query optimization - Deadline: Within 24 hours Please only apply if you have the necessary skills and can deliver within the specified timeframe. This is an urgent project that requires an expert in SQL optimization.
i have a php script with some mysql queries and joins by DEFAULT there is no filter or condition on the STORE ID as when the script is loaded the first time no store id is selected so ALL data will be loaded for all stores now to filter the data for a specific store i added a WHERE clause to my query where o.orders_stores_id = '" . (int)$_GET['store_id_dd'] . "' '" . (int)$_GET['store_id_dd'] . "' is determined once i select a store from the dropdown filter. then it registers once i press submit however this only works if i add that WHERE clause the issue with that WHERE CLAUSE is that the DEFAULT or NULL case will not work and nothing will be returned as the code is treating ...
We are looking for someone, who can write file of hyperledger bevel operator, to deploy hyperledger fabric. Based on your file, we would do the deployment on real time basis and confirm the working of file.
I am looking for a highly skilled web developer or team to create a sophisticated, user-friendly customer portal for my business. The primary goal is to enhance customer experience by providing a seamless interface for users to access their accounts, manage orders, and track invoices with the utmost security. Key Requirements: - Development of a clean, intuitive, and responsive design that supports all devices. - Implementation of account login functionality, ensuring ease of access for users. - Integration of two-factor authentication to add an extra layer of security to user accounts, protecting their sensitive information effectively. Ideal Skills and Experience: - Proven experience in developing customer portals or simil...
Im looking to interface and sync data from a software that has sql database to sap b1 using an automatic replicator that uploads to sap b1 every 3 minutes. only 2 documents type will be sent 1. Delivery Note 2. Sales Order The source database will have sql views mapped with the exact name and nomenclature needed by sap Sap b1 will only receive information from other database, it wont send info to other database
have a text format which need to pivoted and converted to columns and rows
I'm seeking an expert with vast experience in .net core applications to integrate the Google signup feature and fetch data from the Google Contact List. & integrate into existing running projects. The developed application will need to perform the following tasks: Google Signup: - Implement user authentication - Integrate OAuth - Enable email verification Google Contact List: - Fetch all contact details such as name, email, and phone numbers SQL: - To store the fetched data, I need an SQL database set-up wherein the contacts' names, email addresses, and phone numbers will be stored Only developers with profound knowledge in .net core, OAuth integration, and SQL are encouraged to bid on this project. This will ensure ...
...stages of creating an AI-powered call center service tailored for businesses in Egypt, such as restaurants and car dealerships. Our goal is to leverage GPT-4 integrated with AI text-to-speech and speech-to-text models to provide seamless, efficient, and cost-effective customer service solutions. We are seeking an experienced developer to help us create a Minimum Viable Product (MVP) that demonstrates the feasibility and potential of this service. Requirements: - Expertise in AI and Machine Learning: Proficiency in working with GPT-4 or similar models, with a focus on natural language processing and understanding. Experience with speech-to-text and text-to-speech technologies is essential. - Software Development Skills: Str...
Steps to complete the project: 1. Develop an algorithm using OpenCV to detect a drowning person in the swimming pool. 2. Design a robot using ROS-Gazebo to rescue the drowning person, incorporating prismatic joints and a control algorithm for the bucket. 3. Create a ROS-Gazebo simulation of an arena with specified dimensions and the necessary actuators for the rescue robot. 4. Develop a distance calculation algorithm to determine the distance between the origin and the detected drowning person in the pool. 5. Implement the rescue algorithm, including the derivation of the bucket to the destination. 6. Implement the algorithm that control the position and velocity of the actuator with mathematics. 7. Pro...
HEllo, I'm looking for anybody that provide me the SQL query that inserts the answers to the questions about the products from this module: The reply should be some thing like "INSERT ..."
I need a Freelancer to help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software () but failed. So, we suspect that the origin of the file is not ORACLE SQL. I am happy to provide additional information to help you bid properly.
I'm looking for a PrestaShop expert who change the frontend of my prestashop website with a new design that i will provide it ( html template)
...Remote Work Hours : 11.30 AM to 8.30 PM ( May stretch depending on deliverables) Exp: 12 YRS (Minimum) ü Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ü Must have ability to conceptualize ideas and data streams to schem...
Creating Ecommerce Website using CodeIgniter as per discussion
We are seeking a skilled freelancer to develop a simple PHP script focused on data visualization, specifically catering to planetary hours. While the script's core functionality can be achieved through ChatGPT, we believe an experienced individual can deliver efficient results promptly. Description: We require a straightforward script to display planetary hours based on location and date input. Key Functions: The script will closely resemble the functionality of this sample site, with additional features: - Integration of Islamic (Hijri Date) display alongside the conventional calendar. - Option for users to select their location, with the flexibility to change it as needed. - Enhanced visualization by displaying the names of...
Please message me only after you read this and you are positive you can do it: using existing libraries like or NOVAS to make a small C# script that takes date and time, and produces the output: 1- where sun and the moon will be overhead a certain latitude and longitude 2- the % of the the moon phase 3- the relative angular size of the moon and the sun 4- the distance of the moon and the sun for example timeanddate provides this in order to test your results 2024-02-20 09:30:00 UTC - 2024-02-20 14:30:00 UTC -
...experienced developer to create a specialized online database for managing profiles of models and actors we represent. This tool will serve as a centralized platform to efficiently store, access, and manage detailed information about each individual we work with. We have already a database online but we need to divide it in 2 one for adults and one for kids on 2 different websites and make changes **Key Features Required:** - **Data Entry Interface:** A secure, user-friendly interface for our agency staff to manually input personal and professional details of models and actors. - **Comprehensive Data Fields:** Include fields for personal details (e.g., name, age, contact information), physical attributes (e.g., height, weight, e...
I'm seeking a skilled PHP developer to create a script tailored to my specific needs for managing XML data efficiently. This script will play a crucial role in the operation of my e-commerce platform, ensuring up-to-date product listings and accurate inventory management. **Key Requirements:** - Develop a PHP script to parse XML files. - The script must extract specific data elements: Product Names, Prices, Descriptions, and Stock Levels. - Import parsed data into a MySQL database. - This process needs to be automated to run on an hourly basis without fail. **Ideal Skills and Experience:** - Proficient in PHP with a strong understanding of XML file handling. - Experienced in writing SQL querie...
I am looking for a freelancer who can integrate the PayPal Checkout service into SendPulse service. The ideal candidate should have experience with API integration and be able to redirect users to a separate PayPal page for payment processing. We require this procedure: 1. SendPulse issues a PayPal link for the customer. 2. PayPal Payment page opens and there are option to pay by Debit Card , Credit Card. 3. After payment successful the api send back to SendPulse. 4. SendPulse receives the unique payment status as : successful payment , rejected payment or pending payment. Skills and experience needed for this project: - API integration - PayPal Checkout service integration - Strong problem-solving skills The job will be through Anyde...