1) Simple definition of Business Intelligence (BI)
There is a series of complex definition but they have simple one is:
BI is about extracting useful business info from data.
2) At what level of detail are managers interested in data? Give new eg not in the article. At this level of detail, is it still data or something else?
They all collect the mass of data at a truly level of detail which is often far too much for most HIGH level decision makers.
Eg: Most Sale directors need to know Finance managers: Finance department do Profit & Loss statement —> predict Future sales.
3) The useful BI that people need is often based on data held in Multiple systems? What concept does this represent?
The format of data is usually incompatible. It's much easier to create an entirely new system (the data warehouse) to accept incoming data.
4) What does the acronym ETL stand for?
ETL - Extraction, Transformation, Loading (Solve problem)
Extract the data from the source systems, transform it into a compatible format and Load it into a centralised called data warehouse.
