Sql server database connectivity pivot tableJobb

...processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformations Execute SQL procedures and queries in RDS for additional analysis and derived insights. Store final results in the database for website access. RESTful API Development Build a secure RESTful API using AWS API Gateway and Lambda to provide real-time data to the website. Optimize database queries to minimize latency and maximize efficiency. Non-Funct...

Start working laravel deploy on VPS server.

I need help completing a Tableau project. The project includes: 1. Creating a top office table that features the big boss and all higher management, including supervisors and CIOs. 2. Implementing a three-level hierarchy where the top office can see everyone under their line of command, including managers and supervisors. 3. Allowing supervisors and managers to see their respective employees by ID and name. 4. Ensuring that supervisors and managers are also listed as employees under the top officer. 5. Developing a system where each employee can see who their immediate superior is. I am open to suggestions regarding the top office table's content, but ideally, it would include names, roles, and departments. Ideal skills for this project include: - Advanced proficiency in...

I need a seasoned Windows Server Administrator with robust Active Directory management experience. This ongoing project involves configuring group policy for security settings, software installation, and user configurations. Ideal candidates should: - Have in-depth knowledge of Windows Server and Active Directory - Windows OS Hardening - Demonstrable experience in Group Policy configuration - Ability to ensure compliance with security protocols - Proficient in managing software installation through group policies - Skilled in user configuration settings Your role will be pivotal in enhancing our server environment's operational efficiency and security.

I need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.

preciso de uma pessoa perfeita para entendimento de servidores

We are looking for a creative and professional logo and app icon for our platform, Cereale App, a marketplace for buying and selling cereals. The design should reflect the essence of our application: simplicity, connection, and agricultural innov...like "Cereale de vânzare". It should convey trust, professionalism, and relevance to the agricultural/cereal market. The app icon must be visually distinct and recognizable, working well in both small and large sizes. Deliverables must include vector formats (e.g., AI, EPS) and standard sizes for app icons. Notes for freelancers: Feel free to explore ideas related to grains, fields, or digital connectivity. Keep the design clean, modern, and professional. Avoid overly complicated details – the logo and icon should st...

Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code and display a warning message, rather tha...

I'm currently grappling with Many-to-Many relationships in Power Pivot, specifically dealing with sales and event data by SKU. My primary aim is to enhance the precision of my data analysis. However, I'm facing difficulties with incorrect data aggregation. I cannot build a relationship from the Proof and Unique Events table in the photo provided. Skills and Experience Needed: - Extensive experience with Power Pivot - Proficient in managing and interpreting sales data - Expert-level understanding of Many-to-Many relationships - Ability to troubleshoot data aggregation issues

Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.

I'm seeking a freelancer to run a Python script that scrapes the entire DataAxle database of 18 million companies. The end goal is a comprehensive spreadsheet that includes all available fields. Example fields include: - Company name and address - Industry and revenue - Number of employees and contact details - SIC Code - SIC Code Description The primary purpose of this data collection is for sales leads generation. Ideal Skills: - Proficiency in Python - Experience with web scraping - Familiarity with DataAxle or similar databases - Ability to generate clean and comprehensive spreadsheets - Understanding of sales lead criteria

I require a seasoned Network Administrator to assist with managing my Linux server. The primary task involves configuring the server to block and allow specific API calls. Ideal Skills: - Extensive experience with Linux servers - Proficient in network administration - Familiar with various API types (REST, SOAP, GraphQL) - Knowledge of server firewall tools (iptables, UFW, Firewalld) - Strong problem-solving skills

I'm seeking an Android app developer who can create a application for statistical analysis. This app should allow users to input data through a simple form and receive output ranging from basic summary statistics to various hypothesis tests. Key Features: - Data Input: Users should be able to input data in the form of a list or table via a simple form. - Statistical Output: The app should compute and display basic summary statistics (mean, median, mode, variance etc.) and the results of hypothesis tests (t tests, chi square tests, ANOVA etc.) as a text summary. Ideal Skills: - Proficiency in Android app development. - Experience with statistical analysis software/tools.

Website Revamp with New UI/UX Design I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained

...programmer for native Android development. The task at hand is to create a client-server application for managing mobile clients. It's crucial that you have substantial experience working on such applications. Key Requirements: - Expertise in Java or Kotlin for Android development - Proven track record of developing client-server applications - Immediate availability for urgent project commencement In this long-term project, there's potential for permanent hiring. I will consider professionals who demonstrate commitment, deliver quality work, and have sufficient availability to dedicate to this project. Please note, the specifics of the application functionalities, the type of database to be used, and the method of server interaction have yet to...

I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access

I have several Excel/CSV files containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data ...containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data accuracy. - Experience with data entry and database m...

I'm seeking a professional to assist with migrating my Laravel website to a dedicated server. The job includes transferring the database and pointing my existing domain to this new hosting server. Key Responsibilities: - Migrate Laravel website to a dedicated server - Transfer the database - Point existing domain to the new server - Update the Laravel framework during the migration - Implement specific server configurations as required Ideal Candidates Should Have: - Extensive experience with Laravel and server migrations - Proficiency in configuring dedicated servers - Capability to update the Laravel framework - Knowledge of required specific configurations - Excellent problem-solving skills to ensure a smooth transition

...creation, participation, and resolution of disputes, along with strict adherence to security measures. The backend should be robust, efficient, and secure, supporting APIs tailored for the roles. Frontend elements will ensure user-friendly interactions for Players, Admins, and Super Admins. Key Project Requirements: Roles and Access: 1. Players: ◦ OAuth-based login system (Google). ◦ Separate database table for Players for added security. 2. Admins: ◦ Email-password authentication. ◦ Manage player disputes and KYC processes. 3. Super Admins: ◦ Same login flow as Admins. ◦ Elevated permissions for dispute resolution and platform oversight. Features for Players: 1. Authentication: ◦ OAuth-based login (Google) (Already Implemented). ◦ Logout functionality (Already Implement...

We are seeking an experienced Excel expert to assist in developing a dynamic and user-friendly Excel dashboard or summary tab for our HR team. The project will involve leveraging pivot tables and other advanced Excel functionalities to create an interactive and automated reporting tool that provides clear insights into key HR metrics. The ideal candidate will have a strong background in data visualization, formula optimization, and dashboard design to ensure efficiency, accuracy, and ease of use. Our goal is to enhance data analysis and reporting capabilities, allowing the HR team to make informed decisions effectively. Delivery flexible but ideally within 2 or 3 weeks

I am in need of a skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secur...skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secure. - Performance monitoring: Keeping an eye on server performance and addressing any issues that arise. Ideal Skills and Experience: - Extensive experience with Linux and Ubuntu server maintenance. - Proficiency in performing regular updates and patching. - Strong skills in monitoring server performance. I'm looking for someone who can keep my servers running smoothly and securely. Your expertise will be crucial in maintaining the health...

I'm in urgent need of a cyber security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be applicable. Thank you.

I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques

...Achievements: Document Creation and Formatting: Created and formatted professional documents, reports, and proposals using Microsoft Word. Implemented advanced formatting techniques and customized templates to ensure consistency and professionalism. Data Analysis and Visualization: Developed complex spreadsheets in Excel to analyze financial data, track budgets, and visualize trends. Utilized formulas, pivot tables, and charts to provide actionable insights and support decision-making. Presentation Design: Designed engaging and visually appealing presentations using PowerPoint. Incorporated multimedia elements and custom templates to effectively communicate key messages and captivate the audience. Email and Calendar Management: Managed email communications and organized calen...

I'm looking for a Typescript expert to write Typescript serverless functions to: OLD SYSTEM -> Webhook -> Serverless Function -> New Database and OLD SYSTEM <-> Crap API <-> Serverless Function <-> New Database Bidirectional sync Webhook includes the data that needs to be updated in a timely manner Crap API can sync other data (non-timely) and verify the webhook data was correct to update periodically Challenges include: - Inconsistent webhook formats - Unreliable API behavior of old system - Token management of old system API Technical Stack: - Serverless Functions - Database - Modern TypeScript Deliverables: 1. New Database configured with schema and operational 2. Working and fully tested serverless functions - Webhook Han...

I need an expert to update my iOS app Carplay improvement. Carplay works but there are some problems. i need standalone working support for carplay, when user dont open app on device, carplay cant fetch content(radio) and cant play. The project entails: - Improving carplay - Fixing issues - Updating deprecated AP...problems. i need standalone working support for carplay, when user dont open app on device, carplay cant fetch content(radio) and cant play. The project entails: - Improving carplay - Fixing issues - Updating deprecated APIs - Updating deprecated codes It is crucial that you have extensive experience with iOS development and Carplay integration. Familiarity with identifying and rectifying connectivity issues within Carplay is highly desirable. I look forward to your...

I'm looking for an expert who can help me visualize my 2D apartment layout in a modern 3D format. Key Tasks: - Suggest ways to enclose a specific area for a small, work-from-home office. - Provide a 3D representation of how the kitchen, kitchen island, dining table, and living room could look, focusing on modern design aesthetics. - Pay special attention to furniture placement, ensuring optimal space utilization. Ideal Skills: - Proficiency in 3D modeling software (like SketchUp, AutoCAD, etc.) - Strong understanding of modern design principles. - Excellent spatial awareness and visualization skills. This project will help me understand the potential of my apartment and make informed decisions about my space.

I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.

...metadata via a user-friendly web interface, and using OpenAI's embedding with a vector database and GPT APIs to retrieve and generate new content. This will be a new independent prorotype project to get the integrations and workflow set up and working correctly. Full-Stack Developer (Preferred One-Dev Solution) Responsibilities: Develop and maintain a backend pipeline to: - Scrape and preprocess data from client websites. - Chunk content into JSON packets and prepare it for tagging. - Integrate with Supabase for data storage. Build a simple web app for manual metadata tagging: - Design a clean UI for reviewing and tagging content. - Integrate pre-defined tag options for consistency. Set up a vector database for semantic search. Integrate OpenAI’s text-emb...

I'm looking for a skilled Snowflake developer with extensive experience in data warehousing. The project involves integrating various data sources, primarily AWS S3 and SQL databases, with Snowflake. Key Responsibilities: - Data Warehousing: You'll be primarily focusing on the data warehousing aspect of Snowflake. - Data Integration: Integrating AWS S3, SQL databases, DBT, and Snowpark with Snowflake. - Data Transformation: Your main use of dbt will be for data transformation. Ideal Skills: - Proficient in Snowflake, dbt, and AWS. - Experience with data warehousing and integration. - Hands-on experience with live projects using these technologies. - Strong understanding of data transformation processes. Successful candidates will have previous experience working...

I need a designer to help me visualize a modern kitchen with a black and stainless steel color scheme for a potential apartment purchase. The design should in...need a designer to help me visualize a modern kitchen with a black and stainless steel color scheme for a potential apartment purchase. The design should include a kitchen island with extra seating and storage, as well as a dining table and a small office area in the open space. Ideal Skills: - Interior Design - 3D Modelling - Space Planning - CAD Software Proficiency Requirements: - Create a modern style kitchen visualization - Use a black and stainless steel color scheme - Design a kitchen island with additional seating and extra storage - Incorporate a dining table - Propose a design for a small office space wit...

I need a Python Data Analyst skilled in processing data from an SQL database and conducting descriptive statistics.

16. Production Planning Objective The elaboration on this point should answer the following questions: How many machines and assembly places do you need from which kind? Please consider a r...necessary takt time Selection of suitable machines Estimation/Assumption about necessary production time per piece Assumption of a reasonable OEE Definition of Lotsizes (if necessary) Calculation of necessary machinary Assumption of assembly times and equipment Expected results Table with necessary manufacturing times per piece an the referring calcluation Table with the necessary number of machines and the referring calculation Flow chart for the assembly operations including necessary assembly times and workforce Table with the necessary workforce An exact floorplan / factory ...

...items. Testimonials Section: Placeholder for user feedback. Call-to-Action Section: Encourage users to sign up for free access, login, contact us. Comparison Page: A page that dynamically displays comparison results based on API data. Key features: List View: Display items matching the search query. Filters: Allow users to filter results by parameters like price, rating, or features. Comparison Table: Detailed comparison of attributes such as cost, features, and ratings. Action Buttons: "Learn More" or "Contact" buttons for each option. we can discuss this in detail after project allocation. Technical Requirements: Frontend Framework: React.js. API Integration: Fetch and display data from provided REST APIs. Responsive Design: Ensure optimal performance ac...

...web-based systems. -- Work on web development projects using Python and associated tools. -- Ensure code is scalable, maintainable, and efficient. Required Skills: -- Strong experience in Python (3-5 years). -- Proficient with Selenium WebDriver for web scraping and automation. -- Experience with BeautifulSoup, Requests, Scrapy, and other web scraping frameworks. -- Solid understanding of Databases (SQL/NoSQL) and integrating them with web applications. -- Experience in web development (preferably with frameworks like Django or Flask). -- Strong knowledge of Flutter for mobile development. -- Ability to work independently and deliver quality code within deadlines. Additional Requirements: -- Proven experience of 3-5 years in Python and web development. -- Strong problem-solving...

I need a proficient telecom team to assist with the setup and maintenance of a hybrid network for a small office/home office (SOHO). The project requires a seamless integration of wired and wireless elements to ensure smooth connectivity and optimal performance. Ideal Skills and Experience: - Extensive knowledge in both wired and wireless network configurations - Proven track record in network setup and maintenance - Ability to provide post-setup network support - Excellent troubleshooting skills - Experience with small office/home office (SOHO) network setups

I need assistance with manual data entry into an SQL database. The project involves working with database entries, so experience with SQL and data handling is essential. Ideal Skills: - Proficient in SQL - Manual data entry experience - Attention to detail - Data handling skills - Able to work independently and meet deadlines

I am in need of a Tableau expert to develop a project that visualizes our employee hierarchy and access levels. The project should include the following: 1. A "Top Office" table that encompasses all higher management including the CIO, managers, and supervisors. 2. A three-level visibility system: The "Top Office" can see everything beneath them; supervisors and managers can see their respective employees; and employees can only see their immediate boss. 3. Access control settings that allow for 'Editable for specific roles'. This means that only designated individuals can edit certain parts of the project. Data for this project will be sourced from Excel spreadsheets. It is critical that the freelancer has profound experience with Tableau and is able...

I need a detailed and feature-rich mobile React application. The app will consist of: 1. **First Screen**: A login page followed by an area/table selection interface, utilizing a provided REST interface. 2. **Second Screen**: A dynamic search feature for an inventory database (again using a provided REST interface). This should allow for: - Searching via keystroke or, if possible, an optional 1D or 2D scan. - The display reducing on sub-matches. - User selection of items to add to a list, with an optional position attribute. 3. **List Management**: - Editing the list. - Sending the list using a provided REST interface. - Recalling, editing, and resending lists (recalls via a supplied REST interface). - The list must be scrollable to acc...

...things.  I am looking for someone who can understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new code, but for a specific code if...

I'm seeking a skilled professional who can build a Minecraft Pocket Edition server for hosting various competitions. The server will primarily host PARKOUR PVP TNT RUN events. Key responsibilities: - Create a server with custom rules and settings tailored for these specific competitions. - Ensure the server is robust and can handle multiple players without lag. Ideal skills and experience: - Extensive knowledge of Minecraft Pocket Edition. - Previous experience in setting up Minecraft servers. - Understanding of PvP and parkour mechanics within Minecraft. - Ability to create custom game rules and settings.

I'm looking for a GA4 expert to generate a report that includes the (a) effective user id, (b) page title, and (c) date/time of page visit in a table format. So I can export it. Key Requirements: - Proficient in GA4 with extensive experience in data analysis. - Ability to generate comprehensive reports directly within the GA4 interface. - Skills to filter and segment data (for example, by traffic source). Ideal Skills: - Advanced knowledge of Google Analytics 4 (GA4). - Experience with web traffic analysis. - Proficient in data interpretation and report generation.

I'm seeking an expert in proxy server settings and routing to set up a dedicated proxy on my server. The proxy should be tailored for Instagram and the authentication method must be IP-based. Key Requirements: - Set up a proxy on my dedicated server with IPv6/32 - Proxy should be designed specifically for Instagram - Use of IP-based authentication method If the initial proxy setup proves successful, I will contract you for the creation of additional proxies on the server. Ideal candidates should: - Have extensive experience with proxy server configuration - Be knowledgeable about Instagram's functionalities - Provide high-quality service within a reasonable timeframe Anyone who sends a message to this project, I will come to you privately...

... and resolution of disputes, along with strict adherence to security measures. The backend should be robust, efficient, and secure, supporting APIs tailored for the roles. Frontend elements will ensure user-friendly interactions for Players, Admins, and Super Admins. Key Project Requirements: Roles and Access: 1. Players: ◦ OAuth-based login system (Google). ◦ Separate database table for Players for added security. 2. Admins: ◦ Email-password authentication. ◦ Manage player disputes and KYC processes. 3. Super Admins: ◦ Same login flow as Admins. ◦ Elevated permissions for dispute resolution and platform oversight. Features for Players: 1. Authentication: ◦ OAuth-based login (Google) (Already Impleme...

I need a professional with strong Excel skills to help me analyze sales data using pivot tables in a spreadsheet. The primary aim is to gain insights into sales trends over time. Ideal Skills: - Advanced Excel and Pivot Table expertise - Data analysis experience - Ability to uncover trends and insights from data

I'm looking for a skilled professional to assist in designing a Cloud-on-Ramp service offering for an ISP leveraging/reselling Megaport offerings. This service should be geared towards the needs and capabilities of large corporations. Key aspects of the project: - Prior experience with Megaport and cloud networking services for an ISP offering is key - Str...service should be geared towards the needs and capabilities of large corporations. Key aspects of the project: - Prior experience with Megaport and cloud networking services for an ISP offering is key - Strong understanding of the cloud networking needs of large corporations is a plus. Your expertise will play a crucial role in designing and deploying a market offering and bring cloud-connectivity/networking ...

I'm in need of an Excel template builder who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports ...who can create a template for weekly reports concerning employee shift schedules. The primary focus of these reports will be on scheduling management. Key Requirements: - Build an Excel template that can track employee shift schedules on a weekly basis. - The template should be user-friendly and easy to update with new data. Ideal Skills: - Proficiency in Excel and its advanced features (like pivot tables, VLOOKUP, etc.) - Experience in designing Excel templates. - Understanding of scheduling management. I am looking for someone who can complete this task efficiently and accurately, allowing for smooth tracking of e...

I need a skilled professional to install XUI Panel on my Ubuntu Linux server and integrate it with Plex. The installation will need to accommodate custom user permissions, so expertise in setting user permissions within XUI Panel is crucial. Key Requirements: - Proficient in Ubuntu Linux system - Experienced in installing XUI Panel and Plex server - Able to configure custom user permissions in XUI Panel - Knowledgeable in Linux security best practices Please provide evidence of similar projects you've completed. Thank you.

We have 2 SQL databases. A source database and a target database that have completely different structures (tables, field names/types and relations). We're doing some migration planning from source to target and need some consulting advice on how to best map tables and fields for ETL migration. We are looking for a solution that uses AI and/or ML to avoid doing this all manually the schema mapping. Please put "SCHEMA123" at the start of your proposal so we can filter out automated responses. Please list any details of your experience in doing a project like this. Thanks!

...looking for a designer to help gives us a design as a physical representation of the layout of the pipes and where the irrigation systems placed, all the tanks piped in, pump placement, along with a material list, I will attach some examples I need an expert who can help with the overall design layout, including light and table placement, equipment positioning, and irrigation system design. Key requirements: - Design an efficient light layout - Strategically plan table and equipment placement - Create a reliable and effective irrigation system...