Business Analytics

What does ETL stand for?

• Extract, Transform and Linux

• Extract, Transform and Load

• Extrude, Transform and Load

• Extra-Terrestrial Loading

What is a disadvantage of SQL?

• Can retrieve large amounts of data quickly

• Can interact with tables

• Need to be able to code

• Can join multiple tables

An alternative to SQL is to hide the complexity behind what?

• SQL layer

• semantic layer

• stochastic layer

• brick layer

Under OLAP, data is categorised into __ and __

• supervised and unsupervised

• structured and unstructured

• online and offline

• measures and dimensions

Clustering (a data mining method) is good for what?

• grouping

• predicting

• ungrouping

• fine-tuning

An example of association (a data mining method) is …

• regression analysis

• shopping basket analysis

• analysis of variance

• image analysis

A good chart for displaying percentages is a …

• bar chart

• scatterplot matrix

• pie chart

• line chart

A good chart for displaying the inflation rate over time is a …

• bar chart

• scatterplot matrix

• pie chart

• line chart

A data warehouse is optimised for __ access

• read access

• write access

Which has more detail - OLTP or OLAP?

• OLTP

• OLAP