Excel pivot change data source sql jobs
Velocity alert analysis and provide actionable insights. Key requirements include: - Proficient in analyzing velocity alerts using SQL or SPL or Python - Capable of translating data from a word file into actionable insights - Experienced in the field of identity analytics, risk engine, authentication channel for the digital banking platforms - Understanding of Account Takeover (ATO) or digital identity compromise - Leverage known data as it relates to the digital customer identity and risk decisioning. - Analyze data logs from customer authentication channels and digital banking applications for malicious use and bad actors. - Create long-term solutions and automation to processes that can be improved when digital member identity is being utilized. Refer to at...
I'm seeking a professional with exceptional data management and customer after-sales support skills. The selected candidate will be expected to perform the following tasks: Data Entry Tasks: - Data cleaning and organization. - Creating and managing spreadsheets. - Conducting data verification and quality control on all data sets. After-Sales Support: - Managing product troubleshooting. - Overseeing and tracking customer orders. - Handling customer returns and exchanges. Tools Utilized: - Excel for data handling. - Communication via WhatsApp and Facebook for customer support services. The ideal candidate should be proficient in Excel and comfortable using social media platforms such as WhatsApp and Facebook. Previous experi...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and ...
As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...
...looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previou...
I'm looking for a skilled web developer who can assist in updating my landing page. The main goal of this page is to attract and collect information from young adults, so it's crucial that the design is appealing and user-friendly for this demographic group. Key Tasks: - Update the layout: The current layout needs a refresh to make it more engaging and intuitive. - Change the color scheme: A new color palette is needed to better resonate with the target audience. - Add new content: The page needs additional content to better inform and engage young adult users. Ideal Skills and Experience: - Proficient in web development - UI/UX design experience - Understanding of young adult preferences - Strong communication skills - Ability to work collaboratively - Previous expe...
I have an existing website that needs a few minor issues addressed and I'm also looking for the development of both iOS and Android mobile applications. Website Fixes: - Change Homepage: I have a template and I need the homepage to be changed accordingly. - Blog Image & Text: Need to fix the size and text format of the blog images. - Stripe Payment Split: Implement a system for admin commission and payouts to Pujaris. - Duration for Categories: Add a duration for all categories/Pooja and block times accordingly. - Full Front-End Control: Allow for easy front-end changes including menu bar, footer, and banner changes. - Pujari Registration: Implement a user-friendly Pujari registration process. Mobile App Development: - I need mobile applications developed for both iOS and...
I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.
As discussed I have delivered the excel workbook. Thanks!
...the password for an Excel Workbook. It was prepared by an employee who has since left the firm. Note that I am not seeking to have someone recreate this Workbook without the password, but to have the password itself. There are several videos on YouTube about this, but I've had no luck: I've attached the spreadsheet if you want to try. The first person to provide the password will get paid. Just let me know if have it, I'll hire you, and you supply it. PLEASE DO NOT ACCEPT THE PROJECT UNLESS YOU HAVE THE PASSWORD FROM THE ATTACHED SHEET. Key Project Requirements: - Password Recovery: The primary task is to recover the password for an Excel Workbook. Ideal Skills and Experience: - Expertise in Excel Password Recovery - Flexibility
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication ski...
I need a skilled designer to replace the current background on these chairs with a new, realistic outdoor scene. The Project: - The current background of the chairs is an image, and I would like this to be replaced with a realistic outdoor scene. - The outdoor scene should be high quality, detailed and look natural when placed behind the chairs. Skills Required: - Proficiency in photo editing and manipulation. - Ability to create realistic outdoor scenes. - Attention to detail to ensure the scene matches the chair's size and perspective. The ideal freelancer for this project would have experience in similar photo editing tasks, and a strong portfolio that demonstrates their design and editing skills.
I have an existing website that requires an overhaul. I'm looking to change the domain name and revamp the design and functionality of the site. Key Requirements: - Update the design: A fresh colour scheme, a logo redesign, and an improved overall layout are necessary to give the website a modern and professional look. - Enhance the functionality: I want to add a contact form like with earlier site for users to reach out easily and perhaps add social media sharing buttons to improve the site's visibility and user engagement. The ideal freelancer for this project: - Should have experience in website development with a keen eye for design - Familiarity with domain name migration - Proficient in implementing contact forms and integrating social media sharing buttons If y...
...my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience with Minio is an advantage, but not a necessity. This is a great oppo...
I'm looking for a versatile Excel professional. Key Requirements: - Restrict Sheet Access and Hide for specific users - Changes made in the master sheet should be automatically displayed on specific sheet. - When a change is made on the master sheet, the cell should automatically be highlighted in red color. and also reflected in the specific sheet. I am looking for a good english professional . Automatic bidders will be blocked . If you are here type in salut at your beggining of the bid.
It is necessary make some simple changes to a project management application made in Laravel. The change are: Please answer only if have experiences in project management software. And show my the url of similar job made because I don't asign the job without see the real competences
We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...Optimization: Make slight adjustments to existing content to improve visual and typographic consistency. Optimize images and videos to speed up page load times. Post-Launch Maintenance and Support: Provide technical support after integration to resolve any minor issues. Make minor updates as needed based on user feedback. Bookmarks and Hover Effects: Create a bookmark template with a hover effect (color change to green) and show us how to duplicate this process for other pages. Main Objective: Simplify your work so you can focus on important tasks like setting up the forms and making minor adjustments. If you are interested and ready to finalize our website easily and efficiently, please contact us. We are committed to providing all the necessary support to facilitate your wo...
As someone who values efficient and cost-effective operations, I'm intent on leveraging the full potential of my Microsoft SQL Server database. The core of this project involves enhancing performance and decreasing cost. To enrich the function of my database, I'll need an expert who can: - Improve overall performance, guaranteeing smoother, faster operations - Implement strategies for cost reduction without compromising quality and performance The ideal freelancer will be someone with extensive experience in Microsoft SQL Server, superb knowledge in database performance enhancement, and proven strategies for cost-reduction. If you can deliver this, you'd be the perfect fit.
Data entry work from home part Tim e
Perfect english is needed. You need to be able to teach and tutor me in relational data bases and sql. You must be able to share screen and communicate quickly and fast. You must be available from today till 24th of May. I'm looking for an experienced database professional to assist with a relational SQL database project. You will need to assist me to answer questions about the following: The required tasks include: - Relational data bases ( administration, normalisation, sql workbench, my sql, data modelling) - Writing SQL queries - Designing the database schema - Optimizing query performance This project specifically involves MySQL, sql workbench, so proficiency in this database system is a must. The complexity...
I'm looking for a professional who can support me in my Azure Data Factory project. My primary goal is to transform structured data and then load it into Azure SQL Database and visualize it in Power BI. Deal with incremental load, create table relation and contextual data. Skills and Experience: - Proficient in Azure Data Factory - Experience in working with structured data - Expertise in data transformation - Knowledge in loading data into Azure SQL Database - Ability to visualize data in Power BI
Attached is the scope. There will be six images produced, but only the center will change. The sides will stay the same. This is for 6 bronze plaques that will be engraved. The size of the plaques are 8.5" x 22". The minimum pen size / cut / engraving is 1/8". You will have to remove or add detail so that all six images appear to have the same style. Make sure to give your real bid. Thank you for considering this project.
...able to be turned off, accessed or removed without entering the username and password. The user should be able to visit a website to also view the history using their username and password to login. On the web portal, the user should be able to filter by date or activity, such as show everything that happened on the 14/5/2024 or show all instances of Opened Chrome. They should also be able to change their email address and password. We do not need the ability to block or limit anything, just to report. In the admin panel it should show the following: List of users accounts with ability ti view accounts - Reset user's password, etc Number of devices installed Total Number of devices each user has it installed on The app needs to have the following configured: AdMobs Goog...
You need to build a power app for a business process of onboarding, offboarding customers. There is a data...customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital ...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
We are the largest and fastest growing UK charity community delivering support through multiple services via our website. Our website and AI machine learning and GPT are handled by others. We need dev support for the core SQL system and 2 small SQL directories, plus running reports and system admin. We need full stack Microsoft .NET development experience, strong SQL knowledge and exposure to Azure Microsoft services. We require a range of services. We’ll begin with the ad hoc work to begin to build a working relationship and then build that up to the following on an ongoing basis. • Ad hoc tasks for minor tweaks and changes on an ongoing basis. • Larger pieces of work, such as creating a moving from a free to a free and premium versions, with up...
...bug fixes by reviewing code and deploying changes to both Development and Production websites. - Developing a robust back-end, rapid deployment and change management systems to support the website objectives. - Managing GIT Pull request process in BitBucket fro both Development and Production servers (droplets). - Must have docker experience and must be able to assist new developers in local development setup using Docker - Must have social API integration experience and mobile API development experience Key requirements include: - Solid experience in Python and the Django framework 8+ years). - Expertise in relational databases and efficient data handling (Postegres) - Familiarity with web server technologies and cloud services. - Ability to manage back-end changes, me...
...seeking a Business Data Analyst for our team who is willing to work with new beginners in the field. As a Business Data Analyst, you will be responsible for analyzing large datasets, interpreting trends, and providing insights to drive business decisions. The ideal candidate should have a strong analytical mindset, excellent problem-solving skills, and the ability to work collaboratively with a diverse team. Responsibilities: - Collect and analyze data from various sources - Identify patterns, trends, and correlations in datasets - Create reports and dashboards to present findings - Collaborate with cross-functional teams to understand business requirements Required skills: - Strong analytical and problem-solving skills - Proficienc...
...rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Familiar with the nightlife industry...
I'm looking for a tal...specifically aimed at the general public, so it needs to be engaging and user-friendly. Key Requirements: - Modify the content of the provided sample site so that it's a unique site (change many words so it's unique) - Website design experience - Strong HTML skills - Knowledge of responsive design principles - Understanding of user experience The ideal candidate should be able to translate the design into a functional, responsive HTML website. It's important that the design is not only visually appealing, but also optimized for mobile, tablet, and desktop use. Want to make a copy of this site then change the content enough so it's our own, not a copy.
...proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can form basis of design. I...
Looking for WordPress Expert to site change logo. I have minimal html css knowledge I actually Installed a theme from internet but in theme file editor I didn't find a way to change site logo anywhere.
I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to your bids. Thank you.
...of the data engineering project, the types of data sources to be integrated, and the level of data processing required, it's still clear that an accomplished Data Engineer with a vast range of skills and experience is needed for this project. Ideal Skills: - Knowledgeable about data integration, warehousing and building pipelines - Competency in working with various types of data sources including databases, APIs, and files - Proficiency in data transformation, aggregation, and cleaning -Bachelor's degree in Computer Science, Engineering, or related field. -2+ years of experience as a Data Engineer or similar role. -Hands-on experience with PySpark, Scala, and Azure Databricks is required. -Experience with data m...
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project wil...
I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to preserve original formatting in Excel - Excellent English language u...
I'm in need of a skilled professional who can help me generate leads. Unfort...some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in understanding both B2B and B2C lead generation methodologies is also important. Looking f...
I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.
...Development: Create coherent and effective style guides and design systems. - User Experience Optimization: Improve the usability of existing websites to maximize user satisfaction. What We Offer: - Opportunity to work on varied and innovative projects. - Collaborative work environment focused on professional growth. - Remote work flexibility. Required Qualifications: We are seeking specialists who excel in one or more of the listed areas, able to demonstrate skill in translating user insights into designs that clearly communicate and effectively solve problems. Proven experience in UI/UX projects and a portfolio showcasing your skills and success are essential. How to Apply: If you are a UI/UX Design Specialist ready for challenges that drive your creativity and technique, we...
...system in the platform. Customer will buy credits with their credit / bank cards and the credits will be deposited. They will spend their credits by requesting file processes. Also, there will be a shop section in the platform. Customers will be able to buy already uploaded files by admin. Customers shall be able to view their expenses and deposits as a list and that table should be exportable to excel. There will be 3 information pages which customers will be able to search and find for specific information. After you contact, I will explain these pages in detail. For all these functionalities corresppnding admin panel pages are needed. For example: pricing page for file processings, upload page for file requests, upload page for shop, a page to add new vehicles to the syste...
I am looking for a skilled data entry specialist with advanced proficiency in excel. The project at hand is a one-time copy typing task. The task involves: - Entering a variety of data types into an excel spreadsheet (Text, Numbers, and Dates). - Creating a custom excel template with less than 10 columns. Ideal skills and experience for the job include: - Proficiency in using Excel, especially in data entry tasks. - Strong attention to detail to ensure all data is accurately entered. - Experience in creating custom excel templates is an added advantage. Please note, I will provide the document that needs to be copied and expect the resulting spreadsheet to match the information exactly.
...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel fil...
Data Entry Project - I am looking for a freelancer who can assist me with typing work. - The project involves entering data into a spreadsheet or a database. - The ideal candidate should have excellent typing skills and attention to detail. - There is no specific software preference for data cleaning, so the freelancer can use Excel, Python, or any other tool they are comfortable with. - The dataset contains 100-500 records or entries. - The project requires accuracy and efficiency in data entry. - Experience in data analysis would be a plus, but not mandatory. - The freelancer should be able to complete the task within the specified timeframe. - Good communication skills and the ability to follow instructions are important. - This is a one-time p...
want an excel expert for google excel sheet, who can make raw material data entry for purchase of raw material stock add and when someone uses it then particular raw material to be subtracted from that item two sheets one is for list of items & another is for entry
Laravel who can start immediately. Work with ftp only. Import excel work
Yesterday, OpenAI released the new module "ChatGPT 4.0". I want to create a video on how to automate and visualize Excel files using this new version. The thumbnail should include my face, the Excel logo, the OpenAI logo, and the text "Automate Excel with ChatGPT 4.0".
I am in need of a professional web scraper with Python expertise, who can scrape data from a website(with filter Options) and convert it into Excel format. Key Requirements: - Expertise in web scraping with Python, including dealing with website search filters. - Proficiency in data extraction and manipulation. - Experience in converting extracted data into Excel format. Please note that the specific website and the type of data to be extracted has not been provided as it was skipped by me. The project can be detailed further with the selected freelancer. If you have the skills and experience in this area, please do apply.
