Business Intelligence and Data Warehousing

This project focuses on the use of descriptive and prescriptive analysis to tackle environmental damage caused by carbon dioxide and energy consumption. The report utilizes a business evaluation methodology and a powerful business intelligence tool, the Dashboard, to analyze and improve environmental protection. The report also discusses the effects of carbon dioxide on the environment and proposes a BI reporting solution with analytics.

University
*** Semester
Business Intelligence and Data
Warehousing
Student Name:
Register Number:
Submission Date:

Executive Summary
In this project we shall be making use of the Descriptive and Prescriptive analysis and
use the results for tackling the issue of Environment damage and how it is affecting our
planet Earth, by making use of Dashboard, which is a very powerful business
Intelligencetool. We shall be making this report on the study and research work done on
Carbon Dioxide and Energy consumption and its effect on the environment by using a
business evaluation methodology with a creative analytical point.
Real time study and analysis shall be carried out and identification of the primary
execution markers will be carried out to assist the dashboard with all the outcomes and
steps to improve the protection of our environment.

Table of Contents
1. Introduction...................................................................................................................................................... 1
2. Problem Statement.......................................................................................................................................... 2
3. Environmental Issues...................................................................................................................................... 2
4. Effect of Carbon dioxide’s Use on the Environment....................................................................................3
5. BI Reporting Solution with Analytics.............................................................................................................6
5.1 Prescriptive Analysis....................................................................................................................................... 6
Dashboard.............................................................................................................................................................. 6
5.2 Descriptive Analysis........................................................................................................................................ 7
Dashboard.............................................................................................................................................................. 8
5.3 Dashboard’s Prototype.................................................................................................................................. 10
6. Design Mobile Application............................................................................................................................. 11
7. Justification of BI Reporting Solution to deduct Environmental issues in the Organizations...............14
8. Conclusion...................................................................................................................................................... 16
References................................................................................................................................................................... 18

1. Introduction
Global Warming. A term frequently heard and used in today’s world. So, what is
Global Warming? The unnatural heating up of our planet due to the excessive increase
of the trapped thermal energy caused by the various “Greenhouse” gases including
carbon dioxide By making use of some very good methods like Prescriptive
examination and Descriptive examination, we shall use the Dashboard to represent our
project about these environmental problems. Students shall be encouraged to use the
innovativeness of SAP Business Object or Predictive Analytics application to create
investigation plans for the testing business analysis. The idea of using the above tool is,
to pinpoint the real problems facing the environment problems and getting a positive
acknowledgment with response all being carried out by the use of the Dashboard tool.
With the problem lying in the energy consumption, focus shall be to highlight and have a
in-depth look at the environmental issues by utilizing logical tools to make analytical
observations and outcomes. The most important factors that are influencing the
changing environment today are,
 Water scarcity
 Ozone depletion
 Substance transmission
 Pollution
 Use of Energy
 Changing Climate
 Loss of biodiversity
 Dangerous air deviation
1

 Deforestation
 Disposal of waste
 Overpopulation,
 General restorative issues
 Environmental resource depletion
 Ozone layer depletion,
 Acid rain
 Acidification of the Ocean
 Contamination of water etc
Awareness has to be created among all people about the effects of all the above factors
on our environment and how this can lead to a catastrophic situation in the near future.
The rapid cooling and warming periods in short span of time, is resulting in specific
climatic changes which will head into a crisis situation.
By the aid of the Dashboard tool and its features like execution markers, we shall
present this report with evaluation on the basis of descriptive and prescriptive methods
to highlight the excessive overuse of CO2 gas and is harmful effect on the environment
and ultimately on our Planet.
2. Problem Statement
The biotic and abiotic surroundings for us and also the environment in particular
have been severely affected by our actions which had led to the over emission of the
CO2 gas in the environment. This has caused all major problems like Global Warming
and we still have not been able to grasp the gravity of this problem.
2

This Research paper has tried to highlight this issue of over emission of CO2 gas,
its ill affects to the environment, animals, planets and us. Lot of expectations is from the
various Governments, Environment organizations, Corporate world, Business
community and people like us to step and give remedies and take concrete steps to
reduce this burden on the planet. Awareness about the high energy usage and how this
causes problems to the planet has to be highlighted on various Medias. With the help of
the Dashboard tool this can be displayed in a graphical manner for easy understanding
and quality information ("3 Biggest Ways to Reduce Your Environmental Impact", 2018).
3. Environmental Issues
As our planet is being threatened and abused by the various ill-effects of human
activities, it is vital to get to the root of all these issues. Global warming is one of the
factors contributing to the problem but, there are far greater threats affecting more to the
environment. And we have been ignorant of this. Like high energy usage which is a
major threat to the increasing temperature and warming of our planet. The problem is
that global warming has been affected by all these activities being carried out all over
the world, some being minor and some larger. We have to take positive actions to
minimize these dangerous factors so as to reduce their impact or else the day won’t be
far off when our planet will be in total Environmental crisis.
Individuals and families have to come together and start with taking steps to
reduce this harm to the nature. Like reduction of the Ozone layer. This can be done by
less use of vehicles, harmful chemicals and gases etc. ("Business Intelligence
Dashboard", 2018). There can be a marked improvement and reduction of these
3

harmful substances that affect the concentration of the Ozone Layer. Coming together
to make positive changes, from all of us and the families will see a much better and
concentrated Ozone layer Protection than what it is at present level.
4. Effect of Carbon dioxide’s Use on the Environment
Government has been trying from its side to raise awareness and distribute the
knowledge as to how the CO2 emissions from day to day activities have been affecting
the environment structure, families, society, animals, businesses etc. Taking a cue from
this, there are a number of organizations contributing and researching to find solutions
as to how to minimize the CO2emissions in to the atmosphere, as part of their social
responsibility (Living, 2018).
The top level executives and the management team has to consider and develop
the regard chain with factors like, inbound/ outbound coordination's, marketing,
assignments and various offer benefits. The factors that will contribute to the potential
climatic changes can be the outburst in the regard chain which is basically due to the
4

the fundamental extent of benefits. Will it be beneficial to start with $10 for each ton of
release or will it be an essential part for new cases?With the quantity of CO2 emissions
being released into our atmosphere by the outcome of individuals and organizations,
the danger signs have already been reached. Called as “Carbon Footprint”, it is an
important tool to measure the impact on the planet. Individuals, families, institutes and
industry in general should work towards reducing their Carbon footprints by planting
more trees, using fewer vehicles, less energy usage etc.
Regard chain can be distorted or encouraged, as per the releasing impact of the
activities. The channels, customers and the supplier firms should encourage new
releases along with the developing quick control by the organization. Organization along
with their partners should understand the importance of creating essential results. With
the introduction of the daytime supply chains, with their transportation-concentrated
activities have dynamic implications for the advancing back to front impacts. They may
not work in the practical world as there are simply more extravagant releasesunder the
wire stock organization structures. Going against the trusted to goodness limits, the
electronic business with the involvement of the duplication of its small shipments. Same
way, the cut down surges for shoring to get near the collecting of the suppliers,
increases the releases by maximizing the transportation and the frequent offshoring.
To minimize the general effects of energy consumption, various procedures can be
accessed, like:
1) Use of alternative energy like solar energy.
2) Reduction in the energy usage.
5

Proficiency, Effectiveness with its outcome in terms of heat/ power and, Energy
sustainability are the factors to look forward in Solar Energy usage. For identifyingthe
ideal energy source, the following factors have to be considered,
 There should be a reduction of air pollution by its usage.
 Reduce the energy consumption bills.
 Reduction in the ozone-reducing elements/ gases/ substances.
 Economically it can benefit the nation as employment will increase for
establishing this new technology.
 Should give better security and quality by its usage.
5. BI Reporting Solution with Analytics
5.1 Prescriptive Analysis
Prescriptive analytics is utilized to find the best result or outcome among various
choices, given the known parameters by making use of the successful results and then,
restricting and rebuilding them. The right direction and plan is developed by taking these
specific outcomes and getting a more effective, adaptive and sensible solution. The
issue and the problem will be solved amicably by this analysis method as it also gives
the reason and the logic as to how it came to the final conclusion.
Dashboard
The Business Intelligence Dashboard tool on a website makes it possible to give
a visual display of all the Key Performance Indicators and other vital parameters from
the analysed data of the organization. Used by the top management for future planning
6

and effective outcomes, with practical methods to achieve the same. Using multiple
tools and procedures (e.q discerning execution declaring system), the result and the
display are pre-verified before they are sent to the graphic display.
Figure: Sector’s Consumption
48.00B KWh is the total usage and $47.97B is the total arrangements which are
represented in the above dashboard. The Dashboard also gives the figures for the force
cuts and ordinary length of power cuts along with the division arrangements with the
required figures in the display. The Dashboard also has other vital information like a pie
chart depicting all the energy sources like coal, natural gas, nuclear energy and
renewable. The data was collected for a period of 1 year, from Jan’2016 to Dec’2016.
The other bar chart gives the information about the sector wise consumption of this
energy like, industry, private, traffic and others.
5.2 Descriptive Analysis
They are the simpler type of analysis method, using the simplest data features for
7

evaluation, analysis based on the simple graphs, filtering the rough data and are the
base for any of the data quantitative analysis. A more clear understanding and clear
approach is given by this analysis results ("Descriptive, Predictive, and Prescriptive
Analytics Explained", 2018). Same as a “A year”, this analysis clarifies the “A minute"
time, passed off as a year. Assisting the customers to know the basic elements of the
diverse purpose of the test, they make the difference by utilizing the past behavior. The
future of the outcome shall be decided by the effective acknowledgment of this
clarification ("Designing and Building Great Dashboards - 6 Golden Rules to Successful
Dashboard Design | Geckoboard", 2018).
Dashboard
The features of the Dashboard are given below:
 The bar outline is reference to the data in the dashboard.
 Anytime the dashboard’s calendar can be used.
 Real time details, with the help of internet, are provided on the dashboard.
 The name, country, type, zone's region and address (in terms of square feet
unit.) is displayed for any required location
 On the dashboard, the location’s climate details can be found.
 Accessibility to the filtered data.
 Country, state, city and date are the factors in which the data is filtered.
 The utilized energy is displayed and addressed on the dashboard
 It shows the benchmarks, current and previous month's energy usage,
including temperature.
 Consumption of energy is given in Kilowatt hour (Kwh) unit
8

 There is no restriction of using any key markers.
 Pre-selected devices can access and share the necessary information.
9

10

For the above dashboard we have considered the energy consumption for a
building in USA, whose name is "Zion Dado Building." It has well passed the dashboard
level of 35,600 by reaching the value of 2, 812, 5675. Below are the figures for the
energy consumption for the present and previous month,
Previous month Current month
7am ~ 8 am 6 pm ~ 10 pm 7am ~ 8 am6 pm ~ 10 pm
7.45% 20.12% 8.25% 100%
("Causes and Effects of Environmental Pollution", 2018).
59.89 0Fahrenheit was the general temperature for the month ("Getting Started:
Introduction to the Business Intelligence Center", 2018).
5.3 Dashboard’s Prototype
By understanding, managing, extracting and analysing the data, the Dashboard
Prototype gives a more graphical image and representation of what the result is. The
environmental problems and issues, and the solution for the same can be displayed by
this dashboard prototype. With a detailed review and analysis of the collected data, the
dashboard prototype play a vital role by making use of the various features like
executions and markers to specify the executions as per the time frame (like year,
month, week or day) and isolate them from the common executions by using analytical
methodologies. The most vital and important necessities of the organization are
displayed on the dashboard and are called as the key execution markers/ pointers.
Below are the features of the dashboard("Ten key elements for effective dashboard
11

design", 2018):
 The bar outline refers to the data from the present dashboard figure.
 Access can be done anytime for the dashboard’s calendar.
 All the details on the dashboard are real time with the help of internet
 Name, country, type, zone's region and address (in terms of square feet Unit.)
can all be observed successfully for any given location.
 With the aid of a dashboard, climate pertaining to the particular location can
be searched.
 Accessibility to the filtered data is very much possible.
 The country, state, city and date play their role for the filtering of the data.
 The utilized energy has been identified by the dashboard addresses.
 The benchmarks, current and previous month's energy usage, including
temperature and the benchmark levels are all displayed on the dashboard.
 The consumption of energy is given in Kilowatt hour (Kwh) unit.
 Choosing any of the key markers is possible.
 Pre-selected specific devices can access the shared information.
6. Design Mobile Application
The Mobile application specifically designed to address the problems that the
environment is facing is displayed in the below images. Developed by using the QR
code, the name of this mobile application is Predictive analytics.
12

13

The below image shows the QR code for the mobile application ("The National
Academies presents: What You Need to Know About Energy", 2018).
14

7. Justification of BI Reporting Solutionto deduct Environmental
issues in the Organizations
We shall now discuss the possible solutions and recommendations that will
address the problems that our planet and environment is facing today.
Below factors will improve the environmental issues’ execution:
 Different organizations and industrial firms should take concrete and firm
efforts for decreasing the total release of CO2.
 Energy should be used efficiently.
 Grow more trees and plants for reducing the CO2 emissions
 Utilise less the devices and the office machinery.
15

 Check the machine’s energy viability that are utilised in offices.
 Increasing the awareness among the management , executives and
employees in general on the impacts of energy wastage and its impact to the
earth("The Roles of Dashboards and Scorecards - Social Solutions", 2018).
Used and working like a Data mining strategy, the specific and particular courses
of actions can be planned out by this business Intelligence tool and an effective data
analysis can be carried out on it. The multifaceted nature to understand the data has not
been taken into consideration and this is carried out by the data portrayal decision of the
dashboard. The business could definitely improve by assisting the dashboard. It is
applied for keeping a check on the executed and applicable management, which the BI
makes use of, this is in addition to the streamlining of the essential administration
process. For this entire procedure there is a dashboard certification. In cases where the
data based course has been declared, the dashboard displays its effective usage in
perspective of its assessing impacts. Amending and changing the Transtheoretical
Model can be carried out by the ETO execution administration programming on the
dashboard. Change in the required organization can be carried out in the periods of
advancement that are realized. To understand the disapproved of consistently, there
shall always be a persistent screen on the dashboard. Read outs will be displayed for
the reviews of various parts of the data pool in the outcome of a scorecard. Taken as
quantifiable between the organization, people and times, the scorecards are used for
this specific purpose. A fine tuning between the dashboard and the scorecard helps in
giving all the important and vital information to the user.
16

The importance of filtering out from the vast amount of data collected and, gives a
meaningful and effective output is vital for any analytical tool. The dashboard and the
scorecard, both have to work on knowing where the positive data information lies,
recognizes and modifies endorsed techniques and the learning mechanical assemblies
give assistance in this respect to them. Building an exceedingly total gathering of impact
acknowledgement which benefits the WIA itemizing and raising help activities,
dashboards are very effective tools for the organizations and their outcomes helps the
companies in profit building("Types of Analytics: descriptive, predictive, prescriptive
analytics", 2018). Easily and in quick time, the dashboards can display the best
outcomes and results after extracting data from different sources, modifying, blending
and then giving the required specific viewpoint. They also help in sharing the vital
outcomes and also data to a pre specified group of individuals and devices. In a
graphical output which is user friendly, dashboard serves minute to minute details from
all the various inputs, right from single users to big organizations. The examiner and the
final evaluator can see the outcomes and the missing outputs, to further develop and
select specific features so as to get the desired outcome and the accomplishments.
There can be modifications and further additions to the dashboard to get the more
specific result for the dashboard.
17

8. Conclusion
At last with the help of a dashboard, we have successfully completed our project
of the prescriptive analysis as well as the descriptive analysis for finding all the factors
that have harmed our environment and thus our planet.We have discussed about some
of the problems which were unlooked and ignored but are proving to be more
dangerous to the environment like increasing emission of CO2 in the atmosphere. We
went in-depth in our analysis as to how all these factors with the activities of us, humans
is leading to a catastrophic situation for Earth. The important and immediate effective
steps to be taken, not only by every individual but also by the organizations,
governments, firms, and industries to address this problem head on. Data has to be
collected efficiently for analysis to be carried out and the output of the results can be
displayed on a dashboard for further sensible and effective mode of action. We studied
the effects of CO2 gas release by various activities including burning of fuel, enormous
usage of energy, etc and how this distorts the environment, affects the land, water, air
etc. We used some specific analytical tools and procedures to extract information and
study them, developed a business Intelligence model and finally combining all these
data into a dashboard to get the result and a solution for the same. The dashboard, with
the aid of execution markers, helped us to understand how CO2 gas affects the
association business technique, how CO2 gas can be minimized and in future controlled
so that its impact to the environment and to our lives is minimized.
18

References
3 Biggest Ways to Reduce Your Environmental Impact. (2018). Retrieved from
https://www.eomega.org/article/3-biggest-ways-to-reduce-your-environmental-
impact
Business Intelligence Dashboard. (2018). Retrieved from
https://www.klipfolio.com/resources/articles/what-is-business-intelligence-
dashboard
Descriptive, Predictive, and Prescriptive Analytics Explained. (2018). Retrieved from
https://halobi.com/blog/descriptive-predictive-and-prescriptive-analytics-explained/
Designing and Building Great Dashboards - 6 Golden Rules to Successful Dashboard
Design | Geckoboard. (2018). Retrieved from
https://www.geckoboard.com/blog/building-great-dashboards-6-golden-rules-to-
successful-dashboard-design/
Getting Started: Introduction to the Business Intelligence Center. (2018). Retrieved from
https://support.office.com/en-us/article/Getting-Started-Introduction-to-the-
Business-Intelligence-Center-2EA9253A-5B61-4065-B6E3-7A981BB8D90D
Living, S. (2018).Reducing environmental impact. Retrieved from
https://www.unilever.com/sustainable-living/reducing-environmental-impact/
Ten key elements for effective dashboard design. (2018). Retrieved from
https://searchbusinessanalytics.techtarget.com/tip/Ten-key-elements-for-effective-
dashboard-design
The National Academies presents: What You Need to Know About Energy. (2018).
Retrieved from http://needtoknow.nas.edu/energy/energy-costs/environmental/
The Roles of Dashboards and Scorecards - Social Solutions. (2018). Retrieved from
https://www.socialsolutions.com/blog/measuring-impact-effectiveness-roles-
dashboards-scorecards/
19

Types of Analytics: descriptive, predictive, prescriptive analytics. (2018). Retrieved from
https://www.dezyre.com/article/types-of-analytics-descriptive-predictive-
prescriptive-analytics/209
20