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
Introduction: The creating of a computer program involves a number... Read More
The vast majority of us will have, at some point,... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Great Plains fits to majority of industries, in the... Read More
In the Clinton era the status quo was simple: you... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
The US House of Representatives has recently passed the "Spy... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More
One of the things we can be as certain of... Read More
Let's say that you have a software project that's under... Read More
(1) Avoid using the same variable again and again for... Read More
Finally, you have some time to personalize your desktop with... Read More
Program Flow is what you think it is. How the... Read More
Many Webmasters have never bothered to view their website's server... Read More
With thousands of web pages added to the Net every... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Background: For many organizations like ours, the interim target of... Read More
It is possible that if one avoided all sources of... Read More
The stakes are high when considering security, privacy, and savings,... Read More
Lotus Notes Domino is very efficient in electronic document workflow... Read More
SOFTWARE PIRACY We regularly hear reports... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
Itâ??s easy to understand why you might be drawn to... Read More
Following tips help you to learn a software in lesser... Read More
Icons are used everywhere; right from software applications, to internet... Read More
In today's business world it's all but impossible to escape... Read More
There are two major WYSIWYG(What You See Is What You... Read More
If your company has regional and worldwide operations, you might... Read More
At the end of XX century, in the late 1990th... Read More
You've finally created databases that you can actually use to... Read More
When you own a small business, time is money. And... Read More
In this article you will find some background information about... Read More
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More
Whether you have used Microsoft Word for years, have just... Read More
What is a Web Database?A web database is a database... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
2005 ? Back to the Future.What does the future hold?... Read More
Should one use Windows Update?This topic has good and valid... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Viruses and spyware usually show up on your computer one... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
The Software 2005 conference is now a wrap. This conference,... Read More
The java programming language is becoming more and more popular... Read More
Not every software testing project can or should be automated.... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
Most people understand that the "hardware" part of their computer... Read More
The most important things you can do for your computer... Read More
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
The US House of Representatives has recently passed the "Spy... Read More
Crystal Reports is the most flexible tool on the market... Read More
XML parser is a software module to read documents and... Read More
In our case ? we serve Microsoft Business Solutions ERP... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
Bad News - the Threat is Bigger than it SeemedHow... Read More
GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Considering whether or not your software company should hire a... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
Are you lost in the mess of documents that get... Read More
Software |