Page History
CardioLog Analytics version 4.0.0 or higher provides delivers reports via Microsoft Power BI.
The integration with Microsoft Power BI enables stakeholders and portal administrators to perform quick, on-demand slice & dice actions on their data through intuitive reporting dashboards, monitor the KPIs that mean the most to them, and search through it all in one glance.
The integration is available for on-premises deployments of Microsoft Power BI.
System Requirements
Standard Edition | Professional Edition | Enterprise Edition | ||||
---|---|---|---|---|---|---|
Platform | 64-bit | 64-bit | 64-bit | |||
Operating System | Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched) | Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched) | Dedicated Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)
| |||
Application Memory* | Minimum - 4 GB Recommended - 8 GB | Minimum - 8 GB Recommended - 16 GB | Minimum** - 16 GB Recommended - 32 GB | |||
Processors* | 4 Cores | Minimum - 4 Cores Recommended - 8 Cores | Minimum** - 8 Cores Recommended - 16 Cores | |||
SQL Server Edition | Microsoft SQL Server 2012/2014/2016/2017 Enterprise Edition (fully patched) | Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard Edition (fully patched) | Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard or Enterprise Edition (fully patched) | |||
SQL Instance Memory | 4 GBClient | Power BI Desktop* | Power BI Desktop | Power BI Desktop and/or web browser** | ||
Server | Power BI Report Server*** | |||||
SQL Server Edition | SQL Server Enterprise Edition | SQL Server Enterprise Edition | ||||
SQL Instance Memory | Minimum - 8 GB Recommended - | 16 32 GB | Minimum | ** - 16 GB Recommended - | 32 64 GB | |
SQL Server Processors | 4Minimum - 2 Cores Recommended - 8 Cores | Minimum | ** - | 8 4 Cores Recommended - 16 Cores | ||
SQL | ServerStorage | :
|
| |||
SQL System Disk (Mirrored) | 10 GB | 10 GB | 10 GB | |||
SQL Page File Disk | 10 GB | 10 GB | 10 GB | |||
SQL Database Disk | 20 GB per year | 60 GB per year A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | Maximum 600 GB per year A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | |||
SQL Transaction Log Disk | 5 GB A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | Minimum ** - 50 80 GBRecommended - 100 GB A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs | ||||
SQL Temp Database Disk | 20% of Database Disk size | 20% of Database Disk size Recommended - A separate physical hard disk, preferably solid-state drive (SSD) | 20% of Database Disk size Recommended - A separate physical hard disk, preferably solid-state drive (SSD) | |||
SQL Temp Database Log Disk | 1 GB | 5 GB | 5 GB | |||
SQL RAID | RAID 10 or similar | RAID 10 or similar | RAID 10 or similar | |||
Additional Software & Services |
|
|
|
* This refers to hardware allocated for the CardioLog application pool and services, not for the CardioLog SQL server
Option | Dev Est. | System Requirements | Additional Costs Involved | Access Method | Customer Size | Storage Limits | Permissions Support |
---|---|---|---|---|---|---|---|
1) Power BI Desktop via import mode | 0 | Client App Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2 Windows Server 2012, Windows Server 2012 R2 Internet Explorer 10 or greater Available for x64 or x86
In import mode consumes a lot of RAM (depending on dataset site) | Free | Desktop App
| STD | 1GB | No, if connected via import mode |
via Live connection mode | Requires SSAS (option #2) Consume small amounts of RAM ~1GB | PRO ENT | No | RLS via SSAS | |||
2) Microsoft SQL Server Analysis Services Used for "Live connection" mode for Report server or PBI Desktop | 5 | Server App Recommended: 16 Cores, 64 gigabytes of RAM Minimum: 64-bit dual-core processor, 3 gigahertz, 8 gigabytes of RAM At least 80 gigabytes of storage | SQL Server Enterprise - $14,256 | Desktop App or Web access (with option #3) Used as intermedia for large customers Allows to load server RAM instead of client RAM | PRO ENT | No | Allows to have RLS (row-level security) So basically allows having users support |
3) Power BI Report Server Used as GUI Power BI Online substitutor | 5 | Server App Recommended: 4GB RAM, x64 2.0GHz processor, Minimum: 1GB RAM, x64 1.4GHz processor | Comes with Power BI Premium: ~5000$ monthly OR SQL Server Enterprise with Software Assurance Support Cost is 25% from MS server products | Web access | STD PRO ENT | No | Has its own RLS, so supports many users + SSAS can be used if connected |
Power BI report server prerequisites:
...
SQL Server Analysis Services | SQL Server Analysis Services |
(1) Up to a dataset size of 1 GB.
(2) Access to Power BI reports via a web browser requires a Power BI Report Server. Power BI Desktop version should be optimized for Report Server.
(3) Power BI Report Server is included with the Power BI Premium license and with SQL Server Enterprise Edition with Software Assurance support.
Power BI Report Server system requirements - https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements
Power BI Desktop system requirements - https://docs.microsoft.com/en-us/power-bi/desktop-get-the-desktop#minimum-requirements
Download Power BI Desktop optimized for Report Server - https://www.microsoft.com/en-us/download/details.aspx?id=57271