Powered by Adobe Commerce 2.4.3-p2

pbi_sc_mt_logo_240x240.png

Power BI Sales Cube

This is an Integration with a Third Party Service. Other charges and fees may be required to use this extension on your Store
PRODUCT:
0
TOTAL:

Overview

Back to top

Power BI is a cloud-based business analytics service from Microsoft that allows you to have a single view on your most critical business data at any time, from any place. With Power BI account you are able to create, view and share your personal dashboards and reports with other Power BI users, access your dashboards on mobile devices or publish them to the web. 

The Power BI Sales Cube extension includes a fully functional Business Intelligence solution with data preparation, incremental data delivery to Power BI Service and with ready to use reports. 

The extension will automatically process and prepare sales data for analytics, and it will deliver this data to Power BI Service. It will automatically update the data with recent orders by configured schedule. Users of Power BI will have access to a sales dataset that includes a comprehensive data model with different measures and dimensions across the sales process, nicely linked together in the most optimized format for Power BI Service.

Out of the box, reports can be loaded from Magento extension to Power BI Service. Connected with the sales dataset, they will provide insights and analytics based on Magento data. 

Once your data will be delivered to Power BI Service, you can:

  • Use out of the box reports on Web and Mobile App.
  • Create your own reports with a simple drag and drop user interface.
  • Connect to your data from Power BI Desktop and extend the data model with your own calculated measures written as DAX (Data Analysis Expressions).
  • Share your reports, add bookmarks, set up alerts and many other features that continuously improve with new releases of Power BI.

 

Account & Pricing

Power BI Sales Cube extension is integrated with Azure Active Directory (Azure AD) to provide secure sign-in and authorization for your Magento store. Before you start using Power BI Sales Cube you need:

All users, who will be using Power BI from your Magento store will have to be added to your Azure Active Directory tenant.

The extension uses a Client ID to identify itself to Azure AD. You also need a client secret key. Please, refer to Microsoft Power BI documentation for the information on how to set up an Azure AD environment for the Power BI app in and get authentication security token (client secret key). Obtained client ID and client secret key might be provided to the Power BI extension on Magento configuration page.

You can use Power BI service for free or buy Power BI Pro for $9.99 / USER / MONTH. Alternatively, you may purchase capacity based service with Power BI Premium or Power BI Embedded package. See pricing and features for more details. All features described below relate to a free service plan if not stated explicitly.

Additionally, you will be required to register on a website of the extension developer to get the license activation code for your license.

 

Key Features

  • Highly efficient incremental Data Extraction from Magento Platform
  • Prepare and load sales data in a form, optimized for Q&A and Ad-Hoc Interactive Reports
  • The fully automated process of data delivery and reports actualization
  • Embed Reports and other Power BI content to Magento admin pages
  • Use out of the box ready to use reports to help you to get started and give you the inspiration to create your own reports
  • High level of data quality ensured with thorough automated and manual testing
  • Business-friendly, well-documented data model allowing business-oriented users to build reports and dashboards without any technical knowledge
  • Data includes relationships between websites / stores / products / categories / orders / order items / invoices / customers that allow to cross-filter / drill-down to the level of a single order line
  • Support for Power BI workspaces for easy collaboration with your colleagues
  • Possibility to use a separate database for Analytical data processing (Mini DWH / Data Mart)
  • No extra software required. All communication is done via the APIs directly with Power BI Service
  • Backup Power BI Reports

 

Embedded Analytics

One of the important features is the possibility to have embedded reports inside Magento pages. This is extremely valuable because it allows you to make usage of statistics being easily adopted across your company. The key here is that statistics on a particular order/product/customer will be accessible inside Magento just at the time and in the place where you need this information. 

Embedded Question&Answer section in the Magento store allows you to type in your sales related question and get a response in a form of visual representation of your data. You can even save money with Power BI Embedded capacity where you are not required to have Power BI account for every employee who will access the Power BI Reports.

 

Use Cases

  • Provide Mobile access to Magento sales statistics to your team and stakeholders
  • Use interactive reports to analyze sales performance and to understand what are the factors that influence the performance
  • Easily create any custom reports based on sales data of any complexity with custom calculated measures
  • Provide access to ready to use, cost-efficient BI solution for your employees to drive data-driven culture
  • Do not miss market opportunities by letting your Sales and Marketing teams to have an easy way of getting insights from your data
  • Set up measurable goals as your objectives and provide easy ways of monitoring your success
  • Save time and costs on development and integration with BI tools by using ready to use full-stack BI solution provided with high-quality support

 

Sample Reports

  1. Sales Forecasting
  2. Monthly performance report
  3. Related products
  4. Repeated orders
  5. Average order value
  6. Data actualization status
  7. Today's performance
  8. Latest 7 days performance
  9. Orders by state
  10. Average price analysis
  11. Product price change
  12. Sales rule performance analysis
  13. Orders overview
  14. Sales overview
  15. Year to year comparison
  16. Top products
  17. Product attributes analysis
  18. Payments analysis
  19. Workflow time analysis
  20. Sales by location
  21. Age and order behavior analysis
  22. Advanced product search
  23. Products ABC analysis
  24. Customers ABC analysis
  25. Customer-based basket analysis

 

Support

Our support covers the data quality. Together with our SLA we provide Data Dictionary with a description of data tables, columns, and calculated measures. If something does not behave as it is described, we will investigate the issue and provide you with a solution.

Our goal is to make sure that our solution will fit your particular needs and that you will take maximum benefits from insights based on your data. Read more about support conditions in our Service Level Agreement.

With our support, you are not required to have dedicated in-house ETL / BI professionals responsible for maintaining the process of data preparation and delivery. We advise you on how you can achieve your goals with respect to reporting based on your Magento sales data.

Technical Specifications

Back to top

Seller profile

Kyrylo Kostiukov

Seller contact

E-mail

Integrator

Power BI Service

Current Version

2.2.11

Adobe Commerce platform compatibility

Open Source (CE): 2.3 (current), 2.4 (current), 2.2 (obsolete)

Commerce on prem (EE): 2.3 (current), 2.4 (current)

Commerce on Cloud (ECE): 2.3 (current), 2.4 (current)

Type

Stable Build

Updated

11 August, 2021

Categories

Extensions, Reporting & Analytics

Supported Browsers

Chrome, Firefox, Opera, Safari, Edge, IE

Quality Report

Back to top

Installation & Varnish Tests

Passed

Coding Standard

Passed

Plagiarism Check

Passed

Malware Check

Passed

Marketing Review

Passed

Manual Testing

Passed

All tests were conducted on the latest versions of Adobe Commerce that existed for the compatible release lines at the moment of the extension submission. Latest versions of all other software were used, as applicable.

Release Notes

Back to top

2.2.11:

  • Compatible with Open Source (CE) : 2.2 2.3 2.4
  • Compatible with Commerce on prem (EE) : 2.3 2.4
  • Compatible with Commerce on Cloud (ECE) : 2.3 2.4
  • Stability: Stable Build
  • Description:

    Add possibility to use CSV files and Magento API endpoints as a source for Power BI Tables.

2.2.8:

  • Compatible with Open Source (CE) : 2.2 2.3 2.4
  • Compatible with Commerce on prem (EE) : 2.3 2.4
  • Compatible with Commerce on Cloud (ECE) : 2.3 2.4
  • Stability: Stable Build
  • Description:

    Support for latest Magento versions (up to 2.4.2). Bug-fixing. Some extra enhancements and better support for customizations.

2.1.5:

  • Compatible with Open Source (CE) : 2.2 2.3
  • Stability: Stable Build
  • Description:

    First release of Power BI Integration with Sales Cube.

Support

Back to top

The best place to start if you need help with a specific extension is to contact the developer. All Adobe Commerce developers have both a contact email and a support email listed.

Contact Vendor

Q & A

Back to top

Reviews

Back to top