İlhan Kazan

Senior Software Developer and Team Lead, ÇAP Teknoloji. Leads the software team at ÇAP Teknoloji. Works on the development of ÇAP AI BI, the AI-powered business intelligence and forecasting platform, and the S-Leader field sales automation platform, as well as Logo ERP integrations and SQL Server based applications.

Joined: July 27, 2026
Articles: 45

Business Intelligence (BI)

Power BI Row-Level Security (RLS): Protect SME Reports by Role

Power BI row-level security: locked shared dataset on the left; sales and finance lanes with filtered rows on the right; wide manager lane below showing all rows

Share one Power BI report safely: cut row leakage in the model with roles, DAX filters and a publish checklist.

İlhan Kazan
October 16, 2026

SQL / Database

SQL Server Index Maintenance: Fragmentation and Rebuild Guide

SQL Server index maintenance: four stair steps left to right — fragmented uneven index bars with a warning, REORGANIZE sync arrows, REBUILD gear with a green progress bar, healthy even index bars with a green check; a fragmentation donut above

SQL Server index maintenance measures fragmentation and fixes it with REORGANIZE or REBUILD. When to use each, a safe plan and a checklist.

İlhan Kazan
October 9, 2026

Sales Automation

Credit Limit Control in Field Sales: How to Stop Risky Orders Before They Ship

Credit limit control: customer shop card with an open-balance ledger and an overdue row on the left, a credit-limit gauge with its needle in the red zone and a usage bar overshooting the limit in the middle, an ERP server and balance database below, and the rep's phone on the right with the new order on hold and a locked confirm button

Credit limit control in field sales compares the customer's open balance and the new order value with the credit limit in the ERP the moment a rep enters an order. The check flow, practical rules for the field and a rollout checklist.

İlhan Kazan
October 7, 2026

Sales Automation

Field Sales Stock Reservation: How to Reserve Inventory at Order Time

Field sales stock reservation: warehouse panel (database, free crates and a locked reserved crate) with a phone showing order and reserve actions

Field sales stock reservation sets inventory aside at order time so the same quantity is not promised twice.

İlhan Kazan
October 3, 2026

Sales Automation

Offline Field Sales App: Managing Orders and Inventory Without Internet

Offline field sales app: orders queued on a tablet on a rural route with no signal, waiting to sync

A dependable offline field sales app allows field teams to process orders, verify credit terms, and track inventory without cellular reception, syncing reliably once back online.