Business Intelligence: Visual DSS, Power BI & Smart Products Impact

This assignment provides a comprehensive analysis of Business Intelligence (BI) using Visual DSS and Power BI, along with a case study on smart, connected products. The Visual DSS section includes NPV and Monte Carlo simulations to evaluate project proposals. The Power BI section demonstrates dashboard creation and data validation for business assumptions. The case study explores how smart, connected products contribute to business analytics and transform companies by leveraging BI, emphasizing the importance of data-driven decision-making and competitive advantage. The report concludes that BI and big data analytics are crucial for business success, enabling better reporting, analysis, planning, and customer satisfaction.

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

1BUSINESS INTELLIGENCE
Table of Contents
Part A – Visual DSS........................................................................................................................2
Question 1 Solution.....................................................................................................................2
Results analysis........................................................................................................................3
Question 2 Solution.....................................................................................................................3
Results analysis........................................................................................................................5
Question 3 Solution.....................................................................................................................6
Results analysis........................................................................................................................7
Part B – Power BI............................................................................................................................8
Solution for Demonstration 1......................................................................................................8
First dashboard.........................................................................................................................8
Second dashboard....................................................................................................................8
Answer to questions.................................................................................................................9
Solution for Demonstration 2......................................................................................................9
First dashboard.........................................................................................................................9
Second dashboard..................................................................................................................10
Answer to questions...............................................................................................................10
Part C – Case Study Analysis........................................................................................................11
Introduction................................................................................................................................11
Smart, connected products contribute to business analytics......................................................11
Smart, connected products help to transform companies by using business intelligence.........13
Conclusion.................................................................................................................................14
Bibliography..................................................................................................................................15

2BUSINESS INTELLIGENCE
Part A – Visual DSS
Question 1 Solution
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

3BUSINESS INTELLIGENCE
Model Output
Results analysis
The Net Present Value (NPV) has been estimated to be $5440551.00 based on the results
derived from the model. From the NPV value being determined in the model, it can be said that
the claim regarding NPV is correct as it has been calculated to be above $2 million.
Question 2 Solution
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

4BUSINESS INTELLIGENCE
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
Model Output

5BUSINESS INTELLIGENCE
Cumulative probabilities report
Results analysis
From the results, it can said that the senior management should accept the proposed
production of the product. The decision criteria has been taken into consideration to produce
cumulative probabilities report and graph in which it has been identified that at less than 20%
chance, the NPV is $3090358.00 which is obviously greater than $1,000,000.00. Hence, the
decision to accept the proposal is correct as determined from the results.
Question 3 Solution
Monte Carlo simulation Model

6BUSINESS INTELLIGENCE
*Columns
*Years 2018,2021
*Rows
Initial investment needed(0) = 1750000.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 = UNI(45.00,65.00) '.2
Cost of production = NOR(25.00,5.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

7BUSINESS INTELLIGENCE
Model Output
Results analysis
From the produced cumulative probabilities report and graph, it can be said that the CEO
will accept the proposal for production of product. The results depict that at less than 90%, the
NPV is $6619214.00 which means that there is 80% chance the net present value is greater than
$1,850,000. Hence, the decision of CEO to accept the proposal is correct and suitable.

8BUSINESS INTELLIGENCE
Part B – Power BI
Solution for Demonstration 1
First dashboard
Second dashboard

9BUSINESS INTELLIGENCE
Answer to questions
Sub-question_1
From the designed dashboard, it can be said that USA is the country that has the most
SalePrice (sum) of the DB9.
Sub-question_2
Power BI can be used to validate business assumptions in this demonstration with the
help of visualization tools. The data visualization offers functionality so that data can be
analyzed efficiently. In the particular demonstration to check which country has the most
SalePrice of DB9, the data is achieved with a single click only. Hence, Power BI is considered as
a powerful tool that can be used for making business assumptions.
Solution for Demonstration 2
First dashboard

10BUSINESS INTELLIGENCE
Second dashboard
Answer to questions
Sub-question_1
The below list is presented to illustrate the sectors that receive Research Fellowship
funding:
 Health care and social assistance
 Renewable energy
 Agriculture, forestry and fisheries
 Electricity, gas, water and waste services
 Great Barrier Reef
 Professional, scientific and technical services

11BUSINESS INTELLIGENCE
Sub-question_2
The major potential issue being faced while performing data validation based on fields is
output of wrong results. While making data validation, there may be blank data in the fields of
source data which eventually will give erroneous results. Another issue is with Data type as it
may not be retained while source data is imported in Power BI.
Part C – Case Study Analysis
Introduction
This report delineates the part played by various smart, connected products in the
business intelligence and furthermore their ease of use adequacy to drive any business towards
enormous business achievement. Because of incessant development of innovation and also items
in knowledge and associated gadgets in business applications the whole business field is getting
enhanced each day. The connection between the Business Intelligence (BI) and every single
connected product are likewise delineated in this report. With the highlights used by Business
Intelligence (BI) the business endeavors can continue enhancing their operational and practical
methodologies.
Smart, connected products contribute to business analytics
The new business abilities and enormous measure of data those are largely offered by the
smart connected products rethinks the center useful exercises of the organization. Both the cloud
based working framework and programming has turned out to be vital piece of the new items.
Joachimsthaler et al. (2015), has expressed that diverse new item creating standards are rising in
view of the assembling part and other oftentimes evolving forms. This as well as it has been
discovered that, with a specific end goal to secure the business capacities IT security is
considered as a critical part that must be kept up. So as to increase upper hands, the capacities