Sql functions for data analysis jobs
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into...information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or ...
I'm a BCA student with proficient skills in Microsoft Office, Access, Oracle & my SQL. I'm currently seeking a freelancer with advanced data entry proficiency to assist with data entry tasks. Specifically, I need help with: - Entering data into a document - Ensuring that the document has advanced formatting requirements, including tables, charts, and images Ideal skills and experience for this job include: - Proficiency in MS Office Suite (Word, Excel, PowerPoint, Access) - Experience with advanced document formatting - Attention to detail - Ability to work with data accurately and efficiently Please note that while my project is mainly focused on data entry, a background in database management and SQL will be con...
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.
I'm in need of a specialist in data analysis, specifically predictive analysis. The purpose of this project is to generate a sales forecast derived from publicly available data. The resulting prediction should aid in budget planning, identifying sales trends, and setting sales targets. IN NEED OF A DATA ANALYSIS PROJECT FOR PREDICTING SALES Ideal Skills and Experience: - Expertise in predictive analysis - Proficient in analyzing publicly available data - Indepth understanding of sales forecasting - Strong statistical and mathematical skills
I'm looking for an experienced Python developer who has previously worked with options Greeks and the Zerodha API. Your main tasks will involve: - add third order greeks to an existing code The ideal candidate should have a strong command over Python, especially the Pandas library, and a thorough understanding of financial markets, particularly options Greeks. Prior experience working with the Zerodha API will be highly beneficial for this role. I look forward to your proposals!
I'm seeking a proficient freelancer to assist in a straightforward yet critical task. The project involves: - Data Entry: You will be required to input simple text or numbers into an Excel sheet. - Data Collection: Sourcing of data forms part of the project. This encompasses the need to gather the necessary information for the task. The ideal candidate for this role should have: - Strong Excel Skills: Proficiency in Excel is a must. You should be comfortable with data entry and basic functions. - Attention to Detail: Accuracy is paramount in this task. - Research Skills: The ability to efficiently source and collect the required data. Candidates with a track record of completing similar tasks efficiently and effectively will b...
...emerging freelancer specialized in Excel, offering services in data analysis and routine work automation. With academic experience in handling complex Excel functions, I am poised to help clients streamline their operations and uncover valuable insights from their data. Key services include: - Crafting custom Excel spreadsheets for data analysis - Automating repetitive Excel tasks to save time and reduce errors - Analyzing datasets to provide actionable business insights - Creating visually appealing reports and dashboards for easy data interpretation Ideal Project Collaboration: - Clients seeking to improve data management and efficiency through Excel - Projects requiring the transformation of raw data into ...
I am in need of a professional who can create a website that perfectly blends modern and traditional design elements, while focusing on providing an informative experience for my visitors. Key Features and Requirements: - The website is primarily informational in nature, so it must be designed with a user-friendly interface and clear navigation. User should be able to find product description using part number - Required to create a digital product catalogue that can also be downloaded as a PDF booklet - The design should be a seamless integration of modern and traditional styles, ensuring an appealing and unique look that stands out. - It is crucial to include product categories and filters, enabling visitors to easily search and navigate through the content. - The website must a...
As the creator of this project, I'm looking for an AI/ML expert to leverage their skills and experience in object recognition and anomaly detection to analyze various types of video footage - from surveillance videos to live streams and pre-recorded videos. Key responsibilities include: * Implementing object recognition and tracking techniques to detect anomalies. * Ensuring real-time alerts for any suspicious activities, amplifying the safety measures. * Aiming for improved accuracy in detecting potential safety hazards. * Enhancing the efficiency of video footage monitoring and analysis. The ideal candidate should be proficient in AI/ML, with proven experience in object recognition, anomaly detection, and video analytics. The ability to provide real-ti...
...pitch deck for my upcoming event. The purpose of this pitch deck is to attract potential investors. - The ideal candidate should: - Have prior experience in designing pitch decks - Be proficient in creating professional and modern designs - Have experience in incorporating financial projections and market analysis into a visual format - Be able to translate complex data into visually appealing infographics - Be able to adhere to strict timelines and deliver quality work within the given timeframe The pitch deck should include: - Financial Projections: This should clearly and effectively present the financial outlook of the event, making it appealing to potential investors. - Market Analysis: A comprehensive and visually engaging representati...
...Comprehensive Mechanical Design and Technical Drawing for Parasol Mechanism Project Overview: We are seeking a skilled and detail-oriented freelance mechanical engineer or designer to work on a comprehensive mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analys...
I'm looking for a freelancer proficient in Excel for a simple data entry task. The work involves straightforward copytyping of numeric information into an excel sheet. Key requirements include: - Accurate data entry skills - Proficiency in Excel - Attention to detail The project doesn't involve any complex formulas or advanced functions. It's a relatively straightforward task that requires precision and focus. Your role will be to ensure all data is accurately entered into the spreadsheet in a timely and efficient manner. A keen eye for detail and a methodical approach will be crucial for successfully completing this project. Please note that the data entry will be in the form of standard tables, so exp...
I have an edited Excel spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button ...spreadsheet that needs some final touches. I have a macro that needs to be created to hide and unhide rows in the sheet. Key tasks include: - Creating a macro that enables the user to hide and unhide specific rows using a button Ideal Skills: - Expertise in Excel macro creation - Proficient in data manipulation and Excel functions - Experience in creating user-friendly interfaces - Attention to detail to ensure the macro functions correctly and efficiently This project is straightforward and should be quick for...
I'm in need of a skilled Python developer to work on a web scraping project. Key Requirements: - I'm primarily focusing on Web scraping as the main functionality for the project. - You should be well-versed in Python and have a proven track record in data analysis. - Knowledge of web scraping is essential to ensure efficient and reliable data extraction.
...on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills: • Proficient in API development and integration • Practical experience with both Silverstripe and REX Software •...
I'm in need of a skilled Photoshop expert for creative editing on 1-10 photos. Key Requirements: - Creative Expertise: I need someone who can apply advanced photo editing techniques for enhancing the quality and aesthetics of the images. - Attention to Detail: It's crucial that the freelancer pays attention to details to ensure that the edits are flawless and align with my vision. Ideal Skills & Experience: - Proficiency in Photoshop: The freelancer should be well-versed in using Photoshop and have a good understanding of its various tools and functions. - Previous Experience: Experience in creative photo editing and a portfolio of similar projects would be highly beneficial.
I'm in need of a talented individual from Ghana who can assist me with interview transcription and Akan language translation for market research purposes. Required Skills/Experience: - Proficiency in Akan language and English - Experience with market research data collection and transcription - Excellent attention to detail - Ability to maintain confidentiality The candidate should be able to translate interview transcripts from English to Akan, while ensuring the accuracy and quality of the data collected. The collected data will be used for qualitative analysis, so the individual should have a good understanding of the market research process. This project will be ongoing, with the possibility of more work in the future. Experience in m...
I am in need of a skilled investigative journalist with a keen eye for detail, and a tenacious attitude towards unearthing the truth. My project involves delving into some messy details involving freeholder corruption and their lawyer, who had been committing fraud and perjury repeatedly therefore, we can prove it .a background in political and corporate corruption is necessary. Essential Skills: - Investigative Journalism - Political/Corporate corruption exposure - Analysis of legal documents - Interviewing witnesses Project Outline: - The focus will be on exposing corruption within freeholders and their legal advisor. - I offer initial evidence in the form of documents and witness testimonies. - Extracting, corroborating, and confirming the validity of this information wi...
I'm looking for a professional to create a monthly income statement in Excel spreadsheet format. Key Requirements: - The task is to generate an income statement. - The data must be accurate and well-organized. - I would like to have the report in Excel spreadsheet. - The report should be delivered on a monthly basis. Ideal Skills: - Proficiency in financial reporting and analysis. - Advanced Excel skills. - Attention to detail. - Experience in creating income statements. - Timely delivery.
I'm looking for a mechanism design expert who can help me with designing a small mechanism. Your main task will be to provide a detailed force analysis, create a CAD model, present concept sketches, generate a Bill of Materials (BOM), conduct Finite Element Analysis (FEA), and provide cost estimates. Key Responsibilities: - Designing a small mechanism (I will specify details if awarded). - Conducting thorough force analysis to ensure the mechanism's efficiency and safety. - Providing a detailed CAD model of the designed mechanism. - Creating concept sketches for visualization. - Developing a Bill of Materials (BOM) for easy procurement of the required parts. - Performing Finite Element Analysis (FEA) to ensure the mechanism's...
...Our company is seeking an experienced Online Marketing Research Specialist to join our team. Here’s what we’re looking for: Product Research: Dive deep into online products, gathering essential details about features, specifications, and availability. Manufacturers and Suppliers: Identify reliable manufacturers and suppliers, ensuring access to top-quality products. Pricing Insights: Analyze pricing trends to empower informed decision-making. Market Understanding: With a sharp eye for product marketing, provide valuable insights into positioning and promotion strategies. Qualifications: Bachelor’s degree in Marketing, Business, or related field. Proficiency in data analysis tools. Excellent communication skills. Join us in shaping the futu...
I am in search of an experienced SEO professional to help my website gain more v...traffic, search engine rankings, and lead generation - Implement on-page optimization techniques to improve the website's performance on search engines - Conduct detailed technical SEO analysis and suggest/implement changes - Regularly monitor, report, and adjust SEO campaigns for optimal performance Ideal skills and experience: - Proven experience in SEO management with a track record of increasing website traffic, search engine rankings, and lead generation - In-depth understanding of on-page optimization and technical SEO - Excellent analytical skills to measure effectiveness of SEO strategies and make data-driven decisions - Strong communication skills to provide regular update...
I have a bulk of handwritten records that needs to be typed into a spreadsheet. The data will be used for analysis, so accuracy is important, though minor errors are acceptable. Key requirements: - Convert handwritten records into a digital format - Enter the data into a spreadsheet - Ensure moderate accuracy with minimal errors Ideal Skills: - Data Entry - Fast Typing - Attention to Detail - Basic Knowledge in Data Analysis - Experience with Handwritten Data Conversion would be a plus
...need of a Solidworks expert to assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candidates should have a strong background in Solidworks, with extensive experien...
...comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static me...
My goal is to craft a captivating online platf...captivating online platform that will serve as a gallery to exhibit a multitude of art pieces. This webpage will principally serve the following functions: * Display more than 20 works of art * Present an artist's biography * Feature various interview videos Ideal Project Executor: - A freelancer with a keen eye for aesthetics, who can create an attractive and immersive user experience. - Experience in website development that focuses on art or related fields. - Proficiency in efficiently organizing large volumes of content in a neat, user-friendly manner. - Expertise in embedding video content into websites. - A deep understanding of my goals for this project. Looking forward to potential collaborations to ...
...hosting, and your job and its price will be fixed at $25. I won't reply to anyone's bid; I've already wasted a lot of time. Whoever wants to work can create the same product page on their own and bid. I'll talk then, otherwise not." I'm looking for a skilled WordPress developer : I only need one page. It must have a product that functions like this one: I need same website landing page From custom wording to a handcrafted cover, the Personalized High School Diploma for Homeschools is an official document to honor your grad! Homeschool Diploma The product must be customizable with text and adornments that the customer chooses. The most important part is that the customization choices will show on the picture
...user's data is mistakenly being displayed to the first user. This isn't the intended functionality, and I need an experienced developer to solve this issue promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and abl...
Being familiar with grocery industry finances, I need an expert to conduct a detailed analysis regarding a store's annual profitability. This involves but is not confined to: - Breaking down costs and expenses - Calculating and understanding profit margins The ideal professional must have experience in financial data analysis with exquisite accuracy. Favorably, knowledge or background within the grocery retail sector is advantageous. The final analysis report should be delivered in a well-structured PowerPoint presentation that encompasses all key findings. It's important for the report to be clear, and easy to understand for non-finance personnel. I am open for any approaches or suggestions, as long as they fulfill the core object...
I'm in need of an experienced app developer to make updates and improvements in an already built app, and who can seamlessly integrate with the system and other RTOs used in Australia Requirements: - Experti...experienced app developer to make updates and improvements in an already built app, and who can seamlessly integrate with the system and other RTOs used in Australia Requirements: - Expertise in iOS app development - Proficiency in API usage and system integration - Familiarity with Axcelarate is preferable but not required Key Functions: - This application needs to be able to pull and display data from Axcelarate via API. As an app developer applying for this project, you should have a strong grasp of API integration and a proven track record with...
...education to develop an engaging seminar for college students. The aim is not only to build upon their basic understanding of AI, but also to highlight its ethical usage in an academic context and potential repercussions of AI-enabled cheating. Your responsibilities will include: - Creating a comprehensive presentation that explains AI's role in research and data analysis. - Demonstrating how AI can be used effectively for school purposes while also maintaining academic integrity. - Addressing the possible consequences of AI cheating in a straightforward and memorable way. Ideal candidates should have: - A solid background in AI and a deep understanding of its application in education. - Proven experience creating engaging educational content for...
Job Title: Full-Stack Developer for WordPress, .NET Middleware, Azure Integration, and SDK Development Job Overview: We are seeking an experienced Full-Stack Developer to spearhead the development and integration of key system components within our e-commerce platform. The successful candidate will lead initiatives to enhance user interactions by developing a WordPress plugin, building a robust .NET middleware API, and integrating advanced Azure-based messaging services. Additionally, the role involves creating an SDK to facilitate easy integration for third-party AI bot services. This position is crucial for ensuring that our platform not only meets current technological standards but also adapts to future advancements and user needs, enhancing both the scalability a...
...business case and financial analysis document specifically tailored to secure financing and government approval for a real estate project. Key Aspects: - Market Analysis and Trends: The document should provide a thorough examination of the target market's demographics, a comprehensive competitor analysis and an in-depth look at supply and demand dynamics. - Risk Assessment and Mitigation Strategies: I need someone who can analyze potential risks associated with the project and suggest effective mitigation strategies to counteract them. - Projected Financial Performance: The document should include detailed financial projections for the project, outlining expected returns and potential challenges. Ideal Skills and Experience: - Extensive experi...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet....
I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of rental property cash flows.
I'm in need of a skilled Pinescript developer who can perform a thorough clean-up of my codebase. Your primary task will be to remove any unwanted functions or variables from the existing code. Key Responsibilities: - Removing these unwanted elements from the Pinescript code without adding any new features or adding anything Please respond with final offer.
I'm seeking a professional to create an Information Memorandum specifically aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial ...aimed at securing financing from venture capitalists and or private equity. This document should include detailed financial information, such as: - Revenue projections - Profit and loss statement - Balance sheet - Adopt government statistics - Market & Industry Analysis - Design funding models The ideal candidate for this job should have a solid background in finance, business analysis, and experience in creating successful Information Memorandums for the Australian market. They should be able to present complex financial data in a clear and c...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
I'm looking for an experienced app developer who can customize the WoWonder Mobile Apps. Specifically, I need the "Users Nearby" feature to be revamped. Instead of the current functionality, I want users to be displayed in real-time on a map, utilizing Google Maps as the preferred map service. The Wowonder apps information can be found here Key Requirements: - Transform the "Users Nearby" feature into a real-time map display via Google Maps - Integrate user profile previews on the map The ideal candidate would have: - Proficiency in WoWonder Mobile Apps - Extensive experience with Google Maps API - Prior experience with real-time map integration - Strong understanding of
...the field of research methodology. Key Objectives: - Develop a module consisting of 5 to 10 engaging lectures - Covering key topics such as Introduction to Research Methodology, Data Collection Methods, Data Analysis Techniques, Basic Statistics, and Writing Manuscripts for Publication - Ensure the content is beginner-friendly Ideal Skills and Experience: - Experience in developing educational content or courses in the field of research methodology - Strong understanding of research methodology and the ability to simplify complex concepts for beginners - Good knowledge of basic statistics and manuscript writing for publication Your role will involve creating engaging powerpoint presentation. A background in teaching or instructional design wo...
I have a simple python script that interact with an API that takes data from said api and outputs it in a table. The service where I use the API also has a website where I can see in the same table format the exact same data. Pandas know how will help. My problem is that the data from API and from service is mismatching. Your job is too look and identify where the problem is. You will receive both program (simple streamlit app that runs locally) and login details to website to cross check.
I am seeking a proficient Revit and AUTOCAD and ETABS. Looking forward to working with you. Thank you.
...LIMITED RANGE. Your expertise in designing systems with the necessary navigation strategies and motion control algorithms will be required. - Providing real-time position feedback to the user. Your extensive understanding of feedback mechanisms particular to these types of systems is a must. Ideal expertise for the job includes: - Comprehensive knowledge in machine systems control and design. - A thorough understanding of motion control strategies. - A background in data analysis and logs processing. The machine is a Bandsaw to cut small logs into planks. The 2-off, NEMA 23 stepper motor movements are sequential, ie, first one moves then the second stepper moves. The controller is a Raspberry Pi 4, the prefered language is Python. Input to the co...
I'm in search of a talented Angular developer with a keen eye for design for my corporate website. Key Responsibilities: - Designing the webpage layout with a corporate audience in mind - Implementing responsive design to ensure the site functions flawlessly across various devices Ideal candidates should have: - A strong portfolio showcasing their exceptional skills in both Angular and design - Proven experience in creating responsive websites
I ordered a 16’ x 24’ storage shed from Heartland Sheds company, but they could not install it due to my steep slope here. But I already submitted my permit request for it and it was approved. The contractor who supposed to assemble the shed on site suggested to build a cinder block foundation than he could put the shed on it. I did that, but now the building inspector wants me to get an Appendix G form filled out and stamped by a PE to verify the footer and foundation meets NC building codes. Luckily I have plenty of photos and receipts documenting the entire project from excavation to finish. I offer $1,000.00 to get the job done.
...skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task will be to fetch data, analyze it, and p...
