Versions Compared

Old Version 1

changes.mady.by.user Paul Berkowitz

Saved on

compared with

New Version 2

changes.mady.by.user Paul Berkowitz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

CardioLog Analytics provides a multitude of predefined reports via its dedicated user interface.The integration allows for full integration with Microsoft Power BI, which enables stakeholders and portal administrators to perform quick, on-demand slice & dice actions of with their data through additional using intuitive reporting dashboards, monitor the KPIs that mean the most to themrelevant KPIs, and to search through it all in one glancethe data easily.

Contents

 

Anchor
architecture
architecture
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 enable 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 roles and in order to connect to it via the presentation layerrole assignments. Accordingly, end users will have to authenticate be authenticated using ADActive Directory.

 

The database layer (, which includes the data warehouse, ETL process and multidimensional tabular model) , can reside on an a server on-premises server or hosted 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-premises premise database
  3. Cloud-based: Microsoft Power BI cloud interface with a cloud-based database


 Image Added

Data workflow: from data source to data presentationFrom Data Source to Data Presentation


 

Anchor
requirements
requirements
System Requirements

 

Hardware requirements such as including storage and memory are based on the amount of data loaded to the data warehouse, and the multi-dimensional model and will . 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-Premises Premise Office or Office 365 account (per user)

SharePoint Enterprise Edition

Power BI pro account (per user)

 

Integrated SSRS integrated

External internet connection

 

Excel services featuresServices for SharePoint

 

 

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

...