Business Intelligence and Data Warehousing for Earth's Environment Issues

This report focuses on the problems our planet is facing in respect to our environment. Descriptive and prescriptive analysis are conducted using a dashboard. A mobile application is developed as a solution. The best solution for global warming is to decrease energy consumption.

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

Executive Summary
Our focus in this project will be problems our Planet, Earth is facing in respect to our
Environment. The descriptive and prescriptive analysis are conducted. The business
Intelligence device known as dashboard is used throughout this report analysis. A
dashboard is developed, with all its functioning details. All the objectives are met, which
revolves around the protection to the environment. A best possible solution is shared
with justification. The dashboard analyses the real time data. A mobile application is
developed as a solution. The best solution for global warming is to decrease the energy
consumption.

Table of Contents
1. Introduction...................................................................................................................................................... 1
2. Project Objectives............................................................................................................................................ 2
3. Problem Statement.......................................................................................................................................... 2
4. Earth’s Environment related Issues...............................................................................................................2
5. Impact of Carbon dioxide on the Earth’s Environment................................................................................3
6. BI Reporting Solution with Analytics.............................................................................................................6
6.1 Descriptive Analysis........................................................................................................................................ 6
Dashboard.............................................................................................................................................................. 7
6.2 Prescriptive Analysis..................................................................................................................................... 10
Dashboard............................................................................................................................................................ 10
6.3 Dashboard’s Prototype.................................................................................................................................. 11
7. Design Mobile Application............................................................................................................................ 13
8. BI Reporting Solution’s Justification to decline the Environmental issues in Organizations................15
9. Conclusion...................................................................................................................................................... 17
References................................................................................................................................................................... 18

1. Introduction
For many years now, we have understood the impact of Carbon Dioxide (CO 2)
has had on the natural greenhouse warming of earth’s atmosphere, as the more amount
of CO2 in the atmosphere will lead to more global warming. The greenhouse effect
mainly harms the temperature of the planet i.e., the Earth is continuously under the
sun’s radiation, which warms it up and produces all the energy which drives the climate
system, and results in greenhouse effect ("The Carbon Dioxide Greenhouse Effect",
2019). It can be considered as a controversial topic to be discussed (Zhong & Haigh,
2013). The greenhouse gases includes, Nitrous oxide, CO2, methane, and other
greenhouse gases like sulfur hexafluoride, hydrofluorocarbons, and water vapor
("Methane, Carbon Dioxide, Nitrous Oxide and the Greenhouse Effect", 2019). With the
help of a Dashboard, we shall study the current environmental problems faced by us.
The report ensures to understand the environmental issues which are a big threat to the
earth. A set of analysis namely Descriptive and Prescriptive analysis are considered to
help the study of this work.
It is essential for all the human to know the threats for earth, which could cause
environmental change, water scarcity, substance transmission, depletion of ozone,
pollution, and much more. Research has already shown that there won’t be any
saturation in the radiation absorption, if the amount of Carbon Dioxide gas keeps on
increasing in the Earth's atmosphere. Hence, in the future there are high chances to
warm the climate (Zhong & Haigh, 2013).
Therefore, effective measures must be taken to overcome these environmental
issues. The issues must be identified and declined to save the earth.
1

2. Project Objectives
The main objectives of this report are listed below:
1) To understand how the extreme high usage of carbon dioxide can result in
environmental distortion.
2) To find the solution for wastage of energy.
3) To conduct descriptive and prescriptive analysis.
4) To develop a logical tool for making creative analysis with insightful
models, to analyse the environmental issues.
5) To develop a predictive analytical application.
6) To use the dashboard for viewing the significant execution markers.
3. Problem Statement
The problem encountered in this project is the unrecognized environmental
issues. Then, the fact that the release of CO2 is rising which is harming the earth’s
environment. Relatively, it gives rise to various environmental issues. Hence, for
safeguarding the earth’s environmental is essential for people of all levels, including the
government. Henceforth, this study intends to resolve the encountered problems with
the help of business Intelligence device.
4. Earth’s Environment related Issues
It is a known fact that the global warming is increasing drastically, and the current
earth’s environment is in high risk of danger. In any case, global warming isn't the
2

principle environmental issue that must be talked about in this research analysis. Every
year, all the comprehensive networks over the globe test the environmental issues,
where energy consumption is one of the major issues. A portion of the issues are little
which could barely affect the environmental structure, then again, there are not many
environmental issues which verifiably change the earth. At present, the planet Earth is in
a condition where it could confront different common calamities and has a threat to
human life that exists on it. The present environmental issues interface the
vulnerabilities as disastrous. In case these impacts are neglect then there won’t be any
life on earth. There is an instant need to remove all the existing environmental issues. In
the event that the earth isn't given consideration, at that point the fate of the earth can't
be seen, as the environmental issues are grievous which will crush the earth and its
reality.
Moreover, for the ozone layer, it is difficult for us to cease the harm caused to it,
yet at the same time, there are unmistakable advances which could be considered like
expanding the consideration in the territories and all the human families in the societies
will have some duty towards the earth. At the same time, if all the people join hands
together, then it is conceivable to change this activity into a noteworthy party. And, it can
be executed broadly, which can give a sheltered spot to live for all the living beings.
5. Impact of Carbon dioxide on the Earth’s Environment
Emission of the Greenhouse Gases is the reason for the Global warming. Mainly
due to the release of Carbon dioxide, as this particular gas remains in the earth’s
atmosphere for nearly hundred to two hundred years. Thus, the concentration of the
3

CO2 gas keeps on increasing in the atmosphere, which relatively increases the earth’s
average temperature ("CO2 - the major cause of global warming", 2006).
The effect of Carbon dioxide is entangled particularly with business, society, and
environmental systems. Thus, the respective country’s government guarantee to ease
the challenges. By now, the organizations have worked on discharging the carbon
dioxide into the climate, in any case, if it is coherently discovered then this can add to
an enormous sum, including the people and organization. Along these lines, the
organizations who keep on rehearsing such practices will be gravely debilitated as
opposed to the organizations that are chipping away at diminishing the threats and
discovers an answer for the issue (Living, 2018).
To mitigate the main cause of global warming i.e., carbon dioxide emissions the
best solution is reducing the energy consumption ("CO2 - the major cause of global
warming", 2006).
The top administration has to consider the organization's chain for getting clarity
4

for the previous and current effects. Any improvement in the regard to the organizational
chain like inbound coordination, outbound coordination's, assignments and marketing
are different offering advantages which can also do the releases. A higher level of
potential atmosphere impacts is possible in the event that the required degree of
advantages for the upheaval in the regarded organizational chain could lead to a higher
extent of potential atmosphere impact. In case of a new heading expenses $10 for
every ton on discharges, at that point will that be a basic start in the favorable
circumstances or even swallow them totally? "Carbon presentation" increments with the
carbon cost's effect on the advantages. Like the particular threats, the carbon dioxide
gas presence passes on open doors and furthermore challenges the Forestry
relationship, for example, planting progressively a number of trees to dispose of carbon
dioxide from the earth’s air. Passing off paper or packed wood shall be beneficial rather
than slicing them down. For the organizational chain, the CO2 releases have always
affected their activities. The carbon releases could be made by growing speedy control
by the organization or it could be supported by the provider firms, channels, and clients.
It is fundamental for any organization to comprehend the surge it makes its business
partners express, and the one it makes itself, i.e., makes vital focuses for its fall.
Potentially unique outcomes are due to these progressing back to front effects.
For example, In today’s world with just progressively indulgent releases, presenting
daytime organization supply chains, along with their transportation-concentrated, barely
in time stock organization structures, may never again remain flawless. There might be
conflict of interests with the trusted ones as, in the electronic business, with the
duplication of its little shipments. Additionally, the habitually off-shoring that builds the
5

carbon releases by augmenting the transportation may be uprooted with the decline of
floods on-shoring to draw near to gather the providers. Various systems can be taken to
diminish the typical effects of energy consumption, for example,
a) The transforming into sources such as solar energy.
b) Saving the energy consumption.
The solar energy indicates the energy's supportability, its capability, viability
alongside the power and heat it releases. The below points must be considered while
scanning for perfect energy:
1) It adds to diminish the measure of air contamination.
2) The use of energy is diminished and thus it brings about decreasing the power
bills.
3) It redesigns the structure of energy to have security and quality.
4) It helps to diminish the ozone-depletion substances.
5) The Solar energy can improve the state or it's neighbour's money related
problems by the expansion in the number of work places.
Based on the above mentioned points, it is possible to determine a solution to decrease
the energy consumption. However, the understanding of energy and environmental
issues is depicted in the above paragraphs.
6. BI Reporting Solution with Analytics
6.1 Descriptive Analysis
It refers to a procedure that sees the experiences which previously occurred.
6

Assisting in effectively interpreting the information, this type of investigation indicates
the descriptive analysis, which also clears up the harsh information. Clarity is another
positive outcome of this methodology. For separating over a larger scope of time which
finishes the result of the investigation and also analyses this information without much
required assistance. Passed away as past, like "A year”, this analysis identifies the "A
minute" time. This kind of analysis consists of assorted purposes that assist the clients
to gain proficiency with the crucial components when separated along with the past
conduct. The result and its effects on the future outcomes will largely depend upon the
successful identification of the illumination behind the lead. ("Descriptive, Predictive,
and Prescriptive Analytics Explained", 2018).
Tableau Dashboard
The following points help to understand the features of a dashboard:
i. In the depicted figure, the bar outline indicates important data to be
evaluated.
ii. The dashboard shows the necessary place, where on a dashboards screen
the details like the country, name of the place, its type, zone of the
particular region and its address can be viewed easily.
iii. The square feet unit is used for the location.
iv. In a dashboard only the real-time data are extracted via, internet.
v. Then, it is so benefiting that it also has the capacity of presenting the
selected place’s climatic condition.
vi. The data collected in the dashboard can be filtered easily.
vii. The data is filtered based on the data, country, state, and city.
7

viii. In a dashboard, it is possible to view the calendar at any required time.
ix. The dashboard is helpful in presenting the used energy.
x. It displays the benchmarks, energy usage of both the previous and the
present months, along with the place’s temperature.
xi. The required data or information can be shared with the desired devices.
xii. It can select any required key markers.
xiii. The energy consumption is presented with Kilowatt hour (Kwh) unit.
The figure which is exhibited in the above paragraph displays the dashboard's
examination on consumption of energy by the USA, for a specific building called, "Zion
Dado Building." It was able to achieve 2, 812, 5675 as seen on the dashboard, when
compared to the benchmark figure of 35.600.
. For the previous month’s energy usage we have the following,
Between 7AM ~ 8AM Between 6PM ~ 10PM
8

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
The earlier month's energy consumption was noted as 7.45% during the time
period 7 am to 8 am and between the time from 6 am to 10 pm the consumption of
energy is noted as 20.12%. While the present data during the time 7am to 8am displays
8.25% and during the time 6 am to 10 pm it demonstrates 100%. The monthly normal
temperature is displayed as 59.89 0F.
6.2 Prescriptive Analysis
The results are rebuilt and also reconstructed by the use of Prescriptive Analytics.
This type of analysis observes the essential answers to be executed. By the aid of this
investigation, the potential exercises are identified. The corrected arrangements are
prompted when the predefined cures fill up the course. This shows how reasonable and
viable the benefit of this analysis is. It moreover assists with general initiative. In any
case that it can't anticipate what's to come is, it picks why it occurred and likewise
endorses a couple of productive proposition, which could settle the experienced issues
("Descriptive, Predictive, and Prescriptive Analytics Explained", 2018).
Dashboard
Showing the future execution data, the Business Intelligence Dashboard modifies
the normal and regular reports for more in-depth understanding. The Business
9

Intelligence dashboard separates the use of observing the execution system declared.
Since it has the limit of following a great deal of information like the organizing structure,
it checks the reliability of the used strategy to pass on the reply. Also to prepare the
controls there has to be an occasion.
Figure: Industries’ energy consumption
The figure which is exhibited in the above paragraph is the prepared dashboard.
$47.97B is the all out game plans while 48.00B KWh is the entire usage. The dashboard
screen will show courses of action as per the division. As we can see from the
Dashboard, we can settle the normal length of electricity and the quantity of power cuts.
The yearly results of January 2016 to December 2016 are envisioned. On the
dashboard, the pie chart represents the share of Energy resources for different types
like, Coal, Nuclear Energy, Gas and Natural Energy. The zones can be considered as it
10

makes private division, improvement and trade advantage.
6.3 Dashboard’s Prototype
The exhibited design model indicates a dashboard, which is utilized for building
up the reactions of the environmental issues. It successfully addresses the graphical
structure by utilizing the correct tools and devices. A dashboard is utilized to oversee
and comprehend the collected information. Displaying the executions, isolating the
general executions of a particular procedures within any organization in addition with
the tracking procedure, are the most important features in making use of the Information
Dashboard. It is conceivable to see the routine executions depending on week, month,
quarterly based and as yearly based. The dashboard comprises of key execution
markers. Each pointer identifies the key necessities of the organization.
The following points help to understand the features of a dashboard:
a) In the depicted figure, the bar outline indicates important data to be
evaluated.
b) The dashboard shows the necessary place, where on a dashboards
screen the details like the country, name of the place, its type, zone of
the particular region and its address can be viewed easily.
c) The square feet unit is used for the location.
d) In a dashboard only the real-time data are extracted via, internet.
e) Then, it is so benefiting that it also has the capacity of presenting the
selected place’s climatic condition.
f) The data collected in the dashboard can be filtered easily.
11

g) The data is filtered based on the data, country, state, and city.
h) In a dashboard, it is possible to view the calendar at any required time.
i) The dashboard is helpful in presenting the used energy.
j) It displays the benchmarks, energy usage of both the previous and the
present months, along with the place’s temperature.
k) The required data or information can be shared with the desired devices.
l) It can select any required key markers.
m) The energy consumption is presented with Kilowatt hour (Kwh) unit.
7. Design Mobile Application
To address the environmental issues, Mobile application designed is shown in
the below figure.
12

13

With the use of QR code, the above Predictive analytics application is developed.
The QR code is attached below.
14

8. BI Reporting Solution’s Justification to decline the Environmental
issues in Organizations
For the removal of Environmental issues, we shall discuss about and give
justification to this concept. It also suggests necessary recommendations.
The below listed points help in improving the execution of environmental issues:
i. Make efficient use of energy.
ii. Check the estimations like the energy viability of a used machine in the
workplaces.
iii. Make use of standardised steps to decline the Carbon dioxide’s total
release from different organizations and other production centers.
15

iv. Maximize the care related to the energy wastage effects and resultant
impact on the planet Earth.
In order to meet the already mentioned actions, the BI functions like a data
mining strategy. Here, the data is collected and the basic advancements could be
performed. In the dashboard, the data is understood and portrayed to take right
decisions. Thus, the decisions made clears all the confusions. The business can be
improved by offering support to the dashboard. Relatively, dashboard supports to
streamline the important administration processes. For checking the execution and
application management, dashboard certifications are utilized that are used by the
Business Intelligence.
A collaboration of important information between the scorecard and dashboard
takes place as and when required. Then, the important points will be outlined. The user
rehashes the endorsed techniques once it becomes clear the required needs and same
time these are recognized .Therefore, dashboards are beneficial in collecting important
data on the environmental impacts, to help resolve the issues will necessary measures.
It is possible to link a dashboard to several types of data, and it has the capacity of
blending the data from different sources for presenting its point. Additionally, it can set
some fundamental goals and perspectives for simplifying the research. It presents
graphical representation to help understand and it can do the necessary changes to
provide better outcomes.
All the above derived points help to realize the effective and advantage of using
the dashboard.
16

9. Conclusion
This study has understood the environment related issues faced by the planet
Earth. The set objectives are accomplished, for instance, the impacts of extreme high
carbon dioxide release on the environment are studied. The descriptive and prescriptive
analysis are used to study these impact. A dashboard is used to view the significant
execution markers. The harm to the environment is presented in this report along with a
thorough analysis, and the respective solution is a mobile application, which is
predictive analytical application developed to identify the environmental issues. It is
observed that the industries release large amount of heat-trapping greenhouse gases
into the atmosphere which is increasing the climatic impacts. And global warming
occurs due to the emission of greenhouse gases. Thus, the most effective solution is to
decrease the consumption of energy.
The unrecognized environmental issues are identified and the rise in carbon
dioxide is realized to degrade the earth’s environment. It is suggested that the
necessary environmental controls must be taken by the people, organization and
government. The dashboard provides a comparative which helps to see the data and
helps in making right decisions. Finally, a solution for decreasing the energy
consumption is found, by understanding the connection between the energy use and
environmental issues, for improving the earth’s environmental conditions. The
dashboard has the capacity of viewing the data clearly.
17

References
Carbon Dioxide, Methane, Nitrous Oxide, and the Greenhouse Effect. (2019). Retrieved
from http://climatechange.lta.org/get-started/learn/co2-methane-greenhouse-effect/
CO2 - the major cause of global warming. (2006). Retrieved from
https://timeforchange.org/CO2-cause-of-global-warming
Descriptive, Predictive, and Prescriptive Analytics Explained. (2018). Retrieved from
https://halobi.com/blog/descriptive-predictive-and-prescriptive-analytics-explained/
Living, S. (2018). Reducing environmental impact. Retrieved from
https://www.unilever.com/sustainable-living/reducing-environmental-impact/
The Carbon Dioxide Greenhouse Effect. (2019). Retrieved from
https://history.aip.org/climate/co2.htm
Zhong, W., & Haigh, J. (2013). The greenhouse effect and carbon
dioxide. Weather, 68(4), 100-105. doi: 10.1002/wea.2072
18