Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
SQL SERVER – Future of Business Intelligence
Where is BI headed? My take on the future of Business Intelligence, from forecasting and smarter decisions to BI in every industry and business size.
SQL SERVER – Business Intelligence – Aligning Business Metrics
Managers want timely, visual, personal information for faster decisions. How Business Intelligence helps with aligning business metrics across a company.
SQL Server – White Paper – An Introduction to Fast Track Data Warehouse Architectures by Erik Veerman
Erik Veerman’s white paper introducing Fast Track Data Warehouse architectures, reference configurations that take the guesswork out of BI hardware choices.
SQL SERVER – 2008 Star Join Query Optimization
Star Join Query Optimization in SQL Server 2008 Enterprise Edition uses bitmap filtering to speed up data warehouse queries that join fact tables.
Pre-Aggregating Data for Fast Dashboards
Pre-aggregating data can make dashboards fast through summary tables or indexed views when grain, refresh, and reader consistency are clear.
SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions
What is Business Intelligence? A plain introduction to BI and the key terms that go with it, like decision support, data mining, OLAP, reporting and forecasting.