DEV Community: Rıdvan Tülünay (TulunaY)

DAX and ETL Without the Cloud: A Local-First Approach to Business Intelligence

Rıdvan Tülünay (TulunaY) — Sat, 25 Apr 2026 07:57:31 +0000

DAX and ETL Without the Cloud: A Local-First Approach to Business Intelligence

If you have worked with Power BI, you know DAX (Data Analysis Expressions) and ETL (Extract, Transform, Load) are essential for business intelligence. But every time you use Power BI, your data travels to Microsoft servers.

What if you could use DAX and ETL — without sending your data anywhere?

DAX in a Local-First World

DAX is the formula language behind Power BI and Excel Power Pivot. It lets you:

Create calculated columns and measures
Build time intelligence (YTD, MTD, YoY comparisons)
Define KPIs and business logic
Aggregate and filter data dynamically

In LivChart, we built a local DAX engine that runs entirely on your device. Same formulas, same results — zero cloud dependency.

Example: Running DAX Locally

Total Sales YTD = TOTALYTD(
    SUM(Sales[Amount]),
    Sales[Date]
)

This measure works exactly the same in LivChart as in Power BI. The difference? LivChart computes it on your machine, not on Microsoft servers.

ETL Without Cloud Transfer

ETL is how you prepare data for analysis:

Extract — Pull data from Excel, CSV, or SQL databases
Transform — Clean, filter, pivot, and reshape
Load — Push into your dashboard or report

In cloud BI tools, all three steps happen on remote servers. LivChart runs ETL locally:

Connect directly to your database (no data export)
Transform with a visual pipeline builder or DAX
Load into dashboards on your device

Why This Matters

For Financial Teams

Financial data (revenue, costs, forecasts) is highly sensitive. Local processing means:

No risk of data breaches through cloud transfer
Compliance with financial regulations
Faster processing — no upload/download latency

For HR Departments

Employee data (salaries, performance, personal info) is protected by privacy laws. Local-first means:

KVKK compliance by default
No cross-border data transfer
Employee data never leaves company infrastructure

for Healthcare Organizations

Patient records require strict privacy (HIPAA, KVKK). Local processing:

Zero risk of PHI exposure
Audit trail stays on-premise
No third-party data access

Try Local DAX and ETL

Download LivChart and connect your first data source. Your data stays on your machine — always.

Built with local-first principles by Liv Yazılım

Excel Verilerinizi Dashboarda Dönüştürün – Veri Buluta Çıkmadan

Rıdvan Tülünay (TulunaY) — Sat, 25 Apr 2026 07:56:48 +0000

Excel Verilerinizi Dashboarda Dönüştürün – Veri Buluta Çıkmadan

Her ay yüzlerce Excel raporuyla boğuşuyorsanız, bu yazı tam size göre.

Sorun: Veriniz Nereye Gidiyor?

Birçok şirket, Excel raporlarını bulut tabanlı BI araçlarına yüklerken şu riskleri gözden kaçırıyor:

Veri güvenliği – Finansal raporlar, müşteri verileri, stratejik planlar üçüncü taraf sunucularına gönderiliyor
KVKK uyumluluğu – Kişisel verilerin yurt dışına aktarımı yasal risk oluşturuyor
Maliyet – Kurumsal BI lisansları aylık binlerce lira
Bağımlılık – Verendor değiştirmek tüm veriyi taşımak demek

Çözüm: Yerel AI ile Veri Analizi

LivChart, tüm veri işleme işlemlerini kendi cihazınızda yapar. Veriniz asla buluta çıkmaz.

Adım 1: Excel Dosyanızı Yükleyin

LivChart, .xlsx ve .csv dosyalarını doğrudan okur. Herhangi bir dönüştürme gerekmez.

Adım 2: AI Dashboard Oluştursun

Yerel AI modeli:

Veri türlerini ve ilişkileri otomatik algılar
Her veri seti için en uygun grafik türünü önerir
Trendleri ve desenleri yorumlar

Adım 3: Özelleştirin

Sürükle-bırak ile düzenleme:

Grafik türleri (çubuk, çizgi, pasta, ısı haritası...)
Renkler ve temalar
Filtreler ve detaylandırma

Adım 4: PDF Rapor Oluşturun

Tek tıkla profesyonel PDF raporlar:

Sunuma hazır formatlama
AI tarafından oluşturulan yorumlar
Kurumsal markalama seçenekleri

Karşılaştırma

Özellik	LivChart	Power BI	Tableau
Veri cihazda kalır	✅	❌	❌
Yerel AI	✅	❌	❌
İnternetsiz çalışır	✅	❌	❌
DAX formülleri	✅	✅	❌
ETL dahil	✅	✅	Sınırlı
KVKK uyumlu	✅	Kısmen	Kısmen

Ücretsiz Deneyin

👉 livchart.com adresinden indirin ve ilk dashboardınızı saniyeler içinde oluşturun.

Verileriniz sizin cihazınızda kalır. Her zaman.

Bu yazı Liv Yazılım tarafından hazırlanmıştır.

How to Build Dashboards Without Uploading Data to the Cloud

Rıdvan Tülünay (TulunaY) — Sat, 25 Apr 2026 07:50:10 +0000

How to Build Dashboards Without Uploading Data to the Cloud

Most BI tools require you to upload your data to their servers. But what if your data is too sensitive? Financial reports, HR data, strategic plans — you should not have to trust a third party with this information.

Here is how to build production-ready dashboards while keeping your data 100% on your machine.

The Problem with Cloud BI

When you use Power BI, Tableau, or similar tools:

Your data leaves your device — uploaded to Microsoft, Salesforce, or AWS servers
Compliance risk — GDPR, KVKK, and industry regulations restrict data transfers
Vendor lock-in — switching tools means migrating everything
Cost — enterprise licenses can cost thousands per month

The Local-First Alternative

LivChart takes a different approach: all data processing happens on your device. Nothing is uploaded. Ever.

Step 1: Connect Your Data Source

LivChart supports multiple data sources:

Excel files (.xlsx, .xls)
CSV files
SQL databases (MySQL, PostgreSQL, SQL Server, and more)
Direct database connection — no export needed

Step 2: AI Analyzes Your Data

Once you connect your data, the built-in local AI:

Detects data types and relationships
Suggests optimal chart types for each dataset
Creates an initial dashboard layout
Interprets trends and patterns

All of this happens on your machine — no API calls, no cloud processing.

Step 3: Customize Your Dashboard

Drag and drop to arrange your charts. The AI suggestions are just a starting point — you have full control over:

Chart types (bar, line, pie, scatter, heatmap, etc.)
Colors and themes
Layout and sizing
Filters and drill-downs

Step 4: Export Reports

One click to generate professional PDF reports:

Presentation-ready formatting
AI-generated interpretations
Custom branding options

Built for Data Privacy

Feature	LivChart	Power BI	Tableau
Data on device	✅	❌	❌
Local AI	✅	❌	❌
No internet required	✅	❌	❌
DAX formulas	✅	✅	❌
ETL built-in	✅	✅	Limited
GDPR by default	✅	Partial	Partial

Try It Yourself

Download LivChart from livchart.com
Upload an Excel file or connect a database
Let AI build your first dashboard in seconds

Your data stays on your machine. Always.

This post was written using LivChart — local-first AI data visualization.

LivChart: Local-First AI Data Visualization – Your Data Never Leaves Your Device

Rıdvan Tülünay (TulunaY) — Sat, 25 Apr 2026 07:24:31 +0000

LivChart: Local-First AI Data Visualization

Your data never leaves your device.

The Problem

Every time you upload sensitive business data to a cloud BI tool, you risk exposure. Traditional dashboard tools require you to trust third-party servers with your financial reports, customer data, and strategic insights.

With increasing data regulations like GDPR and KVKK, and rising cyber threats, cloud-based BI is becoming a liability.

The Solution

LivChart is a local-first data visualization and dashboard builder powered by AI. It runs on your machine – your data never gets uploaded to the cloud.

Key Features

📊 AI-Powered Charts: Upload Excel, CSV, or connect your database. AI builds the optimal visualization in seconds.
🔒 Privacy-First: All processing happens locally. Zero data leaves your device.
📄 PDF Reports: Generate professional, presentation-ready reports instantly.
🧮 DAX & ETL Support: Built-in data transformation and DAX formula engine.
🗄️ Database Independent: Works with Excel, CSV, SQL databases, and more.
🤖 Local AI: Uses on-device AI models for data analysis and interpretation.

How It Works

Upload your data (Excel, CSV, database connection)
AI analyzes your data structure and suggests optimal visualizations
Customize your dashboard with drag-and-drop
Export as PDF report or share internally

Why Local-First?

In an era of increasing data regulations and cyber threats, keeping data on-premise is not just a preference – it is a necessity.

Comparison with Cloud BI Tools

Feature	LivChart	Power BI	Tableau
Data stays on device	✅	❌	❌
Local AI analysis	✅	❌	❌
No cloud dependency	✅	❌	❌
DAX support	✅	✅	❌
ETL built-in	✅	✅	Limited
PDF report generation	✅	Limited	Limited
GDPR/KVKK compliant	✅	Partial	Partial

Get Started

🌐 Visit livchart.com
📥 Download the desktop app
🔑 Get a license key
📖 Read the blog for tutorials

Built with ❤️ by Liv Yazılım