Ali A.

I'm a Data Analyst and BI Developer with over 4 years of experience turning raw data into interactive analytics dashboards, reporting solutions, and automated workflows. I'm Top Rated on Upwork, with 130+ data analytics projects delivered and 1,000+ hours billed. I help businesses improve reporting, streamline processes, and make better decisions using their data with Power BI, Excel, Looker Studio, SQL, and Python. I work across the full data lifecycle, from extracting and cleaning data to building reliable data models, developing analytical solutions, and automating recurring reports. I translate business questions into measurable metrics and create clear, audience-focused reports. My goal isn't just to make dashboards look good. It's to make them useful. I focus on the KPIs, trends, risks, and opportunities that help stakeholders make informed decisions, supported by clear documentation and maintainable solutions. What I Specialize In Power BI Development & Dashboards ☑️ Interactive executive dashboards with KPI tracking, drill-throughs & bookmarks ☑️ Advanced DAX (time intelligence, dynamic KPIs) & Power Query (M) ☑️ Star-schema data models, semantic models & row-level security (RLS) ☑️ Paginated reports & SSRS-to-Power BI migration ☑️ Power BI Service deployment with scheduled refresh (web & mobile) Excel, Looker Studio & Google Workspace ☑️ Advanced Excel: PivotTables, Power Pivot, lookup functions & VBA automation ☑️ Financial models: 3-statement, DCF valuation, cash flow forecasting & budget vs actual ☑️ Marketing & performance dashboards in Looker Studio (GA4, Google Ads) ☑️ Google Sheets & Apps Script automation Analytics & Reporting ☑️ Financial analysis, performance tracking, sales analytics & inventory/supply chain dashboards ☑️ Digital marketing & PPC performance analysis ☑️ GA4 web analytics: traffic, conversions, funnels & attribution reporting ☑️ Stock market & portfolio data analysis ☑️ Survey data analysis & GIS-supported research SQL, Data Modeling & ETL ☑️ SQL querying & database modeling across Microsoft SQL Server, Azure SQL & Microsoft Fabric ☑️ ETL pipelines & data cleansing for messy, multi-source data ☑️ Microsoft data platforms: Azure Synapse Analytics, Fabric Data Warehouse & Azure Data Factory ☑️ Audits of legacy reports: hard-coded values, duplicate loads & broken references Python & Automation ☑️ Python (Pandas) for data cleaning, transformation & analysis ☑️ Automated reporting pipelines with scheduled refreshes & triggers ☑️ REST API & OAuth 2.0 data extraction and integration ☑️ Forecasting, trend & anomaly detection ☑️ AI-assisted automation (LLM APIs, MCP servers, RAG & FastAPI) ☑️ Git/GitHub version control & well-documented, maintainable code Data Sources & Integrations ☑️ Files & storage: Excel, CSV, Google Sheets, SharePoint, OneDrive ☑️ Marketing platforms: Google Ads, Meta Ads, GA4, LinkedIn Ads, Search Console ☑️ CRM & ERP: Salesforce, HubSpot, Zoho, Wealthbox, Dynamics 365, NetSuite, QuickBooks, Xero ☑️ REST APIs, OAuth 2.0 & Webhooks I have audited and improved data workflows, reporting processes, and analytics solutions to enhance accuracy, efficiency, and reliability. I focus on identifying issues, streamlining processes, and building well-documented, maintainable solutions that adapt to evolving business needs. If your spreadsheets are unreliable, your data sources don't talk to each other, or your dashboards haven't scaled with your business, that's exactly the kind of problem I solve. My Background: I hold the Microsoft Power BI Data Analyst Professional Certificate and studied Mathematics at NUST, which gave me a strong foundation in statistical thinking, a skill I use every day. Since then, I've worked with clients on Upwork and directly, building a proven track record across a wide range of industries and data challenges. I look forward to working with you. Feel free to reach out to discuss your project, share your goals, and explore how we can work together to achieve them. Best, Ali Ahmad J.