While making a BI system we should keep in mind the infrastructure of
the BI system which are of two types technical and non-technical infrastructure. An infrastructure should be right for us to
give the best performance to the clients
· IBM Cognos Business Intelligence, Microsoft BI tools and Jasper
soft BI software are more software’s which are being used in the BI Systems .
· SAP Business Objects: it helps the company businesses to
sort analyze and view their data. SAP is being also used by the De Montfort
University as well.
· Oracle (OBIEE): Oracle Business Intelligence Enterprise
Edition (OBIEE) is basically on the front end of the BI systems. Which provides
with all the analytics functionality that can be used in reporting and in BI
· ODBC: Is a software which helps the API to get all the data
and information from different databases to be used. The most near to this
system is middleware. The ODBC work is to make it possible to get data from
anywhere no matter which database management system(DBMS) has that data, it
manages to collect data from anywhere in the database by inserting a middle
layer known as database driver, between database management(DBMS) system and an
application. Which help to type command that DBMS understand and provide it
with data that is required by the application.
· Software as a Service (SaaS): It is basically a third party
software provider as it provides different kind of software to the clients.
They are provided to them online a few examples of those software are Microsoft
Power BI, IBM Congos analytics etc.
· ETL Tools: Extract transform, and load is the meaning of
ETL it helps to extract data from different databases and transform them as it
feels appropriate and load them into a different BI system like data mining or
data warehouse. it is user friendly software used in BI systems.
· BI middleware: BI middleware is like a glue which helps keeps
everything in BI system togethers. It works on the front end of the BI systems
not only at theback end of the BI systems.
In one of the lab session
of DWS we discussed about some BI infrastructure concepts are present for BI
systems to be used like BI Middleware, ETL tool, software as a service(SaaS)
and ODBC (Open Database Connectivity)
· BI arbitration board (aka steering committee) is also
present to help the team to come up with a decision when they are not able to
decide between things that are needed to be present that is when this board steps
in it comes as a help but some time it also brings in conflict between managers
as they are not able to justify why there method or decision was not selected
so as it is present for help it also brings in a bit of conflict as well.
· Extended Team: According to Moss and Atre this team is
coming and going but it is not present always they are not working on one thing
e.g. business sponsors they might come and go and see the progress report but
they are not always present for the project, as they are not doing just one
thing at a time. Strategic infrastructure architect is one of an example who
are there to give help and come in at any point of the project, but they will
not be present there for the whole of it.
· Core Team: According to Moss and Atre this team is always
present for the whole time of the project in which project managers are there
for they are present for the project all the time and business representatives
are also part of the core team whereas they are not needed for the whole of the
project, but they are still present for the project always.
· Task also showed us that what a person needs to do to
fulfil the clients demands and how he can do so which was shown by the
“Waterfall” approach. There is not just waterfall approach but there are more
approaches which is used to satisfy the needs of the client that is
evolutionary approach and the phased (incremental approach which is used to
divide the project into small parts and work on them. In Moss and Atre’s book
he said what a development team is.
· During the developments lectures we learned how to approach
the problem and what are the things that are to be taken into consideration.
During the task of DWS we learned how to make a feasibility report. Feasibility
report helps us to plan and see if it is worth it or not. In a feasibility
report one should take every aspect into consideration weather it is
commitments, cost planning legal procedures etc. a feasibility report is not
shown up front it plays an important role in the BI development systems.