Data Warehousing and Business Intelligence for Environmental Issues

This report uses business intelligence tools to analyze environmental issues, focusing on carbon dioxide emissions and energy use. It presents both descriptive and prescriptive analyses, visualized through a dashboard. The report explores the impact of carbon dioxide on the environment, discussing strategies for reducing environmental impact through renewable energy sources and energy conservation. It also touches on the potential development of a mobile application for monitoring environmental data. The analysis aims to provide insights for organizations to address environmental concerns effectively. Desklib provides access to similar solved assignments and past papers for students.

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