Reporting Matrix
Expert speak
Visual formulas vs DAX with Marco Russo (1:21:20)
Learn how Inforiver can be a smooth transition for Excel users to Power BI
Explore the numerous features in Inforiver that facilitate fast insights
Learn why Andre Fomin thinks Inforiver is in a league of its own
Deliver a financial statement in less than 5 minutes in Power BI, without using DAX
Rapidly deliver complex financial statements with no DAX knowledge
Overview
No-code reporting (07:50)
Deliver flexibility in layout, presentation and formatting for report developers
Cutting-edge data visualizations (06:44)
Deliver a range of charts inside your table/matrix reports in a single click
Advanced data analysis (09:14)
Enrich your decision-making by using no-code analysis & derivative calculations
Data provenance & audit (04:02)
Track changes to your report & data, and utilize notes to communicate context
What-if simulations (05:06)
Modern forecasting & dynamic simulation capabilities in a spreadsheet-like interface
General
Reorder rows and columns (0:26)
Reorder and custom sort rows and columns in a few seconds, without resorting to DAX scripting or modelling workarounds
Layout options (01:29)
Leverage excel-like layouts such as classic, stepped & outline and show measures on rows or columns
Advanced filtering (02:35)
With advanced filtering, filter values in each column as you can do in spreadsheets
Conditional formatting (01:45)
Apply semantic formatting, color scales, segmentation, data bars and many more in a few clicks
Nested top N + others (01:58)
Identify the most or least important categories using Inforiver's advanced Top/Bottom N + Others feature
Number formatting (01:06)
Apply intelligent number formatting and scaling to your Power BI table/matrix reports
Cell & value formatting (02:33)
Edit font color, style, size, and text alignment in a cell, or apply formatting effects
Notes & annotations (02:59)
Enhance your data stories with cell, row, column & report-level notes, footnotes & annotations
Totals & subtotals (01:25)
Manage row & column subtotals & grand totals the way you want in an intuitive & flexible manner
One-click templates (01:12)
Leverage three types of quick-start business templates, each of which can be customized further
Pagination (00:52)
Build highly-formatted, interactive, no-code paginated reports in Power BI
Group rows and columns (00:40)
Group specific rows or columns seamlessly in your Power BI table/matrix reports
Search & filter (01:33)
Focus on relevant data when there are a large number of records using search and filter
Expand/collapse hierarchy (00:32)
Manage row and column hierarchies with options such as expand or collapse to specified levels, descendants and more
KPI explorer (01:16)
Filter rows, columns and measures, sort by name or value and highlight row/column hierarchies using rules or ranges
Audit log (02:10)
Experience an interactive, filterable, exportable and comment-enabled audit log to track changes to your report
Export to Excel (01:30)
Export your Power BI table/matrix reports to spreadsheets effortlessly
Comparative measures (04:33)
Inforiver delivers the measure management feature to manage comparative measures easily
Images in columns (01:52)
Leverage Inforiver to add measures or columns with image URLs & display them as an image in your Power BI reports
Ragged hierarchies (00:36)
Handle ragged hierarchies easily with Inforiver, without having to worry about blank rows
Formula & calculations
Excel-like cell editing (02:02)
Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells
Insert static and calculated rows and enter values manually or define formulas using an intuitive excel-like editor
Insert calculated column (0:51)
Add custom calculations as columns without having to create new DAX measures or calculated columns in the data table
Insert calculated measure (1:11)
Insert calculated measures when you have column hierarchies in your reports using Inforiver's advanced formula engine
Quick formula options (03:40)
Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group
Invert signs (14:18)
Display +/- signs in the table to indicate revenue or expense accounts and perform aggregations
Planning, budgeting & forecasting
Manual data input (03:02)
Insert, edit and update values in your tabular reports with 50+ inbuilt functions, keywords and references
Allocations (07:57)
Allocate budgets and projections based on past performance or value drivers
What-if simulations (01:07)
Perform what-if simulations in Power BI using a graphical simulation slider
Report viewers can perform data input, simulations, 1-click variance analysis, notes, annotations and more
Graphical tables
IBCS visualizations (04:50)
Experience the fastest way to deliver insightful visualizations following IBCS standards
Bar charts (0:47)
Show the distribution of data within a set of categories or groups with Inforiver's bar charts
Lollipop charts (01:52)
Leverage lollipop charts instead of bar charts when there are a lot of categories
Waterfall charts (01:01)
Show the breakdown of the total change in a value, such as a financial metric using waterfall charts
Bullet charts for 2 measures (01:47)
Compare the performance of two measures with Inforiver's bullet charts that come with six variants
Bullet charts for 3 measures (01:56)
Utilise six variants of 3-value bullet charts for comparing 3 measures seamlessly
Stacked charts (01:02)
Highlight distribution across categories or composition over time using Inforiver's stacked charts
Sparkline charts (02:16)
Incorporate sparklines, spark columns, and their variants such as the win-loss trend to capture performance over time
Tornado charts (01:20)
Compare values across two segments or years using tornado charts
KPI cards (06:07)
Incorporate multi-value KPI cards as part of your table/matrix reports
Blend column (03:31)
Blend two measures in a single column along with formatting, including conditional formatting
Conditional formatting
One-click options (05:33)
Highlight specific performance areas using one-click options such as quick rule, color scales, classifications, and data bars
Semantic formatting (01:13)
Format positive and negative numbers using colors and indicate negative values with "-" or "()"
Heat map formatting (02:29)
Apply color scales such as sequential, qualitative, diverging in a single-click
Format entire row (01:56)
Apply formatting to entire rows or row headers, based on your requirements
Traffic light & arrow alert (02:40)
Apply traffic light icons based on predefined ranges and customize icons/colors
Fill icon and star rating (01:48)
Highlights values with circle fill and star rating icons based on ranges, with custom options
Segmentation (02:27)
Perform analysis such as ABC analysis and create segments based on text, ratings or icon sets
Format top/bottom N rows (01:19)
Highlight top/bottom performers in reports with Inforiver's customizable conditional formatting
Branch level formatting (03:16)
Apply different conditional formatting rules to different branches in a hierarchy
Learn to highlight different levels in a hierarchy based on rules without affecting totals
Dynamic conditional formatting (01:59)
Highlight cells based on a dynamic cell selection
Format using if conditions (02:33)
Easily apply conditional formatting based on IF conditions
Visual-level formulas
Excel-like cell editing (04:36)
Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells
Quick formula options (03:00)
Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group
Smart analysis (03:01)
Perform one-click contribution and variance analysis without using DAX
Excel-like formula editor (04:21)
Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers
Calculated measures and columns (02:31)
Add custom calculations as columns and measures without having to create new DAX measures or calculated columns in the data table
4 ways of inserting rows (06:09)
Insert static, calculated, contribution and template rows in Power BI
Evaluate column before rows (01:49)
Configure the column total and subtotal calculations when inserting calculated rows
Manage aggregations (4:00)
Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation
View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields
Last updated