CSI11100 Business Intelligence and Reporting for Enterprises Report

This report analyzes data from the Trussell Trust, focusing on business intelligence and reporting. It examines various BI tools and their features, highlighting the importance of supporting multiple data sources, statistical operations, and data visualization. The report provides insights into the Trussell Trust's data, including donor demographics by postcode, food stock levels, donation frequency, and food wastage. Key findings reveal that the majority of donors are from postcode 'ML117AG,' bakery items are the most available in stock, donations are frequent in the initial weeks of the month, and the maximum quantity of donations comes from postcode 'ML84AD.' The report recommends notifying potential donors at the start of the month to ensure consistent donations and focusing on collecting specific food items in areas with lower donation rates to improve food distribution. The report is focused on the CSI11100 module coursework 2 assignment requirements.

BUSINESS INTELLIGENCE AND REPORTING
FOR ENTERPRISES

BI TOOLS
• There are multiple business tools are available which can be used
by the organization according to requirement of the organizations.
• Some of these tools includes Tableau, Microsoft Power BI, Oracle
BI, SAP Business Intelligence.
• Some of the most important features for any BI tool includes
Support for multiple data sources, different type of statistical
operations and finally the different types of charts and graphs.

FEATURES OF TOOLS
• Large scale analytics.
• Provides easy Report Sharing capability.
• Integration with the exiting office Suits or information systems.
• Report or insight sharing with easy steps.
• Filtering of the data depending on conditions.

INSIGHTS GENERATED FROM TRUSSEL
TRUST DATA
• From the available dataset different
stock, donations and waste of the foods
are provided.
• The insight at the side shows the donors
from the different post codes as available
from the dataset.
• From the chart it is evident that,
maximum number of donors are recorded
the postal code “ML117AG”.

INSIGHTS(CONTD..)
• As the organization is trying to provide
meals to the clients thus it is important
to have sufficient amount of different
types of food items.
• The next insight at the side, depicts the
available stocks of the different types of
food items.
• Here it is clear that Bakery items are
mainly available in the stock of

INSIGHTS(CONTD..)
• As the trust have to provide foods to the clients
through out the month, thus it is important to
have consistent donations from the donors.
• The insight extracted from the dataset shows
that, there are frequent donations in the initial
weeks of the month.
• Thus, it is important to have consistent
donations from the donors by notifying them at
the first weeks of month inn order to get
donations in the last of month.

INSIGHTS(CONTD..)
• In this section the quantity of the
donations are compared against the post
codes.
• Here, it is found that the maximum
quantity is collected from the postal
code “ML84AD.”
• The lowest amount of donation is
received from the Post code ML117LA.

INSIGHTS(CONTD..)E
• In this insight the wastage of
stock is explored.
• The mostly wasted stock is the
with ID SDK087.
• The mostly consumed stock
with lesser wastage is
STK090.

RECOMMENDATIONS
• As it is observed that there are lack of donations at the end of the
month thus it is suggested to notify the potential donors at the start
of the month to avoid this kind of situation.
• It is important to get the different types of food donations in the
post codes that are showing lesser amount of donation in the
charts, insights.
• Donations of the food items like meat, vegetables and pulses
needs to be collected more in order to provide better meals to