IH
Ivan Hoffman
Business Intelligence Analyst
Home
Projects
Power BIBusiness CentralAutomationsCRM
Thinking
Analytics Approach
About
ResumeContact
HomePower BIBusiness CentralAutomationsCRMAnalytics ApproachResumeContact

Power BI

Dashboards and analytics solutions built around operational decision-making, KPI tracking, and ERP data.

Purchase Order Health
Open PO risk, vendor follow-up visibility, and inbound risk signals using Business Central data.
→
Power BIERPPurchasing
Item Recommendations
Projects demand from trend history and recommends replenishment controls (reorder point, min/max inventory, and order quantities).
→
InventoryDemand PlanningDAX
Top Stocked Items
Surfaces inventory concentration by quantity and value to highlight where cash is tied up.
→
InventoryWorking CapitalReporting
Daily Sales Order Report
Daily volume trends, shipped vs entered visibility, and KPI validation for leadership reporting.
→
Power BIDAXOperations
Inventory Velocity
Fast/slow movers, dead stock signals, and movement trends to support inventory decisions.
→
InventoryModelingKPI Design
2025 Drop Ship & Fulfillment
Tracks fulfillment speed (Days to Fill) and Drop Ship % trends by month across 2025.
→
FulfillmentDrop ShipTrends
Invoice Profit (Line-Level)
Vendor-attributed profitability with invoice → item drilldown, COGS from Value Entries, and clean freight/charges handling.
→
ProfitabilityBusiness CentralModelingDAX
Zendesk Support Dashboard
Ticket volume, backlog, CSAT % Good, ETA/backorders/shortages KPIs, and resolution-time analytics with rolling date ranges.
→
ZendeskSupport OpsPower BIKPI Design
© 2026 built by Ivan Hoffman · with Next.js & Tailwind