Analysis of Business Intelligence and Reporting for Enterprises

This report provides a comprehensive overview of Business Intelligence (BI) and Reporting for Enterprises. It begins with an introduction to BI, emphasizing its integration and ease of use due to pre-packaged applications. The report explores various BI tools and technologies, including Oracle BI, Mic...Read More

Running head: USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
Use of Business Intelligence and Reporting for Enterprises
Name of the Student
Name of the University
Authors note

1USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
Table of Contents
Introduction................................................................................................................................2
BI tools and technologies...........................................................................................................2
Developed sheets and dashboard for the Trussel Trust..............................................................3
Description of the BI report.......................................................................................................6
Conclusion..................................................................................................................................7

2USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
Introduction
Present day Business Intelligence (BI) advances are firmly incorporated, effectively,
and broadly sent and usable for they depend on pre-packaged application. Thus, Business
Intelligence has turned out to be such a great amount of simple to legitimize important
ventures and the expense for creating and keeping up an information distribution center has
fundamentally decreased. With the exponential development in the generation and absorption
of data, using the BI tools different organizations can get insights that can help in exploiting
opportunities in the market.
BI tools and technologies
Oracle BI tool: The Oracle BI is the suite of applications that incorporates business
intelligence and operational tools that are confined in Enterprise Information Model. Users of
this BI tool can get to data through numerous ways, for example, utilizing different
applications or APIs. This tool is likewise outstanding for its ability in providing top to
bottom and exact experiences from the chosen dataset. Through utilization of the device It is
conceivable to keep up objective of the business alongside the IT collaboration effort so as to
use the advantages from the extracted insights.
A standout amongst the most significant highlights of Oracle Business Intelligence is
its Mobile insights that empowers the clients to get to the insight information through the
tablets and other mobile devices. This versatile benevolent element is totally incorporated
alongside Oracle Business Intelligence Suite. This empowers the clients to gives prompt
availability to existing contents such as the scorecards, dashboards and reports. Thusly the it
causes in quick openness to the alongside the diminished time utilization. Along these lines, it

3USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
helps in settling on precise business choices in with better and prepared to go bits of
knowledge.
Microsoft Power BI: This is one of the best business intelligence tools that can be
used by any professional analyst as well as by the non-technical user by connecting to any of
the numerous supported data source. With its inbuilt controls the users can quickly
summarize the insights into a simple report. For the advanced users who try to explore
advanced features of this tool, they can also use the custom measures and tools that can
created through the use of the Microsoft’s DAX query language. For a user who have
knowledge about building spreadsheets/ models in the well-known Excel they can easily
adapt with this BI tool as well as efficiently use the Power BI.
Tableau: This BI tools supports numerous types of data connections or sources along
with the OLAP or online analytical processing as well as big data stores such as Hadoop,
NoSQL along with cloud based options too. This BI tool is also capable of automatic
determination of the relationships among the different attributes of the selected dataset. For
the users it provides an intuitive interface which does not necessarily requires programing or
coding knowledge in order to create complex as well as sophisticated visualizations in order
to convey the extracted insights.
Developed sheets and dashboard for the Trussel Trust
In the following BI dashboards different insights available from the provided data set
is explored in order to help Trussel Trust with the collection of the donations, distribution of
the foods to the clients, and controlling the wastage of the donated foods.
In the first chart the stock quantity is compared with the food type that will depict the
available stock according to the type of the food for Trussel Trust.

4USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
From the above chart, it can be easily stated that maximum stock is available for the
Tinned veg type food and minimal stock is available for spreads, Tubed veg, Frest meat,
Bottled sauce.
Now, the consumption of the food parcel by the clients.
From the above donut chart, it is clearly visible that the client with the ID C014 has
consumed maximum consumption of the food parcel. The C014 consumed 3.73% of the total
food parcels. Other clients who had significant consumption can be listed as C021, C013,
C010, C026, C023, C027, C018, C031, C033, C015, C026.

5USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
In the next insight, the waste of the available donated stocks are analysed. This is
compared with the stock ID.
Here, it can be stated from the above depiction that maximum wasted stock is
STK029 and the minimum utilized stock with lesser wastage is STK092.
In the following section, the wastage of the donated food items that were not
distributed to the clients as the part of the meal.

6USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
From the above chart created in Power BI, it can be easily stated that maximum
amount of the wastage of donation is recorded for the Donor ID D009. The stocks like
STK010, STK029, STK0313, STK087 are the mostly wasted which are donated by D_Code.
Other D-codes with that has the significant wastage of their donations are D001, D006, D007,
D013.
Description of the BI report
Through the use of the available insights, the Trussel trust will be able to find out the
trends in the usage and donated food from the donors. Through the provided dashboard, it
can be stated that, it is important for the Trussel Trust to reduce the wastage of the stock as
well as improve the availability of the different types of food in order to provide better meals
to the families. Following are dashboards that are created for Trussel Trust that includes the
different insights mentioned above to depict the utilization as well as wastage trend of the
stocks.

7USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
Conclusion
The Power BI completely supports the five major elements in the data governance
and analysis. This are quality as well as consistency of the data imposed policies and
standards for the dataset, security and retention with the archiving of the results. With the use
of the BI tools like the Microsoft Power BI, the users are allowed to apply different analytic
functions through the easy drag-and-drop as well as point and click operations to extract

8USE OF BUSINESS INTELLIGENCE AND REPORTING FOR ENTERPRISES
insights from the available data. Furthermore, with the easy profiling of data and cleaning of
the dataset feature also helped in this project to get valuable insight through the analysis.