Business Intelligence Reporting and Dashboard Usage for Environmental Issues

This project focuses on using Business Intelligence Reporting and Dashboard to address environmental issues. It explores the impact of CO2 emissions on the environment and the need for energy consumption reduction. The project also highlights the benefits of using SAP Analysis and Dashboard in making data-driven decisions. The report provides insights on descriptive analysis, prescriptive analysis, and the design of a mobile application. It concludes with the justification of BI reporting solutions for reducing environmental issues.

Executive Summary
Our planet, Earth has been facing lot of atrocities in the form of environmental
problems and in this project we shall be making use of Business intelligence device
like Dashboard to help in addressing this issue. Use of SAP analysis on the collected
datasets like Descriptive analysis and Prescriptive analysis is utilised to study and
evaluating this information. Developing of a design model application is carried out
and then with the guidance of the Dashboard, the evaluation of the problems
concerning the environmental problems is displayed.
Finally we shall discus all the above points and present our report related to
Business intelligence Reporting and usage of Dashboard.

Table of Contents
1. Introduction................................................................................................................................1
1.1 Problem Statement...........................................................................................................2
1.2 Objectives...........................................................................................................................2
1.3 Environmental Issues......................................................................................................2
1.4 Impact of CO2 Use on Environment.............................................................................3
2. Business Intelligence Reporting Solution with the help of Analytics..........................5
2.1 Descriptive Analysis........................................................................................................6
2.1.1 Dashboard..................................................................................................................6
2.1.2 SAP Analysis..............................................................................................................8
2.2 Prescriptive Analysis.......................................................................................................8
2.2.1 Dashboard..................................................................................................................9
2.2.2 SAP Analysis..............................................................................................................9
2.3 Dashboard Prototype.....................................................................................................10
3. Design of a Mobile Application...........................................................................................11
4. BI Reporting Solutions Justified for Reducing Environmental issues......................13
5. Conclusion...............................................................................................................................15
References.......................................................................................................................................16

1. Introduction
Business Intelligence (BI) tools are variety of different application software for
finding the way of collecting information/ data for finding information basically by, to
collect and analyse huge volumes of unstructured data from internal/ external
systems. For preparing reports, dashboards and data visualisations, these given
tools also aid in creating the data for evaluation. Aimed for the business users, SAP
BIis is a reporting and analytics business intelligence (BI) platform. Creating and
making reports that look into the insights, this also consists of a number of reporting
applications that allow users to discover data, perform analysis to derive insights.
SAP BI tools are a great boon specially when handling huge amount of data,
by using and identifying patterns formed, to make smart decisions and effective
strategy for any and all types of settings, without the size or the complexities factor.
This helps to discover data, see the insights of the data, helps to solve the
identified issues and same time predict forecasts (Guru99.com, 2019). The benefits
of using this tool are,
 Analysis and reporting
 Data visualisation and analytics applications
 Office integration
 Mobile analytics.
Now after the studies and research regarding the concerns to the Environmental, the
following were the factors affecting it,
 Depletion of ozone layer
 Shortage of water
 Changes in environmental climate
1

 Air/ Water pollution
 Deforestation
 Rapid Urbanisation
 High energy consumption
 Over population
Danger signs are already there regarding concerns to human life as the ill effects of
changes in the environment, which has been causing release of Greenhouse gases
and overall increase in Global Warming and catastrophic climate changing
conditions.
With the assistance of the Dashboard we shall highlight all these problems and their
solutions for improvement of our Environment, planet and finally our lives.
1.1 Problem Statement
Climate change, pollution, environmental degradation, and resource depletion etc
are some of the major present environmental problems faced by earth. Protection of
endangered species, protection of any ecologically valuable natural areas,
genetically modified foods and global warming are some of the topics that the
conservation movement lobbies are fighting for. And from all these, the biggest
environmental risk facing us is Weather Change and Global warming.
Human activities have destroyed the environment in a very rapid and uncontrollable
rate which is not only affecting the weather, climate but also endangering the lives of
many species.
.
Everyday there are numerous issues creeping in as the activities tend to increase
and repeat. These activities have kept on intensifying and causing severe damage.
One of the major influences to these activities is the wide climatic conditions being
observed. The severity of weather change, more severe weather like storms,
2

cyclones, torrential rainfall, drought, typhoons, etc are the by-products of this
changes taking place in the environment.
We have to face the reality that we are the reason and the cause of all this
catastrophes that is taking place all over the world. These have been doing more
damage and destruction than the natural catastrophes. And sooner we realise this
fact, the better it will be for the future of mankind.
Our project aims to identify the solutions to these problems and with the iad of
business tolls like Dashboard, highlight the answers to these problems.
Objectives
The following are the objectives of this project:
1) To know the causes of carbon dioxide and its impact on the
environment.
2) To resolve energy consumption issue.
3) To perform descriptive analysis
4) To perform prescriptive analysis (Data.worldbank.org, 2019).
5) To design a predictive analytical application.
1.2 Environmental Issues
With Global warming being the hot topic of discussion and research around the
globe, we tend to forget the other factors that are contributing to the decline of
environment around the planet. Research has shown that many other factors are
influencing the damages to the environment and these too have to be studied and
answers sought out for. Thought Climate change has been occurring largely to the
global warming threat, there are factors that are the basic cause for this. And one of
the major contributors to this influence is the high energy consumption around the
3

globe. An environmental impact on our air, water and land, is due to the high usage
of electricity. The amount of fuel needed to generate electricity and the amount of
greenhouse gases and other air pollution emitted all are minimized and reduced
when, producing and using electricity more efficiently. The burning of these fossil
fuels puts tons of C02 in the atmosphere which leads to Global Warming and also by
making use of excessive amount of energy from sources like fossil fuel, biomass,
and waste burning power plants. Negative effects on the environment are caused
with additional impact on human health cause of tall these combustion products.
Adding to the woes of the Greenhouse effect is the emission of CO2 gas. Harmful to
plants and to animals that live in water is the acid rain caused by the SO2 gas in the
atmosphere. This is leading to catastrophic proportions on planet earth.
Financesonline.com, 2019).
A sustained and systematic planning and execution is required from everyone, right
from the nations, governments, organizations, firms, the business community,
families and lastly us, individuals to contribute and reverse this trend. This is the
outcome of many years and decades of abuse and it won’t be stopped or reversed in
an instant. A Collective effort is required to make a powerful impact and change.
Spreading Awareness and letting everyone know about the influences via media,
propaganda channels etc to make sure that the message has been passed well and
understood by everyone that it is our life and our future that we are taking this risk
with.
1.3 Impact of CO2 Use on Environment
CO2 gases impact on the environment is vast and huge including, air pollution,
emission effects etc which is impacting the weather changes. According to studies
4

done by the National Oceanic and Atmospheric Administration (NOAA), the surface
temperature of earth has risen over the last 100 years. CO2 gas is the prime culprit
in this case as per experts even though the effects of this are far more complex.
Resulting in a loss of shoreline and coastal wetlands, evidence finds that ocean
water levels have been steadily increasing, plants and leaf pores shrink as CO2
levels are rising, less cooling power of tree’s as less water is released etc. Knowing
well the ill effects of CO2 gas emissions in the environment, still we have been
releasing an uncontrolled amount of CO2 gas in the atmosphere. This is especially
true for the last few decades and harming the climatic conditions to irreversible
levels. Thus we can clearly observe the damaging effects of environmental CO2
emissions. Fossil fuels release CO2 gas and this continues with the use of auto
vehicles, electricity usage, machinery, factories etc and this is in addition to other
waste gases released during combustion. With the ever increasing population on the
planet, resources are diminishing and in reverse these dangerous gases are
multiplying to unimaginable amount.
We can observe the various energy types’ contribution to the world energy usage in
the pie diagram below.
Other types of energy sources, other than natural fossil fuels, also contribute
(directly or indirectly) to the quantity of CO2 emissions to the environment. This
includes nuclear energy, biomass energy etc. Hydro energy, solar energy, wind
energy etc are the type of renewable energies required ("Energy Use and the
Environment", 2019).
5

Figure: Energy usage globally ("Energy Use and the Environment", 2019)
There is a direct connection to climate change and the energy consumption as per
the above analysis. Over usage of fossil fuels and their burning for energy has led to
massive amount of greenhouse gas emissions, with deforestation being one of the
major contributors ("Energy Use and the Environment", 2019).
6

Figure: Emission of carbon globally by different energy sources ("Energy Use and
the Environment", 2019)
Hence to help planet Earth, the following two factors have to be taken into
account majorly for improving the overall environment,
a. Energy consumption
b. Facilitate the utilization of solar energy.
2. Business Intelligence Reporting Solution with the help of
Analytics
For making better and fruitful decisions, it should comprise of systems made up to
capture, categorize, and analyse corporate data and take out the best practices.
7

Making use of more data set sources, involving, including internal metrics converging
from various company areas, and external data extracted from third-party systems,
social media channels, emails, or even macroeconomic data for the more advanced
Business Intelligence Tools. Assisting companies and firms to gain insight on their
overall growth, sales trends, and customer behaviour, are the optimal business
intelligence software’s. Giving support via cloud deployment, mobile platforms,
applications, BI analysis assists the users to assess the data and the analysis
methodology anywhere they are comfortable to use them. Graphic user friendly
display, data markers, key parameters etc are all used for assisting in decision
making.
External/ Internal sources are used for collecting, generating, filtering , applying
parameters, for generating queries and executing them, preparing reports and finally
displaying the results on the dashboard for the user to make final decisions.
A data management tool that checks, evaluates, controls, and gives a visual
output for the prime business metrics while letting the users to interact with data,
letting them to develop a well-informed, data-driven, and healthy business decisions,
is the tool which we call as Dashboard. These are made use with various business
intelligence (BI) environment, making links between managers and the company’s
strategy, allowing various areas to collaborate more efficiently, and letting employees
to perform with an increased productivity level. To reply the critical business
questions on-demand with the latest up-to-date data with interactive analysis
empowers users. Various perspectives and point of views with just a few clicks is the
additional advantage where data can be checked, with facilities like zooming-in/out,
detailing time intervals, filtering countries or show and hide specific parameters.
8

SAP Business Intelligence has platforms which are highly interactive and
adaptable for the user to make the necessary modifications to give the desired
results and outcomes. Understanding the various situations came to be as also
allowing to locate the patterns in the data and make potential outcomes by using
advanced analysis and then develops the required dashboard. Enterprise-wide
sharing functionalities are the factors that SAP Business Intelligence offers
businesses. Sharing of vital and common information with a controlled organization
can also be carried out by the use of these dashboards.
2.1 Descriptive Analysis
The short descriptive coefficient that summarizes the data set that is either a
representation of the entire set or a sample of a data set is called as Descriptive
analysis. Measured for central tendency and measures of variability (spread) are the
characteristics of the Descriptive Analysis. The mean, median, and mode are the
parameters of the measures of central tendency and standard deviation is that for
measures of variability. Using the past data and combining it with the present
information, it will predict the outcome as per probability outcomes (SAP, 2019).
2.1.1 Dashboard
Titled as per the user’s requirement, the dashboard has the facility to be
customized and named (SAP, 2019).
9

"Zion Dado Building”, (USA) is the building that has been taken in this case
study and finds the energy consumptions and how is the trend. The above
Dashboard gives lot of information to the users like energy consumption, monthly,
10

previous/ current energy usages, etc. Temperature is another parameter that is also
displayed on the dashboard. An example of the information given, 2, 812, 5675 has
been achieved when the benchmark was 35,600.
2.1.2 SAP Analysis
To gain insight for the business data and make optimum decisions that give
effective corporate performance is the use of SAP Analysis. Playing multiple role
like, Information Technology, management and end uses, provides enormous
functionalities in a single platform.
In the below bar diagram we can see that, by use of SAP analysis the
estimated CO2 emission in the specific period. In 2013, the CO2 is 545 kilotons,
whereas during 2016 it is observed to be 380 kilotons.
11

2.2 Prescriptive Analysis
Using both new and historical data for forecasting activity, behaviour and trends,
Predictive analytics is a form of advanced analytics. It involves applying statistical
analysis techniques, analytical queries and automated machine learning algorithms
to data sets to create predictive models that keep a integer value or score on the
likelihood of a particular event happening. For identifying the most likelihood of future
results based on historical data, predictive analytics is the use of data, statistical
algorithms and machine learning methods. For providing a best assessment of what
will happen in the future, the aim is to go beyond knowing what has happened.
SAP has been using Predictive Analytics for making influencing decisions for
businesses and corporates. SAP Predictive Analytics comes in two modules
(element61, 2019):
 Aimed at business users and business analysts are the automated evaluation
module.
 Targeted towards data scientists is the expert analytics model.
Empowered, is the business user, to model around data by making use of the
automated analytics module offering a powerful UI. Needed to build a model, the
efficient interface module assists the users with the following steps,
 : Loading the right data source (any SAP or non-SAP database, excel- or csv-
file), tackling missing values,
 Choosing the target
 Supporting the right variables
 Training and visualizing the model.
No coding or actual modelling experience is required as the wizard assists in a
detailed every step explained support.
12

2.2.1 Dashboard
A data visualization tool that shows on the single screen, the various data like
business analytics metrics, key performance indicators (KPIs) and vital data points
for an organization, department, team or process is called as business intelligence
dashboard (BI dashboard). A dashboard is a tool used for information management
and business intelligence which, organizes, stores, and displays vital data extracted
from multiple data sources and then combined into one, easy-to-access place.
Visually aiding the users to study and understand the complex relationships in their
data, by making use of data visualization by the dashboards unique communicate
metrics. Drawing parallels between various but inter-related metrics, identify
patterns, and fend off potential challenges hidden in an organization’s data by
utilising the power of the data dashboard (Open-data.europa.eu, 2019).
Figure: Consumption by Sector
13

Of the total arrangements $47.97B, totally 48.00B KWh energy is used as per
the display of the dashboard in the above image
2.2.2 SAP Analysis
We shall evaluate the increasing carbon dioxide emission caused by the
vehicles by using the SAP BI analysis. The SAP objects (Analytics, 2019) are used
to analyse the below chart diagram.
Increasing the understanding and perspectives of the end user, the BI
dashboard presents a standard business reports in a displayed manner with the help
of diagrams, charts, bars, interactive tables etc.
14

.
2.3 Dashboard Prototype
Following are the characteristics of a created dashboard,
1) For breaking down the data, it shows a bar outline
2) With a graphical representation, it assists to easily understand the
data.
3) It helps to filter the data; here the data such as country, city, state
name and date are filtered.
4) Displayed on the site with location are the details like name, type,
country, address and the domain of the region (in square feet unit).
5) For a specific location, the dashboard represents the consumption
of energy based on building/ organization.
6) Any time accessible calendar to ease with the dates is a huge
bonus for the user.
7) The necessary benchmarks are revealed on the dashboard’s
screen for the user to cross-check the present and past details.
Here, the energy usage and temperature are cross-checked.
8) Making use of the dashboard, the selected location’s atmosphere
status is displayed.
9) To measure the consumption of energy, the Kilowatt hour (Kwh) is
used.
10)Option for selecting key markers.
11) The condition of the atmosphere could be checked at any time on
the dashboard.
15

12) To analyse, real time data is available.
13) To provide accurate information use of internet connection.
14) It has the capacity of sharing the data or report with various
devices.
3. Design of a Mobile Application
The following section helps in demonstrating the environmental issues on a
developed mobile application as demonstrated in the below images. Using the QR
code, Predictive analytics application has been used for developing this application
(JReport, 2019)
16

17

The QR code for the application is,
4. BI Reporting Solutions Justified for Reducing Environmental
issues
Business Tools (BI) is easy to understand tools used for the evaluation and
data analysis. Effective analysis can be carried out by easy to understand and feel
the outcome of the analysis results in a clearly understandable format (Data.un.org,
2019).
Understanding and studying the information collected is vital for the effective
outcome of the analysis. Proper planning and collection methodology will have to be
18

applied for getting the proper outcome. Use of historical data will be made use with
the present collected data, so as to give the best probable future solution.
The Business Intelligence reporting solutions gives power to the end-users to
critically analyse the data as an expert does, to help the business improve.
A system of various solutions used to garner insights from different types of
data is called a Business intelligence system. Accomplished by utilizing different
techniques to understand historical, live, and predictive data, efficient and effective
business decision making is the primary use of business intelligence. It’s relation to
the vital part of BI is the business intelligence reporting and this BI is defined to delve
deeper into the purpose of BI.
Consider the below given influences and factors to reduce the effects on the
Environmental crises,
a) Controlled Energy utilization.
b) Methodology to reduce the CO2 emission from various different
organizations, outlets and sources.
c) Growing of more plants/ trees to neutralize the ill effects of excessive
CO2 emissions.
d) Vehicle strict check for cutting down on emissions.
e) Spread the awareness and knowledge about the energy consumption
and its positive effect on the environment.
Data mining strategy is made use for meeting the requirements of the
business information and using this with the Dashboard, helps in businesses.
The review of data pool’s various parts is called the scorecard and, combined this
with the dashboard to give all the necessary information as per the users liking
19

preference.
.
With the drastic changes in the business scenarios today, Transtheoretical
Model like models is required on the dashboard for successful ETO execution
administration program and its need for the type of functionalities. Real time inputs
and data feed is used for further analysis and evaluation on the dashboard, so that
the user is always aware and up-to-date for taking the best and most effective
decisions for a given situation. Dashboard is a dynamic system getting data from
various sources and then combining everything together to a more developed
dashboard and to arrive at a focal point where the user makes the decision based on
this output. Of course, the user can modify the outcome display as per the
requirements.
5. Conclusion
With the ever increasing demand of real time analysis and quick results,
highly interactivity dynamic systems are required to make its merit in these quick
decisions for the profit in the company. SAP BI Tools are the right choice to execute
these plans and the desired results.
For our project where Environmental issues were discussed and checked, the
BI tools were used by the researchers to get the necessary outcomes and the
actions required based on the data collected. Editing, manipulation, adding, etc al l
are possible by using the Dashboard tool for critical analytical decisions.
In this report the business intelligence tool like SAP analysis based dashboard
is evaluated for identify the Earth’s environmental issues.The main problem of the
20

project to be analysed is investigated which determines energy consumption as the
main motive. The descriptive analysis and prescriptive analysis are discussed for
better understanding. The features of a dashboard are well utilised with the key
parameters and also the use of scorecards to give the desired outcomes.
Development of a mobile application was also completed with the QR code
successfully.
Finally, we have successfully developed a Dashboard to answer the growing
environmental issues and the solution for it in respect to energy consumption and
controlled CO2 emissions.
21

References
Analytics, S. (2019). SAP Predictive Analytics - Compare Reviews, Features, Pricing
in 2019 - PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices. [online]
PAT RESEARCH: B2B Reviews, Buying Guides & Best Practices. Available at:
https://www.predictiveanalyticstoday.com/sap-predictive-analytics/ [Accessed 1 Jun.
2019].
Data.gov. (2019). Data.gov. [online] Available at: https://www.data.gov/ [Accessed 1
Jun. 2019].
Data.un.org. (2019). UNdata | explorer. [online] Available at:
http://data.un.org/Explorer.aspx [Accessed 1 Jun. 2019].
Data.worldbank.org. (2019). Environment | Data. [online] Available at:
http://data.worldbank.org/topic/environment [Accessed 1 Jun. 2019].
element61. (2019). SAP Predictive Analytics. [online] Available at:
https://www.element61.be/en/competence/sap-predictive-analytics [Accessed 1 Jun.
2019].
Energy Use and the Environment. (2019). Retrieved from
https://courses.lumenlearning.com/boundless-chemistry/chapter/energy-use-and-
the-environment/
22

Financesonline.com. (2019). 15 Best Business Intelligence Tools For Small And Big
Business - Financesonline.com. [online] Available at: https://financesonline.com/15-
best-business-intelligence-tools-small-big-business/#sapbi [Accessed 1 Jun. 2019].
Guru99.com. (2019). 24 Best Business Intelligence(BI) Tools List in 2019. [online]
Available at: https://www.guru99.com/business-intelligence-tools.html [Accessed 1
Jun. 2019].
JReport. (2019). Business Intelligence Reporting: A Complete Overview – JReport.
[online] Available at: https://www.jinfonet.com/resources/bi-defined/bi-reporting/
[Accessed 1 Jun. 2019].
Open-data.europa.eu. (2019). European Environment Agency | European Union
Open Data Portal. [online] Available at:
http://open-data.europa.eu/en/data/publisher/eea [Accessed 1 Jun. 2019].
SAP.(2019). Business Analytics Solutions | SAP. [online] Available at:
https://www.sap.com/india/products/analytics.html [Accessed 1 Jun. 2019].
SAP.(2019). Business Intelligence (BI) Tools & Software | SAP. [online] Available at:
https://www.sap.com/india/products/analytics/business-intelligence-bi.html
[Accessed 1 Jun. 2019].
23