Tool

Management Summary

Short explanation

This page provides in a management summary. The goal of this page is to see very quickly where the environment can be improved.

Functionalities

The possible improvements are divided in the subjects:

– Tables & Columns & Measures

– Report and Pages

– Performance

– Visualization

– Datamodel (Relationships)

Report / Pages

Short explanation

This page provides in an overview of the existing reports, pages and pagefilters.

Functionalities

– Report (s)

– Page (s)

– Page Filter (s)

– Count of above

– Comparable over multiple workspaces and datasets.

Visualization

Short explanation

This page provides insights in the used visualization per page.

Functionalities

– Used visualization per page

– Top 3 – number of visuals per page (KPI)

– Visual vs Visual filter percentage (KPI)

– Top 3 – used visual type (KPI)

– Lay-out of pages.

– Comparable over workspace & dataset.

Tables & Columns

Short explanation

This page provides in an overview of all the loaded tables & columns. It gives insights in usage and if there is a power query dependency (merge).

Functionalities

– Overview of all loaded tables and columns.

– Overview of all loaded tables and columns specified by used or not.

– Overview of all loaded tables and columns. specified if a power query dependency (merge) exist.

– Total size of model by workspace (KPI)

– Total of tables (KPI)

– Total of columns (KPI)

– Comparable over workspace & dataset

Relationships

Short explanation

This page provides insights in al the existing relationships.

Functionalities

– An overview of the existing relationships. Specified by al the necesarry specifications.

– Number of active relationships (KPI)

– Number of crossfilter direction (KPI)

-Number of BI-Directional relationships (KPI)

– Comparable over workspace & dataset.

Measures

Short explanation

This page provides insights in all the measures. By using a drilldown it gives an efficient way of searching measures and their dependency.

Functionalities

– Search in measures. Measure dependency & measure expression.

– #C script with measures to be deleted. This script can be used in tabular editor 2.

– #C script to add all measures to a folder at once.

– Overview of functions in expressions who are know for being heavy on performance.

– Comparable over workspace & dataset.

M-Query

Short explanation

This page provides insights in the m query tables together with its number of dependency (m-query merge).

Functionalities

– An overview of the tables together with their m query and dependency.

– Comparable over workspace & dataset.

Dependency

Short explanation

This page provides insights in the dependency of the data. For example: A measure has a long line of references. Some of these references are applicable to a report. This page shows you all those reports.

Functionalities

– Directly: An overview of measures and fields directly used, specified by report.

– Directly: Number of reports under the chosen field

– Indirectly: An overview of measures and fields directly used, specified by report.

-Indirectly: Number of reports under the chosen field.

User experience (premium only)

Short explanation

This page provides insights in the usage of the reports. This page is optional and only available with a premium workspace. The data of this page goes 1 month back.

Functionalities

– An overview of report and page views by users.

– Unique viewers (KPI)

– Report views (KPI)

– Report opens by date

– Report viewers by date

– Comparable over workspace & dataset.

Performance (premium only)

Short explanation

This page provides insights in the performance of the reports. This page is optional and only available with a premium workspace. The data of this page goes 1 month back.

Functionalities

– Typical opening time per report

– Daily performance

– Weekly performance

– Comparable over workspace & dataset.

In case of premium workspace

In case of pro workspace

Interested? Find me below