mpalgeo

mpalgeo

OnlineOffline

Mastering Power BI, SQL Server, SSIS, SSRS, SSAS.

I am responsible for the Design and the Development of the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2.
The database is being updated daily from the core system via SSIS and a numerous of KPIS are being daily updated during the ETL.
For performance reasons the KPIS are replicated to another DB which exploits the dashboards via Power BI and reports via, SSRS to the consumers.
Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL.
Finally several other reports are daily automatically produced and sent via email to the recipients.
The size of the Master DB, which I am the Admin, is about 4TB and the replicated KPI DB is 350GB

“He did the work in 7 hours while two other providers did work months on it.
[13 September, 2017] i never experienced such a fast solution for my requirement : i had two other teams working on this for weeks .. this provider did it in 7 hours”