Hire the Best Power Query Freelancers
in the Philippines

📊 Data Analyst | Power BI | Excel Automation | Dashboard Development | Business Intelligence I am a Data Analyst with 10+ years of experience helping businesses transform raw data into actionable insights. I specialize in automating reports, building interactive dashboards, optimizing workflows, and creating data-driven solutions that improve decision-making and operational efficiency. I have worked with clients across healthcare, transportation, logistics, manufacturing, finance, and e-commerce, delivering reporting systems that save time, increase accuracy, and provide meaningful business insights. My expertise includes data cleaning, transformation, visualization, process automation, KPI tracking, and business intelligence reporting. I am highly detail-oriented, analytical, and committed to delivering reliable, high-quality results. 💼 Core Expertise ✅ Data Analysis & Reporting ✅ Dashboard Development (Power BI, Excel, Looker Studio) ✅ KPI & Performance Tracking ✅ Power Query & Data Transformation ✅ Process Automation & Workflow Optimization ✅ Business Intelligence & Data Visualization ✅ Forecasting & Trend Analysis ✅ Data Cleaning & Validation ✅ Excel VBA & Automation ✅ SharePoint, Power Apps & Power Automate ✅ Google Sheets Automation ✅ Stakeholder Reporting & Executive Dashboards ✅ Project Tracking & Operational Reporting 🛠 Technical Skills ✅ Microsoft Excel (Advanced Formulas, Pivot Tables, Power Query, Power Pivot, VBA) ✅ Power BI (DAX, Data Modeling, Interactive Dashboards) ✅ Google Sheets & Google Workspace ✅ Power Apps & Power Automate ✅ SharePoint Lists & Data Integration ✅ SQL (Data Extraction & Queries) ✅ Looker Studio ✅ Microsoft Office 365 ✅ Data Visualization & Storytelling ✅ Process Improvement & Automation 🎯 What I Can Help With • Automated Excel & Google Sheets Solutions • Power BI Dashboard Development • KPI & Performance Reporting • Data Cleaning and Transformation • Workflow Automation • Executive & Client-Facing Reports • Operational and Financial Reporting • Business Process Optimization I am currently seeking long-term and full-time opportunities where I can contribute my analytical expertise, automation skills, and business intelligence experience to help organizations make smarter, data-driven decisions.

𝙎𝙩𝙧𝙪𝙜𝙜𝙡𝙞𝙣𝙜 𝙩𝙤 𝙢𝙖𝙠𝙚 𝙮𝙤𝙪𝙧 𝙙𝙖𝙩𝙖 𝙖𝙘𝙩𝙪𝙖𝙡𝙡𝙮 𝙬𝙤𝙧𝙠 𝙛𝙤𝙧 𝙮𝙤𝙪? 🏆 Top Rated · 102+ Projects · 100% Job Success Score 📊 14+ Years in Data Analysis, BI & Process Automation 💰 $3.1M+ in Cost Savings Delivered Through Analytics 𝗟𝗲𝘁'𝘀 𝘁𝘂𝗿𝗻 𝘆𝗼𝘂𝗿 𝗿𝗮𝘄 𝗱𝗮𝘁𝗮 𝗶𝗻𝘁𝗼 𝗰𝗹𝗲𝗮𝗿 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻𝘀. 👇 🎯 𝗗𝗼𝗲𝘀 𝘁𝗵𝗶𝘀 𝘀𝗼𝘂𝗻𝗱 𝗳𝗮𝗺𝗶𝗹𝗶𝗮𝗿? ☑ Your spreadsheet works — but you'd be embarrassed to show it to a client or your boss ☑ You copy and paste the same numbers into the same report every single week ☑ Your data is scattered across files and nothing connects the way it should ☑ You need a dashboard but have no idea where to start ☑ Someone built you something before — it looked nice but broke the moment you touched it 𝗜 𝗳𝗶𝘅 𝗮𝗹𝗹 𝗼𝗳 𝘁𝗵𝗲 𝗮𝗯𝗼𝘃𝗲. 𝗘𝘃𝗲𝗿𝘆 𝘄𝗲𝗲𝗸. 📊 𝗥𝗲𝗮𝗹 𝗿𝗲𝘀𝘂𝗹𝘁𝘀 𝗳𝗿𝗼𝗺 𝗿𝗲𝗮𝗹 𝗰𝗹𝗶𝗲𝗻𝘁𝘀: ✦ $78.3M in dealer transactions tracked in a BI suite — praised by director-level executives ✦ 40–50% reduction in HR reporting time — weekly manual work fully automated ✦ 18% drop in employee attrition —Dashboard flagged 3 high-risk departments early ✦ 34% incomplete pipeline records uncovered in a Salesforce CRM audit — forecast accuracy improved ~25% ✦ $1.35B in market data analyzed across 6 regions — top 3 segments drove 71% of total revenue ✦ 12% reduction in product recall rate — defect-tracking dashboard surfaced quality issues before escalation ✦ $3.1M in consumable cost savings driven through manufacturing analytics ✦ 3 repeat contracts from the same client — they kept coming back because the work was right ⭐ 𝗪𝗵𝗮𝘁 𝗰𝗹𝗶𝗲𝗻𝘁𝘀 𝘀𝗮𝘆: ★★★★★ ❝ This is the third project I've done with Edmar and he is absolutely terrific. He has a 'can-do' attitude and is driven to make sure his work is done correctly, beautifully and on-time. ❞ — Repeat Client ★★★★★ ❝ Our director-level executive was ecstatic with the final dashboard. I highly recommend Edmar for his reliability, skill, and dedication to high-quality work. ❞ — Enterprise BI Client ★★★★★ ❝ Edmar was phenomenal — took a bunch of jumbled data and transformed it into a beautiful visualization that clearly told the story hidden within the data. ❞ — Data Visualization Client 🛠️ 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 & 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 ✅ Exploratory data analysis and pattern identification ✅ Data cleaning and quality assurance via Power Query ✅ Interactive dashboards and KPI visualizations (Excel, Power BI, Looker Studio) ✅ Automated reporting systems that eliminate manual work ✅ Merging and reconciling data from multiple sources ✅ Financial, HR, sales, and operations analytics ✅ Customer segmentation and cohort analysis ✅ Trend forecasting using historical data ✅ Survey data preparation and infographic reporting ✅ Written insight reports and executive summaries 🛠️ 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗘𝘅𝗰𝗲𝗹 & 𝗚𝗼𝗼𝗴𝗹𝗲 𝗦𝗵𝗲𝗲𝘁𝘀 ✅ Dashboard design with advanced formatting and layout ✅ Complex formulas: XLOOKUP, INDEX-MATCH, SUMPRODUCT, Array formulas ✅ Power Query for ETL, data modeling, and transformation ✅ Power Pivot, DAX, and data relationships across large datasets ✅ VBA macros and automation for Excel workflows ✅ Google Sheets automation: IMPORTRANGE, QUERY, FILTER, Apps Script ✅ Dynamic dropdowns, input forms, and user-facing interfaces ✅ Pivot tables, pivot charts, and conditional formatting ✅ Spreadsheet auditing and repair 🛠️ 𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗜𝗻𝘁𝗲𝗹𝗹𝗶𝗴𝗲𝗻𝗰𝗲 & 𝗥𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴 ✅ Power BI dashboard design (DAX, Power Query, data modeling) ✅ KPI framework design aligned to business goals ✅ SQL queries for data extraction 🛠️ 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝗜'𝘃𝗲 𝗱𝗲𝗹𝗶𝘃𝗲𝗿𝗲𝗱: Car Dealership Dashboard · Salesforce Health Check · HR Attrition Dashboard · Revenue Report Dashboard · Sales & Leads Dashboard · Customer Lifetime Value Dashboard · Google Ads Dashboard · Email Marketing Dashboard · Meta Rolling Data Dashboard · Financial Dashboard · Cash Flow Analysis · Payroll Dashboard · Employee Time Tracker · Employee Efficiency Dashboard · Customer Conversion Rate · Customer Journey Pipeline · Pricing Calculator · Compound Interest Calculator · Goal Tracker · Medical & Supplies Dashboard · Immigration Dashboard · Trading Strategy Performance Tracker · Closer Metrics KPI Tracking · Royalty Dashboard · Pay Tracker & Projections · Tariff Calculator · Bracelet Logs Dashboard · Audition Analytics · Program Dashboard · Survey Data Analysis · Retail Origination Report · Service Count Reconciliation · Real Estate Interactive Dashboard · Gantt Chart · Activity Log & Time Tracker · POS & Booker Summary Template · Editor Ranking System · Student Evaluations Infographic · Financial Model Formatting 𝗬𝗼𝘂𝗿 𝗱𝗮𝘁𝗮 𝗵𝗮𝘀 𝗮 𝘀𝘁𝗼𝗿𝘆. 𝗟𝗲𝘁'𝘀 𝗺𝗮𝗸𝗲 𝗶𝘁 𝘃𝗶𝘀𝗶𝗯𝗹𝗲. 👇 Send me a message — I typically respond within a few hours.

Business Analyst & Reporting Specialist | Excel, Power BI, Google Sheets, Microsoft Fabric & Looker Studio Need dashboards that actually get used? I build reporting systems — not just reports. With 6+ years turning messy data into clean, decision-ready visuals, I design scalable solutions your team can maintain and trust. What I deliver: Google Sheets automation & Apps Script Advanced Excel formulas, VBA macros & pivot tables Power BI dashboards, KPI tracking & DAX measures Microsoft Fabric (data pipelines & semantic models) Looker Studio / Google Data Studio visualizations Data cleaning, transformation & validation Workflow automation with Power Automate SharePoint & Google Workspace reporting Past results: automated weekly reports that cut manual work from 4 hours to 10 minutes; built multi-source Power BI dashboards for teams of 50+; migrated Excel-based trackers to Fabric-connected models. I work clean, communicate clearly, and deliver on time. Message me and let's scope your project.

💼 10+ years of experience in Data Analytics 🧩 5 years as a Smartsheet Subject Matter Expert (SME) ⚡ $100K+ earned on Upwork, 30+ completed projects with proven client satisfaction 🏆 Former Top Rated Freelancer (2021–2022) 🧠 Specialized in building smart, automated, and data-driven systems I help businesses streamline workflows, visualize data, and automate processes using tools like Smartsheet, Excel, Power BI, SQL, Databox, Looker Google Studio, and AI Automations, n8n zapier & Make. Let’s talk about how I can help you save time, reduce errors, and scale your operations. 🚀 WHAT I CAN HELP YOU WITH 📊 DATA ANALYTICS & DASHBOARDS Excel templates and Reporting SQL Queries for Data extraction and manipulation Dashboards (Power BI, Tableau, Databox, Looker, and Spotfire) Business Intelligence & Performance Tracking 🧩 SMARTSHEET EXPERTISE Smartsheet Architecture & Setup Forms, Gantt Charts, Calendar, and Cards Advanced Workflows & Automation Document generation and Approval Workflows Dashboards & Reporting Admin, User creation, Sharing and Access Controls Integrations and Smartsheet API Smartsheet Premium Features: Events Reporting Smartsheet Control Center Dynamic views Data Mesh Data Shuttle Pivot Security features: Data Engress SSO Domain Management Sharing Policy 🤖 AI & WORKFLOW AUTOMATION n8n & Make Automation AI-assisted Workflow Design Smart Notifications & Task Routing Cross-platform Data Sync LLMs for Productivity: Chatgpt, Gemini, & Claude ⚙️ PROCESS OPTIMIZATION Workflow Design & Process Mapping Engineering-driven Problem Solving System Efficiency Improvements Scalable Business Automation 💡 I combine engineering thinking + data analytics + automation to create systems that work smarter, not harder. Whether you need better dashboards, automated workflows, or AI-powered processes, I deliver reliable and scalable solutions. 📩 Let’s connect and discuss how I can transform your workflows into intelligent, automated systems.

I am a Reporting & Data Analyst who helps teams turn raw data into clear, reliable reports and improve their reporting processes for faster and more accurate decision-making. I focus on making reporting systems easier to maintain, update, and use. My work usually involves: ✅ Understanding current reporting processes and identifying issues or bottlenecks ✅ Cleaning and structuring raw data for reporting and analysis ✅ Automating repetitive reporting tasks to reduce manual work ✅ Building dashboards and reports for KPI and performance tracking ✅ Consolidating data from multiple sources into a single reporting system ✅ Extracting and preparing data using SQL for reporting needs ✅ Automating workflows and data processes using Power Automate Tools & Skills: ✅ Excel (Power Query, VBA) ✅ Power BI ✅ SQL Server ✅ Power Automate ✅ Reporting automation ✅ Data cleaning & transformation ✅ Dashboard development

I am BUSINESS INTELLIGENCE and FINANCIAL ANALYST for 10 years now. I am working consistently with Data Analytics and PROCESS IMPROVEMENTS / Kaizen and had developed and improved numerous reporting tools for the efficiency and accuracy of the report. I seek to eliminate any type of waste in processing the report which could help my clients/stakeholder on their daily business strategy. Be one of my clients and I could guarantee you that I will provide the QUALITY output that you need. Below is the list but not limited to of what I could for you: Excel & Access Database  Simple-to-Complex formulas  Conditional Formatting  Pivot table/charts/slicer for dashboard and visualization  PowerQuery and PowerPivot  Data connections and relational databases  SQL scripting from different MS product (INNER/LEFT/RIGHT JOIN etc)  User Forms, button, dropdown and other features.  Task Automation using advance macro (vba) coding. PowerBI/PowerQuery/PowerPivot  Creating DAX measures and Data Modelling  Connecting data from hundreds of supported on-premises and cloud-based sources.  Creating interactive reports, graphs and visualization for your business. SharePoint/Sharepoint Workflow/Nintex/Data Flow/PowerApps  Creating online based form using Nintex, PowerApps, and MS Form  Creating workflow such as automatic notification, approval process etc. Others - Financial Modelling, Data Scrapping, Data Mining, Web Research, Admin Support, Virtual Assistance