
In Progress
Posted
Paid on delivery
I'm looking for an Excel expert to create two graphs (a bar chart and a bubble chart) from a provided dataset. The data spans a four-year period from January 2020 to December 2023 and includes various categories such as total reports by year and month, precinct, borough, location of incident, and specific CCRB dispositions. Key Requirements: - Data Wrapping: Use appropriate data wrapping techniques to prepare the data for graphing. - Bar Chart: Categorize this graph by the total reports per year. -Bubble Chart: We will discuss how to categorize this chart, but it will involve the total reports, precincts, boroughs, and locations of incidents. - CCRB Dispositions: These need to be displayed separately by type in the graphs. Ideal Skills: - Proficient in Excel, with a solid understanding of data wrapping and graph creation. - Strong analytical skills to interpret the data and create meaningful visual representations. - Good communication skills for discussing the categorization of the charts. The final deliverables should be provided as an Excel file. The primary purpose of the graphs is for data comparison.
Project ID: 38862440
75 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
75 freelancers are bidding on average $38 USD for this job

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$50 USD in 1 day
8.6
8.6

"Sir/Madam, Excel is my specialty and i love performing complex task in excel. There is nothing in Excel that i can't do. From simple formulas to complex condition based formulas and automation through VBA and MACRO, i am expert in all. My Expertise in Excel Include but not limited to: 1) SIMPLE and COMPLEX EXCEL FORMULAS (ALL TYPES OF FORMULAS) 2) VBA MACRO AUTOMATION 3) PIVOT TABLES 4) DASHBOARDS FULLY AUTOMATED AND VISUALLY APPEALING. 5) AUTOMATED INVOICE AND QUOTE GENERATOR IN EXCEL WITH DATABASE. 6) CREATING ANY TYPE OF AUTOMATED TEMPLATE IN EXCEL. This is my field and I can I can handle this task very efficiently and you can expect 100% accuracy from me. About me I am a Chartered Accountant with more than 8 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 3 years as freelancer. I am EXCEL, VBA, MACROS, GOOGLE SHEETS, ACCOUNTING, FINANCE, BUDGETS ADVANCE LEVEL EXPERT. I have been working as a freelancer from the last 3 years and I have 390+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. Note. The price is negotiable and we can agree on a mutual price. I will be available for any query round the clock WITHOUT any further cost even if the project is completed as i am making permanent clients. Regards Arman Kakar"
$55 USD in 1 day
7.6
7.6

Hi there! As a seasoned data analyst with extensive skills in Excel, data processing and analysis, I believe I'm the right person for your project. I have a strong understanding of the dataset and can easily implement effective data wrapping techniques to ensure the graphs are accurate and meaningful. My proficiency in Excel, combined with my comprehensive grasp of data analysis, will guarantee professional results that satisfy your needs. Moreover, my adeptness at interpreting complex data and transforming it into insightful visual representations is a perfect match for your project requirements. Over my career, I've had countless rich experiences creating charts and graphs to compare and contrast different sets of information, exactly what you need in this project. Additionally, my excellent communication skills ensure we'll be on the same page throughout the process as we discuss the ideal categorization for each chart. Lastly, as a detail-oriented professional with a penchant for delivering exceptional work on time, I assure you of timely delivery without compromising on quality. Your satisfaction is my priority and I anticipate working closely with you to create impactful visualizations that facilitate easy data comparison and comprehension. Let's get started right away!
$29 USD in 1 day
7.5
7.5

Hello, I hope you are doing well. I hold a master's degree in Statistics from a renowned university. I am a well experienced statistician. I have good command over creating visualizations using Excel (please visit my profile to check reviews for my past projects). I have reviewed and understood your requirements, I can help you with this project. Please feel free to ask me, if you have any queries.
$30 USD in 1 day
6.5
6.5

With over 15 years of experience in data analysis and visualization, I bring a wealth of knowledge to this project which aligns perfectly with my skills. My mastery of Excel includes robust capabilities such as data wrapping and graph creation, which are the key requirements for your project. I assure you that my analytical skills will enable me to interpret your provided dataset comprehensively to create compelling charts that fulfill your specific categorization needs. Furthermore, I am experienced in communicating effectively with clients, which will be vital during our discussions on chart categorization. t!
$15 USD in 1 day
6.3
6.3

Hello there, I am a Data Analyst by practice, and by using EXCEL, I can help you discover facts from your data pool. I run both quantitative and qualitative analyses professionally. I am proficient in data cleaning, transformation, and formatting to ensure accuracy and consistency while handling missing data, outliers, and data quality issues. I apply appropriate statistical techniques to make and recommendations while utilizing advanced regression models, clustering, classification, or other relevant techniques. I provide a detailed report summarizing the data analysis findings while presenting key insights, trends, and recommendations clearly and understandably. I deliver visualizations, tables, and charts to support the analysis and enhance comprehension. Please get in touch so we can proceed with the project.
$30 USD in 2 days
6.5
6.5

Hello, I have carefully reviewed the details before placing a bid on your project. I am confident that I can complete the task and provide you with an effective solution. With over 14 years of experience in reporting and data analysis, I have designed and delivered multiple dashboards and implemented VBA automation to reduce human intervention which enhance data accuracy. My dashboards and reports are equipped with dynamic features like checkboxes, radio buttons, drop-down lists, and various graphical data representations, including bar charts, pie charts, heat maps, and Gantt charts. Please feel free to check my portfolio for more information. I look forward to discussing the details further in chat. Thank you for your time. Best regards, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Google Sheets
$25 USD in 1 day
5.7
5.7

I am excited to apply for the Excel expert position to create the required graphs for your dataset. With over three years of experience in Excel and data visualization, I am confident in my ability to efficiently organize and analyze the data, and produce clear, insightful graphs that meet your requirements. For the bar chart, I will categorize the data by the total reports per year, ensuring a clear visual comparison across the four-year period. For the bubble chart, I will work with you to properly categorize the data based on precincts, boroughs, and incident locations, while ensuring CCRB dispositions are displayed separately by type. I will also apply the appropriate data wrapping techniques to ensure the data is well-prepared and easy to interpret. I am highly proficient in Excel and data analysis, and I look forward to discussing your needs further to create accurate and meaningful visual representations. The final deliverable will be a polished Excel file with both charts ready for comparison. Best regards, Tauqeer Ahmad
$30 USD in 3 days
5.8
5.8

Hello, I’m an Excel expert skilled in creating bar and bubble charts for clear data comparison. I’ll wrap the data, categorize reports, and highlight CCRB dispositions, delivering precise, polished visuals in an Excel file. Looking forward to collaborating!
$30 USD in 1 day
5.4
5.4

Hello! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includes Statistics, Statistical Analysis, Data Entry, Excel and Data Processing, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
$30 USD in 2 days
5.3
5.3

Dear Researcher I am experienced academic writer and expert in Power BI, EXCEL, SMARTPLS, NVIVO, SPSS and AMOS for data analysis (Regression, ANOVA, Correlation, t-test, Chi Square test, Block Plot, SEM, Mediation Analysis, CFA and EFA etc.). I always provide results along with descriptive statistics. Looking forward for more discussion please. You can see my related reviews: https://www.freelancer.com/projects/spss-statistics/Help-with-PhD-data-analysis/reviews https://www.freelancer.com/projects/spss-statistics/Data-analysis-SPSS-Discussion-conclusion/reviews https://www.freelancer.com/projects/statistical-analysis/Data-Analysis-for-Research-Article/reviews https://www.freelancer.com/projects/spss-statistics/Statistics-SPSS-29759215/reviews https://www.freelancer.com/projects/statistical-analysis/SPSS-Analysis-25195398/reviews https://www.freelancer.com/projects/spss-statistics/SPSS-assignment-24766032/reviews https://www.freelancer.com/projects/r-programming-language/Statistical-Project/reviews https://www.freelancer.com/projects/electrical-engineering/Engineering-statistics/reviews Regards! Dr Sajed Ali, PhD Note: Bid is just to connect. The actual time and budget may be negotiated as per project details.
$20 USD in 7 days
6.6
6.6

I am excited to help you create the Bar Chart and Bubble Chart based on your dataset from January 2020 to December 2023. With expertise in Excel and data visualization, I’ll ensure your charts are clear, insightful, and effective for data comparison. Plan: Data Wrapping: Organize the dataset for graphing using PivotTables or Power Query. Bar Chart: Display total reports by year (2020-2023) for easy year-over-year comparison. Bubble Chart: Categorize by total reports, precincts, boroughs, and locations, with size and color reflecting different metrics. CCRB Dispositions: Display separate visualizations for CCRB disposition types. Deliverables: Excel file with the two charts. Well-organized data and clear labeling for easy interpretation. Timeline & Cost: Timeline: 3-5 business days. Cost: [Insert Amount]. I look forward to discussing the details and ensuring these charts meet your needs. Feel free to reach out with any questions!
$30 USD in 2 days
5.0
5.0

Hello, I am an Excel expert with a lot of experience in data analysis and visualizations. I can perfectly generate a bar chart displaying total reports per year and a bubble chart categorizing total reports by precincts, boroughs, and incident locations to your requirements. I will also ensure CCRB dispositions are clearly set as separate data points in the graphs. My experience in data preparation ensures the dataset will be fully optimized for meaningful comparison. Kindly let me know. Thanks, George.
$30 USD in 2 days
4.9
4.9

Dear Client, I bring over 15 years of experience and have successfully delivered 80+ projects during the freelancer as well as my jobs career. Some of areas are mentioned below: • Bookkeeping, Accounting, Taxation, compliance, payroll, and system-based solutions. • Data Analytics, Visualization, Advanced Excel dashboards, Power BI, and expert analytics tools for problem-solving, Microsoft, Google sheet • Financial Planning & Advisory, Projections, business plans, financial modelling, investor due diligence, and pitch decks. • Being a FCMA, CIPFA & CPA, I have strong strength on writing different research papers. • ERP Implementation & Advisory: System analysis, business analysis, and gap analysis. • Startup Advisory, FinTech: Dashboards, BizOps, and strategic support for startups. • Strategic Planning, Turnaround, Cost optimization and project recovery. • ESG, Cybersecurity, Forensic audits, compliance, legal & contract advisory. Let’s chat how I can support your business needs effectively. Best regards,
$10 USD in 7 days
4.8
4.8

Hello, Greetings Vanda S., Good afternoon! I’ve carefully checked your requirements and really interested in this job. With strong expertise in Statistics, Statistical Analysis, Data Entry, Excel and Data Processing, I excel at creating dynamic tools for data analysis, automation, and efficient reporting. My skills include advanced formulas, data visualization, and script automation to streamline repetitive tasks. For example, I recently developed an automated pricing calculator in Google Sheets that generated instant quotes based on complex product configurations, incorporating volume discounts and client-specific terms. I’m adept at building user-friendly interfaces and custom dashboards, which provide clients with valuable insights and save time on data management. For more information about me, please refer to my portfolios. freelancer.com/u/apilt9 I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thanks Apil
$10 USD in 1 day
4.4
4.4

As a seasoned Excel expert, equipped with more than seven years of experience, a degree in Industrial Statistics and Mathematical Finance from the distinguished University of Colombo, and fluency in both Microsoft Excel and Google Sheets, I am confident in my ability to handle your project requirements with precision and excellence. Specifically citing your need for data wrapping and graph creation, I've long used these functions in my practice to analyze, present, and make data understandable within a given context. Lastly, I'm dedicated to providing timely results while maintaining impeccable accuracy - something that you can surely benefit from. It would be my honor to help you extract meaningful insights from your dataset through my comprehensive data processing and analytical services. So why wait? Get in touch today and let's make sense out of your data through impactful graphs together!
$20 USD in 4 days
4.4
4.4

As a seasoned software engineer with a specialization in data analysis and a Microsoft-certified expert, I am well-versed in everything Excel has to offer. In the span of my 5-year career, I have gained substantial experience in graph creation and data visualization, exactly what you require for your project. My deep understanding of data wrapping techniques will not only enable me to preprocess your provided dataset efficiently but also create impactful bar and bubble charts as per your specifications. My skills extend beyond Excel. I am adept at SQL, Python, Oracle NetSuite, and widely experienced in other business intelligence tools such as Power BI. This broader knowledge base allows me to tackle complex tasks with ease, drawing robust insights from data that may be missed by others. I also take pride in my communication skills which will result in a smooth creative process between us. Whether it's discussing the best way to categorize the bubble chart or exploring how to incorporate CCRB dispositions separately by type in a visually appealing format, I am here to provide support throughout this project. Choose me for a combination of undeniable expertise and a commitment to producing top-notch results for your data comparison needs. Thank you for considering my candidacy!
$20 USD in 7 days
4.0
4.0

" "Let's hop on chat to discuss the project deadline, budget, and further details. Please review my similar portfolio https://www.freelancer.com/u/Deployyit Thanks and Regards, Umer
$20 USD in 7 days
4.1
4.1

Hi Sir, I have worked as a finance manager in local NGOs, Schools, Chartered Accountant Company & Super Markets, and I have over 15 years of experience. My qualification is an MBA (Master of Business Administration) & I am proficient in Excel Analysis & Graph Creation tasks. I have gone through your requirements and am highly interested. I will deliver the project with 100% satisfaction and under a deadline. I will do this job as per your expectations. Please come over and chat, let's discuss more on the project. I will start work immediately and provide you with daily updates. My Skills; ✅ Proficient in Excel Analysis & Graph Creation tasks. ✅ Strong understanding of accounting principles and financial analysis. ✅ Attention to detail and accuracy. ✅ Proven track record in setting up accounts for service-oriented businesses. ✅ Excellent understanding of both bank, expense, and income accounts. ✅ Ensuring all transactions have receipts attached. ✅ Detailed knowledge and understanding of financial reports. After the competition & delivery of the project, any modification and alteration will be provided free of cost. I am looking forward to working with you! Best Regards, Naseem
$30 USD in 1 day
4.0
4.0

Hi, Having years of expertise in Excel, I can help you create two impactful charts—a bar chart and a bubble chart—that effectively display your four-year dataset, making it accessible and insightful for your needs. For the bar chart, I will carefully categorize the data by total reports per year, ensuring that each year’s data is clearly represented and easy to compare. I’ll apply appropriate data wrapping techniques to clean and prepare the data for accurate graphing. As for the bubble chart, I’ll work with you to determine the best way to categorize the data, integrating total reports, precincts, boroughs, and incident locations, ensuring the visualization is both informative and visually engaging. Additionally, I will ensure that CCRB dispositions are clearly represented by type in both charts, providing an organized view of this important data. By leveraging Excel’s full capabilities, I will create graphs that not only reflect your data accurately but also make it easy to spot trends and draw conclusions. The goal is to deliver clear, actionable insights in a format that is both functional and visually appealing. Please feel free to reach out. I’d be glad to chat more about your exciting project! Thanks.
$100 USD in 1 day
4.1
4.1

Queens, United States
Payment method verified
Member since Oct 12, 2024
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$10-30 USD
₹1500-12500 INR
₹12500-37500 INR
₹750-1250 INR / hour
₹100-400 INR / hour
₹750-1250 INR / hour
$30-250 AUD
₹600-1500 INR
₹37500-75000 INR
₹1250-2500 INR / hour
$30-250 USD
$15-25 USD / hour
₹600-1500 INR
$30-250 USD
$250-750 USD
$15-25 USD / hour
₹750-1250 INR / hour
$15-25 USD / hour
₹12500-37500 INR
€250-750 EUR
$15-25 USD / hour