Procesamiento de datos Jobs

Ayuda para entender algunos temas especificos basicos de power bi y como generar graficos correctamente.

Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento

Se trata de generar informes de ventas en Excel desde un archivo madre, también en Excel

EXCEL. Preferencia: Google Sheets. Tengo una sola hoja con varias columnas: Conjunto 1: columna 1 "Activo" tienen nombres que pueden repetirse. columna 2 "Categoria". tienen clasificaciones. Conjunto 2: columna 3 "Titulo" tiene nombres de Clasificaciones. columna 4 "Categoria de Activo 1" a columna 11 "Categoria de Activo 8". columna 12 a 31 "" y "" con pasos de suma 1 en 1, portan valores numericos del 0 a 5. columna 32 a 41 "D1" con paso de suma 1 en 1. Relaciones: + columna 1, 2 y 32 a 41 estan relacionadas. + columna 3, 4 a 11, 12 a 31 estan relacionadas. Se necesita crear una tabla dinamica donde aparesca cada dato de "Activo" donde se halla una coincidencia "Categoria" con "...

EXCEL COSTOS Y PRECIOS EN base al tipo de producto QUE SE ENUMERARARAN DEL 1 AL 10 (ELECTRONICA, SOFTWARE, ETC) , peso , volumen y costo pagamos unos ciertos impuestos de importacion SEGUN EL TIPO DE PRODUCTO NOSOTROS QUEREMOS QUE EN BASE A ESTOS DATOS QUE VAMOS A PREFIJAR PARA CADA CATEGORIA , YA NOS DE EL COSTO , CUANDO EGREGUEMOS PRODUCTOS NUEVOS COMPLENTANDO LA TABLA. CON LOS COSTOS DE ESTA TABLA , NECESITAMOS OTRA TABLA PARA CALCULAR MARGEN DE GANANCIA TOMANDO EL PRECIO DEL PRODUCTO Y NOSOTROS PODER SETEAR UN MARGEN MODIFICABLE PARA CADA ARTICULO DE NUESTRA TIENDA, ESTOS TIENE UNOS COSTOS FIJOS (FEE FIJO DE VENTA , GASTOS DE ENVIO , COMISIONES DE PLATAFORMA QUE VARIAN) ADEMAS NECESITAMOS QUE EN ESTA TABLA SE PUEDAN HACER ¨COMBOS¨ ES DECIR PONER VARIOS PRODUTOS Y QUE CALC...

Hola, estoy en la búsqueda de un book keeper con excelentes habilidades utilizando macros en excel esto es una de las habilidades importantes que me están pidiendo en el freelancer, indispensable también que tenga experiencia haciendo los libros para negocios en Canadá. Comunicación excelente en inglés. Me gustaría oír de ti. Saludos

Buenas tardes tengo un Excel de facturación y cobranza , incluye devoluciones y transferencias de productos . Deseo que se traslade tal cual como funciona a un sitio web con usuarios , permisos

Presupuesto 9 dólares Realizar una hoja de calculo que me arroje el puntaje y la posicion de una oferta respecto a las otras deacuerdo a unas formulas que asignan puntaje deacuerdo al valor que oferten

Se necesita personal para delegar tareas sencillas administrativas: manejar email, hacer llamadas para informar a clientes (no ventas), y otras tareas típicas de secretariado. Tendrás una persona contigo dándote el training así como módulos de aprendizaje de tus tareas. 1. Manejo de Office (Outlook, Excel y Word). Indicar si sabes usar y configurar cuentas en MS Outlook. 2. Horario compatible con España - GMT+1 (tienes que tener disponibilidad desde las 12 en la mañana) 3. Voz agradable, simpática. De atención al cliente. 4. Indicar experiencia en redes sociales, cuales tienes y qué has hecho con ellas ¿solo uso personal o para alguna empresa? 5. ¿Qué resultados lograste en términos de creci...

El objetivo es mejorar y automatizar una planilla de planificación y gestión de producciones de ropa en Google Sheet. Objetivos específicos. 1.-hoja COPIA PLANILLA PILOTO (Planilla de planificación/Leadtime): Incluir fórmulas que arrojen fechas de cumplimiento según la etapa en la que va en 2.- hoja DASHBOARD: automatizar el prototipo de dashboard según los tiempos de ejecución de la planilla de planificación. 3.- hoja Gantt corte y talleres. Crear visualmente un diagrama de los cortes de tela y de los talleres de producción para mejorar el control El avance es de un 60% Necesitaré una visión de un programador que tengas sugerencias de mejora como por ejemplo integrarlo con power BI Adjunto archivo...

Estoy buscando un experto en Excel para realizar cálculos de ventas y rendimiento. Es importante que el freelancer tenga un sólido conocimiento en: - Realización de cálculos en planillas de cálculo Excel. - Generación de informes de ventas y análisis de rendimiento. Las funciones específicas de Excel a utilizar serán determinadas de acuerdo a los trabajos a realizar. Las habilidades con diversas funciones de Excel (suma, promedio, porcentaje, ordenamiento, etc.) son idóneas para realizar los cálculos de manera eficiente. La precisión y la rapidez son características esenciales para este proyecto.

Estoy buscando un experto experimentado en Google Sheets para mejorar nuestro actual sistema de gestión de archivos. El objetivo principal es generar estadísticas tanto de productividad como de tiempo de procesamiento, así como establecer parámetros de control para monitorear el progreso. Responsabilidades clave: - Tu responsabilidad principal será optimizar nuestro sistema de archivos para generar estadísticas detalladas de productividad y tiempo de procesamiento. - Necesitarás crear informes condicionales basados en el estado actual de diferentes archivos. - Otra tarea clave será integrar datos de varias hojas en nuestro sistema de archivos principal. Habilidades y experiencia ideales: - Conocimiento avanzado de Google Sheets, inc...

los mecanógrafos necesitaban tomar un proyecto de retoques de documentos disponibles en nuestra empresa

I'm looking for an individual who can conduct a site visit at Christiana Slatina Post Secondary School Romania ( Scoala Post Gimnaziala Christiana Slatina Romania) to verify educational certificates of ex-student. Targeted Address : Str. Primăverii 18, Slatina 230125, Romania Issuing Authority : Scoala Post Gimnaziala Christiana Slatina România ( Christiana Slatina Post Secondary School Romania ) The task includes: - Robust verification of diploma. - Ensuring the accuracy and authenticity of provided documents - Taking Geo-Tagged Pics on site - Multiple Site Visits maybe required if complete and accurate result is not obtained. Note : No verbal communication will be accepted as a proof at any stage. I am seeking an individual who lives near to this place and it would be a...

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as well as the das...

I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.

I'm looking for an experienced data scraper who can extract text data from marketing websites for subsequent data analysis.

I'm looking for an individual who can conduct a site visit at Christiana Slatina Post Secondary School Romania ( Scoala Post Gimnaziala Christiana Slatina Romania) to verify educational certificates of ex-student. Targeted Address : Str. Primăverii 18, Slatina 230125, Romania Issuing Authority : Scoala Post Gimnaziala Christiana Slatina România ( Christiana Slatina Post Secondary School Romania ) The task includes: - Robust verification of diploma. - Ensuring the accuracy and authenticity of provided documents - Taking Geo-Tagged Pics on site - Multiple Site Visits maybe required if complete and accurate result is not obtained. Note : No verbal communication will be accepted as a proof at any stage. I am seeking an individual who lives near to this place and it would be a...

I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely beneficial...

I'm seeking a proficient data analyst to create a comprehensive Looker Studio report for me using Google Search Console (GSC) and Google Analytics data. Here's what I need: * Consolidation of GSC data and Google Analytics data into a thorough report. * Ability to effectively analyze and interpret this specific data, and capture relevant screenshots. * Unfortunately, I've not decided on the specific GSC and Google Analytics metrics nor the specific screenshots for this project so flexibility and the ability to suggest relevant metrics is crucial. Skills and Experience: * Proficiency in using Looker Studio to generate reports * Extensive experience with GSC and Google Analytics * A knack for data interpretation and analysis * Excellent judgement in selecting impactful met...

I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and famil...

Looking for a freelancer with expertise in managing and manipulating numeric data sourced from Excel spreadsheets. The work involves: - Efficient management of extensive numeric data - Organizing the data effectively onto separate worksheets according to their specific types Ideal candidates are those with previous experience in data entry and strong proficiency in Excel. Your responsibility would not only be to perform accurate data entry, but also structure it logically and intuitively. It requires excellent attention to detail, precision, and the ability to understand data categories. We value those with a proactive approach who can offer insights into improved data organization. Solid experience in similar projects is preferred.

I need a professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistical analysis - Prior experience in medium-sized dat...

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that a suitable freelancer should possess.

I'm looking for a detail-oriented freelancer who can assist me with a data entry task. The job entails transferring text data from typed documents into Word document format. Key requirements: - Data Entry: You should have a strong eye for detail and be proficient in accurately transcribing text. - Software: Familiarity with Word processing tools is essential. Ideal Candidate: - Strong attention to detail - Proficient in typing and data entry - Experience with Word processing tools The data will be provided in typed documents and needs to be accurately transferred into Word documents. A successful candidate will be able to work efficiently and accurately.

I'm seeking a property manager capable of handling a variety of tasks. Responsibilities primarily consist of a broad range of account management duties: * Gather data from designated sources (e.g., Google Drive) for entry into document management systems or partner websites. * Review documents for accuracy and completeness, attaching supporting files as necessary. * Conduct searches for additional information to complete incomplete documents. * Verify, correct, and manage data integrity, including deletion of unnecessary data and data consolidation. This position demands meticulous attention to detail, a college degree, proficiency in basic software tools (Microsoft Office - Word & Excel), and accessibility to email and devices (computer or phone). We require individuals who can...

I'm urgently in need of a Python specialist to accomplish an assignment using Jupyter Notebook. The task involves reading and merging multiple Excel sheets, and subsequently creating visual representations for the collated data. Key requirements are: - Deep knowledge of Python for data analysis - Proficiency in creating Bar Charts, Scatter Plots, and Line Graphs. - Strong skills in Excel data manipulation. Required libraries/packages expertise: - Matplotlib - Seaborn - pandas Your responsibility will be to decode the problems presented, manipulate provided Excel data accordingly, and present the output in an understandable visual format. Previous experience in similar tasks will be highly regarded. Will show the work on zoom and will connect and probably do it together Max payme...

I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.

I'm looking for a skilled Python programmer to assist in creating a metrics system for my data analysis project. Below are the key aspects of the project: - Data Type: The project will primarily involve the processing and analysis of text data. Prior experience with this data type is a definite advantage. - Goal: The main objective of this project is to perform in-depth data analysis. I need the freelancer to assist in developing metrics and calculations for the data. - Deliverables: The final output should be presented in a report format. Ideal skills for this project would include expertise in Python, data analysis, experience with text data, and the ability to create comprehensive reports. I want to write a python code for the following calculation of Code Synchronization ado...

I'm looking for a diligent freelancer to help me with a straightforward data entry task. The task involves: - Collecting text data from various websites - Organizing and inputting the data into Word documents. The ideal candidate should be: - Skilled at conducting online research - Proficient in Microsoft Word - Detail-oriented and able to maintain accuracy - Good at time management to ensure timely completion of the task. Your role will be pivotal in creating a structured, comprehensive database from the web content I provide.

I'm in need of a skilled freelancer who can assist me with two core tasks - manual data entry and uploading of images or videos on a portal. Key Responsibilities: - Manual Data Entry: The main task involves entering data into a system or platform. This will require a keen eye for detail and accuracy to ensure that the information is correctly captured. - Content Upload: You will need to source images or videos from online video platforms and upload them onto the portal. This requires a good understanding of image and video formats and how to properly upload them. Ideal Skills and Experience: - Proficient in data entry with a high level of attention to detail. - Experience in handling and uploading images and videos would be a plus. - Familiarity with online video platforms is prefe...

I'm looking for help in combining multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process and e...

I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your main goal would b...

I am looking for an experienced auto broker who specializes in used cars. My preferred type of car is a sedan and my budget is below $10,000. Ideal Skills and Experience: • Extensive experience in car brokering, especially used cars. • Deep knowledge of sedans. • Proven track record of finding cost-effective deals. • Excellent negotiation skills. The Job: • Find used sedan cars that fit within my budget. • Expertly evaluate the condition and value of the car. • Advocate for me in negotiations to ensure the best possible price. Priorities: • The car must be fuel efficient. • The condition, history, and pricing of the car must be transparent and verifiable. If you have a keen eye for value and detail, and can find a sedan with these specifi...

Looking for someone to go to a few sites and make me an excel sheet with all the listings on the site . Must speak fluent English

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in datasets.

I need an adept data entry freelancer to skillfully convert text data from various online sources into an organized Excel spreadsheet. You'll reap the benefits of this project if you're detail-orientated, familiar with navigating online sources, and proficient in Excel. - The project involves researching, collecting and collating text data from specific online sources - The final deliverable needs to be an Excel spreadsheet, with data arranged legibly - Demonstrable experience in data entry jobs would be ideal - A keen eye for detail is paramount as exactness is key for this data entry task - You should be comfortable working with Excel and have proficiency in using all its features. The testimonials of your past clients and your portfolio of similar projects will enhance you...

I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.

My project requires the assistance of an experienced data analyst or data miner. I'm working on a market research project, which requires the extraction of text data from a specified website. Here are the specific details: - Task: Extracting text data from a website for data analysis - Output: All extracted text data should be provided in a CSV file Given the nature of this project, prior experience in web scraping, data extraction, or data mining is highly desirable. The ability to accurately extract data and transfer it into a CSV file is essential.

I'm looking for a remote part-time data entry professional with a background in e-commerce. Key Responsibilities: - Data entry: Inputting information into our e-commerce system - Product details: Ensuring that product information is accurate and up-to-date - Inventory management: Monitoring stock levels, making updates as needed The ideal candidate should have: - Experience in data entry - Familiarity with e-commerce platforms - Strong attention to detail - Good time-management skills, as this is a part-time role - Excellent communication skills, as you'll need to liaise with the rest of the team If you're looking for a part-time gig and are confident in your data entry skills, I'd love to hear from you.

I need a freelancer to assist with accurate and efficient data entry into Microsoft Excel. The data is in digital format and involves numeric values. Key Requirements: - Enter numeric data into Microsoft Excel from provided digital sources - Ensure data is accurately transcribed - Maintain confidentiality of the data Ideal Freelancer: - Proficient in Microsoft Excel - Strong attention to detail - Previous experience in data entry, preferably with numeric data - Ability to maintain data integrity and confidentiality. Note: Please ensure you have a copy of Microsoft Excel for this job.

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

I need assistance in copying product data from the manufacturer's site to ours. This is only for approximately 20-25 products. Key responsibilities include: - Transferring product descriptions - Moving over technical specifications The ideal candidate will have: - Proficiency in data entry - Understanding of eCommerce platforms, so that the formatting is correct on our site. Here is an example product: The description should be placed in our description tab. The other info, from Connections to Warranty should be entered in our Tech Specs tab, while retaining the formatting, including symbols. I will provide full URLs to each of the images in the tech specs. I do not want to link to their images. You will not need to do any image editing. I will provide limited access to the back...

Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.

I'm looking for a skilled Python developer who can help me with two key areas: revamping the structure of my code for efficiency and readability, and aiding in the creation of data visualisations. Key Tasks: - Code Improvement: enhancing the structure of my Python code. - Data Visualization: We'll be working on creating a range of data visualizations, including charts and graphs as well as interactive dashboards. You should have experience in creating these in Python. Ideal Skills and Experience: - Strong Python programming skills - Proven track record in code improvement - Previous experience with data visualization, particularly in Python - Familiarity with visualization libraries such as Matplotlib, Seaborn, Plotly, etc. - Ability to grasp complex data sets and translate the...

I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.

I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever can most efficiently extract (using P...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

I am seeking a meticulous freelancer versed in data handling for tourism industry related task. The project entails data entry assignments concerning new partners and promotional spots. Here are the main specifics: - Filling in names, contact details, services, descriptions, locations and hours of operation. - Manipulating our provided templates to ensure data uniformity. - Consistency in handling different content type: hotels, attractions, and flight schedules. The ideal freelancer for this task would have prior experience with data entry, be detail-oriented, reliable and proficient in using standard data entry templates. Knowledge of the tourism industry will be a plus.

I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.