Guide

Learn how to use Flyxar

๐Ÿ 

Homepage

The Flyxar homepage is your entry point. It introduces the platform and gives you two key controls in the top navigation bar: a language switcher and a light/dark theme toggle.

Homepage
What you see on the homepage

The homepage is divided into several sections. At the very top is the navigation bar โ€” it shows the Flyxar logo on the left, and on the right you will find the language switcher button and the theme toggle. Below the nav is the hero section, which explains what Flyxar is in one sentence and shows two call-to-action buttons: Upload Dataset and Explore Demo Workspace.

โœ“Language switcher: EN and TR unlocked, 8 more languages coming soon
โœ“Theme toggle: โ˜€ light mode or โ˜พ dark mode โ€” choose based on your preference
โœ“Hero section: platform overview and two buttons to get started
โœ“Stats bar: 1M+ rows, 10+ KPI modules, 28 tracked metrics, parses in seconds
โœ“How It Works: 4-step visual flow โ€” Upload, Clean, Analyse, Export
โœ“Platform Features: brief descriptions of all 8 modules
โœ“Intelligence Layer: explains Root Cause, Trend, Period Comparison, Scenario features
โœ“Footer: links to Guide, Reports, Alerts, and Settings pages
Pro Tips
โ€บChanging language updates all page labels instantly โ€” no page reload needed
โ€บDark mode is better for long analysis sessions โ€” light mode is ideal for print or presentation screenshots
Go to Homepage โ†’
โฌ†

Upload

Everything in Flyxar starts with a file upload. The Upload page accepts CSV and Excel files and automatically figures out what kind of aviation data is inside โ€” no setup, no field mapping, no configuration required.

Upload page
How to upload a file

There are two ways to upload: drag and drop your file directly onto the dashed drop zone in the middle of the screen, or click anywhere on the drop zone to open a file browser and select your file manually. The accepted file formats are CSV, XLSX, and XLS.

What happens after you upload

As soon as you drop the file, Flyxar starts parsing it. A progress bar fills from 0% to 100% in real time. The platform scans every column, detects the data type (flights, cargo, passengers, airports, or generic), counts rows and columns, and records the upload timestamp. When parsing is complete, you are automatically redirected to the Workspace.

โœ“Supports up to 1 million rows โ€” suitable for large operational datasets
โœ“Flight data detected when columns like DEPARTURE, ARRIVAL, FLIGHT_NUMBER, DELAY are present
โœ“Cargo data detected when columns like CARGO, TONNAGE, FREIGHT, WEIGHT are present
โœ“Passenger data detected when columns like PASSENGER, PAX, LOAD_FACTOR are present
โœ“Airport data detected when columns like AIRPORT, IATA, ICAO are present
โœ“Security: 10 MB file size limit, MIME type validation, CSV injection scan
โœ“No account required โ€” upload your file and analyse instantly
Pro Tips
โ€บFirst row must be column headers โ€” without this Flyxar cannot profile columns correctly
โ€บDate columns are auto-detected: ISO (2024-01-15), DD/MM/YYYY, and MM-DD-YYYY all work
โ€บIATA codes like DXB, LHR, NBO, JFK are recognised automatically with no mapping
โ€บIf your file is very large, try keeping it under 500K rows โ€” parsing will still be fast
Go to Upload โ†’
โš™

Workspace

The Workspace is where you review and clean your raw data before analysing it. It gives you a complete picture of your data quality, shows every issue that was detected, and lets you fix problems one click at a time โ€” or with natural language AI commands.

Workspace
The split view โ€” Original vs Cleaned

At the top of the workspace you will see three view toggle buttons: Original, Split, and Cleaned. In Split view (the default), the screen is divided in half. The left side shows your original raw data exactly as it was uploaded โ€” nothing changed. The right side shows the cleaned version, updating in real time as you apply fixes. Changed cells are highlighted: red for removed or replaced values, green for corrected ones. This lets you see exactly what each fix does before you commit to it.

The top bar โ€” key information at a glance

The workspace top bar shows your filename and total row count on the left. On the right you will see the Issues Detected count (how many data quality problems were found) and the Remaining count (how many are still unfixed). Below the top bar are four action buttons: Profile (opens a column-by-column data summary), Export CSV (download the cleaned data), New File (go back to Upload), and Dashboard (go directly to analysis).

The 10 cleaning actions
โœ“Remove duplicate rows โ€” deletes entirely identical rows, keeping the first occurrence
โœ“Fill nulls with N/A โ€” fills all empty or null cells with the text N/A
โœ“Trim whitespace โ€” removes leading and trailing spaces from all text values
โœ“Standardise dates โ€” converts date columns to a consistent format
โœ“Strip currency symbols โ€” removes $, ยฃ, โ‚ฌ, and other currency signs
โœ“Strip unit suffixes โ€” removes units like 'km', 'kg', 'min' from numeric values
โœ“Uppercase all text โ€” converts all text cells to uppercase
โœ“Lowercase all text โ€” converts all text cells to lowercase
โœ“Title case names โ€” capitalises the first letter of each word (ideal for names)
โœ“Remove empty rows โ€” deletes rows that have no value in any column
Undo and Redo

Every cleaning action is fully reversible. At the bottom of the clean actions menu you will find Undo and Redo buttons. Undo steps back one operation at a time. Redo reapplies it. You can undo as many times as needed โ€” there is no limit. This means you can experiment freely without worrying about breaking your data.

Column Profiling

Click the Profile button in the top bar to open a column-by-column summary of your dataset. For each column you will see: the data type (text, number, date), the number of null or empty values, the number of unique values, and sample values from that column. This helps you understand your data quality before cleaning and decide which actions to apply.

Pro Tips
โ€บAlways check the split view before applying โ€” the green and red highlights show exactly what will change
โ€บInconsistent casing (lhr, LHR, Lhr) breaks route grouping โ€” use Uppercase All before analysing
โ€บRun Fill nulls with N/A before exporting to avoid blank cell issues in Excel
โ€บThe Dashboard button jumps directly to the dashboard with your cleaned data โ€” use it when you are done
Go to Workspace โ†’
โ–ฆ

Dashboard

The Dashboard is the analytical heart of Flyxar. Once your data is clean, every KPI is computed instantly across 7 modules. The dashboard is designed to give you both a high-level summary and deep detail โ€” you control how much you see.

Dashboard
Simple vs Advanced mode

At the top right of the dashboard you will find a Simple / Advanced toggle. Simple mode shows the four most important KPI cards (On-Time Rate, Total Flights, Average Delay, Cancellations), one main chart, and a one-line AI insight. This is the best starting point. Advanced mode adds additional charts, delay cause breakdowns, anomaly highlighting, and all technical metrics. Switch between them any time โ€” your data does not reload.

The 7 KPI modules
โœ“Flight Performance โ€” on-time rate, average delay, cancellation rate, total flight count
โœ“Airport Operations โ€” departures, arrivals, busiest airport, peak hours
โœ“Cargo Analysis โ€” total tonnage, average weight, revenue, yield (revenue per kg)
โœ“Passenger Trends โ€” total passengers, load factor, average per flight, pax count
โœ“Fleet Intelligence โ€” aircraft type breakdown, utilisation rate, performance comparison
โœ“Fuel Economics โ€” total consumption, average per flight, efficiency metrics, cost
โœ“Route Intelligence โ€” unique routes, top route pair, origin/destination analysis
DrillPanel โ€” click any KPI for a deep breakdown

Click on any KPI card and a slide-out DrillPanel appears on the right side of the screen. The DrillPanel shows the full breakdown of that metric โ€” ranked lists of top contributors (routes, aircraft types, airlines), mini charts, statistical summaries, and period comparisons. Close it by clicking the same card again or pressing the Close button.

IntelPanel โ€” the Why? button

On the four main KPI cards you will see a small 'Why?' button. Click it and the IntelPanel opens โ€” this is Flyxar's most powerful feature. The IntelPanel shows you a 6-period sparkline trend, a first-half vs second-half period comparison with direction arrows, and a list of data-driven root causes. For each root cause (for example: 'Route DXB-LHR accounts for 34% of total delay'), you get specific aviation manager recommendations in plain language โ€” with priority levels: Urgent, High, or Medium.

Period comparison

Toggle the 'vs Previous Period' button in the dashboard toolbar to activate period comparison mode. Every KPI card will show a delta badge: a green upward arrow for improvements, a red downward arrow for regressions. The percentage change is calculated automatically from your data. This lets you instantly see whether your operations are trending in the right direction.

Command Bar

Press the / key or Cmd+K (Mac) / Ctrl+K (Windows) anywhere on the dashboard to open the Command Bar. It contains 22 commands including: switching modules, applying date filters, toggling Simple/Advanced mode, switching chart types, navigating to any other page, and more. It is the fastest way to navigate Flyxar without touching the mouse.

Pro Tips
โ€บStart with Simple mode โ€” the four KPI cards give you the big picture instantly
โ€บThe 'Why?' button should be used on any KPI that looks wrong โ€” you will find your root cause
โ€บLoad Factor and Fuel Cost KPIs require those columns to be present in your dataset
โ€บThe Command Bar (Cmd+K) is the fastest way to switch between modules
Go to Dashboard โ†’
โ—Œ

Analyze

The Analyze page lets you focus on one metric at a time and explore it in depth. While the Dashboard gives you an overview across all modules, the Analyze page is for when you want to understand a specific metric โ€” why it changed, what is driving it, and how it compares to a previous period.

Analyze page
Choosing a metric and category

At the top of the Analyze page are the category buttons: Performance, Operations, Fuel, and Custom. Click a category to filter the metrics shown below it. The available metrics are: On-Time Performance, Average Delay, Cancellations, Total Flights, Load Factor, and Fuel Cost. Click any metric button to load the chart and analysis for that metric.

The main chart and sparkline

The main chart area shows your selected metric plotted over time. You can switch between bar, line, and area chart types using the buttons above the chart. Below the chart title is a 7-day sparkline showing the short-term trend โ€” a quick visual pulse of whether the metric is rising or falling. The chart also shows day labels on the X-axis (translated to Turkish when TR is selected).

Period comparison

Click the 'Compare Period' button above the chart to activate period comparison mode. The chart will show two lines or bars โ€” the current period in gold and the previous period in a lighter shade. A delta badge appears on the metric card showing the percentage change. Green means improvement, red means regression. This is the fastest way to answer 'are things getting better or worse?'

The Why? button and DrillPanel

Every metric card in the Analyze page has a 'Why? (Ask AI)' button. Click it to open the DrillPanel on the right side of the screen. The DrillPanel shows a ranked breakdown of the top contributing factors to that metric โ€” broken down by Route, Aircraft Type, and Airline. Each entry shows the contribution percentage and a mini bar. This tells you exactly which route or aircraft type is responsible for a spike or drop in any KPI.

Pro Tips
โ€บUse 'Compare Period' to immediately see improvement or regression โ€” do this first
โ€บLoad Factor and Fuel Cost metrics only show data if those columns exist in your dataset
โ€บThe DrillPanel shows which route or aircraft is causing the most damage โ€” look here first
โ€บDay labels auto-translate in TR mode (Mon โ†’ Pzt, Tue โ†’ Sal etc.)
Go to Analyze โ†’
โšก

Scenarios

The Scenarios page is a what-if planning tool. It lets you model different operational targets and see in real time what the projected impact would be on your KPIs. Use it when you want to answer questions like: what happens if we improve our on-time rate by 10%? What if we cut fuel budget by 15%?

Scenarios page
The 5 adjustable levers
โœ“On-Time Target โ€” set the target on-time departure percentage (e.g. push to 85%)
โœ“Fuel Budget โ€” set the target fuel spending budget
โœ“Delay Threshold โ€” set the maximum acceptable average delay in minutes
โœ“Capacity Utilisation โ€” set the target seat load factor percentage
โœ“Safety Margin โ€” set the operational safety buffer percentage
The Impact Summary panel

On the right side of the screen is the Impact Summary panel. It updates in real time as you move any slider. It shows: Projected On-Time rate (the expected on-time performance under your scenario), Cost Savings (estimated savings compared to baseline), Average Delay (projected average delay in minutes), and a Risk rating โ€” Low, Medium, or High โ€” based on how aggressive your scenario targets are relative to your actual data.

Key Improvements and saving scenarios

Below the Impact Summary you will see a Key Improvements list โ€” plain language descriptions of what your scenario would change in operations. At the bottom of the page are two buttons: Apply Scenario (applies the scenario parameters to the current session) and Save to Library (saves it for future reference). Saved scenarios can be compared against each other.

Pro Tips
โ€บStart by adjusting On-Time Target โ€” see if it has the biggest downstream impact
โ€บA High risk rating means the targets are aggressive relative to your current data โ€” not bad, just ambitious
โ€บSave multiple scenarios to compare different strategies (conservative vs aggressive)
Go to Scenarios โ†’
โ—Ž

Alerts

The Alerts page lets you define thresholds on any KPI. When your dataset crosses a threshold, Flyxar flags it immediately. Alerts are checked every time you load or refresh your data โ€” they are your early warning system for operational problems.

Alerts page
Setting an alert

Click Add Alert to create a new threshold rule. You choose a metric (for example Average Delay), a condition (Above or Below), and a threshold value (for example 60 minutes). Once saved, the alert is active and will be evaluated against your current dataset. If the metric crosses the threshold, the alert status changes to Triggered and it is highlighted in the sidebar so you cannot miss it.

โœ“Supported metrics: average delay, cancellation rate, on-time rate, load factor
โœ“Two conditions: Above threshold (e.g. delay > 60 min) or Below threshold (e.g. on-time rate < 80%)
โœ“Alert statuses: Active (being monitored), Triggered (condition met), Resolved (addressed)
โœ“Add multiple alerts to monitor several KPIs simultaneously
โœ“Triggered alerts are highlighted in red in the sidebar
Pro Tips
โ€บGood starting thresholds: delay > 60 min, cancel rate > 10%, on-time rate < 80%
โ€บMark an alert as Resolved once you have investigated and addressed the underlying issue
โ€บTriggered alerts always appear in the sidebar โ€” nothing will slip past you
Go to Alerts โ†’
โ‰ก

Reports

The Reports page is where you export your cleaned, filtered dataset in the format you need. You can filter by date range and column values before exporting, choose which columns to include, and download as CSV, JSON, or a branded PDF report.

Reports page
Filtering before export

The left panel on the Reports page is the filter panel. At the top is a date range filter โ€” select a date column from your dataset, then set a From and To date. Below that is a column value filter โ€” for each text column with less than 80 unique values, you get a dropdown to filter by a specific value. At the bottom is the column selector โ€” uncheck any columns you do not want in your export. The Export Preview panel on the right updates in real time showing how many rows and columns will be exported.

โœ“CSV export โ€” comma-separated, opens in Excel, preserves all data types
โœ“JSON export โ€” structured JSON, ideal for re-importing into other tools
โœ“PDF export โ€” branded report with Flyxar header, metadata summary, and full data table
โœ“PDF is limited to 500 rows โ€” use CSV for large datasets
โœ“Reset Filters button removes all filters in one click to start fresh
Pro Tips
โ€บFilter down large datasets before exporting โ€” smaller files open faster in Excel
โ€บCSV is the safest option for re-importing into other tools
โ€บPDF is best for sharing with stakeholders who do not have Flyxar access
Go to Reports โ†’
โœฆ

Settings

The Settings page controls how Flyxar looks and behaves for you. All changes take effect immediately โ€” no save button needed except for the row limit preference.

Settings page
โœ“Theme โ€” toggle between Dark mode (navy background) or Light mode (cream background)
โœ“Language โ€” English and Turkish unlocked; 8 more languages coming soon (Arabic, French, German, Spanish, Somali, Chinese, Russian, Japanese)
โœ“Row preview limit โ€” control how many rows are shown in the workspace table (useful for performance)
โœ“Clear loaded dataset โ€” removes all loaded data and starts fresh without refreshing the page
โœ“About โ€” platform version, build info, and mission statement
Pro Tips
โ€บChanging language updates all labels instantly โ€” no page reload needed
โ€บDark mode reduces eye strain for long analysis sessions
โ€บClear data before uploading a new file โ€” this prevents stale session state issues
Go to Settings โ†’