University *** Semester.

University
*** Semester
Business Intelligence and Data
Warehousing
Student Name:
Register Number:
Submission Date:

Executive Summary
Utilizing the business Intelligence device like dashboard, we shall in this Report present the
issues related to our environment. This report presents Descriptive and Prescriptive analysis. The
dashboard is developed and explained in this report. A business analysis is carried out to produce
creative analytical point to solve the carbon dioxide and energy issue. To support the
environment this report determines effective solutions, by clearly analyzing the real time details
from the dashboard. It even helps in recognizing the primary execution markers.

Table of Contents
1. Introduction...................................................................................................................................................... 1
2. Problem Statement.......................................................................................................................................... 2
3. Environmental Issues...................................................................................................................................... 2
4. Effect of Carbon dioxide’s Use on the Environment....................................................................................3
5. BI Reporting Solution with Analytics.............................................................................................................6
5.1 Prescriptive Analysis....................................................................................................................................... 6
Dashboard.............................................................................................................................................................. 6
5.2 Descriptive Analysis........................................................................................................................................ 7
Dashboard.............................................................................................................................................................. 8
5.3 Dashboard’s Prototype.................................................................................................................................. 10
6. Design Mobile Application............................................................................................................................. 11
7. Justification of BI Reporting Solution to deduct Environmental issues in the Organizations...............14
8. Conclusion...................................................................................................................................................... 16
References................................................................................................................................................................... 18

1. Introduction
In earth’s atmosphere, the increased amount of carbon dioxide increases the
chances of greenhouse effect where, the atmosphere traps the increased amount of
thermal energy, which causes the earth to turn warmer than it would be naturally. Thus,
results in global warming. The intention of this report is to present the environmental
issues by using a “Dashboard”. This report encourages a couple of excellent
examinations such as Descriptive and Prescriptive examination. The examination of
business inspection generates creative investigation plans. Utilizing the function of SAP
Business Object and the uniqueness of Predictive Analytics application, this research
paper advises the students to make use of these and to deliver the same with their
potential for the degree progress. The reason behind this is to exactly identify and
investigate the environmental issues by making use of the above mentioned favorable
reply and acknowledgment for their well-judged models. For these study and analysis
for investigating the environmental issues this report will make use of Dashboard.
On the other hand, this report takes actions to develop a logical tool to make
creative examinations and insightful models for the environmental issues. This report
stresses the energy use as an issue. In general, various environmental issues occur
such as water scarcity, environmental change, depletion of ozone, substance
transmission, pollution, energy use etc.
In current scenario, our main concern and the important problems pertaining to
our environment are,
 Climate Change
 Pollution
 Loss of biodiversity
1

 , Dangerous air deviation
 , Deforestation
 , Waste disposal
 , Overpopulation
 , General restorative issues
 ,Environmental resource depletion
 , Ozone layer depletion
 , Acid rain
 , Ocean acidification
 , Water contamination etc.
We have to understand how grave the above issues are and how drastically it is
affecting our planet and the toll it is taking on our Environment. There has been a
marked change in the periods of Warming and Cooling cycles which has added up to
the clearly distinguishing climatic alteration. This makes it more important for us, as
Human beings to understand the outcome of all these affects and the influences that
our Planet is facing with increasing intensity and leading to a path of certain and
imminent catastrophic events.
One major factor where lot of research is currently going on is the marked
change in the environment due to the high use of carbon dioxide. In our Report, we
shall make use of the Dashboard for explaining this issue by presenting it in a very
descriptive and prescriptive manner with, the vital execution markers as part of the
Dashboard’s features.
2. Problem Statement
The main issue of this report is the unrecognized environmental issues. The
carbon dioxide increases the problem of degrading our environment. Environmental
2

issues occur due to the harmful effects of human actions on the biophysical
environment. Thus, to benefit both the humans and the environment, environmental
protection is required by people, organizational or governmental levels to protect the
environment. Thus, we have shed light on the effects on environmental pollution by the
excess use of carbon dioxide. The link between the energy use and environmental
issues should be addressed to improve the current conditions of the planet earth.
However, it is complicated to find the cause of degradation, so the Dashboard is
suggested to clearly view the data ("3 Biggest Ways to Reduce Your Environmental
Impact", 2018).
3. Environmental Issues
As the Global warming is increasing, the present environment is in threat.
However, global warming is not the main environmental issue that must be discussed.
Each year, all the inclusive communities across the globe test the environmental issues,
where energy usage is one of the issues. We have to make people aware that there are
problems which are causing the degradation of our Environment, whether these
problems are small whose effect is negligible or some of the issues which have a higher
and far greater impact on the environment. But in the overall picture, Earth is taking a
toll, particularly the drastic changes to our environment and how this is resulting in the
development of natural catastrophes. Disasters and thus suffering/ destructions are the
outcomes of the current environmental problems. If we fail to be careless about these
issues then it can be disastrous for the Earth. There is an immediate need to work on
the current environmental issues. If the earth is not given attention then the future of the
3

earth cannot be seen, as the environmental issues are disastrous which will destroy the
earth and its existence. Our responsibility and our commitment towards our
Environment should start from every Individual and the family. This will not cease the
damages caused but will definitely help in reducing the ozone layer effects. Care and
precautions in our actions will go a long way to reduce the ill effects on the Environment
("Business Intelligence Dashboard", 2018). All of us together if we resolve and make a
decision of taking positive steps for the betterment of the Environment and its
preservation can definitely lead to a much better, safer and friendly Planet.
4. Effect of Carbon dioxide’s Use on the Environment
The impact of Carbondioxide is complicated especially on the business, society,
and environmental frameworks; so the governments ensure to bring ease. Till date the
organizations have contributed to release carbon dioxide into the atmosphere, however,
it will be logically found that this can contribute to large amount, both the organization
and the public. Therefore, the organizations who continue to practice such practices will
be gravely weakened in contrast to the organizations that are working on decreasing the
dangers and find a solution for a problem (Living, 2018).
4

The organization's regard chain and the factors that affect it like inbound
coordination, outbound coordination's, assignments, marketing, various offer benefits
etc helps the Top management to analyse the back to front impacts and thus make its
releases. A larger proportion of the potential climate influence could be the result of the
fundamental extent of all the benefits to mean the outburst in the regard chain. Will it be
an essential start in the advantages or even swallow these unmitigated, if for each of
the new case and the new heading cost will be $10 for each ton on release? The carbon
cost’s impact on the benefits is directly dependent on the “Carbon presentation"
Examples like, planting more number of trees to discard carbon dioxide from the air will
challenge the Forestry organizations for the reduction of the threats to the environment
and for the carbon presentation passes on open entryways. By utilizing the compressed
wood and conveying paper we can still be profitable. Both by distortion or by
encouragement, these releases could impact the activities of the regard chain and these
releases can be encouraged by the channels, customers and by the supplier firms, in
5

addition to the ones made by developing the quick control by the organization.
The rush that is made by the business partners should be understood by all the involved
organizations and by the organization itself, for example, for the decline creating
indispensable concentrations. This will possibly have an effect on the dynamic
implications from the advancing back to front impacts. Like for example, the
transportation-concentrated daytime supply chains, which are below the wire stock
organization structures, can never be perfect again in a world which constitutes more of
the extravagant releases. And comparing this example with the Electronic industry we
can observe that there will be a negative impact to the trusted goodness limits if there is
a duplication of its little shipments. Similarly, increases in the releases by maximizing
the transportation due to the frequent offshoring can displace the cut down surges on
shoring so that it can get nearer to the collecting of the suppliers. Different procedures
can be accessed to decrease the normal impacts of energy use such as:
1) Transform into sources like the solar energy.
2) Save the consumption of energy.
The solar energy refers to the energy’s sustainability, its proficiency, effectiveness along
with the power and heat it releases. The following must be considered while searching
an ideal energy:
 It contributes to decrease the amount of air pollution.
 Energy consumption is decreased and this in turn results in shrinking the
electricity bills.
 It helps in decreasing the ozone depleting substance.
6

 The solar energy could improve the state or its neighbour’s financial condition
with the increase in the number of work openings.
 It upgrades the framework of energy to have security and quality.
5. BI Reporting Solution with Analytics
5.1 Prescriptive Analysis
For the successful outcomes, prescriptive Analytics is using Restructuring and
Rebuilding. Such an analysis or examination helps to find the necessary solutions to be
implemented. The possible activities are perceived by with the help of this analysis.
With sensible and effective benefits for this examination, the right plan is prompted by
the specified remedies in filling up as the course. It additionally helps with general
leadership. Regardless that it cannot predict what the future is, it chooses why it took
place and similarly prescribes few profitable proposals, which could settle the
encountered issue.
Dashboard
With a unique presentation and display, all the traditional reports about the
business data can be uniquely presented and displayed for further analysis and
execution values, by making use of the Business Intelligence dashboard. The BI
dashboard itemizing utilizes the discerning execution declaring system. Because, it has
the capacity of tracking a lot of information like the itemizing structure verifies the
dependability of a procedure to convey the reaction. But, there should be an event to
get the controls ready.
7

Figure: Sector’s Consumption
The total arrangement is $47.97B and the total usage is 48.00B KWh as same is
represented in the above developed dashboard. This also gives us the picture of the
ordinary length of power cuts and the number of times of force cuts. The results for the
annual period have been imagined accordingly (i.e. from January 2016 to December
2016). The Pie Chart also represents the imperativeness sources, i.e., dull caught coal,
nuclear essentialness, the proportion of practical power source, and gas The above
Dashboard overall helps in making private division, market advantage and
development.
5.2 Descriptive Analysis
It refers to a technique that views the encounters which already took place. This clears
up the rough data and assists with easy translation of the data as, this analysis reflects
8

the estimation analysis. It also clears the understanding and gives a clearer picture by
this approach. Evaluating this data assists the sensible data to study a wider range of
time which completes the analysis’s results. ("Descriptive, Predictive, and Prescriptive
Analytics Explained", 2018). Same like a “Year”, this testing specifies "A minute" as time
which is passed as past. To understand and learn about the fundamental elements
when differentiated along with the past behavior, assists the customer’s when the above
type of tests contain diverse purposes. With the effect on the future, the above study
essentially helps to acknowledge and same time clarify what is behind the lead.
("Designing and Building Great Dashboards - 6 Golden Rules to Successful Dashboard
Design | Geckoboard", 2018).
Dashboard
The dashboard is explained as follows:
 From the presented dashboard figure, the bar outline refers to the data.
 The dashboard’s calendar can be accessed anytime.
 The dashboard provides real time details, with the help of internet.
 The required location can be observed successfully, which displays the name,
country, type, zone's region and address (in terms of square feet unit.)
 The location’s climate can be found with the help of a dashboard.
 The accessibility for the option of filtering the data.
 Depending on the country, state, city and date, the data filtration is carried
out.
 The dashboard addresses the utilized energy.
9

 It shows the benchmarks, current and previous month's energy usage,
including temperature.
 Kilowatt hour (Kwh) unit is used to represent the consumption of energy.
 Any key markers can be selected.
 The necessary information is shared to the specific devices.
10

11

We shall consider a building called “"Zion Dado Building” in the USA, as displayed
above in the Dashboard’s examination and study the energy consumption and its
usage. It has been able to achieve 2, 812, 5675 when the benchmark was only 35.600
in the dashboard. For the previous month’s energy usage we have the following data
("Causes and Effects of Environmental Pollution", 2018),
Between 7AM ~ 8AM Between 6PM ~ 10PM
7.45% (Previous month) 20.12% (Previous month)
8.25% (Present value) 100% (Present value)
59.89 0 Fahrenheit is shown as the normal monthly temperature ("Getting Started:
Introduction to the Business Intelligence Center", 2018).
5.3 Dashboard’s Prototype
The presented design model represents a dashboard, which is used for
developing the responses of the environmental issues. It effectively addresses the
graphical structure using the right device. This device is used to manage and
understand the data. The important usages of a Dashboard are,
1. To display the executions
2. Separate the general execution of the specific methodology for any
organization
3. Tracking of the executions in the organization.
4. Possible to have a look at the daily executions in different time periods like
week wise, month wise, quarterly or based on each year.
12

The dashboard contains key execution markers. All these pointers relates to the
organization’s key necessities. The dashboard is explained as follows ("Ten key
elements for effective dashboard design", 2018):
 From the presented dashboard figure, the bar outline refers to the data.
 The dashboard’s calendar can be accessed anytime.
 The dashboard provides real time details, with the help of internet.
 The required location can be observed successfully, which displays the name,
country, type, zone's region and address (in terms of square feet unit.)
 The location’s climate can be found with the help of a dashboard.
 Accessibility for the option of filtering of the data.
 Depending on the country, state, city and date, the data is filtered.
 The dashboard addresses the utilized energy.
 It shows the benchmarks, current and previous month's energy usage,
including temperature.
 Kilowatt hour (Kwh) unit is used to represent the consumption of energy.
 Any key markers can be selected.
 The necessary information is shared to the specific devices.
6. Design Mobile Application
The problems related to the Environment are shown in the below figure with the
use of a Mobile application. By using the “QR Code”, an application called “Predictive
Analytics” has been developed.
13

14

In the section down below, the QR code has been attached ("The National Academies
presents: What You Need to Know About Energy", 2018).
15

7. Justification of BI Reporting Solution to deduct Environmental
issues in the Organizations
This section discusses the conceivable response to decrease the environmental
issues with few recommendations. The following procedure will improve the
environmental issues’ execution:
 Taking authentic efforts for decreasing the total release of CO2 from various
organizations and generation lines.
 Efficiently utilize the energy.
 Using the Carbon dioxide holding plants and devices.
16

 Taking estimates such as checking the used machine’s energy viability in the
offices.
 The impact on our planet and at the same time the result of Energy Wastage
has to be made aware to the experts. ("The Roles of Dashboards and
Scorecards - Social Solutions", 2018).
Fundamental advances can be carried out on the data extracted from the
business Intelligence that works as a data mining strategy and which also has to fulfill
the specified courses of actions. By using the Dashboard, the data can be best
understood through the data portrayal and thus the plan is the best solution for this. For
improving the business we have to assist the Dashboard, by grasping the
data/information and making decisions by discarding the multifaceted nature. The vital
administration procedures can be streamlined by this. The BI probes the application
management and its execution by utilizing the dashboard certifications. To remove from
the other individuals who tend to lose, is important and good intention. Where the Data
course is given, the dashboard displays its effectives in perspective of its assessing the
impacts. The Transtheoretical Model can be modified as and when required, by
changing the ETO execution administration programming of the Dashboard, as per the
change for the required organizations, and for the periods of advancement.
As a requirement for being disapproved of consistently, this dashboard offers
persistent screen of the program parts. Readouts on the Dashboard fulfil the need of
keeping a scorecard for viewing single or multiple data parts of the data pool.
17

Between the people, organizations and the times, these are used for viably
taking a look at the quantifiable among them. Thus, there is a mutual collaboration
between the Dashboard and the Scorecard for displaying the information as and when
required. The vast amount of data and information can be trimmed by using the
segment of the dashboard and only the important data can be highlighted. The
Dashboard and the Scorecard data consolidates when it is needed that the learning
mechanical assemblies support in perceiving what is occurring and where the
advantages must be occupied. To make a positive impact on the users, this offers
benefits that enable the customers to effectively serve the individuals. The endorsed
techniques are recognized and rehashed. Benefitting the WIA itemizing and raising help
activities, these Dashboards are having far better profitability and even contributing in
building an exceedingly total gathering of impact acknowledgement ("Types of Analytics:
descriptive, predictive, prescriptive analytics", 2018). To show a specific point of view,
this dashboard could be interlinked and blend different types of data, choose the basic
perspectives and display the goals very easily.
A pool of people can be accompanied into a group where this dashboard can share
its information and data thus benefiting every one of them. What helps is that the
Dashboard displays all the information is a graphical form making it much easier for the
user to understand and grasp the message that it wants to convey. Examples and
information is taken directly from the individuals and the same is incorporated in the
system to finally show on the Dashboard. This can be studied and checked by the
responsible individual for the absences and accomplishments, and modifications can be
undertaken to finally get a much better and effective result.
18

8. Conclusion
In the last few years, there has been research going on to evaluate, both the
prescriptive as well as the descriptive causes to our environment has, been taken up in
this research paper. This analysis is completed with the help of a dashboard. This report
determines unrecognized environmental issues and how the carbon dioxide increases
the problem of degrading our environment. The harm to the earth’s environment by
human actions is understood. The report absorbs the immediate need of environmental
protection, which can be provided by people, organizational or governmental levels. The
dashboard’s comparative study demonstrates the data to take sensible decision. Thus,
the objective is accomplished where it finds the reason that causes environmental
distortion due to high carbon dioxide usage, i.e., any type of intensity increase can
impact the circumstances like the air, land, and water. The analytics tools are used in
this study to collect the data. The business Intelligence model developed, where its
resistance is displayed. The dashboard observes the essential execution markers. It
explains the steps to decrease the usage of carbon dioxide. How the impacts shift from
one to another is presented, including how carbon dioxide impacts the association
business technique.
19

References
3 Biggest Ways to Reduce Your Environmental Impact. (2018). Retrieved from
https://www.eomega.org/article/3-biggest-ways-to-reduce-your-environmental-
impact
Business Intelligence Dashboard. (2018). Retrieved from
https://www.klipfolio.com/resources/articles/what-is-business-intelligence-
dashboard
Descriptive, Predictive, and Prescriptive Analytics Explained. (2018). Retrieved from
https://halobi.com/blog/descriptive-predictive-and-prescriptive-analytics-explained/
Designing and Building Great Dashboards - 6 Golden Rules to Successful Dashboard
Design | Geckoboard. (2018). Retrieved from
https://www.geckoboard.com/blog/building-great-dashboards-6-golden-rules-to-
successful-dashboard-design/
Getting Started: Introduction to the Business Intelligence Center. (2018). Retrieved from
https://support.office.com/en-us/article/Getting-Started-Introduction-to-the-
Business-Intelligence-Center-2EA9253A-5B61-4065-B6E3-7A981BB8D90D
Living, S. (2018). Reducing environmental impact. Retrieved from
https://www.unilever.com/sustainable-living/reducing-environmental-impact/
Ten key elements for effective dashboard design. (2018). Retrieved from
https://searchbusinessanalytics.techtarget.com/tip/Ten-key-elements-for-effective-
dashboard-design
The National Academies presents: What You Need to Know About Energy. (2018).
Retrieved from http://needtoknow.nas.edu/energy/energy-costs/environmental/
20

The Roles of Dashboards and Scorecards - Social Solutions. (2018). Retrieved from
https://www.socialsolutions.com/blog/measuring-impact-effectiveness-roles-
dashboards-scorecards/
Types of Analytics: descriptive, predictive, prescriptive analytics. (2018). Retrieved from
https://www.dezyre.com/article/types-of-analytics-descriptive-predictive-
prescriptive-analytics/209
21