Edmar O.
Mabalacat CityPhilippines
100% Job Success
Top Rated

Data ANALYTICS Pro | EXCEL and GSHEET Wizard | DASHBOARD Specialist

𝐓𝐢𝐫𝐞𝐝 𝐨𝐟 𝐰𝐫𝐞𝐬𝐭𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡 𝐲𝐨𝐮𝐫 𝐝𝐚𝐭𝐚 𝐚𝐧𝐝 𝐬𝐩𝐫𝐞𝐚𝐝𝐬𝐡𝐞𝐞𝐭𝐬? 💼 15+ years' experience in Data Analysis ⚙️ Automate Excel | Google Sheets Reports 📊 Create insightful Charts | Visual 🌟 Strong, Creative Engineer | Analytics Expert 🥇 Top Rated | 100% Job Success Score 𝐒𝐭𝐨𝐩 𝐆𝐮𝐞𝐬𝐬𝐢𝐧𝐠, 𝐒𝐭𝐚𝐫𝐭 𝐊𝐧𝐨𝐰𝐢𝐧𝐠: 𝐆𝐞𝐭 𝐀𝐜𝐭𝐢𝐨𝐧𝐚𝐛𝐥𝐞 𝐈𝐧𝐬𝐢𝐠𝐡𝐭𝐬 𝐥 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐞 𝐘𝐨𝐮𝐫 𝐃𝐚𝐭𝐚 𝐓𝐨𝐝𝐚𝐲! 👇🏻👇🏻👇🏻 🎯Data Geek | Analytics 📊 🔥Collecting and managing data, including exploratory data analysis 📈 🔥Identifying trends and patterns in complex datasets 🔍 🔥Quality assurance and data cleansing, using MS Excel and Power Query 🧹 🔥Producing interactive dashboards, graphs, tables, pivot tables, pivot chart and other visualizations, using MS Excel, Power BI, and Spotfire 📉 🔥Creating presentation decks using PowerPoint (or similar) 💻 🔥Providing written reports on findings 📝 🎯Microsoft Excel and Google Sheet Expert 💻 🔥Create, modify and do stunning formatting on spreadsheet 🎨 🔥Calculation and Accounting 💰 🔥Auditing and repairing spreadsheets 🔍 🔥Data modeling and transformation 🔧 🔥Data Entry and Cleansing thru Power Query🧹 🔥Data sorting, filtering and duplicate removal 🔍 🔥Generation of charts, graphs and dashboard 📊 🔥Maximize use of pivot tables 🔍 🔥Utilize look up, excel functions 🔍 🔥Creating basic and complex formulas 🔍 🔥Perform conditional formatting 🔍 🔥Simplify task using basic code and macros 🔧 🔥Google Sheet linkage using Importrange and Query Function🔍 🎯SQL Expertise for Querying Task 💻: 🔥Writing SQL queries to extract data from databases. 🔍 🔥Using advanced SQL techniques such as subqueries, joins, and window functions to extract complex data. 🔧 🔥Creating and optimizing indexes to improve query performance. 📈 🔥Optimizing SQL queries for better performance. 💡 🎯Freelance Experience 💼: I have a wide range of freelance experience from 2022 to 2023. My tasks included data cleanup 🧹, codebook revisions ✏️, data linkage 🤝, mapping review 🗺️, data exploration/analysis 🔍, formula generation 💡, look up and chart generation 📈, spreadsheet auditing 🔎, process simulations 💻, risk assessments 🔍, process documentation creation 📝, cost reduction programs implementation 💰, KPI monitoring systems review 🔎, Interactive Real Estate Dashboard 🏠, Activity Log and Time Tracker ⏱️, Google sheet look up formula optimization 📊, Student Evaluations Infographic and Business plan, Pricing Calculator, Google sheet COGS file clean up, Interactive Dashboard for list of Clients, Compound interest calculator, Meta Rolling Data Dashboard, Google Ads Dashboard, Customer Journey Pipeline Dashboard, Email Marketing Dashboard, Income & Expense Analysis, Product Monitoring Template, Revenue Report Dashboard, Salesfoce HealthCheck Dashboard, Goal Tracker and Financial Model formatting in Microsoft Word and Excel 📄💼. I have also worked on various tools like Google Sheets 💻, MS Word and Powerpoint ✏️ for tasks like creating templates 🎨 , formatting documents ✂️ etc. My freelance experience also includes working on projects like ‘Covid 19 Survey’ 🦠 , ‘Data Linkage’ 🤝 , ’ Data Exploration’ 🔎 , ‘Real Estate Template’ 🏠 , ‘Gantt Chart’ 📊 , ‘Election Result Comparative Analysis’ 🗳️'Dashboard Design' 🖥️ 'Spreadsheet Tutorial' etc. Is there anything else you would like me to help with? 😊 Let's Connect!!!

Edmar O. has more jobs. Create an account to review them

Skills

  • Data Analytics
  • Google Sheets
  • Excel Formula
  • Data Interpretation
  • Interactive Data Visualization
  • Data Visualization Framework

Get started working with Edmar quickly with these predefined projects.

Get started working with Edmar quickly with these predefined projects.

You will get a visually appealing INFOGRAPHIC for your survey data

From $50
3 days delivery

You will get an amazing and interactive Dashboard

From $75
5 days delivery

Testimonials

Endorsements from past clients

"Edmar is one of the core team members who have been always supportive in driving various outreach projects and initiatives in Central Luzon. His dedication from planning to marketing is remarkable. His volunteerism is a proof that despite our chosen careers, we can still strive to go the extra mile and help others in our own simple ways. We would not have achieved our milestones if not for his great contributions at Acts of Love Community. "

Anna C. | Project Management Officer / Project Manager
Nov 2023

Verified


"I recently had the pleasure of working with Edmar on a project and I was extremely impressed with his work. Edmar is highly skilled and knowledgeable in his field, and he consistently delivered quality work that met my expectations. He is also a great communicator and was always available to answer any questions or concerns I had. Overall, I had a fantastic experience working with Edmar and I would highly recommend him to anyone in need of his services. Thank you Edmar for all your hard work!"

Dhan Kevin L. | Project Manager
Feb 2023

Verified


"I have had the pleasure of working with Edmar on several projects that required data analysis and presentation. His proficiency in MS Excel is unmatched. He has an innate ability to take complex data sets and turn them into intuitive, actionable insights. His attention to detail, combined with his strong problem-solving skills, makes him a valuable asset to any team. I highly recommend Edmar for any data analytics role, especially those utilizing MS Excel."

Edgar M.
Jan 2023

Verified