Business Intelligence Reporting Solution with Analytics

This document discusses the use of Business Intelligence and Analytics in reporting solutions for environmental issues. It covers descriptive and prescriptive analysis, dashboard prototypes, and the design of a mobile application. It also explores the impact of CO2 emissions on the environment and the need for energy consumption reduction. The document highlights the role of SAP Analysis in gaining insights and making intelligent decisions.

University
Semester
Business Intelligence and Data ware
housing
Student ID
Student Name
Submission Date
1

Executive Summary
Our planet, Earth is facing severe Environmental issues and in this project we shall use some
algorithm models and tools including Business intelligence device with evaluated reports and
by using the in-depth analysis with various methodologies. In our pursuit for finding the
solutions for these issues and in the safety of Earth we shall make use of Descriptive analysis
and Prescriptive analysis for further analysis. Development of design models for these
applications we are carried out and making use of the analytical tool, SAP analysis each step
for confirmation. Making use of the intelligent tool of Dashboard we shall conduct this
analysis for the problems related to environment.
Thus we shall give full justice to the Business intelligence reporting results for these issues.
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.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
We shall be making use of the SAP BI (SAP BI (Business Intelligence) is a
platform used by SAP systems to provide an organization with a flexible route to
sharing information that available for the entire organization) as a Business
Intelligence (BI) tool for getting the answers to the problems discussed above. The
reason we are using the SAP BI tool when compared to the other probable tools is,
this provides real time analysis with predictive methodology. This is in addition to the
features that it brings to the table which includes proper planning, machine learning,
analysis, and various other features. With the data collected and all the information
available, after carrying out research and studies on the various organizations, the
Dashboard and the analytical tools that were discussed shall take charge. The data
will then be developed with the help of BI tools like SAP BI. Studies and
methodologies will be considered, especially the various patterns formed, data will
be filtered out and necessary data will extract, and effective strategy will be implied
3

on that. Aiding to understand the data, get in to the insights, data visualisation and
analytics applications, assist in analysis and reporting, office integration, ease of
mobile application, and understand the outcome by application of these tools, not
related to the size and the simplicity of the organisation. This has been the reason
why BI tools are the preferred ones when using them for dashboards. The
environmental factors that are affecting our planet includes but not limited to the
following factors,
 Ozone layer depletion
 Water shortage
 Environmental change
 Pollution
 Deforestation
 Energy consumption
 Rapid urbanization
 Use of auto vehicles
 Over population
 Waste disposal
 And many other reasons.
We have clear signs of the catastrophic scenario where earth is going
towards, especially if we do not keep a check on the above issues which has been
the leading cause of the rapid emissions of the greenhouse gases, CO2 emissions
and thus affecting the temperature and the global warming that it is creating, leading
to overallrapid climatic conditions affecting the planet and finally to us, Humans.
Our project thus has the mission of spreading this awareness and also as the
same time pinpoints the exact causes, manage them effectively, reduce their
occurrences and take steps with the future perspective.
4

1.1 Problem Statement
Global Warming. Greenhouse Gases. CO2 Emissions!! These are the words
that have been creating issues to our Environment. Slowly and steadily, the path is
leading to catastrophic proportions if things are not taken seriously and remedy
measures not implied. With every increasing global temperatures and warming of the
earth, affects everything around use and also to us, human beings. Steps have to be
taken stop global warming and minimizing the ozone depleting substances/gases.
One of the main reasons for the increase in global temperatures is the
uncontrolled emission of CO2 gas, whether that is from fossil burning, excessive
auto vehicle usage or even energy consumption. These and various other factors,
small and big contribute to the CO2 gas emission (Das, 2014). The Solar energy and
heat gets trapped in the earth’s atmosphere and these gases are the reason behind
this phenomenon. It’s not only CO2 gas, but there are other various gases,
Chlorofluorocarbons (CFCs), Hydrochlorofluorocarbons (HCFCs),
Hydrobromoflurocarbons (HBFCs), Halons, Methyl bromide, Carbon tetrachloride,
Methyl chloroform, etc.
Thus we shall use a Dashboard to address all of the above problems and to
give a solution for this environmental issue.
1.2 Objectives
Below are the targets of conducting this project,
a) To conduct descriptive analysis
b) To conduct prescriptive analysis
c) To resolve the energy consumption issue.
5

d) . To design a predictive analytical application
e) To identify the carbon dioxide causing factors and its influence on our
environment (Bag, n.d.).
1.3 Environmental Issues
In the previous chapter we have seen how the CO2 and other Ozone
depleting gases are destroying the Ozone layer with increasing the global
temperature. Now, research has shown us that Global warming does not happen
only because of this factor. There are other causes and issues that contribute to this
phenomenon (GARCIA MARQUEZ, 2016).
Various Institutes and Research facilities are conducting research and studies
on this topic worldwide to determine the other factors that affects the Global
temperatures and increasing warming conditions. With the aid of real time evaluation
and continuous data set updates, it has been found that High energy consumption is
one of the biggest threats to global increase in temperature (Open-data.europa.eu,
2019). Our energy production and use is interconnected with many other aspects of
modern life, such as water consumption, use of goods and services, transportation,
economic growth, land use, and population growth. Our production and use of
energy (most of which comes from fossil fuels) also contributes to climate change,
accounting for more than 84% of U.S. greenhouse gas emissions. Research has
proved that these issues and the drawbacks are related to unnatural events.
Everyone has to make an effort in the right direction so as to reverse this trend and
the harmful activities on nature or else the day will not be far off when our inactions
today will result in Catastrophes in the days to come.
Now on the other hand, taking steps does not mean that there is a switch and
just by putting it on “Off” mode will reverse all these ill effects. There has to be a
collective step from every individual, every family, every organization, every industry
6

and every government, to the contribution of restoring back the harmful effects we
have done on nature. Together with solid planning and result oriented steps will lead
us to a much better tomorrow with, minimum effects on our Environment and finally
on our planet (Data.un.org, 2019).
Impact of CO2 Use on Environment
Throughout the years we have created a ton of gas, oil and coal for the
utilization of our day by day lives. With the creation of those materials, CO2 outflows
get into our perfect air and cause an undetectable layer around the earth. This layer
keeps the heat inside the earth so to state, and that cause’s worldwide warming.
New sort of atmospheres will show up in different nations. New sort of temperature,
for example, a lot colder or way more sweltering will emerge. Additionally, the
measure of precipitation will rise comprehensively and extraordinary climate will
happen all the more regularly. Desertification will emerge and the ripe ground will be
lost. This implies increasingly dry zones will show up in nations where it is as of now
extremely hot. Fermentation will emerge. This implies seawater will get progressively
corrosive and in the long run will influence the coral reefs and species that live there.
All these are real and imminent dangers to our environment and to us. Steps
have to be taken and immediately. For this the Nations and their governments have
to step their efforts and initiation. Awareness, spreading knowledge, steps to involve
local people, companies, industries, business sectors etc to this common agenda is
required. Only individual or a few organizations will not result in the required
outcome. Government involvement is a must. Traditional fossil fuels, cause lot of
greenhouse gases, contributing immensely to the global warming and increase in
temperatures. More research and efforts have to be made for alternate, cleaner and
reusable energies like Solar Energy, Hydro power, Wind Energy etc.
7

Figure: Energy usage globally
From the above given graph, we can clearly deduct that climate change and
energy consumption are directly proportional to each other. Deforestation and
burning of fossil fuels have contributed the most to the vast and ever increasing
greenhouse gases.
8

Figure: Emission of carbon globally by different energy sources ("Energy Use and
the Environment", 2019)
The below given points have to be implemented for saving the Earth’s
environment:
a. Energy consumption
b. Facilitate the utilization of solar energy.
2. Business Intelligence Reporting Solution with the help of
Analytics
The business intelligence dashboard is used to interface the business
intelligence software which is used to provide the pre - configured and customer
defined metrics, insights, data visualization and statistics for selected data. It is allow
9

the end users to view the instant results in to the live performance state of data and
business analytics. It is designed to allow users to view the data visualization of their
preferred business intelligence operations, eliminating the requirements for manually
executed the processes and queries. Reporting and getting the right feedback and
decision making is important in the BI Dashboard. Various tools are used on the
Dashboard, for analysis and also the get a simple and clear picture of the various
data that goes into this evaluation (Ask, 2013).
2.1 Descriptive Analysis
The descriptive analytics is used to describe and summarize the selected
data. Generally, it involves to organizing and summarising the data which is used to
provide the easily understand about the data. It is a inferential statistics and it seeks
to describe the data but it do not attempt to create the inferences from the sample to
the whole population (Pope, 2017). Here, we typically describe the data in a sample.
Patterns from past data are studied and evaluated for current sample data sets. They
are easy and simple to use with minimum technical background requirement.
Tableau, QlikView, Google Analytics etc are some of the popular and widely used
Descriptive Analysis tools for data research (Abbott, 2014).
The display after using the above mentioned tools can be as per the users’
choice, like graphical, tabular, bar charts etc. There is flexibility in the usage of the
this tool for the required display (Pyne, Rao and Rao, 2016).
2.1.1 Dashboard
Dashboards can be of three types, namely, strategic, tactical, and operational.
Below is the brief description for each of this type (Data.gov, 2019),
 The operational dashboard is used to shows what is happening
now.
10

 The Strategic dashboard is used to monitor the key performance
indicators.
 The Analytical dashboard is used to use the process data which
is used to identify trends.
These are customizable as per the user’s choice and can be similarly named
as pet their requirement (Mendoza, 2010).
We shall be taking a case study of Energy usage of a building in USA to
demonstrate the ability and usage of a BI Dashboard (Baesens, n.d.). The name of
11

the building in our case study is "Zion Dado Building”. If you see the above
dashboard, lot of information has been provided and data like benchmarking,
monthly energy consumption, previous and current energy usage and temperature is
displayed, giving the user a far better picture and understanding of the whole
scenario. Like the case of 35,600 is the benchmarking, which has achieved 2, 812,
5675.
2.1.2 SAP Analysis
SAP Analysis helps you to gain insight into business data and make intelligent
decisions that impact corporate performance. It’s a powerful tool which plays multiple roles in
the system like such as data management, analytical tool, data restructuring, data
filtration etc (DuttaRoy, n.d.).
We shall consider the below bar diagram as an example for studying the SAP
Analysis function. The data has been for the period from 2012 to 2016 for CO2
emissions. In 2016 the CO2 emissions was 380 kilotons while in 2013 it was at 545
kilotons. The following graph illustrates the estimated CO2 emission in the specific
period.
12

2.2 Prescriptive Analysis
The analytics of predictive is a critical advancement in business
analytics. It is sued to improve the decision making and its process
effectiveness and it also helps us get closer to truing the expected
outcomes to specific situations. Basically, the predictive analytics is use
the modelling and statistics to determine the future performance based
on historical and current data. It creates the business to make the better
decisions bout how to manage and handle the specific situation by
factoring in knowledge of possible situations, past performance, what is
currently happening and available resources.
13

2.2.1 Dashboard
A Dashboard is a data management tool, which is graphically representing
graphs, charts, diagrams, etc to track outcomes, evaluate results, identify important
parameters called “Key Indicators”, study them and finally interpret all of the above to
give the result to monitor the health of a business, department or specific process
(Data.worldbank.org, 2019).
Figure: Consumption by Sector
We have considered the above example of Energy consumption to explain the
concept of Dashboard. We can clearly see in the above diagram where $47.97B is
the total arrangements and 48.00B KWh is the total energy consumption.
2.2.2 SAP Analysis
Next we shall use the SAP BI tool to explain how the auto vehicles have
contributed immensely in increasing the CO2 emissions and thus the greenhouse
14

effect on the planet. The below chart, helps to evaluate the SAP objects
(Bakhshaliyeva, n.d.).
A BI Dashboard is a tool which visually displays the data which it has evaluated
and analysed out of the raw data that had been collected to give the required output
as per the user’s requirement (Barua, n.d.). The features on a Dashboard include
Performance key indicators, Graphs, Bar diagrams, etc to assist organization,
department, team or process in better understanding their structure in terms of the
parameters so displayed (Chabert et al., n.d.).
2.3 Dashboard Prototype
A dashboard created has the following features:
1) For breaking down the data it shows a bar outline.
2) A graphical representation it becomes easy to understand the data..
3) Country, city, state name and date can be taken as parameters to
filter out the data.
4) The location of the site is shown, including the details like name,
type, country, address and the domain of the region (in square feet
unit).
15

5) The consumption of energy based on building/ organization in a
specified location is the example that we have taken for the above
dashboard (O’Neill, 2011).
6) To ease with the dates, it facilitates the users with always
accessible calendar.
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) For measuring the consumption of energy, Kilowatt hour (Kwh) is
used.
9) .Dashboard also displays the selected location’s atmosphere status.
10)Various devices can be connected to the system for sharing the
dashboard and thus the information
11) Dashboard allows checking the status of the conditions at any time.
12) Analyzing of real time data is very much possible.
13)Selection of key markers is done for the dashboard
14)To give the most accurate information, it is always .online receiving
data from the net
3. Design of a Mobile Application
Based on the principle of Predictive analytics application and activated by a
QR Code, the mobile application displayed below assists in understanding the
environmental issues facing us today.
16

17

This represents the real QR code.
4. BI Reporting Solutions Justified forReducing Environmental
issues
For make fast and quick critical decisions, BI tools display the evaluated data
in a very easy format to easily understand it. Assisting the end users to evaluate the
end result displayed on the dashboard, the Business intelligence reporting tool is
very vital and helpful. Reporting of data plays an important role for the tool as it helps
in making all these important decisions (Walker, 2013). Data collected is compared
with the historical data by the Business Intelligence for further study and evaluation.
As the tool is very user friendly and easy to comprehend, the end user can on its
own do the analysis of the data for further usage and decision making. This makes
the end user understand what are the most vital and important parameters required
which influence the data and thus the decision making (Nabavi and Olson, 2019).
18

Some of the actions which are required to be carried out for minimizing the
damage being caused on the environment are mentioned below,
a) Efficient utilization of energy.
b) Implement standard measures to decrease the release of Carbon
dioxide from different organizations and sources.
c) Planting selective plants,which hold the carbon dioxide.
d) Government must enforce strict rules to cut down emission from the
vehicles.
e) Increasing awareness about energy consumption and its impact to the
planet earth.
Data mining strategy is made use of for finishing the requirements of the BI
tool. The scorecard for reviewing different parameters of the data pool and the
dashboard combine together for the benefit of the organization. As per the end users
liking the parameters are selected for the making of the scorecard. It combines the
data and gives it in a more friendly and readable manner for the end user.
T he Transtheoretical model of behaviour change is an integrative theory of
therapy that assesses an individual's readiness to act on a new healthier behaviour,
and provides strategies, or processes of change to guide the individual. The
dashboard uses this same principle and combines it with the ETO execution
administration program. With the rapid increase and modifications in today’s
business world this is essential (Miller, 2015).
With real time analysis and data being fed to the system, the display screen is
always kept update and ready for use with the required results. Data of a particular
topic or area to be analysed is thus monitored in real time. The actual net result is
given after getting all the required data from different sources and then combining/
evaluating it together. There is a viable parameter used in the dashboard, which
19

helps the person to keep a tab on the outcomes and modify the data and/or the
parameter so that the desired results can be achieved (Isson and Harriott, 2013).
5. Conclusion
With the highly competitive world of businesses and corporates, everyone
requires a dynamic data system. By the aid of SAP BI tools, this reporting based
system can achieve this by presenting a highly interactivity system for quick
research, modifications, editing, manipulating, saving of data, and analytical problem
solving decisions. Thus this is an immense help to the business houses and
companies who require such fast making decision models.
Our project had started with the aim of reducing and addressing the
environmental issues that our planet is facing today. With the help of Business
analytical tools like SAP analysis and intelligent display tool Dashboard, we have
been able to express the issues that are concerning to our problem. We have done
research and discussed as to how, energy consumption has become a big factor in
this environmental issue. We took further help from specialised tools like descriptive
analysis and prescriptive analysis, for further evaluation and research and helping
the dashboard to give the entire scenario of our topic. Further to this, a mobile based
application was developed for this task. Thus, the pollutions like air, water, reduction
of the ozone layer, reduction of energy consumption etc will aid in our task by
reducing the energy dependency and consumption, bringing energy saving expense
to industries and overall, helping Mother Nature and our Environment to a better,
cleaner and healthier planet.
20

References
Abbott, D. (2014). Applied predictive analytics. Indianapolis: Wiley & Sons.
Ask, U. (2013). Business Intelligence Practices. International Journal of Business
Intelligence Research, 4(2), pp.1-18.
Baesens, B. (n.d.). Fraud analytics using descriptive, predictive, and social network
techniques.
Bag, D. (n.d.). Business analytics.
Bakhshaliyeva, N. (n.d.). SAP Predictive Analytics.
Barua, A. (n.d.). First Steps in SAP Predictive Analytics.
Chabert, A., Forster, A., Tessier, L. and Vezzosi, P. (n.d.). SAP predictive analytics.
Das, S. (2014). Computational business analytics. Boca Raton, Fla.: Chapman &
Hall/CRC.
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].
DuttaRoy, S. (n.d.). SAP Business Analytics.
GARCIA MARQUEZ, F. (2016). ADVANCED BUSINESS ANALYTICS. [Place of
publication not identified]: SPRINGER INTERNATIONAL PU.
Isson, J. and Harriott, J. (2013). Advanced business analytics. Hoboken, N.J.: John
Wiley & Sons.
Mendoza, R. (2010). Business Intelligence 2.0. International Journal of Business
Intelligence Research, 1(4), pp.63-76.
21

Miller, T. (2015). Modeling techniques in predictive analytics. Upper Saddle River,
NJ: Pearson Education.
Nabavi, M. and Olson, D. (2019). Introduction to business analytics. New York:
Business Expert Press.
O’Neill, D. (2011). Business Intelligence Competency Centers. International Journal
of Business Intelligence Research, 2(3), pp.21-35.
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].
Pope, D. (2017). Big Data Analytics with SAS. Birmingham: Packt Publishing.
Pyne, S., Rao, B. and Rao, S. (2016). Big Data Analytics. New Delhi: Springer India.
Walker, M. (2013). Software development on the SAP HANA platform. Birmingham:
Packt Pub.
22