Power BI Integration

Power BI Integration for Magento platform

  • Integrate with leading reporting solution
  • Automate data extraction, preparation and delivery
  • Analyze detailed sales data easily
  • Access reports on Web and Mobile Apps
  • Embed BI reports into Magento store

Setting up the integration

Simply install and configure our Magento extension and it will prepare and deliver your data to Power BI Service.

No need to invest in costly development and data management.

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 Reports

Get out of the box ready to use reports with out extension to get started from day one.

Get inspired and create your own reports and dashboards as you proceed with analysis of your 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 chaise for you...

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

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.

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 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.

Customizable for your needs

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

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.

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 solution

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

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

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

REST API and OData API

We provide two ways of 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.

Monitor data updates

Keep control over data actualization process by getting information about latest data delivery status.

Power BI Benefits

Once Data is delivered to Power BI...

Create interactive reports

Use data delivered from Magento store to create Interactive Reports and Dashboards in Power BI Service from Microsoft.

Monitor your data with mobile app

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

Add KPIs and calculated measures

Add calculated Measures by writing excel-like formulas in Power BI Desktop.

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.

Setup email and mobile alerts

Setup alerts and get notified on your mobile phone or per email when you reach (or not reach) certain performance threshold.

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.

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.

Packages

  1. Power BI Sales Cube extension for Magento

    Price From: 0,00 €

    Integrate your Magento store with Power BI Service, 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.

    The package includes full set of functionality around our Power BI Integration solutions, including one of the most advanced part of it: Sales Cube - comprehensive sales data ready for analysis in Power BI.

    Подробности

  2. Power BI Sales Cube Lite extension for Magento

    Price From: 0,00 €

    Integrate your Magento store with Power BI Service, 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.

    The package delivers one of the most useful parts around out Power BI Integration solutions: Sales Cube - comprehensive sales data ready for analysis in Power BI.

    Подробности

  3. Power BI Integration Plus extension for Magento

    Price From: 0,00 €

    Integrate your Magento store with Power BI Service, 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.

    The package includes core integration with Power BI Service with extra utilities for those, who actively extend the functionality by creating new datasets and reports or by extending the functionality with custom development.

    Подробности

  4. Power BI Integration extension for Magento

    Price From: 0,00 €

    Integrate your Magento store with Power BI Service, 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.

    The package includes core integration with Power BI Service with automated delivery of recent data from core Magento reports.

    Подробности