Data Science: Generating Reports Using Power BI For Data Visualization & Data Analytics

Report we are going to Build

Reports in Power BI

A Power BI report is a multi-perspective view of a dataset with visualisations representing various discoveries and insights from that dataset. A report’s graphics can range from a single image to multiple pages of images.

Prerequisite

We’ll now generate reports for the model we created using the dataset, continuing where we left off in the previous blog. Let’s create reports when we’ve loaded the dataset into Power BI.

Refer this Blog

Creating Reports in Power BI

These reports will be prepared using various visualisations for various fields and displayed in Power BI’s reports tab.
To begin, we’ll create a visualisation that depicts the quantity sold by product key and product category. We must choose category, product key, and quantity from the Product and Sales Facts tables, and then choose the visualisation from the visualisation tab to create this visualisation.

Select the related columns

The generated pie chart for selected columns

Cluster Stack type representation of the same data

Following that, we’ll make a pie chart to depict the sales revenue for all of the cities.The graph compares the percentage of sales revenue to the total amount of revenue for each city.Select the sales_revenue and city variables from the Sales_Facts and Store tables to build this view.

The donut shaped chart for displaying the sales revenue per city

Detailed report for sales revenue per city

After that, we’ll create a report for the STORE. To that end, we’ll create graphs that compare cost per square foot, budgeted staff, and retail square footage by city. Select cost_per_square_foot and city from the STORE field to visualise the report; similarly, select budgeted_employees and city for the second chart; and finally, select retail square footage and city from the STORE field for the last chart. It will seem as follows:

Comparison of stores by cities

Let’s compare the products’ original prices to the prices at which they were sold. For this, we’ll need description from PRODUCT, actual_sales_price and original_sales_price from SALES_FACTS

This shows the original price of XBOX series X and how much it was sold at

I hope this blog post has helped you learn the fundamentals of Power BI report development for Data analytics and visualisation.