Technical Guide

Platform Documentation

Comprehensive guide to ingestion, sub-second T-SQL analytics, bilingual voice AI, and automated reporting.

1. Multi-Format Dataset Uploader

Supports 9 Enterprise Formats • Up to 10M+ Records

The uploader automatically detects character encodings (UTF-8, Latin-1, CP1252), cleans header column names, and provisions an isolated physical table inside SQL Server with zero data contamination.

Supported Formats & Parsing Engine:
  • CSV (.csv) & TSV (.tsv) — Chunk-streamed with auto delimiter sniff
  • Excel (.xlsx, .xls) — Multi-sheet parsing via openpyxl
  • JSON (.json) & XML (.xml) — Hierarchical tree flattening
  • Parquet (.parquet) & Feather (.feather) — High-speed binary columnar storage
  • Text (.txt) — Fixed-width and custom-delimited files

2. Voice AI & Natural Language Querying

English & Roman Urdu Speech Normalization

Ask analytical questions using your voice or keyboard. The voice engine normalizes spoken typos (e.g., "top 5 ross" ➔ "top 5 rows" or Urdu phonetic phrases like "sab se zyada revenue" ➔ MAX(revenue)) and executes optimized T-SQL in sub-second time.

Query Syntax & Natural Language Examples:
  • "Show top 10 customers by total sales" ➔ Instant GROUP BY aggregation
  • "What is the average transaction amount in 2026?" ➔ Instant AVG with date filter
  • "Which product category has the lowest margin?" ➔ ORDER BY ASC with margin calculation

3. Enterprise Dark Visualizations

Automated AI Chart Type Selection

Every query result generates high-resolution charts automatically. The visual engine detects whether data is temporal, categorical, or relational to render the optimal visualization.

Bar & Column Categorical comparison & Top N rankings
Line & Area Time-series trends & revenue curves
Donut & Pie Proportional share & breakdown analysis

4. Sub-Second Full Export Center

PPTX, PDF, Excel, Word, SVG & CSV

Download complete dataset queries and generated visualizations across multiple executive document formats with embedded AI takeaways in under 100ms.

  • PowerPoint (.pptx) — Formatted multi-slide presentation ready for board reviews
  • Executive PDF — Print-ready briefing with embedded high-res charts
  • Excel Workbook (.xlsx) — Clean data table with summary KPI statistics sheet
  • Word Document (.docx) & CSV (.csv) — Analytical narrative and raw data streams