Business Intelligence - Assignment 1

Running head: BUSINESS INTELLIGENCE
Business Intelligence
Assessment item 1 – Assignment 1
Student Name:
University Name:

1BUSINESS INTELLIGENCE
Table of Contents
Part A – Visual DSS........................................................................................................................2
Answer to Question 1..................................................................................................................2
Analysis of results....................................................................................................................3
Answer to Question 2..................................................................................................................3
Analysis of results....................................................................................................................5
Answer to Question 3..................................................................................................................5
Analysis of results....................................................................................................................6
Part B – Power BI............................................................................................................................7
Demonstration 1...........................................................................................................................7
First dashboard.........................................................................................................................7
Second dashboard selecting DB9 in the slicer.........................................................................7
Answer to questions.................................................................................................................8
Demonstration 2...........................................................................................................................8
First dashboard.........................................................................................................................8
Second dashboard selecting Treemap, Research Fellowship..................................................9
Answer to questions.................................................................................................................9
Bibliography..................................................................................................................................10

2BUSINESS INTELLIGENCE
Part A – Visual DSS
Answer to Question 1
NPV model
*Columns
*Years 2018,2021
*Rows
Initial investment needed(0) = 1750000.00 '.2
Market at time (0)= 420000
Market Growth = 0.15'.2
Market Share = 0.10'.2
Total market = Market at time;Total market(-1)*1.15
Sales Volume = Total Market*Market Share
Estimated selling price = 55.00 '.2
Cost of production = 25.00 '.2
Total Revenue = Sales Volume*Estimated selling Price '.2
Cost of Goods sold = Sales Volume*Cost of Production
Annual overhead cost = 210000
Cash Flow = Total Revenue-Cost of goods sold-Annual Overhead cost
Rate = 0.12'.2
NPV(0) = *NPV cash flow;rate
Model Output

3BUSINESS INTELLIGENCE
Analysis of results
Based on the result of the model, the net present value (NPV) is $5440551.00. The claim
regarding the NPV is correct as in the developed model, the NPV has been calculated for the first
period that is 2018 and it is essential for decision making. The initial investment needed is
$1,750,000 and the claim that has been made for the new product line is over $2 million so from
the calculated NPV it has been found that the claim is correct.
Answer to Question 2
Monte Carlo Simulation Model
*Columns
*Years 2018,2021
*Rows
Initial investment needed(0) = UNI(100000.00,200000.00) '.2
Market at time (0)= 420000
Market Growth = 0.15'.2
Market Share = TRI(0.05,0.10,0.15)'.2
Total market = Market at time;Total market(-1)*1.15
Sales Volume = Total Market*Market Share
Estimated selling price = 55.00 '.2
Cost of production = NOR(30.00,12.00) '.2
Total Revenue = Sales Volume*Estimated selling Price '.2
Cost of Goods sold = Sales Volume*Cost of Production
Annual overhead cost = TRI(150000,215000,350000)
Cash Flow = Total Revenue-Cost of goods sold-Annual Overhead cost
Rate = 0.12'.2
NPV(0) = *NPV cash flow;rate