Business Intelligence

1. Interpret the data – what kind/type of data is it and what can it be used for?
In your answer prepare a table with column names and an explanation of the type of
data and the purpose of each column, in particular of the columns including measures
(such as “Row_Total”).
2. Imagine the following scenario:
You are hired as the new assistant to the executive board. You are asked to prepare a
meeting for tomorrow, in which the board will discuss the following business
a. How have sales developed in 2017?
b. Who are our top 10 Customers in 2017 (based on total dollars spent)?
c. What are our top 10 products in 2017 (based on total units sold)?
d. How are sales distributed over the regions?
3. Prepare an executive dashboard based on the data.














































Sample Solution