XLiQ

XLiQ is a reporting add‑in for Excel that enables true self-service reporting for business users on data held in the Microsoft BI platform, including Analysis Services and Power BI. It combines fully flexible layouts, pixel‑perfect formatting, and embedded custom calculations—capabilities that web‑based reporting tools often struggle to deliver—with an intuitive interface and optional AI assistance to keep the learning curve low.

A paid subscription to the XLiQ Subscription service is required to use the XLiQ addin.

Whether you already build reports in Excel and want to work faster, or have avoided Excel reporting due to the manual effort involved, XLiQ helps you produce better, data-connected reports in less time.

Key Capabilities

Intuitive, responsive report designer
Design structured, data-connected reports directly within Excel.

Dynamic set-based selections
Automatically adapt what's reported as your business structure, account hierarchy, product mix or entities change.

Smart formatting
Apply the full power of Excel formatting to variable-size reports.

Custom calculations
Add report-level business logic without complex syntax or advanced technical skills.

Number decomposition and analysis
Interactively explain and analyse figures to understand drivers and variance.

Flexible layouts and asymmetric reporting
Break away from rigid templates to design reports that match your specific business requirements.

Optional AI assistance
Integrate your AI assistant of choice to use natural language for querying data, building report elements, and automating multi‑step reporting workflows.

XLiQ is an ideal fit for Microsoft BI customers seeking to improve self-service reporting and analysis, helping teams get more from their data and make better-informed decisions.