Skip to content
Sem 5 Prep
← BI & Data ScienceWhat business intelligence and data science are

Formulas for this chapter

Mean of a column

mean = SUM(values) / n Excel: =AVERAGE(range)

Turning raw data into information, the second rung of the DIKW ladder. Always check the answer lies between the smallest and largest values.

SUM(values)
Total of every observation
n
Number of observations

Growth and uplift percentage

growth % = (later - earlier) / earlier x 100

Comparing two periods or two groups. The denominator is always the figure you are comparing against; swapping it changes the answer.

later
Value of the newer period or the group being described
earlier
Value of the base period or the reference group
Step 4 of 25
The real wordsTheory

The BI outputs the outline names

The outline is specific about what BI hands a manager: reports, summaries, dashboards, graphs, charts and maps. Learn that list; it is the answer to "what does a BI tool produce".

It also names the job of data science separately: statistical analysis, quantitative techniques, and explanatory and predictive modelling on data, to generate information and insights that help make actionable decisions.

← BackContinue →