Etl transform excelроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I'm in need of a stellar video editor well-versed in crafting promotional videos with a cinematic style. Your editing expertise will transform raw footage into a compelling, dynamic video with: - The effective integration of special effects to make the video visually striking - Skillful syncing of background music to enhance the mood and message of the video Ideal candidates should have significant background in video editing, particularly in producing promotional content. Impress me with your knack for cinematic aesthetics and ability to incorporate sound and visuals that captivate our target audience.
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancemen...
I'm in need of an experienced architect or interior designer who can create a detailed renovation plan for my old waterfront home in Annapolis, Maryland. The property has gotten into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, which stands at 1300 sq ft, requires a full overhaul to bring it up to modern standards. This includes but is not limited to, flooring, walls, ceilings, and fixtures. - Exterior Painting: The exterior of the house will need a fresh coat of paint to restore it to its former glory and protect it against the elements. - Kitchen Renovation: A complete modernization of the kitchen is necessary to make the s...
I'm in need of an experienced web designer to overhaul my website's outdated look and slow loading speed, while keeping it professional and authoritative. Key Requirements: - Address the outdated design by implementing modern and sleek design elements. - Optimize the site for faster loading speed. - Maintain a professional an...with my brand's personality. Ideal Skills: - Proven experience in redesigning websites with a focus on improving brand awareness. - Strong web design skills, with a keen eye for modern and sleek design elements. - Proficiency in optimizing websites for faster loading speed. Please include samples of your previous work in your proposal. I look forward to working with a talented designer who can transform my website into a visually appealing, ...
...my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm looking for a skilled proposal writer who can help me transform my plain written Catering proposal on a Word document, along with supplied photos, into a visually striking Business Proposal. The goal is to use design software like InDesign (or your choice) to format the proposal in a modern and professional manner. Key Points: - The design of the Business Proposal should be modern. - It should include high-quality images that I have ready to provide. - The final output of this project should be in a digital format such as a PDF. Ideal Skills and Experience: - Proficiency in InDesign or similar design software. - Experience in creating visually appealing Business Proposals. - Strong eye for modern design and layout. - Ability to work with high-quality images. ...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
I am looking for a skilled Android developer who can create an engaging, robust, and seamless B2B ecommerce application for my cement manufacturing unit. Key Features: - Product Catalog: The app should showcase our comprehensive range of products for easy browsing and selection. - Order Management: A seamless and user-friendly system is required for orde...transporting bulk orders. User Role: The app should be built primarily for an administrator role, with the potential to expand to supplier and customer roles in the future. Please note, prior background in developing applications in manufacturing industry will be advantageous. Familiarity with SAP integration is an absolute must. If your expertise aligns with my requirements, get in touch, and let's transform my vision ...
...This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and ma...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient da...
As the main driver of this project, I require a senior machine learning engineer who specializes in working on training Stable Diffusion models. The ideal candidate must have: The ultimate aim is superior task performance, specifically in the realm of Text2Image. We are aiming to improve our system’s cap...learning engineer who specializes in working on training Stable Diffusion models. The ideal candidate must have: The ultimate aim is superior task performance, specifically in the realm of Text2Image. We are aiming to improve our system’s capabilities and exceed our current benchmark. Your role will be pivotal in us achieving this. If you are confident in your ability to develop models that transform the performance capabilities of challenging Text2Image tasks, then ...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
...should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things easier, the filtering of the products could be enabled only for specific categories of products and be presented only on pages of t...
I require a proficient Mandarin to English translator who can transform the content of my business video into English. This includes both generating subtitles that will be added on to the video and a separate transcript. The translator should ideally: - Be fluent in Mandarin and English - Have strong experience in business-related translations - Have a good grasp of translating Mandarin business terminology to English - Experience in adding subtitles to videos The video is in Mandarin and requires exact translation for business purposes. Accuracy is a priority due to the nature of the content.
Pre-teens are a curious bunch, teetering between childhood wonder and teenage independence. Museums, with their vast collections and interactive exhibits, can be the perfect playground to ignite this curiosity and equip them with valuable life skills. But how do we transform a museum visit from a passive stroll to an active learning experience? This blog delves into life skills activities that pre-teens can engage in at museums, turning a casual outing into a springboard for future success. Unleashing the Inner Communicator: Debate Club in the Dioramas: Museums often have dioramas depicting historical events or ecosystems. Divide your pre-teens into groups and assign them opposing viewpoints related to the scene. Encourage them to research and prepare arguments based on the exhibi...
We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Selenium, etc. Solid knowledge of HTML, C...
I'm seeking a creative designer to craft a sleek, minimalist packaging for our screen wipes. The packaging should be designed to box dimensions of 6.3 x 2.5 x 5.2 cm. Key Requirements: - The preferred color ...Ideal Skills: - Proficiency in packaging design, particularly for small boxes. - Strong grasp of minimalist design principles. - Experience in creating visually appealing designs for electronic products. - Solid understanding of color theory and an ability to create a design that is aesthetically pleasing and stands out. This project will suit a designer who can take a straightforward brief and transform it into a visually striking and effective packaging design that perfectly encapsulates the product's purpose. Please include examples of your previous packaging wo...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...and analysis, within a short timeframe. - Entity-Relationship Modeling: Develop and finalize a comprehensive ER diagram that illustrates the database structure and supports urgent marketing analytics requirements. - Efficient Data Export and ETL Processes: Set up and manage the rapid export of data from various platforms using APIs. Develop and implement ETL (Extract, Transform, Load) processes to clean, transform, and load data into the database swiftly. - Documentation: Produce concise and clear documentation on the data architecture, ER diagrams, and ETL processes to support ongoing maintenance and scalability. - Collaborative and Rapid Execution: Work closely with the project manager and other team members to ensure alignment of the database design...
...looking for an interior designer to revamp my small living room with an integrated kitchen bar. I'm particularly keen on a modern farmhouse style to add a cozy and contemporary touch to the space. Our space is full of glass window and with tilted ceiling, need something that highlights the space and also cosy we will add a TV on one of the walls ( size 98" inch ). Key Responsibilities: - Transform a small space (less than 500 square feet) into a modern farmhouse style - Design and redecorate the outside cabin living room - Creative integration of a kitchen bar - Ensure stylish and functional layout and interior elements Ideal Skills and Experience: - Proven experience in interior design, particularly with small spaces - Proficiency in modern farmhouse style - Stron...
...individually. b. Assume both CSI and forensics lab operations work 24/7. c. Model precisely ONE WEEK of sampling – any samples that are have not been completely processed by one week are not included in your analysis. d. The unit of time to use in the model is minutes. e. There is one Rapid DNA sequencer, which is only run once all eight spaces in the cartridge are filled with samples. f. You MUST use Excel to model the process. g. You MUST create, develop and save all your work in one file saved on your OneDrive account. There are no exceptions to this. See Saving and Sharing instructions on pages 10-12. 3. Results to find from your “average” model solution: a. To the nearest ten, how many samples will be processed by the end of the seven days? How many ...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accura...
I'm looking for an exceptional editor to turn my raw manuscript into a polished, captivating fiction book. This project is best suited for someone with experience in: - Developmental editing - Creating engaging content for young adults in the fiction genre Your responsibility will involve improving the plot, characters, dialogue, style, and pacing, and not just focusing on spelling and grammar. This project will demand creativity, a strong attention to detail and a good understanding of what young adults find intriguing. Bear in mind that this project is not just about refining the text but also enhancing the overall storytelling. If you're a developmental editor passionate about creating captivating fiction for young adults, do place your bid.
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for an exceptional editor to turn my raw manuscript into a polished, captivating fiction book. This project is best suited for someone with experience in: - Developmental editing - Creating engaging content for young adults in the fiction genre Your responsibility will involve improving the plot, characters, dialogue, style, and pacing, and not just focusing on spelling and grammar. This project will demand creativity, a strong attention to detail and a good understanding of what young adults find intriguing. Bear in mind that this project is not just about refining the text but also enhancing the overall storytelling. If you're a developmental editor passionate about creating captivating fiction for young adults, do place your bid.
I'm excited to transform my residential garden into a private, serene outdoor living space. I envisage a fresh, revitalized scenery that incorporates distinct elements for functionality and aesthetics. • Creating Raised Beds: We require an expert who can strategically place raised beds for optimal growing conditions and visual appeal. Skill in soil and plant selection would be advantageous. We • Tree Planting: I am planning to have 2 trees planted. Your input on species selection and placement for the best outcome given local climate and soil conditions is needed. • Race Jacuzzi Terrace: In addition to the serene greenery, a race jacuzzi terrace will give the perfect touch to my outdoor living space. Experience with integrating such features into a landscape ...
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
