📊 Dashboard
📁 Projectcts 3
🔌 Connections 5
🪙 Token Economics
📜 Audit 24
⚙ Settings
+ New Projectct
| Agent ▲ | Status | Progress | Token | Cost | Son Runma |
|---|---|---|---|---|---|
| 🔒 Axoria Privacy | ✓ Completed | 8.4K | $0.03 | 14:32 | |
| 🔎 Axoria Explorer | ✓ Completed | 84K | $0.31 | 14:35 | |
| 🛡 Axoria Guard | ⚠ Warning | 52K | $0.19 | 14:38 | |
| 🏗 Axoria Architect | 👁 Review | 68K | $0.25 | 14:42 | |
| 🎨 Axoria Mockup | ✓ Completed | 24K | $0.08 | 14:44 | |
| ⚙ Axoria Pipeline | ✓ Completed | 60K | $0.22 | 14:48 | |
| 📈 Axoria Pulse | ✓ Completed | 22K | $0.08 | 14:52 |
| PII Tipi ▲ | Kolon Sayisi | Maskeleme | Ornek | Risk | |
|---|---|---|---|---|---|
| TC Kimlik No | 3 | SHA-256 | a3f2*** | High | |
| E-posta | 5 | Mask | a***@***.com | High | |
| Telefon | 4 | Mask | +90 5** *** **42 | Medium | |
| IBAN | 2 | Tokenize | TR**...7890 | High | |
| Ad Soyad | 6 | Pseudonym | Kullanici_42 | Medium | |
| Adres | 3 | Generalize | Istanbul, TR | Medium | |
| Dogum Datei | 2 | Age Band | 30-40 | Dusuk | |
| IP Address | 1 | Truncate | 192.168.*.* | Dusuk |
| Kaynak Tablo | Staging Tablo | Satir | Maskelenen Kolon | Status |
|---|---|---|---|---|
| dbo.Customers | stg.Customers | 4,200 | 5 | ✓ |
| dbo.Employees | stg.Employees | 850 | 6 | ✓ |
| dbo.Orders | stg.Orders | 12,400 | 2 | ✓ |
| dbo.Suppliers | stg.Suppliers | 320 | 3 | ✓ |
| dbo.Contacts | stg.Contacts | 1,890 | 4 | ✓ |
| Tablo Adi ▲ | Kolon Sayisi | Satir Sayisi | PK | FK | Null% | Tip | |
|---|---|---|---|---|---|---|---|
| dbo.SalesOrderHeader | 26 | 31,465 | SalesOrderID | 3 | 2.1% | Fact | |
| dbo.SalesOrderDetail | 11 | 121,317 | SalesOrderDetailID | 2 | 0% | Fact | |
| dbo.Product | 25 | 504 | ProductID | 4 | 12.8% | Dim | |
| dbo.Customer | 18 | 19,820 | CustomerID | 2 | 5.2% | Dim | |
| dbo.Employee | 16 | 290 | EmployeeID | 3 | 8.1% | Dim | |
| dbo.ProductCategory | 4 | 41 | CategoryID | 0 | 0% | Ref | |
| dbo.Address | 9 | 19,614 | AddressID | 1 | 1.5% | Dim | |
| dbo.PurchaseOrderHeader | 14 | 4,012 | PurchaseOrderID | 2 | 3.2% | Fact |
| # | KPI Adi | Formul | Kaynak Tablolar | Kategori |
|---|---|---|---|---|
| 1 | Toplam Gelir | SUM(TotalDue) | SalesOrderHeader | Finansal |
| 2 | Mediumlama Siparis Degeri | AVG(TotalDue) | SalesOrderHeader | Finansal |
| 3 | Siparis Sayisi | COUNT(SalesOrderID) | SalesOrderHeader | Operasyonel |
| 4 | Musteri Sayisi | COUNT(DISTINCT CustomerID) | Customer | Operasyonel |
| 5 | Urun Basina Gelir | SUM(LineTotal)/COUNT(ProductID) | SalesOrderDetail | Finansal |
| 6 | Iade Orani | COUNT(ReturnFlag)/COUNT(*) | SalesOrderHeader | Kalite |
| 7 | Brut Kar Marji | (Revenue-COGS)/Revenue | SalesOrderDetail, Product | Finansal |
| 8 | Teslim Suresi (Ort) | AVG(ShipDate-OrderDate) | SalesOrderHeader | Operasyonel |
| 9 | Aktif Urun Sayisi | COUNT(CASE WHEN Status='Active') | Product | Operasyonel |
| Kaynak Tablo | Kaynak Kolon | Hedef Tablo | Hedef Kolon | Tip | Kardinalite |
|---|---|---|---|---|---|
| SalesOrderHeader | CustomerID | Customer | CustomerID | FK | N:1 |
| SalesOrderDetail | SalesOrderID | SalesOrderHeader | SalesOrderID | FK | N:1 |
| SalesOrderDetail | ProductID | Product | ProductID | FK | N:1 |
| Product | CategoryID | ProductCategory | CategoryID | FK | N:1 |
| SalesOrderHeader | ShipToAddressID | Address | AddressID | FK | N:1 |
| Employee | ManagerID | Employee | EmployeeID | Self | N:1 |
| PurchaseOrderHeader | EmployeeID | Employee | EmployeeID | FK | N:1 |
| Kolon | Tablo | Tip | Null% | Distinct | Min | Max | Ort |
|---|---|---|---|---|---|---|---|
| TotalDue | SalesOrderHeader | decimal | 0% | 28,432 | 1.37 | 187,487 | 3,915 |
| OrderDate | SalesOrderHeader | datetime | 0% | 1,124 | 2021-01 | 2026-01 | - |
| LineTotal | SalesOrderDetail | decimal | 0% | 94,201 | 0.98 | 27,893 | 847 |
| ListPrice | Product | decimal | 12.8% | 103 | 0 | 3,578 | 438 |
| # | Kural | Tablo | Kolon | Tip | Sonuc | Seviye | |
|---|---|---|---|---|---|---|---|
| 1 | NOT NULL check | Product | Weight | Completeness | FAIL | High | |
| 2 | Unique constraint | Customer | Uniqueness | FAIL | High | ||
| 3 | FK integrity | SalesOrderDetail | ProductID | Consistency | FAIL | High | |
| 4 | Range check | Product | ListPrice | Validity | WARN | Medium | |
| 5 | Date format | SalesOrderHeader | OrderDate | Validity | PASS | Dusuk | |
| 6 | NOT NULL check | Customer | FirstName | Completeness | PASS | Medium | |
| 7 | Enum check | SalesOrderHeader | Status | Validity | PASS | Dusuk | |
| 8 | Pattern match | Customer | Phone | Validity | WARN | Medium | |
| 9 | PK uniqueness | SalesOrderHeader | SalesOrderID | Uniqueness | PASS | Dusuk | |
| 10 | Cross-table ref | Address | StateProvince | Consistency | PASS | Dusuk | |
| 11 | Freshness check | SalesOrderHeader | ModifiedDate | Timeliness | PASS | Dusuk | |
| 12 | Schema drift | Product | * | Consistency | PASS | Medium |
| Tablo Adi | Tip | Kolon Sayisi | Kaynak Tablo(lar) | Grain | Tahmini Satir |
|---|---|---|---|---|---|
| fact_sales | Fact | 18 | SalesOrderHeader, SalesOrderDetail | Siparis Satiri | 121K |
| fact_purchase | Fact | 12 | PurchaseOrderHeader, PurchaseOrderDetail | Siparis Satiri | 8.5K |
| fact_inventory | Fact | 8 | ProductInventory | Urun/Lokasyon | 1,069 |
| fact_production | Fact | 10 | WorkOrder, WorkOrderRouting | Is Emri | 72K |
| fact_customer_activity | Fact | 9 | Customer, SalesOrderHeader | Musteri/Ay | 45K |
| dim_customer | Dim | 14 | Customer, Person | Musteri | 19.8K |
| dim_product | Dim | 16 | Product, ProductCategory, ProductModel | Urun | 504 |
| dim_date | Dim | 22 | Generated | Gun | 3,652 |
| dim_employee | Dim | 12 | Employee, Person | Employee | 290 |
| dim_geography | Dim | 8 | Address, StateProvince | Konum | 19.6K |
| dim_supplier | Dim | 9 | Vendor | Tedarikci | 104 |
| dim_currency | Dim | 4 | Currency, CurrencyRate | Para Birimi | 105 |
| dim_promotion | Dim | 7 | SpecialOffer | Promosyon | 16 |
| agg_sales_monthly | Agg | 8 | fact_sales, dim_date | Ay | 720 |
| agg_product_performance | Agg | 10 | fact_sales, dim_product | Urun/Ceyrek | 2,016 |
| Versiyon | Date | Degisiklik | Olusturan | Status | Action |
|---|---|---|---|---|---|
| v1.2 | 2026-03-22 14:42 | Agg tableslari eklendi, FK duzeltme | AI Agent | Review | |
| v1.1 | 2026-03-22 10:15 | dim_promotion eklendi | AI Agent | Approved | |
| v1.0 | 2026-03-21 16:30 | Ilk model created | AI Agent | Approved |
| # | Sayfa | Gorsel Sayisi | Filtre | DAX Measure | Drill-through |
|---|---|---|---|---|---|
| 1 | Executive Dashboard | 8 | Date, Bolge | 6 | Var |
| 2 | Satis Analizi | 6 | Urun, Kategori, Date | 8 | Var |
| 3 | Musteri Segmentasyonu | 5 | Segment, Bolge | 4 | Yok |
| Model | Tip | Materialization | Bagimlilik | Status |
|---|---|---|---|---|
| stg_sales_order_header | Staging | view | source | ✓ |
| stg_sales_order_detail | Staging | view | source | ✓ |
| int_sales_joined | Intermediate | ephemeral | stg_sales* | ✓ |
| fact_sales | Mart | table | int_sales_joined | ✓ |
| dim_customer | Mart | table | stg_customer | ✓ |
| Paket Adi | Kaynak | Hedef | Tip | Satir Sayisi | Status |
|---|---|---|---|---|---|
| Load_DimCustomer.dtsx | SQL Server ERP | DWH | Full Load | 19,820 | ✓ |
| Load_DimProduct.dtsx | SQL Server ERP | DWH | Full Load | 504 | ✓ |
| Load_FactSales.dtsx | SQL Server ERP | DWH | Incremental | 121,317 | ✓ |
| Kaynak Tablo | Kaynak Kolon | Hedef Tablo | Hedef Kolon | Donusum |
|---|---|---|---|---|
| SalesOrderHeader | SalesOrderID | fact_sales | order_number | CAST(VARCHAR) |
| SalesOrderHeader | OrderDate | fact_sales | date_key | CONVERT(INT, FORMAT) |
| SalesOrderHeader | CustomerID | fact_sales | customer_key | LOOKUP dim_customer |
| SalesOrderDetail | ProductID | fact_sales | product_key | LOOKUP dim_product |
| SalesOrderDetail | OrderQty | fact_sales | quantity | DIRECT |
| SalesOrderDetail | UnitPrice | fact_sales | unit_price | DIRECT |
| SalesOrderDetail | LineTotal | fact_sales | line_total | DIRECT |
| SalesOrderHeader | TotalDue | fact_sales | total_due | DIRECT |
| Measure Adi | Formul | Kategori | Format | |
|---|---|---|---|---|
| Total Revenue | SUM(fact_sales[total_due]) | Finansal | $#,##0 | |
| Total Orders | DISTINCTCOUNT(fact_sales[order_number]) | Operasyonel | #,##0 | |
| Avg Order Value | DIVIDE([Total Revenue],[Total Orders]) | Finansal | $#,##0.00 | |
| YoY Growth | VAR _cy=[Total Revenue] VAR _py=CALCULATE(...SAMEPERIODLASTYEAR) RETURN DIVIDE(_cy-_py,_py) | Time Intel | 0.0% | |
| Revenue MTD | TOTALMTD([Total Revenue],dim_date[full_date]) | Time Intel | $#,##0 | |
| Revenue QTD | TOTALQTD([Total Revenue],dim_date[full_date]) | Time Intel | $#,##0 | |
| Revenue YTD | TOTALYTD([Total Revenue],dim_date[full_date]) | Time Intel | $#,##0 | |
| Gross Margin | DIVIDE(SUM(fact_sales[line_total])-SUM(fact_sales[unit_cost]*[quantity]),SUM([line_total])) | Finansal | 0.0% | |
| Customer Count | DISTINCTCOUNT(fact_sales[customer_key]) | Operasyonel | #,##0 |
| Ad ▲ | Tip | Motor | Host | Port | Status | Son Test | Action | |
|---|---|---|---|---|---|---|---|---|
| SQL Server - ERP Prod | RDBMS | SQL Server 2019 | erp-sql-prod.internal | 1433 | Aktif | 2026-03-22 13:15 | ||
| PostgreSQL - Analytics | RDBMS | PostgreSQL 15 | analytics-pg.internal | 5432 | Aktif | 2026-03-22 12:00 | ||
| Azure SQL - DWH | Cloud | Azure SQL Database | dwh-server.database.windows.net | 1433 | Aktif | 2026-03-22 11:30 | ||
| Oracle - Finans | RDBMS | Oracle 19c | oracle-fin.internal | 1521 | Aktif | 2026-03-21 18:00 | ||
| MySQL - Legacy CRM | RDBMS | MySQL 8.0 | crm-mysql.internal | 3306 | Hata | 2026-03-20 09:00 |
| Agent ▲ | Input Token | Output Token | Total Tokens | Model | Cost | Oran |
|---|---|---|---|---|---|---|
| 🔒 Privacy | 5,200 | 3,200 | 8,400 | GPT-4o-mini | $0.03 | |
| 🔎 Explorer | 52,000 | 32,000 | 84,000 | GPT-4o | $0.31 | |
| 🛡 Guard | 32,000 | 20,000 | 52,000 | GPT-4o | $0.19 | |
| 🏗 Architect | 42,000 | 26,000 | 68,000 | GPT-4o | $0.25 | |
| 🎨 Mockup | 15,000 | 9,000 | 24,000 | GPT-4o-mini | $0.08 | |
| ⚙ Pipeline | 38,000 | 22,000 | 60,000 | GPT-4o | $0.22 | |
| 📈 Pulse | 14,000 | 8,000 | 22,000 | GPT-4o-mini | $0.08 | |
| TOPLAM | 198,200 | 120,200 | 318,400 | - | $1.08 |
| Zaman ▼ | Kullanici | Agent / Modul | Action | Details | IP | Status | |
|---|---|---|---|---|---|---|---|
| 14:52:18 | System | Axoria Pulse | Completed | 18 DAX measure, .bim file created | 10.0.1.50 | Successful | |
| 14:48:05 | System | Axoria Pipeline | Completed | 5 dbt model, 3 SSIS, 2 Airflow DAG | 10.0.1.50 | Successful | |
| 14:44:32 | System | Axoria Mockup | Completed | 3 pages wireframe created | 10.0.1.50 | Successful | |
| 14:42:11 | System | Axoria Architect | Review | Star Schema v1.2, awaiting approval | 10.0.1.50 | Waiting | |
| 14:38:47 | System | Axoria Guard | Warning | DQ Skoru 74/100, 3 high risk | 10.0.1.50 | Warning | |
| 14:35:22 | System | Axoria Explorer | Completed | 23 tables, 147 columns, 18 KPI | 10.0.1.50 | Successful | |
| 14:32:08 | System | Axoria Privacy | Completed | 0 PII leak, 8 PII tipi masked | 10.0.1.50 | Successful | |
| 14:30:00 | Ali YILDIRIM | Axoria Pipeline | Started | ERP DWH 2026 pipeline started | 192.168.1.10 | Successful | |
| 14:25:14 | Ali YILDIRIM | Project | Create | ERP DWH 2026 projesi created | 192.168.1.10 | Successful | |
| 13:15:30 | Ali YILDIRIM | Connection | Test | SQL Server - ERP Prod bağlantı testi | 192.168.1.10 | Successful | |
| 13:10:05 | Ali YILDIRIM | Connection | Create | Azure SQL - DWH bağlantısi eklendi | 192.168.1.10 | Successful | |
| 12:45:20 | Ali YILDIRIM | Settings | Update | AI Model ayarlari guncellendi | 192.168.1.10 | Successful | |
| 12:30:00 | Ali YILDIRIM | Connection | Test | MySQL - Legacy CRM bağlantı testi | 192.168.1.10 | Failed | |
| 12:00:15 | System | Connection | Test | PostgreSQL - Analytics otomatik test | 10.0.1.50 | Successful | |
| 11:30:00 | System | Connection | Test | Azure SQL - DWH otomatik test | 10.0.1.50 | Successful | |
| 10:15:42 | Ali YILDIRIM | Axoria Architect | Approvedi | Star Schema v1.1 onaylandı | 192.168.1.10 | Successful | |
| 09:45:00 | Ali YILDIRIM | Workspace | Create | Musteri C (Perakende) workspace eklendi | 192.168.1.10 | Successful | |
| 09:30:10 | Ali YILDIRIM | Connection | Create | Oracle - Finans bağlantısi eklendi | 192.168.1.10 | Successful |