Recently added item(s)
You have no items in your shopping cart.
This is one of the most advanced examples amoung sample reports. It shows ABC analysis of customers by the revenue. In this case ABC analysis will show what proportion of customers generates 70%, 20% and 10% of the total revenue. Drill down to each single customer allows to understand, what customers generate most of the revenue.
Filters: webiste, store, product category, customer group, date filter. These filters allow to restrict ABC analysis to certain website / store / product category or customer group.
KPIs: high overview of the ABC anlaysis with specifying what proportion of customers generates 70%, 20% and 10% of the total revenue.
Table lists top 200 customers by revenue.
Chart with ABC line. Typical shape of this line will have few items in A area and more products concentrated in C area. Customers in A area would be those that generate most of the revenue and require most of the attention.
This report is created based on data from Magento e-commerce platform. Any online store build with usage of Magento (1-st or 2-nd version) can have this report installed with Power BI integration extension for Magento that enables business intelligence functionality in Magento store.
The report is hosted by Power BI Service from Microsoft. It is connected to a dataset, created and published to Power BI Service by Power BI Sales Cube extension installed on Magento e-commerce platform.
The report automatically updates its data every hour. it is based on demo magento data where several new orders are generated every day.
The process of data update involves:
Such report may be accessible by different Power BI users of the same organization. Also, users may access it using Power BI Mobile App on Android, iOS or Windows Phone.
The report is based on Sales Cube dataset provided with Power BI Sales Cube extension for Magento. After installing the extension, user may create and configure dataset with Magento data that will be avialable in Power BI Service. The extension comes with a report template for this report.
This report is intended to provide out of the box functionlity together with Power BI Integration extension. And even though, this report could already bring value to the business, it is just an example of what could be created based on Sales Cube dataset. It could easily be edited and adjusted to comany needs.
From simple reporting to more advanced analytics, integration with Power BI opens lot of possibilities for Magento merchants.