⚡ I solve your toughest data challenges with Excel-first solutions – building automated dashboards, advanced models, and decision-ready reports that save time, reduce errors, and deliver insights. I’ve delivered: • Excel-based HR and operations systems • Automated financial models & tools • Dashboards (Excel, Power BI, Looker) • Medical and clinical data reports • Staff compensation and survey analytics • Project management and analytics web apps All of these were built for real business use, not academic exercises. Explore my 7 selected projects in the “Other Experiences” section to see how I bring data to life. 🧠 Core Expertise • Advanced modeling, reporting, and dashboards • Advanced Excel analytics: dynamic arrays, lookup architectures, data cleansing, and visualization • Automation with formulas, Power Query & VBA • Simulation & optimization (linear & non-linear programming) with Solver & @RISK • Financial modeling, valuation, and forecasting • Scenario, sensitivity, and what-if analysis (Goal Seek, Data Tables) • Statistical analysis and predictive modeling • Trend analysis (regression, smoothing, forecasting) • Survey design, analysis, and reporting • Decision support for finance, operations, and analytics teams • AI prompting and leveraging LLMs to streamline data workflows and reporting (Google Certified) Power BI, SQL, and other tools are used when they add value, not complexity. ✅ Why Clients Work With Me • Excel mastery with business judgment • Extreme ownership of outcomes, not just deliverables • Clear communication and honest expectations • Precision-driven execution under real constraints • 6+ years on Upwork, trusted by clients worldwide 🖥️ Tools & Technologies • Excel / Google Sheets (Advanced) • Power Query, Power BI, Looker Studio • @RISK, Solver • Gemini 🎓 I hold a Master’s in Finance (Data Analytics focus) with a strong foundation in Economics and Statistics. This allows me to bridge technical rigor with practical business execution.

Looking for someone who is savy on excel and google sheet, I am the guy! Excel and google sheet expert with satisfied client feedback in automating financial template and dashboard, business workflow automation and ecommerce data. I help businesses, entrepreneurs, and busy professionals save time and work smarter by providing top-quality self sustaining automated file, spreadsheet or dashboard with reasonable price. With over 9 years of engineering experience handling daily operational reports, I've built countless automation solutions using advanced Excel and google sheet formulas, VBA macros and google apps script — completing in minutes what used to take hours. I create custom tools that are fast, reliable, and 100% accurate — so you can focus on what really matters in your business. What I Can Do for You: Data Entry Automation using power query or excel macro Csv File Auto Extraction Custom Excel VBA Macros and automation Excel Form and Module Power Query for Data Transformation DAX Formula in Power BI for Smart KPIs Invoice & Purchase Order Automation Inventory and Stock Management Systems Automated Daily Reports with Auto Emailing System Customer Service System Automation within Google sheet KPI Dashboards in Excel & Power BI KPI Graphs, Charts, and PivotTables Google sheets, google apps script and looker studio reporting Custom excel/google sheet templates (Finance, Sales, Lead Generation, CRM systems, Personal budgeting, Project Management, KPI Dashboard, Human Resource Dashboard) Custom Excel Dashboard Automatic Excel/Google sheet Report Why Choose Me? 100% Job Success High-Quality, Professional Work On-Time Delivery Affordable Pricing, no extra charges for revision related to the job Whether you're a startup founder, business owner, manager, or just someone who needs a smarter spreadsheet—I’m here to make your data work for you. Let me automate your workflow while you focus on growing your business. Feel free to message me with your requirements — I’ll be available for message anytime and available for zoom or any other platform for meeting at 6pm to 12pm MYT on weekdays and 9am to 12pm MYT on weekends.

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.

🟢 4+ Years of Experience 🟢 Excel & Google Sheets Expert 🟢 Data Visualization & Automation Expert I’m a full-time Data Analyst with a passion for transforming data into useful actionable insights. I’m Proficient in Data Cleaning, Statistical Analysis, Automation and Data Visualization using tools like MS Excel, VBA, Google Sheets, Apps Script, Power BI and Looker Studio. I’ve a keen eye for patterns and trends within complex data sets, that enables me to help you automate your workflow. What I Offer: 🟢 Data Analysis ✓ Expertise in transforming raw data into meaningful insights using MS Excel and Google Sheets. ✓ Data cleaning, statistical analysis, Template Design and complex calculations through Power Query, Advanced functions and pivot tables ensuring data accuracy. 🟢 Automation ✓ Proficiency in Excel VBA and Google Apps Script for creating robust automated solutions. ✓ Development of complex macros for automating repetitive tasks to save time, reduce errors and enhance workflow efficiency. 🟢 Business Intelligence ✓ Skilled in designing intuitive visualizations using Power BI and Looker Studio. ✓ Translation of complex data sets into easily understandable visual analytics 🟢 Reporting & Dashboards ✓ Creation of automated reports and interactive dashboards that empower stakeholders to make informed decisions. ✓ Utilization of advanced techniques and tools to develop dynamic, user-friendly reporting solutions. Why should you work with me? 📌 100% Client Satisfaction 📌 Instant Response Time 📌 Strong Communication & Collaboration abilities 📌 Commitment to Quality Work 📌 On-Time Delivery Let's work together, if you're looking for a data-driven professional who can help you optimize your workflow!

🚀 Bringing Data to Life for Smarter Decision-Making 🚀 📊 $30M+ Business Impact Enabled Through Data-Driven Dashboards 📊 500+ Automated Reports Delivered 📊 Expertise Across 20+ Industries, Including E-commerce, Finance, and Healthcare With years of experience delivering advanced visualizations and automated dashboards for global clients, I specialize in turning complex datasets into clear, compelling, and actionable insights that drive results. SERVICES OFFERED: 🎯 Custom Dashboards & Reporting: Fully customized dashboards tailored to your business needs, automating data from tools like GA4, Paid Ads, and CRM systems. 🎯 Data Storytelling: Crafting compelling data narratives using advanced visualization techniques to enhance understanding and strategic decision-making. 🎯 Performance Monitoring & Insights: Real-time dashboards for monitoring KPIs, identifying trends, and uncovering opportunities for optimization. 🎯 Data Cleaning & Preparation: Ensuring accurate and clean data inputs for visualizations that are reliable and insightful. TOOLS EXPERTISE: ✅ Google Looker Studio: Advanced calculated fields, data blending, robust visuals, and custom metrics. ✅ Tableau: Interactive dashboards, advanced analytics, and performance optimization for large datasets. ✅ Power BI: Enterprise-grade dashboards with real-time data integration and predictive insights. ✅ Google Cloud Platform (GCP): Comprehensive cloud solutions for data storage, processing, and real-time pipelines. ✅ BigQuery: Scalable data warehouse for advanced querying, seamless integration with BI tools, and enabling analytics-driven insights. ✅ SuperMetrics & PowerMyAnalytics: For seamless data extraction and automation. ✅ Microsoft Excel & Google Sheets: Advanced charts, pivot tables, and data transformations. CERTIFICATIONS: 🎓 Google Data Studio Certification 🎓 Tableau Desktop Specialist 🎓 Power BI Data Analyst Associate WHY ME? ⭐ Business-Driven Visuals: My approach focuses on aligning visualizations with your business objectives. Whether it's tracking revenue, optimizing marketing campaigns, or uncovering operational inefficiencies, I create visuals that answer key questions effectively. ⭐ Technical Expertise: With expertise across the leading visualization tools, I can seamlessly integrate data from multiple platforms into a single source of truth for your team. ⭐ Creative Problem-Solving: I excel at finding innovative ways to present complex data, ensuring clarity and engagement for all stakeholders, from analysts to executives. ⭐ Proven Track Record: I’ve delivered dashboards that increased efficiency, uncovered insights, and helped businesses achieve measurable growth. ⭐ Global Collaboration: Having worked with clients across various industries worldwide, I prioritize clear communication, quick turnarounds, and collaborative workflows. CLIENT REVIEWS: 😇"The level of collaboration despite of working as remote team surpasses expectations. Very impressed." 😇"Manav helped our team tremendously with BI report rebuilds and supporting users. He's very proactive." 😇 "The team was great to work with! They delivered the work that we needed done, were very communicative and thorough with the work they were doing as well as upfront about the amount of hours they were going to need to complete the job."

→I design KPI-driven Power BI and Looker Studio dashboards that convert complex data into strategic, decision-ready intelligence. Top 3% on Upwork | 70+ clients across eCommerce, marketing, supply chain, finance, and operational analytics. → My work extends beyond dashboards. I architect automated data pipelines, attribution models, and scalable BI infrastructure that create a single source of truth for founders and executive teams. The objective is simple: faster decisions, capital efficiency, and measurable growth. 🔧 𝐓𝐨𝐨𝐥𝐬 & 𝐄𝐱𝐩𝐞𝐫𝐭𝐢𝐬𝐞: Microsoft Power BI, Google Data Studio, Google Sheets and Excel Dashboards and Trackers. API Integrations with (Windsor AI, Coupler io, Supermetrics, Fivetran, Coefficient,Powermy analytics and Synchub). Data Modeling, KPI Dashboards, BI Reporting. ETL Pipelines and AI automations via N8N and Makecom SQL Server, MySQL Azure Database, Google BigQuery Azure Synapse DAX & Power Query (M Language) CRM, ERP 🏢 𝐈𝐧𝐝𝐮𝐬𝐭𝐫𝐢𝐞𝐬 𝐒𝐞𝐫𝐯𝐞𝐝: → Digital Marketing & Performance Analytics Google Ads, Meta Ads, GA4, PPC analytics, attribution modeling, blended ROAS, MER, CAC, LTV, and conversion tracking dashboards in Power BI and Looker Studio for media efficiency and capital allocation decisions. → eCommerce & Revenue Operations Shopify, Amazon, WooCommerce revenue analytics, gross and contribution margin tracking, SKU profitability, cohort retention, AOV optimization, demand forecasting, and full-funnel revenue intelligence systems. → CRM & Lead Generation Intelligence GoHighLevel, Pipedrive, WhatConverts, Klaviyo, Mailchimp. Pipeline analytics, sales velocity, close-rate optimization, and lifecycle performance reporting for scalable growth. → Inventory, Retail & Operations Analytics Inventory turnover, stock-out risk, supply chain KPIs, retail sales performance, production efficiency, cost variance analysis, and operational forecasting dashboards. → Healthcare, Hospitality & Real Estate Analytics Clinic revenue dashboards, patient acquisition tracking, hotel occupancy and RevPAR analytics, and real estate sales pipeline intelligence. 📈𝐖𝐡𝐚𝐭 𝐈 𝐃𝐞𝐥𝐢𝐯𝐞𝐫: → Revenue Analytics & Profitability Intelligence I design executive dashboards in Power BI and Google Looker Studio aligned with Gross Margin, Net Revenue, Contribution Margin, LTV, CAC, MER, Blended ROAS, AOV, Cohort Retention, and Cash Flow Forecasting. → End to End Data Engineering & Automation I build automated ETL pipelines using Power Query, SQL, BigQuery, and API integrations to eliminate spreadsheet dependency. Your data syncs daily across Shopify, Amazon Seller Central, GA4, Meta Ads, Google Ads, Klaviyo, and CRM systems. No manual reporting. No fragmented data silos. → Full Funnel Marketing Attribution & Media Efficiency I implement performance tracking systems to calculate exact Customer Acquisition Cost, Customer Lifetime Value, MER, Blended ROAS, and Incrementality. I build attribution models that support media scaling decisions and budget reallocation strategies. → Advanced Data Modeling & DAX Architecture I develop Power BI data models using Star Schema design, optimized DAX measures, and transformation logic in M Language. → eCommerce Operations & Inventory Intelligence I create demand forecasting models, SKU level profitability trackers, inventory turnover analysis, stock out risk indicators, and cash flow planning dashboards to improve operational efficiency and working capital management. → Predictive Analytics & Revenue Forecasting I build time series trend analysis, cohort retention analysis, customer segmentation models, and revenue projections to support strategic planning and board level reporting.

I am a highly organized Virtual Assistant and Excel Specialist with over 7 years of experience in Microsoft Excel and Google Sheets. I hold a degree in Industrial Statistics and Mathematical Finance from the University of Colombo and have successfully completed more than 1,000 projects for clients worldwide. In addition to advanced Excel expertise, I provide reliable virtual assistance, project coordination, administrative support, calendar management, data organization, and communication support to help businesses operate more efficiently. My strong attention to detail, time management skills, and ability to coordinate tasks across teams ensure that projects are completed accurately and on time. My expertise includes: • Excel Report Automation using VBA, Power Query, and Advanced Formulas • Custom Excel and Google Sheets Template Design • Virtual Assistance and Administrative Support • Calendar, Email, and Appointment Management • Project Coordination and Follow-Up Tracking • Data Entry, Data Collection, and Internet Research • Dashboard Development and Data Visualization • Power Pivot and Data Consolidation Solutions • Excel Macro Development for Process Automation • Advanced Formula Creation and Data Analysis • Excel to PDF and Other File Conversion Solutions • Detailed Business Reports and Performance Tracking • Spreadsheet Maintenance, Data Cleaning, and Validation I am committed to delivering 100% original, high-quality work with excellent communication and timely project completion. Whether you need a dependable Virtual Assistant, an Excel automation expert, or someone to coordinate and streamline your daily operations, I am here to help. Feel free to contact me anytime to discuss your project requirements.

Need business trackers and KPI dashboards that actually run your day, not your time? I build clean, dependable solutions in Excel and Google Sheets so your team gets accurate numbers, automated updates, and decisions at a glance. 📊⚡ HOW I CAN HELP YOU • 📈 Executive dashboards (finance, sales, operations, PMO) with drill-downs, trends, and alerts • 🧭 Business trackers: budget vs. actual, cash flow, sales pipeline/CRM, project & task status, inventory, OKRs • 🧹 Data quality: Power Query transformations, validation rules, error checks, audit trails, tidy models • 🤖 Automation: one-click reports, scheduled refreshes, PDF/email exports (VBA & Apps Script) • 🔗 Integrations: CSV/API/Sheets/Excel into refreshable models; optional Power BI layer for leadership views • 📝 Smooth handoff: concise user guides, Loom walkthroughs, and lightweight documentation for your team CLIENT RESULTS & SOCIAL PROOF ⭐ “Mohammed did a great work! Delivered exactly what I asked for and on time. Communication was smooth and the dashboard looked clean and professional. Would definitely hire again.” Juman (Budget Tracker) ⭐ “Highly professional, very responsive, and delivers quality work on time. His attention to detail and proactive updates made the process smooth and efficient.” Ade (Project Management Tool) ⭐ “Mohammed is one of the best and most efficient professionals I've worked with! Always willing to accommodate every request and always very creative!" Harry (Meal plan company system) • Recent wins: • a complete finance & operations management system in Google Sheets for a meal-plan company • a digital financial planner integrating budget, savings, and real-time dashboards • a full projects tracking system with executive project overview dashboard • a one-click Google Sheets budget tracker digital product with automated logging and dropdown inputs • an Excel Budget-vs-Actual report with dynamic tables and variance drill-downs • a sales performance tracker combining robust backend logic with intuitive visuals LET’S GET STARTED ☎️ Share your goal, the KPIs that matter, I’ll reply with a short plan, clear options, and a quick timeline. Ready to move? Message me and let’s build a tracker or dashboard that saves time and drives decisions. 🚀 MY SKILLS, EXPERIENCES, AND TECHNOLOGIES • Excel: Power Query, Power Pivot, Pivot Tables, Dynamic Arrays, XLOOKUP, INDEX/MATCH, SUMPRODUCT, VBA automation • Google Sheets: QUERY, ARRAYFORMULA, FILTER, IMPORTRANGE, Apps Script, protected ranges, real-time collaboration • Reporting workflow: requirements gathering, KPI design, QA checks, stakeholder-friendly documentation and handoffs • Domains: finance & budgeting, sales performance, PMO/project tracking, operations metrics, executive KPI packs KEYWORDS Excel expert, Google Sheets expert, Power BI, KPI dashboard, business tracker, budget vs actual, cash flow tracker, sales dashboard, project tracker, inventory tracker, OKR dashboard, variance analysis, financial modeling, Power Query, DAX, VBA, Apps Script, automation, data cleaning, data modeling, business intelligence, reporting templates, ETL, data pipeline

Hi, I'm Sonay. I help businesses turn messy, complex data into highly organized, automated, and visually striking Excel and Google Sheets dashboards. Instead of overwhelming spreadsheets, I focus on user-centered layouts, functional aesthetics, and logical structures so you can quickly track metrics and make accurate decisions. My expertise and proven track record on Upwork include: • Automated Dashboard Design: Creating dynamic KPI displays, sales funnels, and automated budget/expense trackers with clean visual charts. • Data Structuring & Management: Cleaning, organizing, and consolidating large datasets for seamless daily tracking and academic research. • Custom Template Formulations: Designing professional tracking systems, from website/social media engagement trackers to detailed project cost management tools. I prioritize flawless accuracy, clear communication, and timely delivery. Let's work together to transform your data into a practical, beautiful, and fully automated system built around your specific needs.

Transform Your Workflows with Expert Google Apps Script Automation Are you looking to streamline your processes, reduce manual effort, and enhance productivity? I’m a seasoned Google Apps Script (GAS) automation developer with over three years of specialized experience, ready to take your operations to the next level. What I Bring to the Table: -AppSheet Solutions Across Industries: With over 20 custom-built AppSheet applications in fields ranging from medical and industrial to chemical testing and home inspections, I create intuitive, powerful applications tailored to meet industry-specific needs. My apps optimize data collection, analysis, and reporting, streamlining workflows and improving productivity. - Advanced Automation Expertise: I craft powerful automation scripts and formulas that elevate the functionality of Google services. Whether it’s automating repetitive tasks or integrating complex systems, I bring efficiency and precision to every project. - Seamless API Integrations: From Google Sheets to Google Forms, Google Document AI (OCR), and third-party platforms like Zapier, Make.com, and DocuSign, I have a proven track record of integrating APIs that unlock new levels of functionality. Key Areas of Specialization: - Inventory Management Automation: Say goodbye to manual updates and errors. I automate your inventory management using Google Sheets, ensuring real-time updates, automated stock alerts, and accurate order tracking—so you can focus on growing your business. - Form Submission Automation: Free up your time with automated actions post-form submissions. For example, I’ve developed scripts that automatically score trivia events, providing instant feedback and results—allowing hosts to enjoy the event without the hassle of manual scoring. - Data Mastery with Google Sheets: Whether it’s crafting complex formulas, generating insightful pivot tables, or designing compelling charts, I make sure your data works for you, not the other way around. - AI-Powered Data Extraction: In data-driven industries like healthcare, I harness the power of AI OCR to accurately extract crucial information from documents. By integrating Google Document AI with Google Sheets, I streamline data processing, significantly reducing errors and manual input. Why Work with Me? My mission is to empower businesses by leveraging automation and cutting-edge tools. With a focus on enhancing efficiency, accuracy, and decision-making, I’m here to help you optimize your workflows and achieve your goals faster. Let’s collaborate to transform your processes into seamless, automated operations that drive success.