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