Business Intelligence Reporting Solution for Environmental Issues

This report discusses the use of business intelligence reporting solution to identify and solve environmental issues. It covers descriptive and prescriptive analysis, dashboard prototype, and the impact of CO2 on the environment. The report also provides insights on how to design a mobile application and justifies the use of BI reporting solution to tackle environmental issues in organizations.

DATA WAREHOUSE AND
BUSINESS ANALYTICS
Student Name:
Student ID:

Executive Summary
The aim of this report is to separate the problems related to environment with
the help of business Intelligence discernment device. Dashboard is considered as
the best example for this. On the other hand, this report coordinates with one of the
analysis such as, Descriptive and Prescriptive analysis. This is business
investigation that generates creative analysis arrangements. A primary thought of the
researcher is to guide the students to speak out their abilities as far as advancement
and innovations for the SAP Business Object or Predictive Analytics application,
which needs outlining the responses of advantageous perception for demonstrating
prescient models, so that it can recognize the systematic problems. Here, the
investigation corresponds with the problems of environment, using the Dashboard.
Then, this report’s target is to decide how high vitality utilization can cause
environmental contamination. In connection with assurance, the clear analysis and
the point of view for investigation is divided in this report, with the help of dashboard.
Therefore, the dashboard’s assistance helps to identify the primary execution
markers.
1

Table of Contents
Introduction........................................................................................................................................2
Problem Statement...........................................................................................................................4
Environment and related Issues...................................................................................................4
Impact of CO2 Use on Environment.............................................................................................5
BI Reporting Solution using Analytics........................................................................................6
1.1 Descriptive Analysis........................................................................................................6
1.1.1 Dashboard..................................................................................................................7
1.1.2 SAP Analysis..............................................................................................................9
1.2 Prescriptive Analysis.....................................................................................................10
1.2.1 Dashboard................................................................................................................11
1.2.2 SAP Analysis............................................................................................................12
1.3 Dash board Prototype....................................................................................................13
Design Mobile Application...........................................................................................................14
Justification of BI Reporting Solutionto deduct Environmental issues in Organizations
.............................................................................................................................................................15
Conclusion.......................................................................................................................................17
References.......................................................................................................................................18
2

Introduction
The aim of this report is to separate the problems related to environment with the
help of business Intelligence discernment device. Here, dashboard is referred as the
best example. There is coordination with various analyses such as, Descriptive
analysis and Prescriptive analysis, in this report. It contains investigation of business
that generates creative arrangements for the analysis. This report’s primary idea
refers to provide instructions for the students to express the capabilities they have as
far as advancement and innovation of SAP Business Object or Predictive Analytics
application, there is a need of outlining the responses of advantageous perception
for demonstrating the prescient models. This helps in recognizing the systematic
problems. This report investigates the corresponded of the environmental issues, by
using the Dashboard. Furthermore, this report requests to execute the explanatory
instruments to create imaginative analysis perception arrangements and prescient
models to find the problems.
In this report, the problems which are serious includes, energy utilization.
Different environmental problems exists such as the following- decreasing water,
depletion of ozone, substance emanation, environmental change, vitality use,
contamination etc. The key environmental problems include, contamination,
Biodiversity loss, dangerous atmospheric deviation, Climatic Change, Deforestation,
excess population, Disposal of waste, Acid Rain, Depletion of environmental
resource, Depletion in the Ozone Layer, Acidification of Ocean, contamination in the
water, general medical problems and so on.
Today, there is change in earth’s environment and this fact cannot be refused.
According to the earth’s adjustments, it is important to stop the associated problems.
3

Different climatic changes occur due to global warming and cooling periods. This has
adverse impact like uncertain disasters. Thus, there must be some awareness made
related to the environmental risks that earth is confronting.
This report’s target refers to deciding how high the energy utilization could
results in environmental contamination. In connection with assurance, clear analysis
and the view point of the investigation will be subdivided, by using the dashboard.
The primary execution markers will be recognized by utilizing the dashboard.
Project Problem
As specified in the presentation, the given topic relates to environmental
problems, these problems relates as the foundation for environmental problems that
aren’t distinguished. It is carbon dioxide which causes the real problem in terms of
contaminating earth’s surroundings. Such an examination needs thorough
investigation, to decide how much high use of carbon dioxide could result in
environmental contamination. The connection among energy utilization as well as
the environmental problems should be spoken to enhance the environment of earth.
Generally, examination is complicated to be viewed in the business Intelligence
device. Thus, a Dashboard is suggested to have clear information ("15 Current
Environmental Problems That Our World is Facing - Conserve Energy Future",
2018).
Problems related to Environment
4

As the Global warming increases, the current environment has a serious
threat. In worldwide the examining the problems of environment are viewed by each
individual, at least once in a day, where energy utilization is one such problem.
Specific problems are small that could scarcely impact on the environmental system.
However, there are some environmental problems that can definitely transform the
nature. Thus, our Earth is at risks of various environmental calamities. The current
environmental issues build the vulnerabilities to calamities and tragedy. If such
problems aren’t taken care, earth will definitely see serious natural disasters. Earth’s
general population are busy in their lives and it is time for them to future of their next
generations. In light of the fact that their little imprudence can prompt difficult issue.
Because these serious environmental problems can harm the future generation.
Here, the vital point to be noted is that, it is difficult to physically end the harms which
are being caused to the ozone layer. However, different techniques are present that
could be taken care. For instance, expanding the awareness among the
neighbourhood networks and among the families who can show some commitment
to help the nature. Subsequently, when just some people hold on hands this can turn
into a substantial gathering and extensive commitment. Thus, it will surely have a
good place for human survival ("6 Best Practices for Creating Effective Dashboards",
2018).
CO2’s effect on the Environment
Their complicated natural impacts can particularly impact the society,
business, the organic frameworks, and the government hopes to ease the assets it
has with broad bearings. As the associations have straightforwardly delivered carbon
5

dioxide, but it will logically identify that those outpouring contains high cost, both
related to cash as well as socially. With such lines, the organization which continue
standing on the side-lines would be gravely debilitated in concern of those who right
now are detailing with the techniques to diminish the risks and discover the high level
in a warming and in the world which is carbon-obliged.
Different strategies are available for diminishing the natural effects of energy
utilization. A portion of the strategies are recorded below ("Big Data Analytics:
Descriptive vs. Prescriptive - InformationWeek", 2018):
 The energy consumption must be saved.
 Transform to sources such as cleaner energy.
Cleanenergyrefers to energy proficiency, sustainable energy sources,
effective combined heat and power. Accompanying concentration should be
remembered while viewing the perfect energy, as follows:
 It supports in decreasing the contamination of air.
 It adds to decline the depleting substance in the ozone.
 It decreases the energy consumption that likewise diminish the power
bills.
 It enhances the energy framework's unwavering quality and security.
 The clean energy will upgrade the financial improvement of state or the
neighbourhood with expanding work openings.
Analytics helping BI Reporting Solution
6

1.1 Descriptive Analysis
Descriptive Analytics is a strategy which sees the experiences that occurred
previously ("Business Intelligence Dashboard Examples and Templates", 2018). This
examination is indicated as the measurement investigation. Because, it clarifies
crude information and effortlessly helps in information translation. Benefits of such
an approach provides clarity and the understanding ability. The reasonable
information could without much of a stretch help to separate, over a wide span of
time, which causes the analysis to effectively finish up the of the information
examination’s consequences. The investigation indicates "A moment" time that is
crossed as past, for instance, "A year." Such an examination comprises of different
points of interest which assist the clients with learning vital subtle elements, when
contrasted and the past conduct. Likewise, it successfully appreciates the
explanation of how it impacts the future ("Business Intelligence | Microsoft", 2018).
1.1.1 Overview of Dashboard
The following clarification refers to dashboard:
 Bar diagram is presented for information analyse.
 Alternative of information examining is available, wherever the filtration is
completed based on the city, nation, date and the state.
 Location of site is seen, which demonstrates the name, type, nation, address
and the area's territory (in square feet).
 The dashboard represents the energy utilization.
 It explains the diagram which demonstrates the benchmarks, previous
month’s usage, current month's usage and normal temperature.
 In the dashboard, calendar’s accessibility is present.
7

 Area’s climate status is mentioned.
 Energy consumption is represented in terms of Kilowatt hour i.e., Kwh.
 Main markers can be selected ("Business Intelligence | Reporting | Dashboard
| Cynosure Solutions", 2018).
 In the dashboard, the climate conditions can be viewed as and when needed.
 It provides the real time revealing.
 The dashboard receives continuous data of the selected website, by making
use of internet browser.
 The data needed is shared with any device such as versatile or a work area.
8

The above figure represents the dashboard and the United States of
America’s energy utilization investigation, for "Zion Dado Building".
9

In dashboard, the benchmarking denotes 35.600, however it has achieved 2,
812, 5675. A month ago the energy utilization was 7.45% between 7 to 8 am, and
during 6 to 10 pm the energy utilization was 20.12% ("Causes and Effects of
Environmental Pollution", 2018). While, the present qualities for 7 to 8 am indicates
8.25% and for 6 to 10 pm it demonstrates 100%. The month-to-month normal
temperature is appeared as 59.89 0F.
1.1.2 Analysis of SAP
The measurements of CO2emission during 2012 to 2016 is taken by SAP
assessment. The below graph is displayed by utilizing the insights from the databank
and a chart is made by utilizing the Excel record with the help of SAP business
Object. It demonstrates that the pinnacle estimation of CO2emission is found during
2013, as 545 kilotons. During 2016, it reduced to 380 kilotons.
For the most part for insights, the illustrative examination is utilized, for
example the fundamental number juggling issues like midpoints, rate changes and
so on. This approach of examination is effective to the point that the information can
10

be separated as far as segments and can be totalled. Along these lines, comparative
count can be effectively done utilizing the elucidating investigation. It additionally
backings to demonstrate the aggregate stock present in the stock, alongside client
points of interest like normal sum spent on each and every client, contingent upon
multi month or a year. The deals and benefit can be related effectively. The
announcing arrangement of unmistakable examination features the chronicled bits of
knowledge relying upon any association's financials condition, their activities,
creation, stock, deals and clients.
1.2 Prescriptive Analysis
The prescriptive Analytics utilizes the calculation like restructuring and rebuilding, to
give successful appeal on the outcomes. The investigation finds the required
solutions like what must be done further. The conceivable activities are recognised
by this investigation. The provided prescriptions fill as direction, which prompts the
correct arrangement. The benefits of this examination are powerful and reasonable.
Further, it helps in the basic leadership. Despite the fact that it can't foresee what
may occur in the future, however without any doubt it decides why it happened and
recommends some gainful proposals("Causes and Effects of Environmental Pollution
- Conserve Energy Future", 2018). The proposals are great and can settle the issue.
1.2.1 Dashboard
The Business Intelligence dashboard changes the conventional reports of
business knowledge and displays a prescient execution metric. The business insight
dashboard detailing utilizes perceptive implementation announcing framework. Since
it can track the data, as the detailing framework checks the process reliability for
delivering the response. If there should be an occurrence of preparing control, the
11

perceptive response will be given("Descriptive, Predictive, and Prescriptive Analytics
Explained", 2018).
Figure: Consumption by Sector
The previously mentioned figure represents the created dashboard. The
aggregate utilization is 48.00B KWh and the aggregate deals is $47.97B. The deals
by division appear in the dashboard. At that point, the quantity of intensity cuts and
normal length of intensity cut can likewise be resolved, as shown in the figure. The
impacts in a year are pictured i.e., from January 2016 to December 2016.Followed
by energy sources, i.e., the measure of sustainable power source, dark collared coal,
atomic energy and gas are externally represented in a graph. The areas considered
12

are, exchange, benefit, industry, private department and group("Environmental
Impacts of Renewable Energy Technologies", 2018).
1.2.2 SAP Analysis
One of the fundamental explanations behind expanding the CO2emission from
the vehicles is presented by utilizing the SAP Business Object programming. The
below graph is provided, which is finished with Excel investigation of SAP objects.
The Business Intelligence dashboard changes the customary reports of the
business insights and exhibits in a prescient execution metric frame. The business
knowledge dashboard announcing utilizes the prescient execution detailing with the
framework. Since it can undoubtedly tract the data as-This revealing framework
checks the procedure's security for creating the reaction. If there must be an
occurrence of preparing strength, the prescient reaction will be given.
1.3 Prototype of Dashboard
The model of the Design takes after the dashboard. This dashboard is utilized
to build up the response for the natural issues. The dashboard is popular for
speaking to the graphical structure with a proper device. This gadget is utilized for
dealing with the information and furthermore to have insight of information. The
fundamental target of utilizing the dashboard is to track, appear and break down the
13

general execution of the particular procedure in any association. It is conceivable
forthe execution on the basis of day-to-day, week-after-week, month-to-month, and
on quarterly or yearly basis. The dashboard contains key execution markers. These
pointers are identified with the association key necessities("Global Warming: Energy,
Environmental Pollution, and the Impact of Power Electronics - IEEE Journals &
Magazine", 2018). The below mentioned clarification indicates the dashboard:
 The Dashboard is expressed in the below provided figure.
 The bar outline appears to look at the information.
 The alternative of examining the information is available, where filtration is
finished based on the date, nation, state and city.
 The interested site's location is effectively seen, which indicates the name,
type, nation, address and the area's territory (in square feet).
 The dashboard represent the energy utilization.
 It portrays the chart which demonstrates the benchmarks, previous month’s
usage, current month's utilization and normal temperature.
 Calendar is accessible in the dashboard.
 The climate status of the area is provided.
 The energy consumption is represented in terms of Kilowatt hour (Kwh).
 Any key markers could be picked.
 Whenever required the climate conditions can be seen, in the dashboard.
 Real time revealing is given by the dashboard.
 It gets to the constant data of the selected website, by utilizing the internet
browser.
 The required data is given to any gadget. For example, portable or work area.
14

Application Design
for the Mobile
The Mobile application for environment issues is shown below.
The application name is predictive analytics application.In this application generated
by the QR code.We are developed the QR code for this application.
15

16

QR code is attached here("The National Academies presents: What You Need to Know
About Energy", 2018).
17

Justification of BI Reporting Solution to identify the Environmental
problems in the Organizations
The possible response for decreasing the environmental issues in a suggestion
are talked in this section. The accompanying strategies will enhance the execution of
the environmental issues:
 Efficiently use the energy of power.
 Take estimates like, venture on checking energy effectiveness of the
machines utilized in the workplaces or business.
 Take genuine endeavours to diminish the sum in CO2 discharges from
different assembling association and production lines.
 Use CO2 retaining plants and apparatus.
18

 Increase theawareness among the specialist on the effects of energy wastage
and its effect to the earth(Shards, Dalen& Turban, 2017).
To meet the previously mentioned arrangements, the business Intelligence detailing
the arrangement can go about as a data mining method, where the information can
be followed and vital advances can be taken. This arrangement is viewedas the
current best answer and it comprehends the information through information
representation choice in the dashboard. This choices disposes the multifaceted
nature to comprehend the information. Improving the dashboard can enhance the
business i.e., it can help to investigate new open doors for the little firm or a major
association. Additionally, it helps in streamlining the basic leadership process. The
dashboard guarantees to check the execution and deals with the application, which
is utilized in the BI. It is important to have a powerful plan to separate from the other
people who lose("The Roles of Dashboards and Scorecards - Social Solutions",
2018).
The dashboard demonstrates its effectivenessbased on its viewsto estimate
the impacts, where information based direction is given. In the dashboard, the ETO
performance management software can be tweaked as required for adjusting the
Transtheoretical Model, in the phases of progress that are actualized for the
improvement of the required administration. The dashboard offers continuous screen
of the program components which are required to be managed regularly. A
scorecard signifiesthe preview of one or numerous parts ofinformation pool, this is
the place for the dashboard to draw read-outs("Top 6 BI Dashboard Best Practices
In The Digital Age", 2018).
They are used for effectively looking at measurability between the
associations, individuals and eras. In this manner, the scorecard and the dashboard
19

cooperates for demonstrating the required data at whatever point required.
Henceforth, this component of the dashboard could slice through reams of
information for conveying only the huge features of the data. The basic learning tools
that backs in recognizing what is happening and where the assets must be diverted
incorporates the advanced dashboard and the scorecard. It offers functional learning
which allows the clients to successfully serve its members. At that point, it
distinguishes and repeats the prescribed procedures. The dashboards are so much
advantageous that they even contribute for building an exceedingly complete
grouping effect which confirm the benefits of WIA detailing and raising support
activities.
The dashboard can be associated with different type of information. It can mix
the information from different sources to have an all-encompassing perspective, and
next it can choose basic viewpoints and mirror the destinations effortlessly. In
addition, the dashboard can be worked together with the same number of individuals
to share the outcomes and information. Above all, the dashboard gives moment
show of the information in a graphicalrepresentation. It additionally distinguishes the
examples and patterns in the conduct of the members and their inclusion. This
approach of the dashboard decides the goals and the investigator can check the
achievement and disappointment. The adjustments can be made to enhance the
outcome sooner rather than later.
Conclusion
This report has successfully written to represent the descriptive and prescriptive
analysis, for separating what occurred in the past years, related to environmental
issues. The dashboard is utilized to finish the examination. The assurance of how
the high energy utilization can cause environmental contamination is talked in this
20

study. The principle execution markers are distinguished. The dashboard is
produced and clarified. The idea of elucidating and prescriptive investigation is
examined and a similar examination is directed. As indicated by the information
representation technique, the selection of a reasonable choice help is finished. The
target of the examination is met. The examination accumulates information of
utilizing the Analytic instruments. The business insight's model is composed and its
defence is displayed. The dashboard is utilized for recognizing the primary execution
markers. The effects of energy usage conditions are examined and it is seen that
any type of power age could have effect on the situations. For example, land, air and
water. It is likewise realized that the effects shifts. Also, how CO2 impacts the
association business technique were talked about and how to decrease the CO2 gas
utilization were identified.
References
21

6 Best Practices for Creating Effective Dashboards. (2018). Retrieved from
https://www.tableau.com/learn/whitepapers/6-best-practices-for-effective-
dashboards
15 Current Environmental Problems That Our World is Facing - Conserve Energy
Future. (2018). Retrieved from https://www.conserve-energy-future.com/15-
current-environmental-problems.php
Big Data Analytics: Descriptive Vs. Predictive Vs. Prescriptive - InformationWeek.
(2018). Retrieved from https://www.informationweek.com/big-data/big-data-
analytics/big-data-analytics-descriptive-vs-predictive-vs-prescriptive/d/d-id/
1113279
Business Intelligence | Microsoft. (2018). Retrieved from
https://www.microsoft.com/en-us/sql-server/business-intelligence
Business Intelligence | Reporting | Dashboard | Cynosure Solutions. (2018).
Retrieved from http://cynosure-solutions.com/solutions/enterprise-business-
solutions/business-intelligence-and-reporting
Business Intelligence Dashboard Examples and Templates. (2018). Retrieved from
https://www.clicdata.com/examples/
Causes and Effects of Environmental Pollution. (2018). Retrieved from
https://helpsavenature.com/causes-effects-of-environmental-pollution
Causes and Effects of Environmental Pollution - Conserve Energy Future. (2018).
Retrieved from https://www.conserve-energy-future.com/causes-and-effects-of-
environmental-pollution.php
22

Descriptive, Predictive, and Prescriptive Analytics Explained. (2018). Retrieved from
https://halobi.com/blog/descriptive-predictive-and-prescriptive-analytics-
explained/
Environmental Impacts of Renewable Energy Technologies. (2018). Retrieved from
https://www.ucsusa.org/clean-energy/renewable-energy/environmental-impacts
Global Warming: Energy, Environmental Pollution, and the Impact of Power
Electronics - IEEE Journals & Magazine. (2018). Retrieved from
http://ieeexplore.ieee.org/document/5439042/
Learn about Energy and its Impact on the Environment | US EPA. (2018). Retrieved
from https://www.epa.gov/energy/learn-about-energy-and-its-impact-
environment
Sharda, R., Delen, D., & Turban, E. (2017). Business Intelligence. Pearson Australia
Pty Ltd.
The Roles of Dashboards and Scorecards - Social Solutions. (2018). Retrieved from
https://www.socialsolutions.com/blog/measuring-impact-effectiveness-roles-
dashboards-scorecards/
Top 6 BI Dashboard Best Practices In The Digital Age. (2018). Retrieved from
https://www.datapine.com/blog/bi-dashboard-best-practices/
23