Calculate time attendance sql jobs

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including t...number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Excel.

...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial. Please bid $20.

...developer to integrate an "in app chat" feature into my existing .Net MVC5 aspx SAAS project, with a particular focus on real-time communication functionality. Key Expected Features: - Bootstrap 3 compatibility - Chat server - Client (html and jQuery preferred) - Ability to create groups (add and remove participants) - Show users online status - Storing chat history - Ability to send/receive documents and audio files Ideal freelancers for this role should possess the following skills and experience: - Proficient in .NET MVC5 and Bootstrap 3 - Experience in chat server and client development - Ability to write clean, maintainable jQuery and HTML - Familiarity with real-time communication platforms UI Presentation: The chat messages should be displayed as chat...

Do you like getting freebies and earning a decent side income at your spare time? If so, become a product tester for Deal Select today! 3 Benefit of participating - Keep all received product samples. - Participate anytime, anywhere; each product testing project takes 10-15 minutes to complete. - Great side income at your spare times. Candidates should meet the criteria below. • Enjoy trying out different / new products. • Capable of formulating constructive reviews • Individuals residing in the US or Canada. Being familiar with the online consumer product landscape of US and Canada regions. Your responsibility: Once you have received the item, utilize the item for a specified amount of time. Then formulate a product review. The review is to be written wit...

...freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Upda...

...professional looking for part-time work in the technology sector. My skills are in management and design. Key Requirements: - Part-Time Commitment: I'm interested in a part-time role, so please provide opportunities that align with this. - Technology Industry: I'm particularly interested in technology roles, so please consider this when suggesting positions. - Management & Design Skills: My core competencies lie in management and design. I'm looking to leverage these skills in a part-time capacity. Ideal Candidate: - Experience in Technology: A background in the technology industry is highly desirable. - Understanding of Design & Management: Expertise in design and management will be valuable for the tasks at hand. - Ability to Wo...

long term , full time flask developer needed to build ecommerce backend you should start right away should have proficiency in flask, jquery, ajax and mongodb budget INR 100 per hour, need to work for another 15 to 20 days

... to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial of $20.

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

...proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over 12 hours...

I need a comprehensive and efficient transportation per student cost model developed as soon as possible. Key Components: -Finding out per student cost -Finding out per bus cost Data Points: - I will provide you with the information that can help calculate the key components stated above. Ideal Skills and Experience: - Proficiency in cost analysis and financial modeling - Experience in transportation logistics and efficiency - Ability to work quickly and accurately, delivering within a tight timeline.

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criter...

Looking for a skilled animator to join our team, focusing on creating compelling motion graphics videos for our YouTube channel. We will need someone that can w...creating compelling motion graphics videos for our YouTube channel. We will need someone that can work daily and create 1-2 minute of motion graphics per day. Here is an example of the type of work we need: Key Requirements: * Proficient in Motion Graphics Animation * Deadline-oriented and able to take on daily projects on a full-time basis Ideal freelancer should also be an avid viewer of YouTube content, so they understand the platform's style and demographic. This position is meant for someone with initiative that's seeking a long-term working relationship.

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

... to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I'm seeking an entry-level candidate for a full-time customer service, data entry, and sales & marketing role. Key Responsibilities: - Providing top-notch customer service, handling inquiries and resolving any issues that may arise - Accurately entering data, ensuring the maintenance of up-to-date and correct records - Assisting in sales and marketing efforts to drive business growth Ideal Candidate: - Entry-level professional eager to learn and grow in the industry - Strong communication and problem-solving skills - Proficient in data entry and customer service systems - Basic understanding of sales and marketing principles This role offers a competitive salary range of Rp1.500.000- Rp3.500.000 per month and the opportunity to work full-time. If you're a ded...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.

We are looking for a full time employee with graphic designing and video editing skills. Must have laptop and good internet connection and should know Telugu, Hindi and English Languages.

I'm urgently seeking a skilled developer to set up a Helios 2 Lidar camera for detecting human figures and calculating distances up to 10 meters. Key Requirements: - Proficiency in setting up and customizing Helios 2 Lidar camera - Mastery of object detection, specifically human figures. - Capable of imp...Lidar camera - Mastery of object detection, specifically human figures. - Capable of implementing short-range distance calculation (up to 10 meters) The project demands someone who has a strong understanding of Lider camera configurations, and advanced skills in object detection and distance measurement methodologies. Your competence in creating systems to accurately detect human figures and calculate short-range distances will be the driving forces behind the success o...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should loo...

I'm looking for an experienced developer to create a web-based application focused on real-time fund transfers using UPI protocols. The application should be designed with the following features in mind: - **Primary Purpose**: The main goal of the application is to enable real-time fund transfers securely and efficiently. - **User Interface Elements**: The key focus here should be on an interactive transaction history. Users should be able to easily track and monitor their transactional activities within the app. - **Security Features**: Implementing two-factor authentication is non-negotiable. Please ensure that the application is extremely secure, and that all data associated with transactions is encrypted and protected. Ideal candidates should have prior experienc...

...text such as header footers or non-essential information. You might also need to correct any formatting issues or errors introduce during copy 3 Text Analysis: Analyze the copied text for various metric such as word frequency readability score sentiment analysis or topic modeling. This can provide insight into the writing style tone and themes present in the text. 4 Statistical Analysis: Calculate statistical metrics such as word count average sentence length or vocabulary richness to gain deeper insights into the writing style and complexity 5 Visualization: Create visualizations, such as word clouds histogram or scatter plot to represent the analyzed data in a more intuitive and understandable way. 6 Interpretation: Interpret the results of the analysis, drawing con...

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm looking for an experienced Flutter developer to create a cross-platform app compatible with both Android and iOS. Key Requirements: - Develop a seamless, efficient, and user-friendly app for both Android and iOS - Ensure the app is responsive across devices and screen sizes - Create a scalable architecture to support future updates and integrations Ideal Skills and Experience: - Proficient in Flutter and Dart - Prior experience in developing cross-platform apps for both Android and iOS - Knowledge of mobile app best practices, design principles and guidelines - Strong problem-solving skills and ability to troubleshoot and optimize app performance - Good understanding of APIs and integrations The timeline for this project is flexible, so you can work at your own pace. Looking fo...

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

Please send your expected monthly salary if working on a monthly salary basis. The lowest, but experienced offer will have a better chance. Monthly salary will be considered to calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of ...

...backoffice system for managing bookings. The functionalities I'm aiming are: - User needs to enter details like Agency name, pax name, mobile number, pick up location, pick up time, date of flight travel, flight departure time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success...

Hello i am looking For full time Developer On monthly basis Timing is flexible we can discuss on chat Also please bid if you are freelancer only company/agency please dont bid

I'm looking for a PHP script expert who can create a real-time data retrieval system for my MySQL database. The script will connect to the BeachesMLS Matrix RETS Server and download all the properties into my database as soon as they are sold. Key Requirements: - Real-time Data Retrieval: The script should constantly monitor the BeachesMLS Matrix RETS Server and instantly download all the sold properties into my MySQL database. - Comprehensive Property Details: The script should specifically download details like price, location, size, agent information, property status, listing date, amenities, property type and the number of bedrooms for each sold property (all fields available) Ideal Skills and Experience: - Proficient in PHP: You should have a strong understanding...

...communication and have experience with complex fixes, when a task is assigned it needs to be resolved and whatever else is found quickly. Bugs mean the site is down or not working and dont have time for excuses or inexperience. This is a long term position as once you get use to the sites (about 12) the issues tend to be the same. DO NOT apply just to work temporarily because you need money today, please. I dont want to invest time for someone who will just fix a few tasks and then disappear. No place holders, please! I need someone who is serious and can do the work, if you are not an expert dont waste my time please! MAX BUDGET $5 an hour and looking to eventually work with you directly after this project, a team would be great this way i can make sure i always ...

I am seeking a talented developer to create a software that can interact with Interactive Brokers and TastyTrade for index based options trading. This project will require strong skills in both Python and Java, as well as a deep understanding of trading algorithms and experience with real-time data streaming. The software should be capable of the following: - Real-time data streaming: The software will need to retrieve and process real-time market data for accurate decision making. - Order placement: The software will need to execute buy and sell orders based on pre-defined algorithms. - Technical indicators: The software should be able to use popular technical indicators to inform its trading decisions. Your experience in algorithmic trading software development, us...

...website builder to create an online platform for selling meat. The site should be user-friendly, secure with all necessary features for an E-commerce platform. Key Features: - Product Catalog: The website will need to display a range of meat products with detailed descriptions and pricing. - Shopping Cart: An intuitive shopping cart function that allows users to add and remove items, as well as calculate their total cost. - Payment Gateway: A secure payment gateway to facilitate smooth transactions. - Delivery Schedule (Slots): I'll need customers to be able to choose from available delivery slots for their orders. Ideally, I'd like the website to be built with scalability in mind, in case we wish to expand the product range or services in the future. Prior experienc...

...a proposal withg AI please resubmit your bid with a genuine response. Thanks. **Job Posting: Full-Time Bilingual Virtual Assistant (English/Spanish)** Thank you for taking the time to read through this job description. We are passionate about our work and seek to collaborate with equally passionate and detail-oriented individuals. This is a permanent, full-time position requiring your complete dedication. **Compensation:** Please submit your bids based on a monthly salary. Payments will be made weekly, as the month will be segmented into weekly milestones. Take your time to craft a thoughtful proposal that reflects your skills and passion. **Job Requirements:** This role demands a full-time commitment of 8 hours per day, with an additional 1-hour b...

I'm looking for a talented freelancer to build a custom table that can accurately determine partners' collection and payout within our dental practice. This table should be flexible enough to allow for the substitution of various numbers, which in turn reconfigures the other numbers in the table. Key Components: - The table will need to calculate individual doctors' collections and revenue based on specified variables - Additionally, the table will need to factor in: - The predetermined variables for calculating individual doctors' collections and revenue - Management fees - The table will also need to consider the partner's percentage ownership for each partner in the practice. This percentage ownership will be calculated based on the i...

(Please read- stop automated bidding) I'm looking for a proficient developer with expertise in both WordPress & Laravel platforms. Your primary tasks will include: - Simultaneous development on both platforms - Integration of payment gateway API using Laravel -5y + experience in WP Your ideal skills and experience would consist of: - In-depth knowledge of WordPress & Laravel. - Strong ...APIs, particularly payment gateways. - Excellent problem-solving skills to effectively manage any integration issues that may arise. - Familiarity with user interface design is a plus, but not a prerequisite. In summary, I need a developer who is adept at integrating payment gateway APIs, while simultaneously understanding and utilising the strengths of both WordPress and Laravel platforms...

Please see .pdf file for full explanation. I am seeking a skilled developer to create a sophisticated online booking form. This form will require the unique capability to calculate distances between both residential and business addresses. Key Features: - The form should consider distances with traffic considerations, hence requiring a level of accuracy beyond simple point-to-point measurements. - It should also be intelligent enough to accommodate multiple non-consecutive destination inputs. Ideal Skills: - Strong understanding of geolocation APIs for accurate distance calculation. - Prior experience in designing intelligent online booking forms. - Proficiency in UX design to ensure user-friendly interactions. - Understanding of traffic patterns will be a significant plus. Th...

I'm looking for an Executive Assistant to handle a minimum of 10 to a maximum of 20 hours per week. The main tasks will include: - Email and Correspondence Management: Be responsible in manag...Correspondence Management: Be responsible in managing my emails, filtering important ones and responding to them accordingly. - Personal organization: This requires you to assist me with daily tasks that optimize my time and productivity. - Customer Care: You'll have to occasionally interact with our coaching clients ensuring their experience is satisfactory. An ideal candidate must possess excellent communication skills, have experience in admin roles, and be well organized. A background in customer service would be an advantage as you'll be dealing with our coaching c...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

We are looking for a remote Swedish or Norwegian speaker operator for a customer service job . 8 hours/day, Monday - Friday. Central Europe working hours. Inbound and email customer service for an online shop. 1 week test. Bid with your cheap cost per 20 hours (the test period). Please write a couple of line of your self or better send a CV. Thank you

...triangles so that we can calculate all the angles and then additional diagonals which will enable us to detect incorrect measurements being entered. The process begins as follows: (Assume all heights are equal initially. Enter heights after the minimum number of diagonals have been entered.) 1. Enter all perimeter measurements. 2. For a 4-sided polygon need 1 diagonal. 3. For a 5-sided polygon need 2 diagonals – both originating from one point. i.e. B-D, B-E 4. For a 6-sided polygon need 3 diagonals – each connecting with the others. i.e. B-D, B-E, B-F Pole heights are entered at this point to be able to calculate the true lengths of the remaining diagonals. All subsequent measurements are calculatable. (Red Dashed Lines on attached drawings) We ...

I'm looking for a knowledgeable and experienced writer to create a comprehensive guidebook geared towards first-time home buyers navigating the UK mortgage industry. This book will serve mainly as a pathfinder assisting these individuals to navigate this complex sector with ease. Key Focus Areas: - Detailed explanation of the mortgage application process which will serve as a guide to first-time home buyers. - Intense elaboration on the various types of mortgages available in the UK, highlighting their differences, benefits and drawbacks. The perfect freelancer for this job is preferably someone with mortgage industry experience or a professional writer with extensive research skills. An understanding of the UK housing market is key to ensuring accuracy and usefulnes...

I'm looking for an expert in creating comprehensive trading spreadsheets. This task requires not only solid experience in spreadsheet creation but also a deep understanding of cryptocurrency trading. Key Requirements: - Real-time data updates: The spreadsheet should allow for live updates of cryptocurrency trading data. - Performance tracking: It should have features to track trading performance over specified time periods. - Profit/loss calculation: It should be equipped with formulas to calculate profits or losses accurately. - Automatic multi-spreadsheet referencing: It needs to be able to link data across multiple spreadsheets automatically. The created spreadsheet should support all available cryptocurrencies, therefore a broad knowledge of the crypto mar...