Description
Reporting Studio is a comprehensive solution for creating graphics for reports, presentations and dashboards consisting of charts, tables and highlighting according to the IBCS notation concept. From its integrated analysis of the business significance of the available data, it automatically suggests which graphics to use in each case.
The Reporting Studio Power BI custom visual is fully integrated in Microsoft Power BI. Power BI functions such as filtering, cross-filtering, cross-highlighting and drill-through are available.
Fields of application
Data-driven standard reporting, ad-hoc analyses, dynamic dashboards and presentations with a uniform IBCS notation concept.
Graphic features
Reports, presentations and dashboards can be created with charts and tables according to the IBCS notation principles. The most suitable visualizations for the available data set are suggested automatically.
Available graphic objects:
- Unstacked columns and bars
- Stacked columns and bars
- 100% stacks
- Waterfalls
- Point and line charts
- Area charts for stacked point-lines
- Tables
- Multicharts
Variance chart types
- Columns and bars for simple delta variances
- Waterfall columns and bars for cumulative variances
- Needle chart type for percentage variances
Charts and tables can be supplemented generically with any number of subcharts. The structure of data series and table columns is data driven.
Tables can be supplemented with charts as variance columns.
Available highlighting and controls:
- Comments (comment reference and external comment text)
- Value indicator (highlights a value in the graphic)
- Difference indicator (highlights the difference between two values)
- Scaling indicator (highlights scaling differences between different charts)
- Text box as an html box to display static text, images and other multimedia content
The object properties have sensible default settings but can also be customized in properties dialogues.
All objects, such as pages, charts, subcharts, series, categories, data points and highlighting, are displayed in a structure tree, where they can also be selected for editing.
Objects can be inserted by drag & drop and linked to data.
The user interface is the same for all user roles (Designer and Viewer).
Custom notation concept
Customizable stylesheets make it possible to define and update a notation concept with logos, colours, line widths, point sizes, fonts, etc.
Data sources and data handling
Data sources
In the Reporting Studio custom visual, the available data are analysed in each case for business significance and suitable visualization types (graphics) are suggested on that basis.
Excel workbooks can also be added to Reporting Studio as data sources directly from outside Power BI.
A demo data source for each chart type is also included so that charts can still be inserted if a user-defined data source is not yet available.
Data preparation
In the Data Manager, a Reporting Studio wizard, the data are displayed multidimensionally with the dimensions arranged in rows, columns and filters. Dimensions can also be classified according to business significance in terms of time, scenarios (streams), calculation method and measures. Multiple time dimensions can be assigned, as well as a supplementary scenario, the type of a measure (stock or flow value) and its unit.
The user can also display a graphic preview of the current data configuration in the Data Manager.
All dimension elements can then be individually classified, re-sorted and filtered in the dimension editor.
Exports
Reporting Studio visuals can be exported with the standard Power BI functionality.
Saving projects
All settings the user makes in the Reporting Studio visual are saved in the parent Power BI project together with the visual itself.
Access modes
The Reporting Studio custom visual is available across the entire Power BI platform, including Power BI Desktop, Power BI Service (Cloud), Power BI Report Server, Power BI mobile apps (IOS & Android), Power BI Embedded and publish to web.
Languages
The languages supported by the Reporting Studio custom visual are English, German, Spanish, French, Italian, Dutch, Portuguese, Russian, Serbian and Chinese.
Licensing
The full function range of Reporting Studio can be used for free without a licence. A watermark is displayed in Viewer mode, which can be removed by entering a licence key.
The Reporting Studio custom visual is licensed and delivered via Microsoft AppSource or as a file with a separate licence key.
Scope of delivery
- Power BI visual (.pbiviz)
- Access to the online help
- Sample project (.pbix)
System requirements
Power BI Online or Desktop