Professional Data Analyst, Excel Expert & BI Specialist | Google Certified
Hello! I’m Abaid Ullah, a Master’s degree holder in Mathematics, an experienced teacher, and a professional Data Analyst & Spreadsheet Expert with several years of hands-on freelance experience helping businesses make smarter, faster, and data-driven decisions.
Along with my academic background, I have completed Google’s Data Analytics Certification, strengthening my advanced analytical, data cleaning, visualization, and reporting skills. Over the years, I have built fully automated business systems, dashboards, trackers, performance analytics, and clean, structured datasets for clients across e-commerce, education, healthcare, marketing, real estate, and more.
I help companies transform scattered data into meaningful insights using powerful automation, clean structures, and professional dashboards. My solutions are focused on accuracy, scalability, and ease of use.
Excel & Google Sheets Development
- Automated dashboards & reports
- Advanced formulas (XLOOKUP, ARRAY formulas, LET, LAMBDA, INDEX/MATCH)
- Power Query transformations
- VBA automation & custom workflows
- Data cleaning & structuring
- Business trackers (attendance, finance, CRM, operations, sales, etc.)
Data Analysis & Reporting
KPI design & performance monitoring
Trend, growth, and comparison analysis
Forecasting, statistics & modeling (leveraging mathematics background)
Marketing & sales analytics
E-commerce performance insights
Custom reporting frameworks
Period-over-period analysis (MoM, YoY, WoW)
Business Intelligence & Dashboards
Power BI (DAX calculations, modeling, interactive dashboards)
Looker Studio & Data Studio reports
Automated refreshable reporting pipelines
SQL-based datasets
Connecting APIs, Sheets, databases, and BI tools
Database, Integration & Automation
SQL Server database design, ETL, and data pipelines
AppScript automation in Google Sheets
Data syncing between Sheets ↔ SQL ↔ Power BI
API data extraction & scheduled automation scripts
Advanced data flow setups for websites & CRMs
Custom Systems I Build
Lead management systems
Attendance apps (online/offline syncing)
Financial models & profitability analysis
Inventory & order dashboards
Performance OS for marketing agencies
Website analytics dashboards (Google Analytics → Sheets → BI)
Client inquiry/CRM systems
Hospital data entry systems with secure login & forms (Excel + VBA)
Technical Skills & Keywords
Excel, Google Sheets, VBA, AppScript, Power BI, Looker Studio, Data Analysis, Dashboard Design, Data Cleaning, Data Automation, SQL, SQL Server, API Integration, ETL, Python, Business Intelligence, Reporting, KPIs, Forecasting, Data Modeling, Pivot Tables, Power Query, DAX, CRM Development, Operational Dashboards, Marketing Analytics, E-commerce Analytics, Database Management, Spreadsheet Expert, Data Analyst, Automation Specialist.