Sql code extract xls filepekerjaan

I'm seeking an experienced data visualisation expert to design a one-page, real-time business analytics dashboard in Grafana. Key Responsibilities: - Use SQL Database as the sole data source for the dashboard. - Implement various visualisations as per the attached specifications. Ideal Skills: - Proficiency in SQL and Grafana. - Strong understanding of data visualisation techniques. - Experience in creating business analytics dashboards. Please refer to the attached picture for the specific types of visualisations needed.

I'm looking for a professional to help extract specific healthcare data from a country of my choosing (I will provide in chat) and guide me through the process(coding part). The data of interest includes: - Doctor's Name - Registration Number - Practicing End Date - Specialty - Place of Practice - Address of Place of Practice -Contain 18480 Record The final output should be delivered in a CSV file. I will provide the specific sources or databases from which to extract this data, which may include government health sites, public health records and medical association databases. Ideal skills for this job include data extraction, data analysis, and proficiency in working with CSV files. Previous experience in extracting healthcare data would be a significant...

I need a small web scraping project to extract property listings from the site: ******************* The script should be able to scrape the following details from each property listing: - Property address - Price - Description The ideal freelancer for this project should have experience with Scrapy and web scraping in general. The code needs to be runnable by myself on a virtual server, which I can rent if necessary. It should be capable of running daily, without any captchas but with some tricks to bypass potential obstacles on the site. Please provide me with an estimation for this micro-project. Thank you.

Sila Dafter atau Log masuk untuk melihat butiran.

...feature-rich coupon code website. The platform will leverage a Headless WordPress setup, where WordPress will serve as the backend and the frontend will be developed entirely in JavaScript. This is a high-priority project, and we require someone who can work in a pair programming mode with our team. We are looking to build a GrabOn-like coupon code website that utilizes Firebase as the primary backend (including notifications and all relevant Firebase modules), paired with a modern JavaScript frontend (e.g., , Node.js) for superior performance and scalability. Additionally, WordPress will serve as an admin panel purely for managing content, while the core business logic and data handling will reside in Firebase. Project Overview We aim to create a sleek, modern coupon...

...and/or sizes (based on user input) with this geometric pattern applied. Deliverables Currently, I have a working project, and I need two modules added to it: The first image recognition module will "extract" geometric patterns and an 8-bit color palette from the rug/carpet images the user selects. (input = path to file) The second module - image generation - based on extracted patterns and user input it will create a new image of a rug/carpet. (input = size and shape) I use code IDE: Clion. I attached my libs, config screenshots, and rugs image files. Feel free to use any other photo Source code: Note: I want to specify this job. We are not talking about stretching and resizing the extracted pattern, but we're talking

...has a keen eye for detail. Responsibilities: Design and develop scalable and efficient web applications. Write clean, maintainable, and efficient code. Collaborate with the team to define and implement new features. Debug and resolve issues across the stack. Optimize applications for maximum speed and scalability. Stay updated with emerging trends and technologies in web development. Requirements: Proven experience as a Full Stack Developer. Proficiency in front-end technologies (HTML, CSS, JavaScript, React, Angular, or similar). Strong back-end experience with Node.js, Python, Ruby on Rails, or similar frameworks. Familiarity with databases (SQL, MongoDB, etc.). Experience with version control systems like Git. Ability to work independently and meet deadlines. Good co...

Data from pdf or word files to system software

I need a professional with strong expertise in Azure and GitHub to assist with deploying an application. The specific type of application and Azure service are yet to be determined, so flexibility and broad knowledge in these areas are crucial. Key Skills and Experience: - Proficient in Azure services - Experienced with GitHub and application deployment - Flexible and adaptable to various application types - Ability to provide insights on suitable Azure services for deployment - Excellent problem-solving skills for any unexpected deployment issues Please note, I have not yet defined specific deployment requirements, but I am open to suggestions based on your expertise. Your ability to propose effective Continuous Integration/Continuous Deployment (CI/CD) strategies, custom deployment scr...

Payment for 2nd logo!

Responsibilities: Reconfigure and optimize our Google Ads accounts to enhance targeting and effectiveness. Overhaul our Google Analytics settings to capture essential data and provide deep busi...independently. Experience in optimizing Google Analytics in medium to large enterprises. Proficiency in data visualization tools such as Google Data Studio or Tableau. Demonstrated ability to derive business insights from data. Preferred Qualifications: Previous successful implementation of multi-channel analysis and advanced data tracking projects. Excellent analytical thinking with the ability to extract business insights from data. Case studies or examples of past projects where your Google Analytics configuration and optimization significantly improved data reporting and business decisi...

Features 1. File Upload and Storage • Automatic saving of email attachments. • File upload functionality available on the website. • Uploaded files are stored on the server, categorized by customers. 2. File Analysis • Extract data from saved files using OCR and GPT. • Extracted data is stored and categorized in the database by customers. 3. Data Editing (Grid-based) • Data Grid: • Display data in a spreadsheet-like format. • Includes filtering and search functionality. • Editable Cells: • Customer data and analysis results can be edited in real-time. • Edit Logs: • Automatically save all modification history. • Logs include data before and after modification, along with timestamps. 4. Excel/CSV Ex...

I'm in need of a database expert for managing and analyzing hospital data. Your primary task will involve creating, optimizing, and querying a SQL database. Key Responsibilities: - Conduct data analysis and produce comprehensive reports on patient health records, staff performance, and inventory management. - Create and optimize the database for improved performance and efficiency. - Develop an ER Diagram to visualize the database structure. Ideal Skills: - Extensive experience with SQL and database management. - Strong skills in data analysis and reporting. - Proficiency in creating and interpreting ER Diagrams. - Background in healthcare data analysis preferred but not required.

... "storeExists": false } } Part 2: Temporary Link Behavior When the temporary link is accessed, the page should display the following: Total number of registered stores. Store order number (based on its creation sequence). Store name. Store location (latitude and longitude on a map). When the location is updated, the address (region, city, district) should also be updated dynamically. Use an SQL query to determine the exact address based on the geographical location. If no district data is available, provide an "Other" option. Store address, including region, city, and district. Store status, selectable from a predefined list (e.g., operational, under maintenance, opening soon). Store type, selectable from a predefined list (e.g., mall, part of a small mark...

I have an STL file for a 3D print and I need a latch to be moved 1mm up, maybe 2, we have to check after printing it. See attached picture. That's it! I do not have a STEP file, only the STL.

I'm seeking a seasoned Data Analyst with a keen focus on predictive analysis. The project primarily involves working with data sourced from a SQL database. Key Responsibilities: - Conduct predictive analysis to identify future trends and potential outcomes. - Extract and manipulate data from the SQL database to facilitate analysis. - Present findings in a clear and concise manner. Ideal Skills and Experience: - Extensive experience in data analysis, particularly predictive analysis. - Proficiency in SQL, with a robust understanding of database management. - Strong ability to interpret complex data sets and identify patterns. - Excellent communication skills for presenting data findings.

I'm currently facing a critical issue with my Microsoft SQL Server. The database appears to be corrupt, and I'm unable to access it. I'm seeking a skilled professional with extensive experience in Microsoft SQL Server to help diagnose the problem and restore access to the database. Key Requirements: - Proficient in Microsoft SQL Server - Experience with database recovery and troubleshooting - Ability to diagnose and fix database corruption issues Please provide examples of similar issues you've resolved in the past. Thank you.

I need a Python expert who can create a script that retrieves redirect links for Google Hotels. The script should be efficient and able to handle various scenarios. this redirects in the browser, i need to extract the redirect link with additional params, so i can scrape it

I need an AI agent that can extract contact data from social media platforms, primarily Instagram, and manage my email marketing tasks. Key Requirements: - Data Extraction: The AI should be able to extract 'Name' and 'Email' from Instagram, FaceBook, Ticktok, X, Youtube and compile this data into a CSV file. - Email Management: It should check for duplicate entries and manage email campaigns, sorting emails based on their status (with a focus on 'Opened'). It should have the ability to send emails in batches. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who can deliver a system th...

...feature-rich coupon code website. The platform will leverage a Headless WordPress setup, where WordPress will serve as the backend and the frontend will be developed entirely in JavaScript. This is a high-priority project, and we require someone who can work in a pair programming mode with our team. We are looking to build a GrabOn-like coupon code website that utilizes Firebase as the primary backend (including notifications and all relevant Firebase modules), paired with a modern JavaScript frontend (e.g., , Node.js) for superior performance and scalability. Additionally, WordPress will serve as an admin panel purely for managing content, while the core business logic and data handling will reside in Firebase. Project Overview We aim to create a sleek, modern coupon...

Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium). Provide a final bid upfront.

I'm seeking a skilled mobile app developer to create a QR code printing application that operates on both iOS and Android platforms. The app should be capable of generating and scanning QR codes, with a specific focus on QR codes containing contact information. Key Features: - Cross-platform compatibility (iOS and Android) - QR code generation (specifically for contact information) - QR code scanning capabilities - Printing functionality Ideal Skills and Experience: - Proficient in mobile app development for both iOS and Android - Experience in creating apps with QR code functionality - Knowledge of handling contact information in QR codes - Prior work with printing functionality in mobile apps Please provide examples of similar apps you have developed ...

I'm looking for a WordPress developer with a strong design sensibility to help me improve a few parts of my website. The components to be redesigned and delivered as coded components are: - The **booking form**: The goal here is to enhance the visual design to a modern and clean aesthetic. The form should also be optimized for ease of use and quick submission. - The **car blocks** on the homepage: These should be visually appealing and consistent with the overall modern and clean style. - The **price list** on the car page: This component should be redesigned to improve its visual appeal and usability. Ideal candidates for this project will have: - Extensive experience with WordPress development - Strong skills in web design, particularly in creating modern and clean layouts - A...

I am seeking assistance with preparing for a data science interview, specifically focusing on technical questions. Key Areas of Focus: - Machine Learning - Statistical Analysis - Data Visualization - SQL Please note that I prefer the technical questions to be scenario-based. Your expertise in these areas will be invaluable in helping me succeed.

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

Sila Dafter atau Log masuk untuk melihat butiran.

I need a skilled graphic designer to create a classic-style design for a double-sided restaurant menu. The specific menu content will be provided in a Word document. Ideal Skills: - Proficient in Adobe Illustrator, InDesign or similar design software - Strong understanding of classic design aesthetics - Prior experience in restaurant menu design - Excellent attention to detail

...are seeking a part-time backend developer with expertise in PHP and SQL to maintain our APIs and build internal dashboards for operational and analytical purposes. Knowledge of Shopify Store APIs is a strong advantage. Responsibilities: Maintain, optimize, and troubleshoot our existing APIs. Develop internal dashboards to streamline operations and provide insights. Ensure seamless integration between Shopify APIs and our backend systems. Implement backend improvements for performance and scalability. Debug and fix backend-related issues as they arise. Collaborate with the team to implement new features or updates as needed. Requirements: Proven experience in backend development, with strong skills in PHP and SQL. Familiarity with RESTful APIs and their integrati...

...seeking a part-time backend developer with expertise in PHP and SQL to maintain our APIs and build internal dashboards for operational and analytical purposes. Knowledge of Shopify Store APIs is a strong advantage. Responsibilities: - Maintain, optimize, and troubleshoot our existing APIs. - Develop internal dashboards to streamline operations and provide insights. - Ensure seamless integration between Shopify APIs and our backend systems. - Implement backend improvements for performance and scalability. - Debug and fix backend-related issues as they arise. - Collaborate with the team to implement new features or updates as needed. Requirements: - Proven experience in backend development, with strong skills in PHP and SQL. - Familiarity with RESTful APIs ...

...Mobile responsiveness for user convenience - A review and rating system for spots and users Ideal Candidate Should Have: - Proven experience in full-stack web development - Strong knowledge of front-end technologies (HTML, CSS, JavaScript) and frameworks (React, Angular, Vue, etc.) - Familiarity with back-end development (Node.js, Ruby on Rails, Django, etc.) - Experience with database management (SQL, MongoDB) - Ability to implement interactive maps using APIs (Google Maps, Mapbox) - Knowledge of payment gateway integration (Stripe, PayPal) - Commitment to developing a user-friendly interface and seamless user experience This project will require someone who is not only technically skilled but also creative and insightful when it comes to user experience design. I look forward...

...classify URLs as phishing or legitimate using data from PhishTank and other sources. User Interface: A simple and user-friendly form where users can input a URL and receive a clear phishing or legitimate verdict. Phase 2: Browser Extension Real-time analysis of visited websites: Perform content and URL analysis in the background. Display warnings for suspicious websites. Email header analysis: Extract email headers to detect spoofing attempts. Analyze links in emails using the same ML model. Technology Requirements: Frontend: Modern and responsive web design (e.g., React, HTML/CSS/JS). Backend: Python/Flask or Node.js for feature extraction and API integration. Machine Learning: Use libraries such as TensorFlow or scikit-learn for model development. APIs: Integrate PhishTank, Wh...

I have a code and I need to implement the following steps: Install Node.js and NPM if you haven't already. Set up a new React app using create-react-app. Install dependencies like Material UI and axios. Add the code I provided in the appropriate files in your React app. Optionally, set up a backend API to interact with the AI engines. Run the React app and test the search functionality.

Code analysis, problem correction, first try

i have understood completely sir i am start working after accepting this quote

Job Title: Freelance Full-Stack Developer About Us: We are a pre-seed startup progressing toward our MVP, a dy...development using Node.js and familiarity with Java. • Knowledge of working with APIs, including: o Integrating third-party APIs into the application. o Creating RESTful APIs for connecting the front-end and back-end. o Handling API security and authentication (e.g., OAuth, API keys). • Familiarity with Figma for interpreting and implementing design prototypes. • Understanding of databases (e.g., MongoDB, SQL) and cloud platforms. • AI knowledge is a bonus but not required for the MVP stage. • Ability to quickly learn and adapt to an existing codebase. • Excellent communication and problem-solving skills. The project budget will be determine...

I'm looking for a skilled software developer to create a kiosk-based application. This app should have distinct backend and frontend f...roles: office personnel, vehicle owners, and administrators. - An interface for office personnel to input and manage vehicle data. - A user-friendly frontend for vehicle owners to access and pay towing fees. - Integration with a Pax A920 payment terminal for seamless transactions. The application should use an SQL database for managing vehicle and towing fee data. The ideal candidate should have: - Proven experience in developing kiosk-based applications. - Strong expertise in SQL database management. - Skills in creating secure user authentication systems. - Experience in integrating software with payment terminals. Looking forward t...

There is a repository on github that contains the Whaticket code with some modifications. This code includes a connection to Facebook, Instagram and has a native integrated flowbuild. I am having a lot of difficulty installing it on my Hetzner VPS server. I need a programmer who can get the repository and get it running perfectly. If someone already has another more complete Whaticket code with more features, we can negotiate.

I need an experienced server technician to upgrade my current Server 2008r2 to Server 2012r2 and then to Server 2025. The upgrade should be seamless with all current components and services preserved. The services running on the Server 2008r2 include Active Directory, File Server, and SQL Server. Key Requirements: - Expert in server upgrades and migrations - Knowledgeable in preserving server components and services - Capable of re-adding Remote Desktop Services post upgrade Post-upgrade, I will need Remote Desktop Services updated to allow remote access for employees, as well as the license server and licenses. I also require all configurations and settings, including Group Policies, User Accounts, and Software Applications, to be migrated during the server upgrade. Plea...

I am seeking a skilled Python developer to enhance my web scraping code. The primary focus is to improve the accuracy of the data being collected. The code currently scrapes textual data from various websites. Key Requirements: - Expertise in Python, specifically in web scraping libraries such as BeautifulSoup, Scrapy, or Selenium. - Proven track record of improving code accuracy. - Experience with web data extraction. Please provide examples of your previous work in your proposal.

I need assistance troubleshooting and correcting some Arduino code. The code is supposed to turn on a small pump and keep it running until a set conductivity threshold (780) is reached in the water. This is part of a larger science fair project focused on Diabetes. Ideal Skills: - Proficient in Arduino programming - Experienced in troubleshooting and correcting code - Knowledgeable about conductivity sensors The task should be relatively quick and straightforward for someone with the right skills and experience. Please reach out if you can help. Thank you!

...company) to support efforts to improve data quality, accuracy, and reliability. A strong understanding of data quality principles and data cleansing techniques is required. You will be leveraging your expertise in data management, as well as your understanding of the bank's systems and data models, to identify and resolve data inconsistencies. The role requires proficiency in SQL and Python, as well as experience with SQL-based data manipulation and analysis. We are planning to sign a contract with a starting date of February with a multi-month engagement, up to 12 months - it will not be a permanent hiring contract. The project will be during working hours. Key responsibilities include: - Enhancing data quality and reducing deficiencies. ...

Design and implement the image upload and preview functionality. Integrate Google Cloud Vision API to extract text content and bounding box coordinates from uploaded images.

...explaining complex concepts clearly and effectively. Training Objectives: • Apply DDD principles using within a .NET framework. • Cover all listed main and subtopics with practical exercises to enhance understanding and application. • Equip participants with skills to set up, develop, and deploy applications using the discussed frameworks. Programming Tools: • Visual Studio Code or JetBrains Rider for code development. • Postman for API testing and interaction. • Docker for containerization and environment management. • Additional tools may include Git for version control and Azure DevOps for continuous integration and delivery. Main and Subtopics: 1. Overview of .NET 2. The .NET Application 3. Classes and Objects 4. Instance Constr...

What is possible with AI? I have a list of actors/actresses and want to get detailed biographies. I have a list of movies and want to get details about plot, writer, director, cast, poster and so on. Input format is CSV. Output format is SQL. I have thousands of movie clips and would love to get short descriptions on what can be seen. Not transcriptions - descriptions please. I have a 4090 from Nvidia and a lot of time to process these tasks. What is possible? I already run CrewAI scripts but the accuracy is poor. Can it be done better? Get in contact with me to discuss all of this or just one part of it.

I am seeking a Python expert to help me review my code. Ideal skills and experience: - Strong proficiency in Python - Experience in code review - Ability to identify and suggest improvements - Excellent communication skills

Sila Dafter atau Log masuk untuk melihat butiran.

I need a freelancer to help me restore a MySQL database using .SDI, .MYD, and .MYI files. The job involves restoring the tables, f...involves restoring the tables, fixing potential errors, and ensuring the data is accessible. After the restoration, I also need a backup in SQL format. Key tasks: - Restore the database accurately - Fix any possible errors - Ensure data accessibility I have complete documentation on the database schema, so you'll have all the necessary information to complete the task. The SQL backup must be: - Compatible with MySQL 8.0 Ideal skills and experience: - Extensive knowledge and experience with MySQL - Proficient in working with .SDI, .MYD, and .MYI files - Experience in database restoration and error fixing - Ability to create a MySQL 8.0 ...

I have a Docker Image which contain mysql database image I need someone who is good at Docker, who should install this Docker Image and export data from the Database. I need at the end complete data from Database as .sql file

...readable format (preferably PDF, but TXT or similar is acceptable). 2. Attachments: • Extract and save attachments into a separate folder for each email account. 3. Custom Time Filter: • For some accounts, only emails and attachments older than 4 years need to be saved. 4. Preferred Storage Solution: • Use a shared Dropbox folder to organize and upload the data. This will allow seamless syncing and access to the output. Access Details: • I will provide SMTP/IMAP addresses, usernames, and passwords for all accounts. Skills Required: • Familiarity with email clients, IMAP/SMTP protocols, or tools/scripts for bulk email downloading. • Ability to convert email contents into readable formats (PDF/TXT). • File organization and atten...

My Streamlit-based Python project has maintainability issues and a few UI bugs that need fixing. The code requires refactoring for better maintainability, and there are a couple of UI components that aren't working correctly. Key Requirements: - Refactor the existing Python code to improve maintainability. - Fix UI bugs affecting buttons and the layout. - Address layout issues including misalignment and overflowing content. The ideal freelancer for this project should have extensive experience with Python and Streamlit, a deep understanding of code maintainability, and a keen eye for UI/UX issues. Your ability to deliver a well-structured, maintainable codebase and a smooth-functioning, properly aligned user interface will be crucial for the success of this pro...