Business Intelligence Reporting Solution with Analytics

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