Power BI Assessment Report
This topic contains information about the Power BI assessment report. The assessment assesses workloads and produces in-depth insights that help to plan the migration in a phased manner. The input format for Power BI assessment is PBIT.
In This Topic:
Highlights
The highlights section gives you a high-level overview of your assessment summary of the analytics performed on the selected workloads.
Summary
This section provides an overview of input source files and the associated workload inventory including entities, worksheets, filters, and more.
- Files: Displays the total number of files.
- Entities: Displays the total number of entities.
- Worksheets: Displays the total number of worksheets.
- Filters: Displays the number of filters that are applied to worksheets or graphs. Filters are used to filter out the data to minimize the data set size, remove irrelevant records, etc.
- Measures: Displays the number of measures that are derived from tables using expressions. Measures are custom formula applied to the table/dataset for data analysis.
Columns
This section provides details about the columns in the entities including the total number of columns and number of calculated columns.
- Total Columns: Displays the total number of columns available in the entities.
- Calculated columns: Displays the number of calculated columns. Calculated columns are columns in which expressions or operations such as min, max, sum, avg, etc. are applied to derive values.
Analysis
This topic provides a detailed examination of source files, and worksheets.
Files
This section provides a comprehensive analysis of the source file including statistical information about entities, worksheets, filters, and measures.
- File Name: Displays the name of the file.
- Entities: Displays the number of entities in each file.
- Worksheets: Displays the number of worksheets in each file.
- Filters: Displays the number of filters in each file.
- Measures: Displays the number of measures in each file.
Worksheets
This section provides details about the worksheets including its name, visualization objects, filters, and more.
- Worksheet Name: Displays the name of worksheet.
- Visualization Objects: Displays the number of visualization objects in each worksheet. Clicking the value provides details about the specific visual types present on the worksheet.
- Filters: Displays the number of filters in each worksheet.
- Associated File: Displays the file path of each worksheet.
Downloadable Reports
Downloadable reports allow you to export detailed Power BI assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.
Types of Reports
In the Reports section, you can see various types of reports such as Insights and Recommendations and Source Inventory Analysis. Each report type offers detailed information allowing you to explore your assessment results.
Insights and Recommendations
This report provides an in-depth insight into the source input files. It contains the final output including information about worksheets, tables, graphs, measures, and more.
PowerBi Report.xlsx: This report provides insights about the source inventory. It helps you plan the next frontier of a modern data platform methodically. It includes information about worksheets, tables, graphs, measures, and more.
This report contains the following information:
- Report Summary: Provides information about all the generated artifacts.
- Volumetric Info: Presents a summary of the aggregated inventory after analyzing the source files. For instance, it provides volumetric information about the total number of files, worksheets, graphs, measures, and so on.
- Worksheet Summary: Lists all the worksheets along with information about the number of graphs, filters, and more.
- DataSet Summary: Lists all theDataSet Complexity information about the number of Table, and more.
- Visual Summary: Lists all theVisual Complexity with information about the number of filters, and more.
- Table: Lists all the tables in the source files.
- Graphs: Provides information about graphs including visual types, row values, categories, and more.
- Measures: Measures are derived from tables using expressions. This sheet provides information about measures including associated tables and expressions.
- Filters: Lists all the filters that are applied to worksheets or graphs. It includes information about tables, condition columns, condition values, and more.
- Calculated Columns: Calculated columns are columns where expressions or operations such as min, max, sum, avg, etc., are applied to derive values. This sheet provides information about calculated columns including types, expressions, and more.
Source Inventory Analysis
It is an intermediate report which helps to debug failures or calculate the final report. It includes all the generated CSV reports such as powerbi_summary.csv, powerbi_table.csv, powerbi_worksheet.csv, and more.
power_bi_dataset_complexity_summary.csv: This report provides information about dataset complexity. It includes information about the total number of tables, measures, columns, and more.
power_bi_visual_complexity_summary.csv: This report provides information about visual complexity. It includes information about the total number of filters, measures, columns, and more.
powerbi_summary.csv: This report provides information about the Power BI source input files. It includes information about the total number of sheets, tables, filters, and more.
powerbi_table.csv: This report provides information about tables in the source input files including the number of columns in each table.
powerbi_worksheet.csv: This report provides information about worksheets including the number of graphs, filters, and more.
Leaplogic