Now let's look at the different kinds of tools which can be used to the dinner business and set setup
or the more common tools used for business intelligence can be seen on the screen.
Now they are listed considering the increasing costs the functionality the increasing business intelligence
complexity and the degrees of the total number of users because earlier you used to have designated
task for the all app tools.
Now like I've been mentioning there are cell service business intelligence tools now.
Now with the self-service be to who's a single person or a single resource can do multiple things right.
So whatever is listed on the screen are common ones like I've mentioned there are more advanced tools
in the market now and those are giving multiple options and depending on the need you have to evaluate
and assess that tools.
And based on that you need to choose which is better.
You can say these are the common ones.
The first one.
Now it's not a designated business intelligence tool but the moment we say data the first thing which
comes up in your mind is the rows and columns and which is excellent.
Right.
And it is surprising that it is Microsoft Excel.
There are several reasons for it right because it comes along with your office Microsoft Office whichever
year's version which you using considering a lot cheaper compared to the current self-service tools
which are charging like more than $2000 per year per license.
Right.
It's commonly used.
And you can easily send an excel sheet to another person without worrying whether the recipient knows
how to read it how to use it because it's it's one of the standard tools which everybody knows within
the Iraqi world and it has the most of the functionalities which are required for us to make the data
more visually delivered.
Right.
In fact it is still so popular that all third party reporting or lack tools or the self-service I have
an export to Excel import to excel as source.
And even for hornbill solution the ability to export numbers to excel usually needs to be built because
that's one of the common sources or common tools which are used across right axil obviously is the best
used for business operations reporting and google tracking and the worship Microsoft itself is giving
a lot of options for you to start with the templates so you don't have to do a lot of the work.
There are existing templates take them start using them and you can enhance it based on whatever it
is you need.
Reporting tools now the common ones which can be used are the business objects Cognos click View Tablo
Syncsort there are lots of new ones like Ahmir breast and a couple of other ones which are coming up
with the big data initiatives nowadays.
Right.
So these tools provide some flexibility in terms of the ability for each user to create schedule and
run their own reports along with the dashboard gap abilities to visually to make the data reporting
more visually good and get the in-depth view of multiple granular levels of the reporting.
Right now the business operations reporting and dashboards are the most common applications for most
common duties for reporting to all the tools the older tools are usually used by advanced users.
They make it easy for users to look at the data from multiple dimensions depending on how the Joines
of it in the cube have happened.
And based on that they can generate the different ways of looking at data.
Right.
All the tools are used for multidimensional analysis wherever you are using this high pick in cubes
or SSR cubes data mining tools.
Now the data mining tools are usually only for specialized users and in an organization even larger
ones there are usually only a handful of users using data mining tools.
There are not many data mining tools which are used in recent days because things have changed and all
of these are capable of the self-service be-I tools.
And based on the necessity as you can see data mining includes lots of factors within it and all of
these factors can be considered in any of the self-service tools which are currently available in the
market.
Right.
So like I've mentioned I did not take specific to this list like Tablo.
You said business objects Cognos click view or any of that reason being all are good.
All have their own capabilities their own advantages and disadvantages.
But depending on what you need depending on what the organization needs you have to choose the right
tool.
Right.
The overall purpose of this tool is to make anybody use the data which is present in your data warehouse
to generate the reports and create the dashboards which will visually show you the current state of
your data current state of your business current state of your.
Right.
So those are the different types of tools which can be used.