Posted on July 7th, 2008 by admin
I hope this will help the BI practiser to evaluate the tools used at different process and the available tools.
Types of business intelligence toolsThe general categories of business intelligence tools are:
1.Spreadsheets[1]
Lotus 1-2-3
Microsoft Excel
Apple Numbers
OpenOffice.org
more
2.Reporting and querying software - are tools that extract, sort, summarize, and present selected data […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Interesting, Interview Questions(& answers), Software
Posted on July 2nd, 2008 by admin
Why Build a Data Warehouse?
For decades, companies have been spending millions of $$$’s on systems to streamline and automate the execution of the business plan. Over time, these systems have become more and more integrated within a companies operations and between business partners. However, due to the granularity of the data stored in […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Interview Questions(& answers)
Posted on July 2nd, 2008 by admin
Business Intelligence Overview
True value of Business Inteligence comes from recognizing and harnessing the power of technology to help change the way you do business. After all – unless there are real decisions made with the information provided by a data warehouse, all you have is a data warehouse, not a decision support application.
[…]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on July 2nd, 2008 by admin
Business Intelligence
A new technology can analyze data at amazing speeds. So why is higher ed slow to adopt?
Listen to higher ed futurists and you’ll be convinced that business intelligence is the wave of the future. It is the next “it” thing that will connect every part of the enterprise. Best yet, BI will link […]
1 Comment »
Filed under: Business Intelligence, DataWarehousing
Posted on July 2nd, 2008 by admin
What is the Difference Between Querying and Browsing Data?
Search is beginning to gain interest in the business intelligence (BI) space, and several people have begun asking about the difference between querying data (using a traditional database query language) and browsing data using a search tool, and which approach to use when. This blog entry is […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, SQL
Posted on July 2nd, 2008 by admin
When is a Data Warehouse Appliance not a Data Warehouse Appliance?
Data warehouse appliances are so-called because they are used for storing and managing the data associated with data warehousing projects. Strictly speaking though these products should be called database appliances, or simply data appliances, because they support only the database processing component of a data […]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on June 30th, 2008 by admin
Is Data Warehousing Essential to Business Intelligence?
The role of data warehousing is changing as companies move toward using new business intelligence approaches.
Over the last few issues of this newsletter, I have been writing about the impact of Enterprise 2.0 approaches on business intelligence (BI). I intended this time to write about how business intelligence […]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on June 30th, 2008 by admin
The Most Successful Business Intelligence Tool
When evaluating, selecting and deploying business intelligence tools, one of the most important steps is to understand which segment of user needs you are trying to fulfill and then match the tool to that segment.
Business intelligence (BI) has become a smorgasbord of user interfaces, with certain modules generating more excitement […]
No Comments »
Filed under: Business Intelligence, DataWarehousing
Posted on June 30th, 2008 by admin
The Business Intelligence and Data Warehousing Glossary
I have collected and compiled this from a very nice website.Some of the terms are relating to Microsoft’s tool (Microsoft’s Analysis Services ) but that can be generalised to other non-microsoft tools also.
Link >>
Agent
An application that searches the data and sends an alert when a particular pattern is found.
Aggregations
Information […]
No Comments »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers), OBIEE, PL/SQL, Reports, SQL
Posted on June 26th, 2008 by admin
Life cycle of a DW ( Data Warehouse ) project
After many requests ,I am compiling everything in one page for easy page navigation and easy learning.hope you like it.
1 )Requirement Gathering
Requirements Gathering is started by directly discussing or with JAD sessions (Joint Application Development) with the End users .The help of Business leader or Business […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Interview Questions(& answers), Oracle Apps, Reports, SQL
Posted on June 20th, 2008 by admin
This short Article shows the basic Installation steps in installing OBIEE on your windows PC.
Pre-requisite
Computer with Windows XP (Home Basic) ,RAM 2GB, HDD approx 80 GB
JDK 1.5 installed and JAVA_HOME created.
Download the OBIEE setup from the www.Oracle.OTN.com. After downloading, I recommend to unplug the internet (turn off wireless internet or unplug the LAN wire )from […]
9 Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, OBIEE, Reports
Posted on June 20th, 2008 by admin
create JAVA_HOME quickly with following steps on Windows XP (Home Basic)
The goal is to create a new variable called JAVA_HOME in Windows Operating system,so get access to System Properties window and create new variable called ‘JAVA_HOME’ and insert value where your BIN folder of JDK within your system.
more detailed steps as below.
1)Right Click on “computer”
2)Select […]
1 Comment »
Filed under: Business Intelligence, DataWarehousing, Discoverer, Oracle Apps, Software
Posted on June 18th, 2008 by admin
Benefits of data warehousing
Some of the benefits that a data warehouse provides are as follows:
A data warehouse provides a common data model for all data of interest, regardless of the data’s source. This makes it easier to report and analyze information than it would be if multiple data models from disparate sources were used to […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 18th, 2008 by admin
Repository is a place where data are stored and maintained. A repository can be
a place where data is stored
a place where specifically digital data are stored
a site where eprints are located
a place where multiple databases or files are located for distribution over a network,
a computer location that is directly accessible to the user without […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 18th, 2008 by admin
Metadata (singular: metadatum) (sometimes called Metainformation) is “data about data”, of any sort in any media. An item of metadata may describe an individual datum, or content item, or a collection of data including multiple content items.
Metadata (sometimes written ‘meta data’) are used to facilitate the understanding, characteristics, and management usage of data. The metadata […]
No Comments »
Filed under: DataWarehousing, Discoverer, PL/SQL, SQL
Posted on June 17th, 2008 by admin
Database Normalization and Table structures
Normalisation is the term used to describe how you break a file down into tables to create a database.
There are 3 or 4 major steps involved known as
1NF (First Normal Form),
2NF (Second Normal Form),
3NF (Third Normal Form) and
BCNF (Boyce-Codd Normal Form).
There are others but they are […]
No Comments »
Filed under: DBA (DataBase Administrator), DataWarehousing, Interview Questions(& answers), PL/SQL, SQL
Posted on June 17th, 2008 by admin
How to find a column in database
Once, at a client site I was asked to do a drill through report from Purchasing to Fixed Assets. I don’t remember the exact details but it had something to do with Purchase orders. I knew little bit about Oracle Purchasing but had not worked enough on Fixed Assets. […]
1 Comment »
Filed under: 11i, Business Intelligence, DataWarehousing, Discoverer, ERP, Oracle Apps, PL/SQL, SQL
Posted on June 16th, 2008 by admin
Incremental Enhancements
After the system is up and running in the Production environment,there are situations where small and minor changes arises.(Incremental Enhancements).The task can be as simple as to do the changes in the production environment,but is highly risky to do on live (production)systems.Do the chnagses on the Developmetn and roll out the changes in the […]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)
Posted on June 16th, 2008 by admin
Development life cycle of a DW ( Data Warehouse ) project.
The DW project follows following different stages.
1. Requirement Gathering
2. Physical Environment Setup
3. Data Modeling
4. ETL
5. OLAP Cube Design
6. Front End Development (Reports )
7. Performance Tuning
8. Quality Assurance
9. Rollout To Production
10. Production Maintenance
11. Incremental Enhancements
google.load(”visualization”, […]
No Comments »
Filed under: Ad Hoc Reporting, Business Intelligence, DBA (DataBase Administrator), DataWarehousing, Discoverer, ERP, Interview Questions(& answers), Oracle Apps
Posted on June 16th, 2008 by admin
Production Maintenance
After the DW project goes live activities like taking backup on regular time period and mangaging crisis becomes very important and needs to be planned well in advance.
The other task is to monitor the Users and to know how much they utilize the DW; so future enhancements can be planned.
Next >> Incremental Enhancements
[…]
1 Comment »
Filed under: Ad Hoc Reporting, Business Intelligence, DataWarehousing, Discoverer, Interview Questions(& answers)