Price From: €0.00

* Required Fields

Price From: €0.00

Power BI Sales Cube extension for Magento

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.

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

Details

Key Features

Comprehensive sales dataset

Deliver all data related to sales in its best shape optimized for usage with Power BI. Business friendly data model provides easy way to analyze data without technical knowledge about Magento internals.

Automated and iterative data delivery

Keep your reports and dashboards up to date with recent data. Deliver only latest orders' data without the need to do a costly and long-running full data reload.

Analyze full history of orders

Do not restrict yourself in your analysis. Our highly optimized solution will handle full history of orders that can fit into Power BI Service. Our scalable solution may also work with hardware resources dedicated only for analytical data processing.

Ready to use Power BI Reports

Get started quickly with extensive set of ready to use out of the box reports. Use our sample reports to get first insights and get inspired on creation of more reports and dashboards.

Empower Magento with embedded analytics

Embed Power BI reports on different Magento pages to get reports for each product / customer / order just within Magento. Include Question&Answer section in Magento Overview page and start literally asking questions to your Magento store.

Use REST API or OData API

The extension offers two ways of integration where each way helps to satisfy certain use cases. REST API dataset is more business friendly and easy to use. OData allows more advanced usage with custom data modeling.

Highly customisable

Build with best practices of BI industry our solution is ready to satisfy all sorts of needs for any business. Our support will be there to guide you to the right ways of achieving your business goals with our solution.

Power BI Benefits

With your Magento data being delivered to Power BI, you can stay informed about your key business activities. Keep overview over your business with Power BI and share regularly your business insights with your stakeholders and your team.

Interactive Reports

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

Mobile App

Access your reports and dashboards anytime with Power BI Mobile App

Data Alerts

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

 

Getting up and running

  1. Install Extension on your online store running on Magento
  2. Register App for Power BI in Azure Active Directory and obtain Client ID and Client Secret
  3. Configure API in Magento by entering Client ID and Client Secret
  4. Connect your Magento user with a Power BI Account
  5. Create Sales Cube dataset for Power BI
  6. Publish the dataset and start data loading process
  7. Upload sample reports to Power BI and assign them to the created dataset
  8. Configure embedded content based on Sales Cube dataset and related reports.
  9. Configure the schedule for automated data refresh

Registration and usage of Azure Active Directory for setting up the Power BI API is free and you should be able to setup the integration without the need to purchase any services from Microsoft.

Once the data will be delivered to Power BI, you can use the delivered dataset to create reports and dashboards. You can access created dashboards with Power BI Online Service or using Power BI Mobile App.

Sample Reports

The Sales Cube package comes with 30 different reports, some of them include several pages. List of the reports is available on out page with report examples.

Each report could be opened on our website. The report examples are integrated with out sample data and you can play with filters/selections to test the functionality of the reports.

One of the sample reports: Monthly Sales Report

Additional information

License and Support

We offer yearly and perpetual license. Each license is valid for one Magento installation. Term license includes continuous support, upgrades to latest Magento and Power BI releases, provides access to latest features. With perpetual license the support is limited to 1.5 years, with possibility to extend this period.

Available packages

The Power BI Sales Cube is released in two different packages to meet certain business cases.

Power BI Sales Cube

The most comprehensive package that on top of core integration with Power BI includes advanced data modeling part, forming a Sales Cube - extensive dataset with all data related to sales process. Instead of relying on core Magento reporting, Sales Cube includes alternative logic for analytical data preparation and forms a structure that is optimized for being used in Power BI.

Additionally, the package includes embedding functionality, sample ready to use reports and integration with usage of OData for more advanced use cases.

Power BI Sales Cube Lite

This package includes one the most advanced parts of our Power BI Integration: the Sales Cube. With Sales Cube users can get their data delivered to Power BI in its best shape. At the same time, Lite package does not include all of the extras that come with the full Sales Cube package.

See our Product Overview and Features & Pricing pages for full list of available functionality.

Development package extension

For those willing to extend the functionality of Power BI integration with custom development we offer to extend the support with an extra Development package. This will open access to source code, to available code documentation and will include support on development related topics.

Use the following link to purchase the development support extension for the Power BI Integration: Buy Development Support.

Contact us

Feel free to contact us if you have any questions.