Data Warehouse and Business Analytics: Environmental Report ITECH7406

This report, developed for the ITECH7406 Business Intelligence and Data Warehousing course, presents an analysis of environmental issues using business intelligence (BI) and data warehousing techniques. The report focuses on developing BI solutions, particularly dashboards, to address environmental concerns such as CO2 emissions and climate change. It utilizes both descriptive and prescriptive analysis, incorporating SAP Business Objects and predictive analytics to identify trends, patterns, and potential solutions. The report includes a dashboard prototype and a discussion on designing a mobile application for environmental data access. Furthermore, it justifies the chosen BI reporting solution for addressing organizational environmental issues and concludes with key findings and recommendations. The analysis covers various environmental aspects, including energy consumption, pollution, and the impact of CO2 emissions. The student utilized various datasets to illustrate the approach and provide innovative analytics visualization solutions and predictive models.

Data Warehouse and
Business Analytics
Student Name:
Student ID:

Abstract
This report describes to develop utilizing the business intelligence insight gadget is
the isolates the ecological issues of the dashboard. This report is one of the
investigation it will be facilitates of the Descriptive and Prescriptive analysis. The
business analysis which produced the creative analysis of arrangements. To
understudies to talk their capacities of the essential that idea of extent progress of
the SAP Business Object or application of predictive analytics of the creativeness as
the sketching out of the valuable reactions is requires of the recognition the showing
the judicious models to the efficient issues. The natural issues of the related
assistance of the dashboard. Regarding confirmation of the descriptive and analysis
of prescriptive will be impecunious down in the reports using a dashboard. The
essential markers execution will be perceived.
1

Table of Contents
Introduction........................................................................................................................................3
Problem Statement...........................................................................................................................4
Environment and related Issues...................................................................................................5
Impact of CO2 Use on Environment.............................................................................................6
BI Reporting Solution with the support of Analytics...............................................................6
1.1 Descriptive Analysis........................................................................................................7
1.1.1 Dashboard..................................................................................................................7
1.1.2 SAP Analysis............................................................................................................10
1.2 Prescriptive Analysis.....................................................................................................11
1.2.1 Dashboard................................................................................................................11
1.2.2 SAP Analysis............................................................................................................13
1.3 Dash Board Prototype...................................................................................................14
Designing the Mobile Application...............................................................................................15
Justification of BI Reporting Solution to deduct the Organizational issues related to
Environment.....................................................................................................................................18
Conclusion.......................................................................................................................................20
References.......................................................................................................................................22
2

Introduction
It is a report which is developing utilizing the business intelligence insight of the
natural issues is isolates for the example in the dashboard. This imaginative
investigation which produces the business examination of the course of action. The
creativity for predictive analysis application or SAP Business Object , as it required
delineating the recognition beneficial of the essential idea of understudies to talk
their capacities for reaction of the judicious models to perceive exhibiting the
methodical issues. The ethical issues is compared examination is here with the
assistance of Dashboard. Moreover the informative instruments to solicitations of the
execution to make observation of creative inspection in games plan and issues of the
insightful model. The issue that is not kidding in this statement is energy usage. The
issues of ecological likewise, dimi Nish water and ozone exhausting fabric spread,
use of essentialness and the change of natural use, pollution ET caters. The natural
issues of the environmental likewise The use of the sully Biodiversity loss, a unsafe
deviation of barometrical issue, overpopulation, Environmental Resource Depletion,
change of climate, waste Disposal, Ozone Layer Depletion, Deforestation, Ocean
Acidification, Acid Rain, water defilement, and medicinal of general issues etc. Today
changing the earth and it can't be denied. The alternation in the earth of the wind up
to vital related issues. The environmental results of warming and distinctive climatic
changes are happening a cooling periods, which are the eventual outcomes of
debacles. The ecological dangers are required to people to know the planet is going
up against.
3

The high level energy use can cause of the ecological issues. The dashboard of
the affirmation, clear examination and the destitute down in this report of the
prescriptive examination. The essential execution markets will be perceived by the
using help of the dashboard.
Problem Statement
The CO2emission of the global warming is contributing the "greenhouse gases" and the used
for reference in which the "warming of the global potential" of other greenhouse gases. The
carbon dioxide which is used for impacts of normal environmental concentrations to the
human health. The greenhouse effect is should be increasing the extra carbon dioxide. The
atmosphere traps increased heat which causes Earth to become cooler when compared to its
natural coolness. There is increase in the global temperature which results in global warming.
The natural issues of the data it can emits the carbon contributes to change the climate for the
consequence of the human and can used for the environment by using the view of dashboard.
Carbon dioxide from the greenhouse gas produces the burning fossil fuels. This was used by
the emission of carbon is raise the temperature using the trapping solar energy in the
atmosphere. Natural processes produce relatively small amounts. The combustion of fossil
fuels releases is an effective proof which builds GHGs and it refers as a preliminary reason
for global warming which is seen in the past few decades. CO2 emission can be used. For the
emission of carbon dioxide, there exists both natural as well as human sources, where the
natural sources incorporates the respiration, sea discharge and decomposition. But, the human
resources originates from the actions such as deforestation, from generation of cement, and in
addition from the fossil fuels’ burning namely, the natural gas, oil and the coal. Sun’s energy
on the Earth is absorbing that use of redirecting energy back to the surface of Earth.
Greenhouse gases that trap the additional heat of the increasing in the amount of carbon
dioxide that create an overabundance of the environmental issues of by using the business
intelligence.
4

Environment and related Issues
The environmental issues that can defined the many different types of planets systems
(water, air, soil, etc) the mistreatment of the result is developed the human interference by
using the plant of the dashboard. The lots of environmental concerns that are facing the
addition of current mother Earthling in the dashboard’s environmental information that
provides the app implemented of a couple of other use cases as follows:
1) Environmental information reporting
2) Environmental experience (guide for electronic nature).
Reporting the information of environment sticks to a specific pattern to capture the
spontaneous observation of the dashboard. The issues of the environmental problems that are
likewise global warming, depletion of ozone layer, climate change, acid rain, water pollution,
air pollution acid rain, urban sprawl waste disposal etc. impacts each human as well as the
animals including the earth. The environmental problems are used to protect from the
endangered species and to protect the natural areas which are more valuable, genetically
modified the dashboard of global warming is used for imbalance, pollution, land pollution,
urban sprawling and deforestation of the effects of dangerous cause by overpopulation.. The
planet Earth of the natural disasters which affects the ecological framework of the community
once in multi day. The current natural issues is consideration, the planet is headed for a
fiasco. The inclusive community on this planet which are specific future, in light of the way
can used for the troublesome issues, using any and all means. The hard to physically damages
of the crucial point caused to the Ozone layer, the distinctive advanced which can be taken
5

for the instances of the families of little responsibility is growing the mindfulness in the area
system.
Impact of CO2 Use on Environment
Their characteristic effect of the mind boggling with especially affects the business, society,
and natural systems. Governments will plan to facilitate its advantages with wide heading.
The environmental impact of the combustion of carbon dioxide of the contributes emission
changes of the natural system. The affiliations have clearly conveyed of the carbon dioxide
which is used for the terrific cost, both money related with social environment The
consequence of the human and environment of decrease the dangers of the high ground in a
warming, is Distinctive procedures are accessible for decreasing the common impacts of the
used vitality. The recorded underneath the part of the system:
• To save the energy capably.
• The sources to the change of cleaner vitality
Clean energy refers to energy capability, economical source of power, viable power to join
the warmth of the environment. There are going of the idea of energy on the recollected
centre is seen as:
 The diminishing contributes of the air pollution.
 The substance is ads the decrease the ozone of draining releases.
 To reduce the power bills is the similarly of the vitality.
 The structure of the energy is used of the faithful aspect and safely.
 The clean energy of the money related state of change of the increasing opening for
the work.
6

BI Reporting Solution with the support of Analytics
1.1 Descriptive Analysis
The primary level for data processing which generates the historical data’s summary
for yielding beneficial information and that which prepares the data for the next analysis that
delivers the information about the incidents that occurred is known as descriptive analysis.
Where, it describes the feature of the basic data study of the dashboard. It provides simple
summaries related to the sample and measures. The graphics analysis refers to the basic
virtual quantitative analysis of the data. Dashboard refers to a simple but highly power
packed business intelligence tool. This tool can be utilized for displaying several major
performance indicators for the business organization so as to assist of the environmental
issues for comparing the indicator’s actual values along with the Forecasted benchmark
values that reflects the organization’s objectives and targets. However, it is used for
signalling whether particular numbers or trends are good or not, acceptable of the range of
time and the examination. The data sensible of the isolated over huge amount of time that
provides data investigation’s results of complete examination. The specific examination “a
single minute" that which is passed as past, is equivalent to "a single year". The customer
with learning the essential unpretentious components of the effectively acknowledge the
clarification behind the direct impact of the future.
1.1.1 Dashboard
The underneath specified illumination indicates to the dashboard:
• The data is accessible to the inspecting and the finishing of filtration in the date of
the light, state, country and city.
• The location area is scene, which exhibits of the type of name, address of the
country, and the regions doming.
7

• The energy usage is speaks to the dashboard.
• It clarifies of the benchmarks of the graph, earlier months and utilization of the
current months used of the current temperature.
• The available of the calendar in the dashboard.
• The territory of the status is the atmosphere is given.
• It energy utilization is spoken to as far as (Kwh)).
• The key markers could be picked.
• The atmosphere conditions are required to the dashboard.
• The dashboard is given by the uncovering of the Real time.
• It receives nonstop information related to the chose site, from the web program.
• Required imparted information for any gadget is flexible.
Example, flexible or work region.
8

The figure illustrated in the above section is using the dashboard of the energy used in
the USA, which is recognized as, Zion Dado Building. The dashboard denotes the
benchmarking as 35,600, which has accomplished 2, 812, 5675. The multi month back
9

energy usage is indicated as 7.45% between 7 to 8 am. However, the energy use indicated
20.12 percentage during 6 to 10 pm in the evenings. The existing characteristics from 7am to
8am displays 8.25 percentage and from 6pm to 10pm it reflects as 100 percentage. The
month-to-month typical temperature is displayed till 59.890 F.
1.1.2 SAP Analysis
Carbon dioxide emission of the estimates that amid 2012 to 2016 using by the SAP evolution.
The databank is using by the bits of knowledge of the outline is made up of the Excel records
assistance of SAP business Object. The estimation of the carbon dioxide amid of 2013, as
545 kilotons, amid 2016, it determined to 380 kilotons.
Generally, the knowledge bits illustrative investigation is used, for instance the basic
number juggling problems such as rate changes, midpoints, and so on. Such a methodology
of investigation is viable for a point which the data could be isolated similar to fragments and
could be summed up. Thusly, similar tally could be viably completed using, clarifying
examination. It also helps to show the total available stock in the stock, close by customer
purposes of intrigue like ordinary total spent on every last customer, dependent upon multi
10

month or one year. Arrangements as well as the advantage could be connected successfully.
Declaring game plan of obvious examination includes the chronicled bits of information
depending upon any affiliation's financials condition, their exercises, creation, arrangements,
stock and customers.
1.2 Prescriptive Analysis
Prescriptive analysis can be used for the business analysis that is finding the given
situation. The Prescriptive analysis that are used for depends upon the Descriptive analysis of
the branch of advance analysis in the used for the many techniques of statistics, data mining,
the machine learning and the artificial intelligence of the data will be analysis prediction of
the future. The dashboard of the most kind feature fall into one of the following paradigms:
Descriptive, Evaluative, exploratory or predictive. "A prescriptive strategy of the whole
objects of the main elements is developed the progress of strategy commence". Such as the
analysis of the outside environment and the resources usually starts with the environmental
by using the dashboard.
1.2.1 Dashboard
The business intelligence of the dashboard that used for the farsighted exaction
metric. The business information knowledge of the dashboard which has used for the
reporting execution system. The specified the structure of the dependability and the track of
information is conveying in the reaction. In the event that there must exist a single event for
receiving the ready control, then the insightful reaction would be provided.
11