Excel BI skills for AI agents / 面向 AI Agent 的 Excel BI 技能包: VBA, Power Query M, Power Pivot DAX, MDX/CUBE, ADO/SQL, QA.

AI-Powered Procurement Intelligence Dashboard — Python + Excel Power Query + Gemini API

Primary Health Centers (PHCs) are the backbone of rural healthcare—but data on their performance is often scattered, out-of-date, or hard to interpret. I created this end-to-end analytics solution to bridge that gap, empowering health teams to make real-time decisions with confidence.

Build Power BI-like Excel executive dashboards with Power Query, Power Pivot, DAX, PivotTables, PivotCharts, and slicers.

Healthcare Operations Intelligence Platform | End-to-end Power BI project featuring SQL-based data modeling, DAX measures, and 7 interactive dashboards for executive, patient, doctor, hospital, billing, appointment, and lab analytics with actionable business insights.

Complete Power BI skill for OpenClaw AI agents — DAX, Power Query, REST API, Semantic Link & report automation

Interactive Power BI dashboard analyzing global terrorism trends using GTD with KPIs, Map by Squillion, TMap, Filled Map, slicers, and drill-through analysis.

Interactive Power BI dashboard analyzing pharmacy sales, profitability, customer behavior, and inventory performance using DAX, Power Query, and business intelligence reporting.

Sales and profit analysis dashboard built with Microsoft Power BI

comprehensive Business Intelligence & Data Analytics dashboard for Zain Cash (Iraq FinTech) built using Power BI, SQL, and DAX.

10 hands-on Microsoft Power BI Data Analyst PL-300 labs covering Power Query, data profiling, star schema modeling, DAX, time intelligence, performance optimization, reports, storytelling, AI visuals, workspaces, refresh, dashboards, apps, RLS, sensitivity labels, and exam readiness.

An end-to-end Business Intelligence project analyzing public transparency data from Rio Grande do Sul (Brazil). Features a data engineering pipeline using Python (Polars) and interactive Power BI dashboards.

Premium Power BI dashboard analyzing Paris 2024 Olympics using DAX, Power Query, Python, and custom GEOJSON maps for athlete, medal, country, and historical Olympic insights.

Análise de custos logísticos no e-commerce com foco na redução de frete e geração de insights financeiros (Potencial de~R$114 mil).

Business Intelligence pipeline using Python, SQL, Power Query, Power Pivot, DAX and Excel to build an executive sales dashboard.

Stage-by-stage finance reconciliation pipeline (Python + SQLite): ingest exports, normalize vendors, match transactions ↔ payments, flag exceptions, and build refreshable Excel/Power Query dashboards.

Power BI Dashboard Portfolio showcasing real-world projects on sales analysis, customer insights, risk analysis, and business performance reporting using Power BI, DAX, Power Query, and data modeling. Includes interactive dashboards, KPIs, and analytical reports.

Export Power Query M scripts from Excel workbooks into standalone .pq files.

Risk & return analysis of 150K LendingClub loans ,Python preprocessing, Excel/Power Query cleaning, and an interactive Power BI dashboard. Finds the highest-interest loan grades are the least profitable once defaults are counted.

A labor market intelligence platform that analyzes 123K+ job postings and 213K+ skill mappings to uncover hiring trends, skill demand, salary patterns, and career insights.