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. 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