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.
A Minimal BI Stack on SQL Server
A minimal BI stack can start with SQL Server tables, stable views, one scheduled load, and one reporting tool that a small team can run.
Data Mining: A Simple Introduction and a SQL Basket Example
Market-basket analysis turns purchases into measurable product relationships. Deduplicate products within each order, calculate support, confidence and lift in T-SQL, and interpret the counts before drawing conclusions from a small sample.
SQL SERVER – Languages for BI – MDX, DMX, XMLA
A friend knew BI means Business Intelligence but asked which languages it uses. Quick definitions of MDX, DMX and XMLA, the languages of SQL Server BI.
SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions – 2
Important terms and definitions in business intelligence, explained in plain words and grouped by how data moves from source systems to reports.
Year-to-Date Totals Next to the Same Period Last Year
A fair year-to-date comparison needs the same dates from last year. Here is a short query, plus the leap day trap.
SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
Business Intelligence basic terms explained in plain words: BI, data warehouse, data mart, cube and more, so the BI vocabulary is easier to follow.