Business Metrics In Power BI Reports To Achieve Logistics Insights

No comments

In this demonstration, we focus on a Power BI Showcase that contains reports presenting key business metrics for a transportation company.

The reports in this Showcase use simulated data that came from the bookings received by the company from a variety of clients in different channels.

The data spans for five months, and is spread throughout the major cities and towns in New Zealand.

This Power BI Showcase is broken up into five reports.

Bookings Summary

The Bookings Summary is the first report, which allows an executive or manager to analyze key business metrics, such as Profit Margins, Bookings, Sales, Discounts, and Data on new customers.

business metrics

By linking the data model in the report, we’re able to interact with the charts. This allows us to drill into different key metrics within our data.

For instance, this chart shows the Total Sales by client grouping.

We can see how the Total Sales is distributed throughout the country.

Bookings Analysis By Location

The second report focuses on location analysis.

business metrics

This enables us to analyze our data from a spatial perspective.

For instance, we can navigate to Auckland and analyze all the bookings per client grouping. 

The black represents our retail clients, and the blue for our corporate clients.

We can also use the filters to make the charts show data for a specific month.

We can also make a selection on the destination type.

By doing this, we’re able to look at the trends in our data.

Booking Channel & Type

The third report shows the booking channel and type.

business metrics

It has a similar layout to the second report where the filters are located on the left-hand side, and the summaries are shown in pie charts located at the top of the report.

These charts enable us to filter the other visualizations.

Loyalty & Client Groupings

The fourth report shows the Loyalty and Client Groupings.

business metrics

The key business metrics are summarized into various visualizations which can be manipulated as desired.

Age, Gender & Passenger Type

The last report focuses on age, gender, and passenger type.

business metrics

In this report, the charts are dynamically linked to each other which makes it easier for us to filter the metrics and work around the analysis.

Conclusion

The five reports within this Power BI Showcase give us a good overview on the key business metrics of a transportation company.

With this, we’re able to gather valuable insights related to the logistics aspect of our business and see the trends in our data.

All the best,

Sam

Membership Banne
Center of Excellence

***** Related Links *****
Custom Dynamic Segmentation Using DAX In Power BI
Tips For Power BI Report Design – Best Practices
Create Reports In Power BI To Show Deviations And Insights

***** Related Course Modules *****
Power BI Showcases
Learning Summit Series
Business Analytics Series

***** Related Support Forum Posts *****
Map Visualisation Type In Cohort Analysis Showcase
Ideas For Getting Some Insights
3D Scatter With Variable Point Size?
For more visualization analysis queries to review see here….

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.