Every data team eventually hits the same wall. You spend days building a complex financial reconciliation report inside a BI dashboard—only to watch it break under nested headers, cross-sheet references, and multi-level grouping. So what happens next? Someone opens Excel. Again.
And then there's the other side: a high-stakes executive presentation where a wall of charts says everything and nothing at the same time. The question from the room is always the same: "What's the story here?"
These aren't competence problems. They're tool-mismatch problems. A single dashboard can't serve both the CFO's month-end close and the CEO's strategic review. That's why we built a dual-engine approach in Lingyang Quick BI: Spreadsheets for precision, and Data Screens for storytelling.
The Spreadsheet Engine: Built for Finance and Power Analysts
When we talk about "spreadsheets" in a BI context, most people assume we mean a basic grid with a database connection. That's not what this is.
Quick BI Spreadsheets were designed around a simple observation: don't fight user habits—augment them. Financial analysts and supply chain operators already know Excel fluently. The friction comes when those locally built sheets become siloed, version-drifted, and manually refreshed.
Here's what changes when you move that workflow into Quick BI Spreadsheets:
400+ Native Excel Functions, Zero Re-Learning
The spreadsheet engine supports nearly 400 high-frequency Excel functions natively. Cross-sheet references, array formulas, VLOOKUP equivalents—all familiar syntax. A seasoned analyst can start building on day one without a training course.
Cell-Level Precision for Complex Report Structures
We engineered the component to handle the kinds of reports that make traditional BI tools choke:
- Multi-level and merged headers
- Multi-level floating elements and grouping
- Diagonal headers
- Multiple report bodies on a single sheet
- Business detail lists, grouped reports, cross-tab reports, master-detail reports, multi-column layouts, query-style reports, and data entry forms
Real-Time Database Connectivity
This is where the spreadsheet stops being "just Excel." Reports bind directly to underlying data sources. When a transaction posts in the ERP, the spreadsheet reflects it—no manual refresh, no "is this the latest version?" email chains.
The Data Screen Engine: Executive-Grade Visual Storytelling
Now flip to the other problem. A dashboard full of charts is not the same as a data narrative. Executives don't want to explore data—they want to see the point.
Quick BI Data Screens address this by treating visualization as presentation design, not just data rendering.
Cinematic-Quality Components, Zero Code
The component library ships with industry-specific templates and assets that you can install with one click. Charts now support animation effects to reinforce the visual atmosphere. The result: something that looks like it came from a professional design agency, built by a business user in an afternoon.
Narrative-Driven Presentation
The data screen engine supports multi-scene, multi-page storyboarding. Instead of dumping every metric onto one page, you sequence them:
- Where we are — current state
- What moved — key drivers
- Where we're going — forward view
This is "point of view first" visualization. You lead with the conclusion, then let the data back it up.
Why Both Engines Matter
The underlying principle is straightforward: the right tool for the right job.
| Concern | Spreadsheets Handle | Data Screens Handle |
|---|---|---|
| Primary audience | Finance, analysts, operators | Executives, leadership, board |
| Data complexity | Multi-level headers, cross-sheet logic, custom formulas | Aggregated KPIs, visual narrative, brand-level polish |
| Update frequency | Real-time, automated refresh | Periodic, event-driven (reviews, summits, command centers) |
| Output | Pixel-accurate compliance reports | Immersive, story-driven presentations |
Putting them together creates an end-to-end flow: fine-grained processing → macro-level visualization. The data doesn't get rewritten between the two engines; it just gets presented differently.
What This Means in Practice
- Month-end close: Finance builds complex reconciliation reports with multi-level grouping and cross-tab logic—no manual VLOOKUP chains, no version drift.
- Annual strategy meeting: The same underlying data powers a cinematic data screen that walks the leadership team through the year's narrative in three acts.
- Supply chain monitoring: Operational teams track granular metrics in spreadsheets; directors review summary dashboards on screens in the command center.
The data is consistent. The presentations are context-appropriate. Nobody's manually copy-pasting between tools.
Get Started
If you've been forcing a single dashboard to do jobs it was never designed for, it's worth trying a dual-engine approach. Quick BI Spreadsheets and Data Screens are available now.
Have questions about migrating your existing Excel-based reports into a live BI environment? Drop a comment below—I'd love to hear what your toughest reporting challenge is.
Top comments (0)