I will build automated excel dashboards, power query models and sql pipelines


About this gig
Are manual copy-pasting, broken VLOOKUP formulas, and messy reconciliations soaking up hours of your work week?
I help business owners and teams replace manual spreadsheet headaches with smooth, 1-click automated workflows and clear executive dashboards.
How I Can Help You:
- Power Query Automation: Say goodbye to repetitive data prep. Automatically merge, transform, and clean raw files in seconds.
- SQL Database Connections: Streamline raw database extracts straight into your spreadsheets for real-time reporting.
- Data Modeling & DAX Measures: Build solid Star Schema models with dynamic year-over-year metrics, variance checks, and custom profit calculations.
- Executive-Ready Dashboards: Turn dense tabular data into clean, interactive scorecards with dynamic slicers and KPI alerts.
Featured Portfolio Assets:
- Multi-Currency Financial Reconciliation Pipeline
- Automated Inventory, Sales & Margin Tracking Engine
Quick note before ordering: Every dataset is unique! Please send me a quick message before placing an order so we can discuss your specific data layout and project goals to ensure the best results.
Get to know Fariha Asif
Data Automation and Financial Reporting Specialist
- FromPakistan
- Member sinceOct 2026
Languages
Urdu, English
My Portfolio
FAQ
Q1: Can you connect my raw SQL database directly to Excel?
Yes! I can write custom SQL scripts to pull, filter, and aggregate data directly into Power Query or Excel, eliminating manual exports and copy-pasting completely.
Q2: What if my raw files change format or have messy data types?
I build automated Power Query ETL pipelines that automatically clean dirty data, trim spaces, fix date formats, and append new data seamlessly upon refresh.
Q3: How do I share my dataset safely with you?
You can share mock/anonymized sample files (with sensitive company information removed or scrubbed) or share sample structural templates. I maintain 100% data confidentiality.
Q4: Will I be able to update the dashboard myself once you deliver it?
Absolutely! I design 1-click update pipelines. You simply drop your new raw data files into the designated folder and click Data -> Refresh All. I also include a 60-second video walkthrough showing you exactly how to operate it.
Q5: Do you support multi-currency calculations and dynamic financial formulas?
Yes, I use Power Pivot and DAX formulas to evaluate row-level currency conversions, variance logic, and dynamic profit margins across various date ranges.
Q6: Why should I message you before placing an order?
Every dataset and reporting setup is unique. Contacting me first allows us to clarify your specific scope, verify file structures, and ensure you get the exact package tailored to your needs.

