This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.
Defining OLAP Solutions
The data warehouse offloads data from a multitude of sources. The cleaned, validated and loaded data is voluminous and daunting. This data needs to be organized, categorized and arranged in meaningful order for analytical purposes. OLAP solutions are specifically designed to cater to this need.
OLAP solutions used by Data warehouses are:
Multidimensional views of data. Data in the data warehouse is organized into subject oriented categories and tables. Fact tables are constructed and linked to various dimensional tables in star or snowflake schemas or combinations of them to form multidimensional views of data. Cubes are built using these multidimensional schemas. Rapid browsing and querying then becomes possible. These views are independent of the way in which data is stored in the data warehouse.
Interactive query and analysis of data is another OLAP solution that enables users drill down, drill up and slice data by using multiple passes. Users can drill down to successive lower levels of detail or roll up to higher levels of summarization and aggregation.
Analytical modeling is an OLAP tool that is a calculation engine for deriving ratios, variances etc., involving measurements and numerical data across many dimensions.
Functional models are made available by using OLAP for forecasting, trend analysis etc. They support users in data analysis.
Graphical OLAP tools are used to display data in 2D or 3D cross tabs and charts and graphs with easy pivoting of axis. This is important for users who need to analyze data from different perspectives and the analysis of one perspective leads to business questions that need to be examined from other perspectives.
Rapid response to queries is a must in any analysis of data and the measure of success for the OLAP tool. Nigel Pendse and Richard Creeth, authors of the OLAP Report developed the FASMI (Fast Analysis of Shared Multidimensional Information) test to judge whether or not an application qualifies to an OLAP tool. Their contention was that an OLAP tool should provide fast browsing capabilities (< five seconds), should contain analytical tools both for the developer and the end user; the cubes must be able to handle the security requirements of sharing confidential information and it should present data multi-dimensionally.
Multi dimensional data storage engine stores data in arrays. These arrays are logical representations of the business dimensions.
Understanding Data Warehouse design
At a very global level, construction of the data warehouse is a business project by itself. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.
The general questions that are asked may be as below...
Do we need a data warehouse?
How will it help the business?
What will it mean in terms of cost?
What are the current data analysis methodologies being adopted?
In what way are they deficient?
Will setting up the data warehouse help in reducing these deficiencies?
What kind of reporting and analysis do we really want?
What is that we are getting now?
Will such data analysis make the business more efficient?
Will it help the business improve its services and customer relations?
Once the replies to the above questions have been asked, the organization needs to examine other very crucial issues that will determine the wrap and hoof of the data warehouse that is being set up.
What are the kinds of data that are being generated by the enterprise? What kinds of data storage technologies are currently being used to backup and store historical data?
What other external sources of information do we need to tap to make the data in the data warehouse meaningful for analysis?
What kind of hardware and software will be required to set up this data warehouse?
Who will be the personnel to handle the process of creating the data warehouse?
Which departments will benefit from the data being created?
Will the data warehouse be scaleable?
How will it connect to the different data sources for data?
How will we ensure that quality data is generated?
What kinds of tools will be deployed to support end user needs for reports and analytics?
The answers that emerge from these questions will be a set of business requirements. These requirements will determine the kind of data warehouse that will be ultimately set up in the enterprise. The first steps would be to define the global parameters that will shape the design of the data warehouse. The design can be a top down approach as recommended by Bill Inmon or a bottom up approach recommended by Ralph Kimball. It can be a combination of the two called the Hybrid approach or it can be a federated approach. Let us have a brief look at what these different approaches mean.
For more visualization of this article along with the screen shots and complete free training tutorials on Microsoft Analysis Services visit
http://www.exforsys.com/content/category/17/253/332/
Exforsys is a community of developers specializing in C, C++, C#, Java, J2EE, .NET, PeopleSoft, SAP, Siebel, Oracle Apps., Data warehousing, Oracle/SQL Server/DB2 and Testing. Please visit http://www.exforsys.com for more tutorials, for IT Interview questions visit http://www.geekinterview.com, for articles and resources visit http://www.itquestionbank.com
![]() |
|
![]() |
|
![]() |
|
![]() |
Do you remember that frustrating feeling when you find an... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Have you ever noticed that when you look at your... Read More
It could just be me, but my experiences with document... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Microsoft Business Solutions Great Plains was designed back in the... Read More
The java programming language is becoming more and more popular... Read More
Just stress testing one of the latest Linux distributions. Been... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Almost all new and major brand of PCs come with... Read More
Your computer cost you from hundreds to thousands of dollars,... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
There are so many different programs that clutter up your... Read More
So, you've bought a new Macintosh, and now you may... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
In this small article we will be looking at the... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
We all take the computer for granted. I mean, all... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
RSS (Really Simple Syndication) is a way for a site... Read More
Just imagine: you are walking, say, towards your car, and... Read More
In this short FAQ style article we would like to... Read More
The intuitive algorithm.Roger Penrose considered it impossible. Thinking could never... Read More
Microsoft PowerPoint has dramatically changed the way in which academic... Read More
Adware is a type of Spyware program that displays some... Read More
Microsoft CRM is CRM answer from Microsoft and attempt to... Read More
If you copy something from a Web site or elsewhere...... Read More
Every day millions of new web documents emerge on the... Read More
Microsoft Business Solutions Great Plains has Project Accounting module where... Read More
Microsoft Business Solutions offers several ERP applications: Great Plains, Navision,... Read More
Customer Relationship Management (CRM) is a strategy and processes used... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
The destruction of the Soviet Union about 15 years ago,... Read More
The various resume software offered, particularly on the internet, can... Read More
Whether you are an experienced web programmer or a complete... Read More
IBM Lotus Domino or Microsoft Exchange?The severe competition continues for... Read More
One day, you suddenly realize that your computer started to... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
Document Management or Enterprise Information Management is perhaps one of... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Following tips help you to learn a software in lesser... Read More
This short paper will expand on two key reasons to... Read More
Around the same time Microsoft made its move with .Net... Read More
IBM Lotus Notes Domino and Microsoft CRM (Client Relation Management)... Read More
The first topic we are going to discuss... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Microsoft Great Plains could be tuned and setup to fit... Read More
Microsoft Retail Management (RMS) and Microsoft Great Plains are retail... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
The java programming language is becoming more and more popular... Read More
Did you ever want to erase everything on your computer?... Read More
MS CRM is very close to document workflow automation, including... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
C/SIDE (Client/Server Integrated Development Environment) - The core of... Read More
Let's first look at your ERP system selection (without Retail... Read More
MicroWorld Technologies, Inc. the leading solutions provider in the area... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
Just imagine: you are walking, say, towards your car, and... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
What is Colossus?Colossus is software licensed to about twenty-five insurance... Read More
Software |