Published On Nov 19, 2011
Demonstration of how a simple Business Intelligence Solution works. It demonstrates 1) an Extract Transform Load process (ETL), 2) Data warehouses, 3) Reporting & Scorecarding, 4) Root Cause Analysis (RCA), 5) Decision Tree Predictive Models, 6) Model scoring, 7) Profit charts & finally 8) Campaign Return on Investment Analysis. The demonstration uses SQL Server databases, SQL Server Integration Services (SSIS), SQL Server Analysis Services (Via the excel addin), PowerPivots, and Excel.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...