CardioLog Analytics allows for full integration with Microsoft Power BI, which enables stakeholders and portal administrators to perform quick, on-demand actions with their data using intuitive reporting dashboards, monitor relevant KPIs, and to search through the data easily.



Solution Architecture

Data Layer

A "data warehouse" is built on top of the CardioLog Analytics database using an ETL (Extract, Transform, Load) process.

The multi-dimensional tabular model enables fast and reliable aggregated queries from the data warehouse and a semantic layer for the end users. The tabular model contains security based role assignments. Accordingly, end users will have to be authenticated using Active Directory.

The database layer, which includes the data warehouse, ETL process and multidimensional tabular model, can reside on a server on-premise, or in the cloud. 

Presentation Layer

The integration is available for on-premise, hybrid, and cloud-based deployments of Microsoft Power BI:

  1. On-premise:
    1. Reports in Excel - Power BI view and Excel pivot tables
    2. Reports embedded in SharePoint (Excel services)
  2. Hybrid: Microsoft Power BI cloud interface with an on-premise database
  3. Cloud-based: Microsoft Power BI cloud interface with a cloud-based database

Data workflow: From Data Source to Data Presentation


System Requirements


Hardware requirements including storage and memory are based on the amount of data loaded to the data warehouse, and the multi-dimensional model. Exact specifications will be provided per customer upon request.
View the following to assure that your system meets the minimum software requirements for the Power BI integration: 

On-Premise Excel/Office 365

SharePoint Embedded Excel

Power BI User Interface

SQL Server 2012 BI Edition or higher*

SQL Server 2012 BI Edition or higher*

SQL Server 2012 BI Edition or higher*

Active Directory

Active Directory

Active Directory

On-Premise Office or Office 365 account (per user)

SharePoint Enterprise Edition

Power BI Pro or Power BI Premium Per User license (per user)


Integrated SSRS

External internet connection


Excel Services for SharePoint



* SQL Server 2012 BI Edition or higher is required when the Data Warehouse is hosted on-premises. When using a cloud-based database you can sync the data to the cloud using Power BI personal gateway.



  • No labels