Q.
What is BI (BUSINESS INTELLIGENCE)?
Asked by radhavenkat,
21 Jun '07 07:12 am
Earn 10 points for answering
Answers (3)
1.
Glossary of few most used BI Terms:
Ad-Hoc Query: Any query that cannot be determined prior to the moment the query is issued. A query that consists of dynamically constructed SQL, which is usually constructed by desktop-resident query tools.
Crosstab: A process or function that combines and/or summarizes data from one or more sources into a concise format for analysis or reporting.
Data Analysis and Presentation Tools: Software that provides a logical view of data in a warehouse. Some create simple aliases for table and column names; others create data that identify the contents and location of data in the warehouse.
Data Dictionary: A database about data and database structures. It is catalog of all the data elements, containing their names, structures, and information about their usage which is in a central location for metadata. Normally, data dictionaries are designed to store a limited set of available metadata, concentrating on the information relating to the data ...more
Answered by Shilpa Mehta, 30 Aug '08 04:24 pm
Ad-Hoc Query: Any query that cannot be determined prior to the moment the query is issued. A query that consists of dynamically constructed SQL, which is usually constructed by desktop-resident query tools.
Crosstab: A process or function that combines and/or summarizes data from one or more sources into a concise format for analysis or reporting.
Data Analysis and Presentation Tools: Software that provides a logical view of data in a warehouse. Some create simple aliases for table and column names; others create data that identify the contents and location of data in the warehouse.
Data Dictionary: A database about data and database structures. It is catalog of all the data elements, containing their names, structures, and information about their usage which is in a central location for metadata. Normally, data dictionaries are designed to store a limited set of available metadata, concentrating on the information relating to the data ...more
Report abuse
Useful
(0)
Not Useful
(0)
Your vote on this answer has already been received
2.
BI are report generating softwares which sits on top of ERP. these are third party softwares like Cognos, Crystal.
you can design reports in it.
Answered by sudhir chauhan, 21 Jun '07 12:26 pm
you can design reports in it.
Report abuse
Useful
(0)
Not Useful
(0)
Your vote on this answer has already been received
3.
Report abuse
Useful
(0)
Not Useful
(0)
Your vote on this answer has already been received