Loading...

Magento Power BI Extension

  • Most advanced Magento Business Intelligence extension
  • Available for Magento 1 and Magento 2
  • Magento advanced reporting and analytics
  • Create reports and dashboards with the best BI tool
  • Access BI reports on Web and Mobile App
  • Embed Magento BI reports into admin pages

Setting up the integration

Simply install and configure Power BI Integration plugin and get our of the box Magento Business Intelligence solution with advanced Magento reporting capabilities, automated data extraction, preparation and data delivery.

Configure API
Connect with Power BI
Create Sales Cube dataset in Magento store
Publish Sales Cube dataset to Power BI Service
Start data loading of a sales cube dataset
Minotor data loading process of sales cube dataset
Create report inside Power BI Service
Connect to Power BI Service Datasets from Power BI Desktop
Configure data actualization scheduler
Datasets Overview in Magento
Use reports templates
Publish report templates to Power BI Service
Make backup and copy of reports inside Power BI Service
Access Power BI Reports within Magento
Open Power BI Reports within Magento
Configure embedded Power BI content inside Magento
Use preferable mode of embedding of Power BI content inside Magento
Show customer statistics as embedded Power BI Report
Show order statistics as embedded Power BI Report
Show product statistics as embedded Power BI Report
Enable Question and Answer field inside Magento
Enable OData API in Magento store
Enable OData API access to a dataset in Magento
Connect to Magento from Power BI Desktop via OData API
Create custom data model with OData connection in Power BI Desktop
Use OData connection with Dataflows inside Power BI Service
Use Power Query to manipulate with data delivered via OData API
Configure efficient ETL process for data extraction and preparation
Customize dataset schema for advanced use cases
Use development toolbox to manipulate with Power BI integration setup
List of ETL jobs inside Magento platform

Sample Magento BI Reports

Get out of the box ready to use advanced reports with our Magento module to get started from day one.

Get inspired and create your own custom Magento reports and dashboards as you proceed with analysis of your Magento data.

Sample Power BI Report showing sales forecast based on Magento e-commerce data.

Monthly performance report based on Magento e-commerce data.

Related products report based on Magento e-commerce data.

Repeated orders report based on Magento e-commerce data.

Average order value report based on Magento e-commerce data.

Data actualization status report based on Magento e-commerce data.

Today's performance report based on Magento e-commerce data.

Latest 7 days performance report based on Magento e-commerce data.

Orders by state report based on Magento e-commerce data.

Average price analysis report based on Magento e-commerce data.

Product selection page of Product price change report based on Magento e-commerce data.

Product price change report based on Magento e-commerce data.

Page 1 of sales rule performance analysis report based on Magento e-commerce data.

Page 2 of sales rule performance analysis report based on Magento e-commerce data.

Page 3 of sales rule performance analysis report based on Magento e-commerce data.

Orders overview report based on Magento e-commerce data.

Sales overview report based on Magento e-commerce data.

Year to year comparison report based on Magento e-commerce data.

Top products report based on Magento e-commerce data.

Page 1 of product attributes analysis report based on Magento e-commerce data.

Page 2 of product attributes analysis report based on Magento e-commerce data.

Payments analysis report based on Magento e-commerce data.

Workflow time analysis report based on Magento e-commerce data.

Page 1 of sales by location report based on Magento e-commerce data.

Page 2 of sales by location report based on Magento e-commerce data.

Age and order behavior analysis report based on Magento e-commerce data.

Report with advanced product search based on Magento e-commerce data.

Products ABC analysis product search based on Magento e-commerce data.

Customers ABC analysis product search based on Magento e-commerce data.

Page 1 of customer based basket analysis report based on Magento e-commerce data.

Page 2 of customer based basket analysis report based on Magento e-commerce data.

Page 3 of customer based basket analysis report based on Magento e-commerce data.

Page 4 of customer based basket analysis report based on Magento e-commerce data.

Key Features

Read, why our integration solution is The Best choice for you...

Incremental data export icon

Incremental data export

Incrementally extract only the latest data from Magento Platform to increase speed and efficiency of data extraction with Sales Cube extension.

Automated data delivery icon

Automated data delivery

Make sure that your reports and dashboards are updated regularly with most recent data. The extension allows you to schedule automated data delivery to Power BI Service on a weekly, daily, hourly or even with several minute intervals.

Analytics Embedding icon

Embedding to Magento

Make sure that your reports and dashboards are updated regularly with most recent data. The extension allows you to schedule automated data delivery to Power BI Service on a weekly, daily, hourly or even with several minute intervals.

Backup reports icon

Backup Power BI content

Save copy of your Power BI reports to ensure that your work will not be lost and can be reused with other datasets.

Download/Upload reports from/to Power BI.

Customization icon

Customizable for your needs

Modular implementation allows extending the functionality of the extension to support any custom functionality of your Magento installation.

Scaling icon

Scalable Setup

Separate database for Analytical data processing (Mini DWH / Data Mart)

Use replication database to extract data from. Perform analytical data processing on separate database server.

Data Modeling Icon

Business-friendly data model

No need to know internals of Magento or its data storage. Just create reports based on well-known terminology such as orders, products, categories, tax classes and so on.

High quality - Icon

High quality solution

Our data model is well tested and documented. The data quality is covered by our support agreement.

History of orders - Icon

Full history of orders

You can deliver up to 10 GB of data that in most cases will cover complete history of your online store.

Out of the box reports - icon

Out of the box reports

Benefit from the first day by installing our out of the box Magento reports. Customize and create new reports as you continue using the Power BI Integration.

Reporting APIs icon

REST API and OData API

We provide two ways of Magento integration with Power BI to ensure maximum flexibility to satisfy any possible needs. REST API for more automation and better usability, OData for more flexibility advanced usage.

BI Monitoring Icon

Monitor data updates

Keep control over data actualization process by getting information about latest data delivery status in Magento admin panel.

Power BI Benefits

Once Data is delivered to Power BI...

Create interactive reports

Use data delivered from Magento store to create custom BI reports and dashboards in Power BI Service from Microsoft.

Interactive Magento BI reports will let you see why things happened and how to improve business performance in the future.

Created advanced Magento Business Intelligence reports will allow to get into the lowest level of detail and see exactly, what orders and products influenced your business performance the most.

Creation of a report in Power BI Service based on Sales Cube data from Magento

Monitor Magento data with mobile app

Use free Power BI Mobile App available for Windows Phone, Android or iOS to access your Magento reports and dashboards, receive alerts and to have access to your data from any place at any time.

Example of Magento mobile report with Sales Forecasting
Example of Magento report in mobile app with Price Rule Analysis
Example of Magento mobile advanced report with Price Rule Analysis for single product

Add KPIs and calculated measures

Add calculated measures by writing excel-like formulas in Power BI Desktop to extend your Magento analytics with more customized KPIs.

Creation of custom calculated measure for Magento reports in Power BI

Use QnA or Cortana with Magento data

Embed Question & Answer section to your Magento store and type questions to get answers as data visualizations.

Integrate with Cortana service to teach voice assistant to use reports with Magento data.

Power BI Question&Answer section embedded into Magento admin dashboard

BI alerting icon

Setup email and mobile alerts

Access Magento mobile reports, setup alerts and get notified on your mobile phone or per email when you reach (or not reach) certain performance threshold.

BI Content Sharing icon

Share content with your colleagues

Publish data and create content inside Power BI Workspaces and share it with other Power BI users from your organization.

BI reporting bookmarks icon

Bookmarks and many more

Enjoy usage of bookmarks and of all other functionality that is released regularly with every new update of Power BI Service.