Business Intelligence Reporting Solution or Dashboard?

Assignment 1: Business Intelligence and Data Warehousing Name: Register No.: Guide: Date: Executive Summary The spot light of this research is on Business intelligence (BI) reporting solution or a dashboard. The project will help the students to present their innovation and creativity in applying SAP Business Object or Predictive Analytics, for designing useful visualization solutions and to present the predictive models for various sorts of analytic issues. For instance, water reduction, energy consumption, climate change, greenhouse gas emission, carbon footprint, pollution dashboard

Assignment 1: Business Intelligence and
Data Warehousing
Name:
Register No.:
Guide:
Date:

Executive Summary
The spot light of this research is on Business intelligence (BI) reporting solution or a
dashboard. BI is an information management tool, which is utilized for tracking the
metrics, KPIs, and other important data points that are appropriate for the business or
for any particular process. The data visualization in the dashboard simplifies the
complicated data sets. The research ensures to review and examine the environmental
issues. Subsequently, the scope of report is that the senior executive is interrogated for
making arrangements for the meeting with the board of association. Before, the
commencement of this meeting, the senior executive is required to present the
prescriptive and descriptive analysis reports. The analysis determines the issues to be
improved in the environment.

Table of Contents
1. Introduction........................................................................................................................................................... 1
1.1 Case Study........................................................................................................................................................ 1
1.2 Scope of the Solution...................................................................................................................................... 2
2. Energy Consumption........................................................................................................................................... 2
2.1 Impact of Electricity on Environment.............................................................................................................5
3. Selected Analytics................................................................................................................................................ 6
3.1 Prescriptive Analysis....................................................................................................................................... 7
3.2 Descriptive Analysis...................................................................................................................................... 10
4. Dashboad and its Explanation..........................................................................................................................12
4.1 Solution Overview.......................................................................................................................................... 14
4.2 Prototype of the Business Intelligence Application using Dashboard.....................................................14
5. Logical Recommendation to Improve the Environment.................................................................................16
6. Conclusion.......................................................................................................................................................... 18
References................................................................................................................................................................... 20

1. Introduction
This report projects on the business analytics project, for generating innovative
analytics solutions. The project will help the students to present their innovation and
creativity in applying SAP Business Object or Predictive Analytics, for designing useful
visualization solutions and to present the predictive models for various sorts of analytic
issues. Environmental issues is the discussed topic in this report, by using the business
Intelligence tool like, Dashboad. The important task of this report is to apply any of the
analytical tools for developing innovative analytics visualization solutions and predictive
models based on environment. For instance, water reduction, energy consumption,
climate change, greenhouse gas emission, carbon footprint, pollution dashboard and so
on.
The objective of this research is to have hands on experiences of using SAP
Analytics tools for exploring, extracting and analyzing the data of the enterprise.
Appropriate models will be drawn. Two different types of analysis such as Descriptive
analysis and Prescriptive analysis will be conducted in this report. The prototype of the
business intelligence will be designed for the application design. The key performance
indicators will be analyzed using the Dashboard, which will be created using an
appropriate tool. Depending on the BI analysis and gained insights with the help of data
set, logical recommendations will be made to improvise the environment. Justification
for the BI reporting solution/dashboard will be provided.
1.1 Case Study
This case study is related to environmental issues. The environmental issues can
be energy consumption, climate change, greenhouse gas emission, carbon footprint,
pollution dashboard, and so on. In this report the business Intelligence tool like,
1

Dashboad is used for the help. The purpose is to improve visualization related to
analytics and to predict the data set depending on the environment. In this mainly water
reduction is concentrated.
1.2 Scope of the Solution
The senior executive is interrogated for making arrangements for the meeting
with the board of association. Before, the commencement of this meeting, the senior
executive is supposed to provide the prescriptive and descriptive analysis reports. The
meeting will talk on the accessibility of database information and what monitoring and
quick solutions can be supported for the encountered environmental issue. Therefore,
the proposed system must be capable of finding the issues which are important to be
noticed by the board members. Further, it needs analysis to act on the administration
part for improvements in the environment. Therefore, this report will help the company’s
senior executive for their meeting.
2. Energy Consumption
During 2000 to 2016, the United States of America's energy consumption has
increased. The year 2016 saw huge energy consumption, and has also resulted in high
consumption of natural gas and petroleum. Moreover, the industry sectors has
increased its electric power demands. ("U.S. energy consumption rose slightly in 2016
despite a significant decline in coal use", 2017).
2

Figure: Energy consumption in the United States of America
The coal consumption has become low with 9% and has increased the renewable
energies like petroleum, nuclear fuel and natural gas. The highlight is that the United
States is largest energy consumer in the world.
3

Figure: Information of Energy consumption, according to 2017 reports
4

Figure: In 2016, Energy consumption (Dutton, 2018)
Figure: In 2016, Energy Generation ("About the U.S. Electricity System and its Impact
on the Environment", 2018)
2.1 Impact of Electricity on Environment
Though electricity is clean and is safe comparatively with other forms of energy,
the environment is affected due to the electricity generation and transmission. However,
every single electric power plants has environmental impact, especially the certain
power plants have higher impact. In the United States of America, the government has
passed certain laws which see to it that the impacts of electricity generation and
transmission are governed, to secure the environment. The Clean Air Act regulates the
emission of air pollutant emissions from several power plants. Additionally, the U.S.
5

Environmental Protection Agency (EPA) is present for administrating the same act i.e.,
Clean Air Act. This act is standardized base in the emissions for the power plants via,
several programs like Acid Rain Program. The reduction of air pollutant emission has
decreased to a larger extent due to the stress on Clean Air Act, in the United States of
America.
The impact of power plants on the landscape is observed, where it determines
that all the power plants contain physical footprint (i.e., power plant’s location). Certain
power plants are relatively small because they are placed wither inside, on, or next to
the existing building, which makes the footprint small. Certain power plants which burn
solid fuels may have areas for storing the combustion ash. The power plants have large
structure, which alters the visual landscape i.e., as much as the structure is larger, there
are high possibilities that the power plant could have high impact on the visual
landscape. ("Electricity and the Environment - Energy Explained, Your Guide To
Understanding Energy - Energy Information Administration", 2018).
3. Selected Analytics
The Business Intelligence reporting solution or the dashboards are selected,
because it can help to map any data set and helps the users with the generation of
reports, as per their needs. The simple thing about this solution is the reports can be
generated with few mouse clicks. Even it is possible to go in-depth of the data for
detailed examination of the report. BI reporting is an effective solution which is flexible
and easy to use for differentiating with various dimensions of data that has to be
analyzed in different forms like, tabular, chart, pivot, reports comparison and so on. It
also provides several effective filters which could be applied for the analysis. Moreover,
6

the reports of BI can even be automatically shared and emailed as Excel, CSV or PDF
attachments. Additionally, the body of the email can even have embedded HTML. Thus,
a group of users have report sharing facility ("Business Intelligence Reporting &
Dashboards", 2018).
For the business Intelligence reporting solution the prescriptive and the
descriptive analytics are selected and are discussed in the below sections.
3.1 Prescriptive Analysis
The Prescriptive Analytics utilizes optimization and simulation algorithms for
advising on the possible results and answers. This analysis supports to find the answer
of what has to be done next. Prescriptive Analytics provides advice for the possible
outcomes. It helps to prescribe various possible actions, which acts as a guidance for
the solution. Therefore, this type of analytics just provides good and effective advice.
Prescriptive analytics tries to quantify the impact of the future decisions for advising on
the possible outcomes, even before making any decisions. It generally not just predicts
what would happen, however it also ensure to determine why it would happen and
provides suggestions in terms of effective actions that can be implemented to resolve
the problem. This type of analytics can be used anytime required for providing helpful
advice for the users, for their problems ("Descriptive, Predictive, and Prescriptive
Analytics Explained", 2018).
The Business Intelligence dashboard modifies the traditional business
intelligence reports and represents it in the form of predictive performance metric
("Business Intelligence Dashboard Examples", 2018). For business intelligence
7

dashboard reporting, the predictive performance reporting system is a method which
follows process based tracking system as follows:
1) Check the stability of the process, which produces the response.
2) If the process is stable, in such case provide a predictive response such
as in future what is expected if some steps are not taken.
The below analysis represents the analysis of environmental issues which are
determined, for the current year 2018.
The explanation of the dashboard is as follows:
8

1. The dashboard has site selector option with the global map. In the dashboard,
the selected area and building’s details in terms of descriptive analysis will be
processed, depending on the weather condition of that location. The building is
named as “Zion Dado Company.” This company is selected for evaluating the
energy consumption.
2. The time variance and monthly temperature variance can be seen. Energy
consumption in this company during 2016 is analyzed, which is 28,126 kilowatt
hour, where the bench mark was 35,600 kilowatt hour.
3. The previous month’s energy contribution/ electricity consumption was
comparatively less with the currently viewed month, i.e., 7.45 percentage of
contribution in April 2016 and 8.25% in May 2016. Even the duration of electricity
usage is specified, i.e., 7- 8 am.
4. The weather condition is noted in terms of monthly Average temperature basis,
which is 59.89 0F.
5. In the energy consumption period i.e., 6-10 pm 21.07 percentage is shown for
May 2016 and 20.12 percentage is showed for April 2016.
6. The above provided data is analyzed using a graph in the dashboard. The
interpretation is clearly visible which determines that the temperature has
increased from last year.
7. Pink line denotes the daily benchmarking in the graph, then the purple wave
represents the average temperature which is increasing and the blue bars
represents the energy consumption of the selected company.
9

3.2 Descriptive Analysis
The Descriptive Analytics helps to see the insight into the past. It is a statistic
analysis which describes or summarize the raw data and helps it to easily interpret the
data, in an understandable form. This type of data mainly describes the past, using the
present data. In this analysis, past denotes a year or even one minute ago time period.
The descriptive analytics are beneficial as it assists in learning important details from
the past behaviors and comprehend how the behavior could influence the future effects
or consequences. Wide range of statistics comes under descriptive analysis like, basic
arithmetic sums, percent changes, averages and so on. The underlying data is applied
with basic mathematics to know the count and aggregate of the filtered column of data.
Basically, for calculating practical calculations, various statistics are available. The
descriptive statistics benefits to represent the total stock in the inventory, average
10

amount spent on each customer every year and for representing the changes in the
sale. Generally, descriptive analytics reports deliver historical insights based on the
organization’s financials condition, production, its operations, inventory, sales and
customers ("Descriptive, Predictive, and Prescriptive Analytics Explained", 2018).
The below analysis represents the analysis of environmental issues which are
determined, in the year 2016.
The main indicators for analyzing the report in the dashboard are as follows:
a) Location: The place will differ for analysis, whose conditions will change
based on the following indicators, weather, time, date and consumption.
b) Weather Condition: The weather changes periodically and cannot be
controlled. The indicators here refer to how are the changes in the
11

weather, i.e., is it normal or there are any unusual things which changes
the weather.
c) Data and Time: The impact of weather is determined based on date and
time factors. The implementation of measures can also be determined
with these factors.
d) Energy Consumption/ energy wastage: The high energy consumption
can lead to increasing the environmental issues.
4. Dashboad and its Explanation
The dashboard summarizes the business information in a simple view using
various database sources, For instance, financial spreadsheets, HR statistics and
12

operational performance.
Allow your management teams to monitor real time information and KPI’s easily,
accessible from any location using a web browser. Set up target and performance
based triggers to receive email alerts when your business is working to target or
underperforming. The Dashboard reporting enables your team to drill down using
dynamic charts. Providing rule based and divergent data exploration. This means the
user can compare data from various divisions or separate entities of your business, in
an understandable format, no more trawling through spreadsheets and reports in
multiple formats, Choose graphs, charts or tables to suit your business needs and pull
in the data from many sources.
The below mentioned image depicts the created dashboard.
13

4.1 Solution Overview
Business Intelligence reporting solution is an information management tool. It is
utilized for tracking the metrics, KPIs, and other important data points that are
appropriate for the business or for any particular process. The data visualization in the
dashboard simplifies the complicated data sets ("Business Intelligence Dashboard",
2018).
Dashboard
The proposed business intelligence application system must be designed
depending on the requirements of environmental issues, which as discussed in this
report. The constraints must be validated with the issues and expenses of the
environmental issues in a single year. The report must be generated on a yearly basis.
The proposed business intelligence application design must investigate the
performance of the environment improvement. This application should assist the Board
members in evaluating the required budget. With the help of the dashboard it is easy to
retrieve the required data and relate it with expenses. It can further provide accurate
information on the exact environmental issues which need immediate solution.
Additionally, the administrators can monitor the data. The application must help in
providing help in decision making.
4.2 Prototype of the Business Intelligence Application using Dashboard
The Design of the prototype looks like a dashboard, which is utilized for
developing solution for environmental issues. Basically, the dashboard is a graphical
structure producing tool, which is utilized for data management and data visualization.
The primary purpose to use the dashboard is tracking, showing and analyzing the
14

complete performance of the specific process or an organization. The performance can
be viewed based on daily, weekly, monthly, quarterly or on yearly basis. It contains the
key performance indicators which are related to the organization’s key requirements.
The dashboard is explained in briefly, as follows:
1) The above Dashboard’s financial status is analyzed. The budget is
$15044, and its expenses is $45133.
2) Thus, the Board members 85% of the target and the expenses are 75%.
Therefore the profit is increased to 13% and expenses are increased as
4%.
3) The required site or location for analysis can be selected. The data can be
filtered based on date, country, state and city.
4) The bar chart are used for comparison of seriousness of the issues in a
specific duration.
5) The key indicators can be selected and the weather conditions can be
viewed, in the dashboard.
6) The dashboard also shows the calendar.
7) Further, the details of the site or location can be viewed such as, name,
type, country, address and its area in square feet.
8) At last, the below graph depicts the energy consumption, where the graph
represents the daily benchmarks, average temperature and energy
consumed in kilowatt hour (Kwh), for a selected place.
9) The dashboard provides real time reporting, where it access real time
information from the required site with the help of the web browser and
15

provides information to any device like mobile, desktop or a tablet
("Business Intelligence - Dashboard Reporting Solutions", 2018).
5. Logical Recommendation to Improve the Environment
The relevant laws and regulations imposed for the organizations, for consuming
energy are reviewed.
It is observed that in the United States of America, electricity is generated with
the help of various resources like natural gas, nuclear power and coal. Wind and solar
energy are the fastest growing sources which are renewable in nature. Large part of the
United States has its electricity generated at the centralized power plants. Though it is
less but the production of electricity is increased through distributed generation.
The environmental issues can be decreased by increasing performance in the
16

following areas:
1) Efficiently use energy
Ensure to save the energy, which is the most important suggestion. It can be
achieved introducing economical processes which can decrease the electricity
bill amount, then by changing the behavior of the workers and by victimization
many economical instrumentation.
2) Invest on checking energy efficiency of the machines used in the offices or
business
This can also cut down much of the cost from the electricity bill and also help to
conserve energy.
3) Make efforts to decrease the bills
Invest on energy saving machines which are environmental friendly.
4) Use energy saving plants and machinery
5) Educate the worker about the impacts of energy wastage and its impact to
the environment.
According to Business Intelligence analysis and the gained insights from the data
set, for improving the environment it is recommended to:
1) Increase awareness on effectively using the electricity without any
wastage.
2) The amount of electricity utilized at homes and offices is based on
weather, part of the day and time. Thus, the time for high usage must be
determined and more electricity should be produced at that specific time
17

("About the U.S. Electricity System and its Impact on the Environment",
2018).
3) The electric utility companies along with the grid operators should work
hand-in-hand for generating the exact amount of electricity, for meeting
the electricity demands. In case of the increased demands, the operators
must respond and increase the power production in the power plants
which are being operated ("About the U.S. Electricity System and its
Impact on the Environment", 2018)
4) Make sure that the end users agree to consume less electricity from the
grid ("About the U.S. Electricity System and its Impact on the
Environment", 2018).
5) Take efforts in the development of air quality, soils, water flow and its
quality.
6) Increase awareness among the people on saving environment.
7) Take steps towards energy conservation.
8) Take strict measures to reduce and control environmental issues and their
negative effects.
9) Take controlled measures for controlling carbon dioxide in the air.
10)Develop waste water recycling project.
11)Educate people to start using the environment friendly.
6. Conclusion
As per the data visualization approach, an appropriately suitable decision support
is selected. The objective of the analysis is met. This analysis helps to experience the
usage of SAP Analytics tools with respect to data. Necessary application design model
18

is found. Descriptive analysis and Prescriptive analysis are conducted. The prototype of
the business intelligence is designed. Justification for the BI reporting
solution/dashboard is provided. The key performance indicators are analyzed using the
Dashboard. The dashboard is developed successfully and is explained. Based on the
Business Intelligence analysis and gained insights from the data set, logical
recommendations are suggested for improvising the environmental issues.
19

References
About the U.S. Electricity System and its Impact on the Environment. (2018). Retrieved
from https://www.epa.gov/energy/about-us-electricity-system-and-its-impact-
environment
Business Intelligence - Dashboard Reporting Solutions. (2018). Retrieved from
https://www.cleardatagroup.co.uk/document-management/business-intelligence-
dashboard-reporting/
Business Intelligence Dashboard. (2018). Retrieved from
https://www.klipfolio.com/resources/articles/what-is-business-intelligence-
dashboard
Business Intelligence Dashboard Examples. (2018). Retrieved from
https://www.smartersolutions.com/business-intelligence-dashboard-examples.html
Business Intelligence Reporting & Dashboards. (2018). Retrieved from
http://www.enhancedretailsolutions.com/business-intelligence-reporting/
Descriptive, Predictive, and Prescriptive Analytics Explained. (2018). Retrieved from
https://halobi.com/blog/descriptive-predictive-and-prescriptive-analytics-explained/
Dutton, J. (2018). Energy Production and Consumption in the United States | EBF 301:
Global Finance for the Earth, Energy, and Materials Industries. Retrieved from
https://www.e-education.psu.edu/ebf301/node/457
20

Electricity and the Environment - Energy Explained, Your Guide To Understanding
Energy - Energy Information Administration. (2018). Retrieved from
https://www.eia.gov/energyexplained/index.php?page=electricity_environment
U.S. energy consumption rose slightly in 2016 despite a significant decline in coal use.
(2017). Retrieved from https://www.eia.gov/todayinenergy/detail.php?id=30652
21