Defining Olap Solutions And Data Warehouse Design
|
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
|
|
|
Great Plains Custom Development: Dexterity, Vba, Sql, Crystal, Econnect ? Overview For Programmer
Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. It has multiple customization/modification/reporting tools. Currently there is upgrade campaign to version 8.0 and due to the discontinuation of the technical support for Microsoft Great Plains Standard on Ctree and Pervasive SQL - we see substantial increase in migration needs: migration from c...(related: Software)
Daffodil Db: Web Database
What is a Web Database?A web database is a database for the internet. You can get access to your data via the internet from anywhere in the world. Or, you can create a database driven website by using such databases. A web database stores large amount of information in an organized format that is easily accessible from scripting languages (like PHP).In web databases, modifications, like the ones constantly used by e-commerce sites, for example, can be performed without any hassles .That makes the dense editing of the html code obsolete. Repeated types of data, like contact information, can be generated automaticall...(related: Software)
Unwanted Files
A LOT OF UNWANTED FILES.When you uninstall an item of software, there are generally a number of redundant files left behind to clutter up your hard drive.Over the course of a year or two they can be using valuable hard drive space that would be better reserved for more important things.These files are backups that are generated when software is installed, the reason is not important. All that we need to know is that when the software is un-installed they are no longer required.To remove them and free up drive space is a simple procedure.If you are using Windows 98 - ME - or 2000.Click on Start>Search>For file...(related: Software)
Linux ? Keyboard Or Mouse
Just stress testing one of the latest Linux distributions. Been testing it for about two months. You know, Linux has advanced some distance since 1992-1993. It looks great! Because Linux is customizable, I decided to change a few of the resident commands. These were not wholesale changes and everything worked out o.k. So I started thinking again. You know, that can lead to solutions you can't get out of. In this instance, everything worked like a trusty timepiece.Why customize it? It's much easier to navigate all of the menus within KDE or Gnome. Set-up most commands with my personal, seven set-ups. With seven set-ups, my self scribed moniker for the upgrade; most applications are accessible with no more than seven key combinations. Open a file? Ctrl-Alt-A. If you want to search inside a sub file, just click, Ctrl-...(related: Software)
Your Computer May Be Infected, Heres How To Check (not About Virus)
NOTE: Please take time to read on - it may be vital for your PC's security. If you are not in the mood, just save it or print it out for later reference.A recent research revealed that 80% of the computers today is infected with these dangerous spyware and most of the users not aware of it. (Your computer could fall into this lot too.) The most dangerous f...(related: Software)
What Is Groupware?
Vince Lombardi once said that, "The achievements of an organization are the results of the combined effort of each individ...(related: Software)
Ukraine: A Prospective Player On The World Software Outsourcing Market
The destruction of the Soviet Union about 15 years ago, made a huge country with a great level of IT science divided into small bricks. Nowadays, despite Russia's expansion into the world software development market, Ukraine keeps playing an important role here too. There are several prerequisites for this.PrerequisitesTraditionally, Ukraine always was a technical region of the USSR. No wonder, the IT education was and still is one of the most popular and respective education in the region. Such well-known Ukrainian universities as Kyiv National Technical University, Donetsk National Technical University etc. as well as new establishments with more innovative approach for IT specialists education, such as Donetsk State Institute of Artificial Intelligence and others, educate a new prospective generation of youn...(related: Software)
Microsoft Great Plains Implementation: Collection Management ? Overview For Consultant
Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product ? Great Plains provides such horizontal solutions as Collection department automation. The most common question we hear in collection department is how we assign problem clients to sp...(related: Software)
Groupware As A Document Manager: Collaboration Series #3
This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Some of these characteristics may go hand in hand with business collaborative needs. Other characteristics go beyond what some groupware providers have to offer. The purpose of these articles is to equip the groupware user or investigator with helpful knowledge about the product in order to enable more effective use or to lead the investigator to...(related: Software)
Microsoft Crm Integration With Microsoft Office Documents ? Overview For System Integrator
Microsoft CRM is CRM application, maintained and supported by Microsoft Business Solutions. Microsoft CRM utilizes majority of the Microsoft technologies: Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing, .Net web services to name a few. There is market demand on the efficient integration of MS Office documents into Microsoft C...(related: Software)
Microsoft Great Plains: Exchange & Brokerage ? Implementation Notes
If you company is small or mid-size special products or materials exchange broker, you probably have custom in-house made exchange application. Nowadays exchange is done over the internet, so you might have advanced web-based exchange application. Microsoft Business Solutions Great Plains could play the role of the backend: accounting, sales and purchasing ordering, backordering, allocation, collection. In this case we expect tight integration between your exchange application and Great Plains. In this small article we consider industry / market niche specifics and the ways to realize these requirements:? Exchange Transaction. Exchange transac...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software