Data Warehouse is a collection of data in support of management’s decision making process. It is developed for Business Intelligence in the healthcare of South Africa. This system is used for reporting and data analysis.
The following list of reports can be generated:
The cube in RAM is using 120 Gb. The sources for the data which are used in the cube during ETL: MySQL, MS SQL, CSV files, Excel files, FTP server, Dropbox, OData. The biggest table in the cube is 250 million rows.
Azure DB, C#, DAX, IT solutions, Microsoft Excel/Power View, MS Power BI, MS Report Builder, MS SQL Server 2012/2014, MS Win Server 2012, MySQL, PowerShell, SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), TFS (Team Foundation Server)