each spreadshhet in an organisation be assigned a unique identifier
Spreadsheet identifier (SSID)
a type of advanced data analytics used to support business decision making.
Busiess Intelligence Technologies
Global spreadsheet query
a dimensional database has one fact table as its center. A relational database does not have one central database table. Instead, it resembles an interlocking chain, linked together without a center.
Relational database or dimensional database
How is data stored using BI technologies
1) fact table
2) dimension table
Two types of database in the dimensional database?
MS SQL server Relational Database
has one fact table & two or more dimension (DIM) tables
a referential constraint between two tables. A foreign key is a field in a relational table that matches a candidate key of another table. The foreign key can be used to cross-reference tables.
Two types of dimensional database structures. Both have one fact table at the centre in a star structure, the dimension database tables are all related onl to the central fact table, creating a star shape.
In a snowflake structure the dimension tables relate to the fact table like a snowflake. There is one inner circle of dimension tables & additional dimension tables are related to the inner dimension tables. At most, a query traverses only three tables.
Star & Snowflake
includes data transferred from the operational database; can also include data from other sources, including shadow data; may contain duplication & inconsistencies.
- extracted from the relational database
- reorganised into dimensions
- transferred & loaded into data warehouse tables
To perform BI analytics, the data must be
Dimensional Database Star Structure
The word fact is added to the database fact table name. Dim is added to the dimension database table names.
Difference between fact and dimension table
a step-by-step solution to a problem
Fig7.24 pg 282
ETL for Loading DimSalesTerritory Table Using MS SQL Server
typically used on relatively unstructured data; can be used to mine text stored in various enterprise documents, including emails, word processing documents & reports.
searches the Internet for specific paterns on Web sites