Data Warehouse and BI: Environmental Issue Analysis Report

This report delves into the analysis of environmental issues using business intelligence (BI) and data warehousing techniques. It begins by outlining the environmental challenges faced by businesses, including climate change, pollution, waste management, and greenhouse gas emissions. The report then conducts a descriptive analysis of past environmental data, focusing on the year 2016, using BI visualization tools like dashboards to assess trends in weather, pollution, and electricity consumption. This analysis includes key performance indicators (KPIs) related to weather patterns, time dimensions, geographical locations, and pollution levels. Following the descriptive analysis, the report performs a prescriptive analysis of current environmental issues, looking at data from 2018, and explores predictive analytics solutions. Finally, the report proposes solutions for improving the environmental performance of business organizations, emphasizing the importance of data-driven decision-making, compliance with environmental regulations, and the implementation of total quality environmental management (TQEM) programs. The report highlights the need for continuous improvement and the use of data to identify opportunities for environmental enhancement.

Business Intelligence
and Data Warehouse

Table of Contents
1. Introduction......................................................................................................................................2
2. Analyzing the Problem of Given Case.......................................................................................2
3. Descriptive analysis.......................................................................................................................5
4. Prescriptive Analysis.....................................................................................................................7
5. Solution for Improving Environment in Business Organizations.......................................8
6. Conclusion.....................................................................................................................................11
References.............................................................................................................................................12
1

1. Introduction
This report analyzes the environmental issues by using business Intelligence
visualization tool such as Dashboard. We are going to conduct two different types of
analysis and they are Descriptive analysis and Prescriptive analysis. Descriptive
analysis will be done to analyze what was happened in past year related to
environmental issues and discussed with dashboard. Prescriptive analysis will be done
to analyze the statistical data of environmental issues that are at present. These
dashboards will be created by using given data set sources. After analyzing the issues
how to avoid these issues and the improvisation of business organization’s environment
will be discussed in detail.
2. Analyzing the Problem of Given Case
The given case is about environmental issues. Our planet is plagued by using
environmental issues that dissipate natural assets and strain livelihoods which are
exacerbated with the aid of negative business practices. If left unchecked,
environmental problems negatively affect each groups without delay, as in deliver chain
disruptions, and continuously, as in health problems that lead to lack of man-hours and
performance. Following are some common environmental issues that groups need to be
addressed to make sure sustainability and long-term financial viability (Șterbuleac &
Toma, 2018).
Climate change
Weather change is an international trouble with grave implications:
environmental, social, financial, political and for the distribution of products. It
represents one of the primary annoying situations going through humanity in our day. If
present developments hold, this century may well witness incredible weather alternate
and an unparalleled destruction of ecosystems, with critical effects for every person.
Pollution
In the world, the largest ecological issues refers to pollution, because of its
tendency to be a common side-effect of people’s life (Frank, 2012). The air
contamination can be considered as an after-effect of petroleum derivative ignition, and
in addition different gases and poisons discharged by businesses and manufacturing
2

plants ("Causes, Effects and Solutions to Environmental Pollution | Earth Eclipse",
2018).
Environmental issues in Business organization
The major issues related to environment influences the business’s incorporated
modern waste, economical improvement of crude materials along with air outflows and
water ("Environmental Issues That Affect Business", 2018). All the above mentioned
problems can have impact on the business. Because, the organization is liable to obey
the laws, for changing the gear and techniques as it helps in meeting forced gauges
that, is an expense for the organization. Various organizations comprises of strict
changes comprised of targeted goal for saving the earth and "make the right decision."
Such type of organizations have to pay for all the defensive and proactive natural
measures and endeavor for recovering costs based on purchaser positive attitude or
additional shopper base picked up from an ecologically inviting arrangement.
Waste
Organizations which fabricates the items eventually in the assembling procedure,
producing waste. The natural laws and great ecological citizenship disallows
unpredictable dumping of assembling results. Thus, the organizations should select how
to get rid of it easily. Various executable and reusable programs, offer what they jar of
the loss to different producers, who use it in their own assembling forms as crude
material. In any case, the effect could cost more for the business in terms of strategies,
working hours and caring for particular things to move the waste items from the office
and assembling procedure of business (Butnariu & Avasilcăi, 2013).
Raw Material Development
All producers utilize crude materials for assembling their products. While, these
crude materials are common, for instance, wood, laws and great natural citizenship
require that the business take measures to supplant what it employments. Christmas
tree branches are a prime case, as merchants purchase from producers who reap and
replant so as to keep from draining whole backwoods of normally happening pine trees.
Once more, the effect on business is taken a toll regarding higher crude materials costs,
3

which as a rule incorporate the provider's cost to "replant" or "restock" the regular crude
materials (Creighton, 2014).
Discharges
Assembling forms regularly create air and additionally water outflows, which
incorporate molecule or synthetic filled smoke, slag and particles and chemicals that
saturate ground water through run-off ("TOP 10 Causes Of Environmental Damage",
2018). Ecological insurance laws expect organizations to shield the earth from
presentation to these emanations. Healing procedure incorporate setting screens of
determined measures over smoke stacks, filtration of waste water and fixing of
maintenance lakes with mud and poly liners. New directions are actualized as often as
possible that require retrofitting of assembling offices with expanded securities, for
example, screens of even better checks and lake liners of more up to date and more
secure materials (www.dw.com, 2018). These measures are exorbitant to business and
influence organizations first by diminishing overall revenues.
Greenhouse Gas Emission
The emission of greenhouse gas has declined as 4% from 2005 to 2014. But in
the year of 2015, the control board has reduced the emission by 15%. If we not able to
assign any emission reduction goal, we could not achieve anything in future. The main
cause of pollution is consuming more electricity. It should be avoided so that we can
reduce the greenhouse gas emission in high electricity consumption areas. It has
4

decreased the emission by 17% from the year of 2005 to 2014. But in some areas, the
emissions are not reduced because, they are consuming high amount of electricity
("Types of Environmental Problems", 2018).
3. Descriptive analysis
Generally, the Descriptive analysis process uses the data mining and also data
aggregation technique to visualize the data at past and produce report about past result
(Yusof & Yusof, 2013). In this project, we have got the data source from global web
server and the descriptive analysis has carried out by analyzing the environmental
issues determined in the year of 2016 (Meiliana, 2015). Nitrogen is one of the excellent
individuals to developing crop yield (Heymann, Machado, Torri & Robinson, 2012).
Mixed with its relative low rate and immoderate capacity move back, farmers are willing
to over exercise nitrogen as an insurance coverage to make certain they maximize
yield. Due to the environmental issues, agriculture affects the most (Intelligence, 2011).
The key performance indicators of the analysis report is given below (Post &
Kagan, 2012).
1. Weather: How the weather is changed periodically? Is this normal and usual
weather change? The reason behind the abnormal or drastic change in climate?
How many days/week/month difference in weather changing?
2. Time: Time dimension is an important factor of climate change. It varied every
month and every day. The issue in environment can be analyzed of specific time
period.
3. Place: Weather will not be same for all places. It will be changed according to
the time period and temperature.
4. Pollution: Due to the environmental pollution such as over exhausting of
Carbon-di-oxide, Carbon monoxide, Nitric oxide, Sulphuric acids and so on.
These are poisonous to our environment. How much amount of these chemicals
exhausted from factories and which area causes high pollution?
Dashboard:
5

By using a business intelligence visualization tool, the above mentioned
dashboard is created. The dashboard is outlined below.
1. The key indicators are weather condition, place (site), time, pollution rate and the
pollution occurrence rate in electricity consumption. These are analyzed.
2. On the top, the site selector is presented. We have chosen the United States as
place. In this country, the descriptive analysis is carried out for the weather
condition of Zion Dado Building and it is a working office.
3. As time varied day-by-day, minute-by-minute, the weather conditions such as
temperature and moisture in air is also changed. Periodically change is accepted.
But if the changes happened abnormally, then the main reason is environmental
pollution.
4. It is analyzed by calculating the time variance, temperature variance of every
month. In the year of 2016, the average electricity consumed by the Zion Dado
company is 28,126 kWh. From the total consumption, the people consumed
8.25% of total electricity consumption at 7 to 8 am. But it is less than the
6

electricity consumption at 6 to 10 pm. Because in this time period, 21.07% of
total electricity is consumed. So In this specified time period, environment is
polluted at high rate.
5. Due to high pollution, the temperature is also increased and the average
temperature of the specific period is analyzed as 59.97F.
6. The bar chart shows that the electricity consumption of Zion Dado building. Is
shows that high electricity is consumed on September 4, 2016.
4. Prescriptive Analysis
We are going to analyze the environmental issues determined in the year of 2018
(Present year). Predictive analytics gives itself to the greater nitrogen problem due to
the fact the models can be evolved to address a massive shape of inputs and spatial
variant. However, there are various one in all a type elements that should moreover be
considered on the same time as developing a predictive analytics solution for agriculture
(Boehlke, 2018).
AgDNA plans to deal with the excess nitrogen issue by in a perfect world
organizing nitrogen necessities to site-specific conditions spatially all through the field.
Thusly intra-field soil irregularity can be managed and moreover periodic instabilities in
atmosphere using PC showing.
The association's essential development merges forefront disseminated
registering structure, immense data examination frameworks, high-assurance air data,
soil qualities and as associated agronomic information from in-field equipment. The
distinctive information sources are then joined with the latest item and Precision
Nitrogen Management (PNM) models to logically predict soil nitrogen necessities.
The resulting encounters are passed on as nitrogen application proposals and
variable rate arrangements (VRx) that can be passed on remotely to in-field equipment
for execution. This ousts contact from the structure by giving a steady two-way
correspondence of data to and from the mechanical assembly.
Nitrogen is one of the excellent individuals to developing crop yield. Mixed with
its relative low rate and immoderate capacity move back, farmers are willing to over
exercise nitrogen as an insurance coverage to make certain they maximize yield.
7

The dashboard is explained below.
1. On the top of dashboard, the site selector is presented. We have chosen the
United States as place. In this country, the descriptive analysis is carried out for
the weather condition of Zion Dado Building and it is a working office.
2. It is analyzed by calculating the time variance, temperature variance of every
month. In the year of 2016, the average electricity consumed by the Zion Dado
company is 28,126 kWh. From the total consumption, the people consumed
8.25% of total electricity consumption at 7 to 8 am. But it is less than the
electricity consumption at 6 to 10 pm. Because in this time period, 21.07% of
total electricity is consumed. So In this specified time period, environment is
polluted at high rate.
3. The temperature is increased when comparing to previous years. The average
temperature of the specific period is analyzed as 60.02F.
4. The bar chart shows that the electricity consumption of Zion Dado building. Is
shows that high electricity is consumed on May, 2018.
8

5. Solution for Improving Environment in Business Organizations
Consistence with relevant laws and directions is a fundamental organization
working necessity that must be accomplished through line administration and affirmed
by reviews. In the natural region, there is never an absence of information
("Environmental Organizations - HOH-SC.org", 2018). However unless those
information are converted into valuable data, they are only an immense arrangement of
numbers futile for setting needs or deciding. The superseding objective for compelling
natural execution estimation frameworks ought not to be on consistence; rather, it ought
to be to assemble data for use in recognizing open doors for persistent change. Thus
lies the linkage between natural estimation frameworks and any quality change process,
which can be reworded as total quality environmental management (TQEM).
Most organizations are simply starting to execute TQEM programs. Helpful
ecological execution estimations require quite a while of data in light of the fact that
TQEM measures advance or persistent change as opposed to depending on supreme
measures of value. Most organizations are as yet creating and testing their natural
estimation frameworks. Be that as it may, there have been a few late meetings
regarding the matter, and organizations are starting to share their encounters ("Is Big
Business the Solution to Environmental Problems?", 2018).
The initial phase in building up a successful estimation framework is to
distinguish the data required. By utilizing TQM standards, this must be gotten from the
prerequisites of the clients, both inner and outer. It recommends that viable ecological
9

estimation frameworks gather data from three interrelated points of view: process
measures and changes, natural outcomes, and consumer loyalty ("Finding Global
Environmental Solutions", 2018).
Advancement and utilization of environmental estimation frameworks are still in
its earliest stages, and the frameworks keep on evolving quickly. Since environmental
issues are mind boggling and frequently interrelated, successful environmental
estimation frameworks can turn out to be very intricate, and beginning execution can
give off an impression of being a mind-boggling errand. In any case, introductory usage
of a fairly direct framework, with an acknowledgment that nonstop overhauling and
changes will be essential, is a sensible approach that will start the procedure of
persistent change of natural execution (Azevedo & Santos, 2012).
The performance of environment can be improved by following acts.
Reduce prices by up environmental performance
Good environmental practices will cut back prices by clipping business' use of
packaging, raw materials, water and energy.
Utilize energy a lot of with efficiency
Conserving energy is the easiest method to save lots of cash. Therefore, cut
back our business' carbon footprint. Changing worker behavior, victimization a lot of
economical instrumentation and coming up with a lot of economical processes in all
ways in which we'll be able to lower the bills. We will be ready to cash in of sure tax
breaks too.
Reduce waste
Waste is the result of victimization the materials inefficiently. For, waste prices at
two fold, we pay once for materials that we simply do not use so a second time to urge
obviate them.
By victimization raw materials a lot of with efficiency, recycling, reducing
packaging and creating production processes a lot of economical, we'll be able to
economize and facilitate defend the atmosphere ("10 Current Environmental Issues -
Conserve Energy Future", 2018).
Invest to save lots of
10

Paying for normal examination and maintenance of kit might prevent cash within
the long run - as an example by up energy potency, reducing the use of raw materials or
avoiding breakdowns.
Various vital edges are present for investing on technology which decreases the
use of energy and water. Lots of kit prices are high for running when compared to shop
for. We’ll economize by disbursement a lot of within the 1st place to shop for a lot of
energy-efficient machinery and instrumentation.
Reduce bill
Investing in energy, water-saving technologies and environmentally friendly
machines, our business might qualify for Excess Capital Allowances (ECAs). All these
things will assist to cut back the bills. The following are the ECA schemes:
Energy-saving plant and machinery
Low carbonic acid gas emission cars, fossil fuel and chemical element refueling.
Infrastructure
The machinery and plant for water conservation.
Improve worker performance
By providing excess allowances and appreciations, the organization can get
improvisation in worker’s performance ("4 Environmental Issues That Matter to
Employees – and Employers", 2018).
Making Business Organizations Greener
Green teams not every single humanitarian exertion are about magnanimous
giving. Frequently, they're tied in with changing our own particular practices and those
of the general population around us. With organizations now beginning to see the
benefit of being green, manageability officers have turned out to be relatively
omnipresent.
Characteristic assets are winding up rare and expensive; at the same time,
clients, representatives and speculators are progressively earth cognizant. As the
advantages turn out to be more evident (and the choices more untenable), our part
associations are working with business and industry in an assortment of approaches to
enable them to reinforce their sense of duty regarding maintainability.
11