Notes on “Power BI – What Is It, How it Works, and Why it Matters” (John White)
Michael Sampson - Currents
JULY 15, 2014
Some notes: - classic architecture – from source data, extract / transform / load, into a storage alternative, and then ready for design and visualization. In a Microsoft world, ETL is done by SQL Server Integration Services (SSIS), storage in SQL Server DB with SQL Server Analysis Services, and design and visualization through Reporting Services (SRSS, on SQL Server), SharePoint (Excel Services, PowerPivot for SharePoint, SSRS SharePoint Mode, and PerformancePoint), or Excel.