Best way to learn pivot tables in excel jobs

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks ...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I'm looking to develop a custom indicator on the TradingView platform. This indicator needs to be a combination of a Zigzag indicator and a Pivot indicator, which can be tailored based on my specific requirements and trading rules. Key Features: - Custom Zigzag Indicator: The indicator should be able to identify the various price swings in the forex market in a zigzag pattern. - Pivot Indicator: It should also be able to calculate and mark pivot points based on the price action. - Customizable: The indicator should be flexible and adjustable to my specific trading strategies and preferences. - User-Friendly: It should be easy to use and understand for a trader, with clear visual markers and alerts. Skills a...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...professional logo to represent my company, Renewable Energy Alliance. We're dedicated to promoting renewable energy sources, and I want our logo to reflect this mission. Key requirements include: - The design should be visually appealing and memorable, representing the concept of renewable energy, particularly solar in a fresh and modern way. - I'm open to creative interpretations, but I'd prefer to avoid cliches like light bulbs and generic green symbols. - The logo should be resizable and work well both in color and black and white. Ideal freelancer should have: - Proven experience in logo design and a strong portfolio to showcase. - A good understanding of the renewable energy sector or a willingne...

I'm looking for a skilled UI/UX designer to work on my web and app design projects. You should have at least 5 years of experience in UI/UX design and demonstrate expertise in tools such as Figma and XD. Please apply with a portfolio. Key features I'm looking for include: - Responsive design: The design should adapt seamlessly to all screen sizes and devices. - Intuitive navigation: The user should be able to easily find their way around the platform. - High-quality visuals: I aim for a trendy and futuristic style for my web design. The visuals should be engaging and visually appealing. If you have a strong background in UI/UX design, particularly with web and app design, I look forward to reviewing your application.

...seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly ...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.

...some amendments made to my website Font loading issue At the moment I have a font loading issue with several different fonts being loaded before the final one is loaded. I need one font instantly loaded rather than how it appears currently. I’m happy for this to be a different font (such as one that sits on Google), if it will load instantly, however I want the font still looking good, Lead Form capture not working The form capture isn’t working correctly. Originally it was sending through to my email address when someone filled out a form, however I had my email moved from GoDaddy to Google and it hasn’t worked since. Additionally the form capture doesn’t have the capability to actually see the responses within WordPress...

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in ...

I'm in need of a book cover for my upcoming novel on Ehlers Danlos Syndromes. The ideal candidate to take on this project should have: - Capable of designing in a realistic style - Experience in creating book covers, particularly for medical or health-related topics - An understanding of the needs of a sensitive or niche audience - Ability to capture the essence of a medical condition visually, while keeping it professional and engaging. I'm open to suggestions on how to best visually represent this rare medical condition in a way that will appeal to potential readers. If you have a portfolio that demonstrates your ability to handle such a project, I'd love to take a look.

I'm seeking a talented graphic designer to create a striking image for an ultimate frisbee disc. The design should seamlessly incorporate our team logo and abstract player silhouettes. Key Requirements: - Incorporate team logo: The image should prominently feature our team's logo in a way that complements the overall design. - Abstract player silhouettes: I'm looking for a creative approach to incorporating player silhouettes. Rather than a realistic representation, the design should focus on abstract interpretations that capture the essence of the sport. Ideal Skills and Experience: - Graphic Design: A strong portfolio of previous design work, particularly in sports-related imagery, will be highly beneficial. - Creative Thinking: The abi...

I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Go...

I'm looking for a Python developer to assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scr...

...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm seeking a freelancer with solid experience in crafting effective proposals. Your main focus will be on crafting job proposals specifically for the logo design industry. Key Requirements: - I need someone who has a proven track record of creating persuasive, professional and detail-oriented job proposals. - You should have a good understanding of the logo design industry. - You should be adept at identifying selling points and presenting them in a clear and compelling way. - Previous experience in the design field would be a plus. Please note: I'm not looking for automated or AI-generated proposals. Your writing should be original and tailored specifically for each job posting.

Skills require...securely. Authentication: OAuth for handling secure authentication with streaming services. Technical Requirements and Development 1. Secure Authentication: Implement OAuth or a similar secure authentication protocol to allow users to log into their streaming services without storing their credentials. 2. Device Management: Develop a system to manage devices that can stream content, ensuring only authorized users can access the services during their stay. 3. Session Management: Ensure that user sessions are automatically ended upon checkout, or provide a simple way for users to log out when they are done watching. 4. Privacy and Security: Since the app will handle sensitive login information, ensure that the data is protected through en...

I'm in need of a talented writer who can distill our year's company updates and key achievements into a riveting and professional annual newsletter. Your writing will be digestible, engaging, and appropriate for a diverse audience which includes our dedicated team, potential customers, and the general public. Key tasks will include: -Writing succinctly about our company updates and milestones, potentially including interviews with key team members. - Ensuring the tone remains professional yet approachable throughout. - Incorporating engaging elements that capture readers' interest and encourage them to learn more about our projects and initiatives. The ideal freelancer for this role will have: - Significant experience writing newsletters or similar ...

...degree to administer an on-site exam in Salmiya, Kuwait. This is a one-time gig with the potential for future opportunities. We provide test administration and accommodation solutions to test-takers nationwide. For this purpose, we look for professionals who we contact on an "as-needed" basis to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for communication assistance. The candidate is deaf or hard of hearing but is able to read lips. For this assignment, you would be required to be on site and repeat comm...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I need a PHP script to update an existing PDF file with data from a form. - The purpose is to update information in the PDF file, not generate new ones. - The edited PDF will be displayed once, not saved for future reference. - The data that I'll be entering into the form is a bit more complex than just text. It includes text, images, tables, etc. The ideal freelancer for this project should have: - Strong understanding of PHP. - Experience with PDF manipulation in PHP. - Ability to work with various data types in PDFs. - Attention to detail to ensure the PDF retains its original style, font, spacing, etc.

I'm looking for a professional who can scrape specific tables on a government website for insurance claim statistics. Key Requirements: - Web Scraping: You should have prior experience in web scraping and can navigate through the website's structure to extract relevant data. - Data Extraction: The main focus will be on compiling data related to insurance claim statistics. The final deliverable should be a well-organized dataset with accurate claim statistics. Please share your experience in similar projects.

I'm in need of an experienced UI/UX designer for my website. The website serves as a platform for providing information and needs to have a user-friendly navigation and layout. Requirements: - Proficiency in website UI/UX design - Able to integrate a smooth sign-up/login process - Dashboard screens - Incorporate GPS tracking and chat/message function seamlessly Skills and Experience: - Experience in creating user interfaces for other informational websites - Strong understanding of information architecture - Able to create accessible, user-friendly designs with a focus on user experience - Previous experience integrating GPS tracking and chat/message functions The designer I'm looking for must value user-centered design principles...

...designer to create an engaging pitch deck for upcoming accelerator sessions. The deck will be used to communicate with potential partners, offering them a clear snapshot of our goals and vision. • Type of deck: Pitch deck • Intended audience: Partners The deck should succinctly present our accelerator sessions, highlighting their unique features and benefits. The aim is to entice potential partners and lay a solid foundation for future collaboration. Desired skills for this task include: • Experience in designing professional pitch decks • Proficiency in tools like PowerPoint, Keynote, Prezi • Sound knowledge of visual storytelling • Experience dealing with partnerships in startups or tech companies Your role...

I need a comprehensive PowerPoint presentation created for a comparative analysis of 5 companies. guys i have all the data and the outline its probably an hours or twos work is there anyone who can do this Key deliverable...presentation - Effective integration of all data, ensuring the audience can easily understand and compare the various aspects of the companies - Clear, concise articulation of the information Ideal skills for this project include: - Proficiency in creating professional, high-quality PowerPoint presentations - Ability to analyze data and present it in a comparative manner - Strong communication skills to ensure the information is presented clearly and effectively - Attention to detail to ensure all data is accurately includ...

I need help with data entry and formatting for a Go...need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questi...

I need a comprehensive and professional formatting of a government project report. This report is aimed at analyzing the effectiveness of current government program...is aimed at analyzing the effectiveness of current government programs, identifying areas for further improvements and suggesting recommendations for future initiatives. The needed formatting requirements include: - Font style and size - Heading styles - Margins and spacing - Including images, tables etc. Ideally, you possess a keen eye for detail and an understanding of government report structures. A background in preparing and formatting formal documents or reports is a plus. The project has to be completed ASAP, so time management skills are crucial. Please bid, outlining your relevant skills and es...

...Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, includi...

...company committed to providing high-quality educational cartoon videos for children worldwide. Our mission is to foster learning and development in young minds by delivering engaging content in multiple languages. Currently, we offer educational materials in six languages, including English, Arabic, Pashto, Persian, Urdu, and Dari, with plans to expand to encompass 100 languages in the future. - The main purpose of the site will be to showcase our educational cartoon videos. There won't be nursery and childcare services offered through the website, it's strictly for displaying our work. - Visitors should be able to interact with the site in a way similar to the YouTube Kids platform. Th...

I'm in need of a skilled PHP developer to create a custom admin dashboard. The primary goal of this project is to provide a user-friendly interface for my data, with the following features in mind: - **Data Visualization**: I want the dashboard to be able to display key data pertinent to my business. This may include sales data, user activity, and website traffic. - **User Management**: While not explicitly stated, I understand the importance of user management in an admin dashboard. Therefore, building a system that allows for user management is a crucial part of this project. - **Role-based Access Control**: I want the dashboard to have role-based access control. This means that users will have different levels of acces...

We want to distribute our OpenGL-Based media server software via Linux. Appimage looks like a usable way to deploy on multiple distributions. We target solely x64 architectures. The software uses OpenGL, video capture, audio output and input and connects to IO devices via USB. We already have a working .deb workflow and it would be great if you could create an appimage workflow for us that we can introduce into our deployment.

...designer to create a jiu jitsu journal. This journal should be not only a place to log training and progress, but also a source of inspiration and mindfulness. It needs to have a clean and minimalist design. Here's a detailed list of what I am looking for: - Training log section per training session - Technique library or pages dedicated to techniques - Progress tracker which includes tracking for belts, stripes, seminars, competition history - Sections for gratitude, mindfulness, wellbeing, and meditation challenges - Pages with inspirational quotes - Blank pages filled with key questions and prompts about jiu jitsu eg: What are your short, medium and long term SMART goals. What does jiujitsu mean to you? Why should you compete? What lessons do...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love ...

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared ...

I'm currently seeking a skilled developer to create an e-commerce platform, named "yuk pencet", tailored towards young adults aged between 18 and 35. The primary feature that I'm looking to include in this platform is product customization. Key Requirements: - Develop an intuitive, sleek e-commerce platform that aligns with the preferences of the specified age group - Implement the product customization feature in a user-friendly way, ensuring it's engaging and easy to use Ideal Skills and Experience: - Proficient in e-commerce platform development - Prior experience in creating platforms for young adult audiences - Expertise in integrating complex customization features - Strong UI/UX design skills ...

I'm in need of a talented designer who can create realistic mockups of various tables for my home decor line. Key Responsibilities: - Designing and creating mockups for tables - Ensuring the mockups are of high quality and look realistic - Providing a variety of designs that align with my brand Ideal Skills & Experience: - Proficiency in design software such as Adobe Photoshop, Illustrator, or others - Experience in creating mockups, particularly for home decor items - A good understanding of my brand and design aesthetic - Strong attention to detail and ability to deliver high-quality, realistic designs %d7%a9%d7%95%d7%9c%d7%97%d7%a0%d7%95%d7%aa-%d7%a1%d7%9c%d7%95%d7%9f this is reference for the type of design I'm looking ...

I'm seeking exp...seeking experienced Javascript and Jquery developers to help create several interactive features on a web platform. The project involves: - Developing dynamic content loading: The platform will require the ability to dynamically load content, including tables, charts, and other visual elements. - Implementing real-time notifications: The system will need to push notifications to users in a dynamic, real-time fashion. - Ensuring full responsiveness: It's crucial that the project be fully responsive across all devices. The ideal candidate will have a proven track record of web development, particularly in Javascript and Jquery, and a strong understanding of user experience and responsive design. You should be able...

...Marketing Specialist to help me achieve my company's marketing objectives. Key Responsibilities: - Increase brand awareness through SEO, SEM, content marketing, and social media. - Achieve marketing KPIs such as growing the number of followers on social media platforms and increasing website traffic. - Develop and execute detailed marketing plans to support product launches. - Conduct thorough market research to identify industry trends and opportunities. - Create and optimize blog and social media content. - Implement growth marketing strategies to boost user acquisition and retention rates. Successful applicants will have: - Proven experience in generating leads, improving conversion rates, and executing marketing campaigns for SaaS products....

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

...strong level of experience and skills in managing safety issues at large scale events with an expected attendance of more than 5,000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events safety related matters Skills and Experience Required: - Proven experience in large scale event safety management. - Expert knowledge of various safety threats and first-hand experience in plannin...

...skilled freelancer to develop a Procurement Management App using PowerApps. This comprehensive app will streamline various aspects of procurement, including sales, purchases, offer comparison, offer creation, order recording, item creation, and purchase analysis. Offer Comparator: The app should allow users to upload supplier offers, compare them against existing database entries, and identify the best offers based on configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, an...

I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication and negotiation skills.

I'm in need of a skilled graphic designer to help create a cohesive and modern visual identity for my e-commerce business. Requirements: - Company Logo: I'm looking for a professional and modern logo that'll represent my brand's image effectively. - Sliding Banners: I need 5 unique banners for the website. These should be catchy and designed to encourage visitors to shop. - Social Media Ads: I'm also after 5 unique images to be used for Instagram and Facebook ads. These should focus on new arrivals, seasonal offers, and best sellers in a way that's visually appealing and engaging. Ideal skills and experience: - Experience in branding and logo design - Proficiency in creating web banners wi...

I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks

I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knac...

...Microsoft Word Form document (tables filling 2 pages) that I'd like converted into a webpage form that users can interact with. The form will be used to enter essential information to properties by our data entry operators. This will be one (1) html page only, no backend development necessary (php receiving the form optional, see below). „Nice Admin“-Template must be used: Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, includi...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analys...