Can any one give me the real outcome of the above two terms in modern environment . We have discussed to get the BI and Data intelligence as well

we have ERP and BI and some level of Data intelligence . but company management is asking US to have good MIS ?  I have to  know the idea where we can sit this in the business .
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:

•      BI ( reporting so that business can make decisions) , Data Warehouse ( business data stored) , ERP ( all info that is do with people, their daily operations, reminders, salary payment info, business trends etc)  are specific applications of MIS.

•      If MIS is knowledge, the above can be considered as books.

MIS is the process by which organization collect data organized, stored and disseminated for the use of decision making, this can be manually or computerized.

ERP) is business management software that allows an  organization to use a system of integrated applications to manage the business. ERP software integrates all facets of an operation, including development, manufacturing, sales  and marketing.

Here is a good discussion

curAuthor Commented:
if I ask the question like this . management is asking us to have MIS system . but we have ERP/HR/Accounting application running . Do we need the MIS or BI to get the decision making outcome
Kanti PrasadCommented:

MIS is a whole set of all your applications. So I think they are looking for a BI Report solutions. You can get those reports from all the individual applications databases or all the applications data loaded into Data ware house (DWH) and the report data is taken from the DWH.

BI Reports needs tools like Crystal reports, Microstrategy reports, Business object reports etc.... So behind these tools relevant SQLs or stored procedures are run on the respective databases and the results are presented by these tools.

MIS means all individual applications put together i.e  BI Report solutions + DWH + Daily Transcations applications ( business trading) + ERP ( Resource information and their operational activities (i.e Customer relations info, account ( i.e Employee salary info, etc ), HR, Marketing people and their operational activities) + all your other applications.

To give management ( i.e CEO, Marketing heads, accounting heads, HR heads ) proper reports there should a BI team developing reports. These report requirements need to given by the business (i.e all the relevant departments)
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

curAuthor Commented:
we have different application in different flat forms . SO we can have all in to DWH and get the data via BI tools . is that the idea will cover
Kanti PrasadCommented:

Data ware house db can hold data from various applications. Say in telecoms if they have landline, mobile, broadband and Television as their products. So all of these customers data can be loaded into DWH and reports can be generated.
Say in banking various trades data from various applications can be loaded into DWH.
So depending on the business you are in and the applications, dept etc you can architecture the DWH and then creates reports.
curAuthor Commented:
thanks  .still I can get the reports from the individual application without having DWH . this will have the disadvantages vs DWH
Kanti PrasadCommented:
Hi Cur

You can get reports from individual apps but they will be very slow as application databases are transactional databases i.e they are normalized ( data put into multiple tables and joined) and you are getting reports while business transactions are updated on-line. This is not good in the reports point of view and also on the transaction point of view as both will get slow.

DWH is an analytical database and isolated from daily trade transactions and also it is de-normalized i.e data put into 1 or two tables max ( facts table and dimension tables) and hence company-wide reporsts are taken from DWH for better performance.
curAuthor Commented:
Thanks for your information  . I am interesting in studying for BI and DWH in the future . do you have any advice on the study path .And also comment the difference or limitation on the below

SQL reports  / BI And DWH
Kanti PrasadCommented:

BI and Report are the same which gets data from DWH.

In general Report is a front view that a user views the Database (DWH or app DB) data. So between the view and DB a developer will write SQL queries to get required data from the DB that will be shown on the front view.


Look at the links



curAuthor Commented:
I hope some of the ERP will provide all the details in one box solution with BI tool . so that we don't want to have separate MIS system to have access to all the application via DWH
Kanti PrasadCommented:

Yes if you have the data you can have the reports without a DWH but if performance is the key which is in large organisations then DWH is the way they will prefer.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.