Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Five Tips For A Great Software Demo Whether you need to close a sale, gather end-user feedback, show progress to your customer, or simply explain how your product works, sooner or later, you will need to demo your software product.Over the years, I've had the opportunity to perform hundreds of demos to audiences of various sizes. Theres Gold in Your Websites Server Log Many Webmasters have never bothered to view their website's server log. Ignoring your server log is like flying with a blind pilot. You Can Write Microsoft Office Program in About 60 Minutes Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. Hubris - Definition: Microsofts Passport Before September of 1995, Microsoft ignored the Internet because their 16-bit Windows 3.1 operating system couldn't handle the 32-bit Internet world. MSN Messenger Is A Sweet Way To Communicate MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. Microsoft Great Plains Integrations - Tips for Developer In this short FAQ style article we would like to introduce you - software developer, programmer, database administrator into Microsoft Great Plains Integration tools and optionsMicrosoft Great Plains is main Microsoft Business Solutions product for US mid-market. Historically Great Plains Software designed Great Plains Dynamics and Dynamics C/S+ as multiplatform application and the integration was possible via Great Plains Dexterity or Dexterity-based end user tools, such as Import Utility and later on via Integration Manager. Microsoft Great Plains Project Accounting - Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. What is Software Piracy? There are several kinds of software piracy. The bottom line is when software is pirated, the developer does not receive compensation for their work. Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics - highlights Microsoft bought Navision, Denmark based software development company, along with Great Plains Software. Now Microsoft Business Solutions offers the following ERP applications: Navision (former Navision Attain), Microsoft Great Plains (former Great Plains Dynamics/eEnterprise), Solomon, Axapta. Adware and Spyware What is 'adware'?Adware is basically software or scripts that are hidden on your computer, that make advertising show up all over the place. It may be an extra menu in your web browser, icons appearing on your desktop, bookmarks or favourites appearing out of no where, and pop up ads that seem to come from no where!What is 'spyware'?Spyware is similar in nature to adware, however I feel its purpose is slightly more sinister. What You Should Know About Installing Screensavers Do you remember that frustrating feeling when you find an interesting screensaver and can't install it on your computer? This article will help you to never have it again.Back to when Windows 95 started to find its home on many computers there was just half a dozen of screensavers preinstalled with the system. Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. You should probably expect some issues when you have software development company to be bought by big player - in this case Great Plains Software was bought by Microsoft (Bill Gates was a friend to Doug Burgum - owner and leader of Great Plains Software - Great Plains Dynamics/eEnterprise). SQL scripts for Project Accounting: Microsoft Great Plains series - overview for developer Microsoft Business Solutions Great Plains has Project Accounting module where you can budget the project, assign it to customer contract and then log expenses, timesheets, inventory spending, and finally bill the customer against the project or contract. Microsoft Great Plains Project Accounting does excellent job, but there are cases when you need developer or MS SQL DB Admin touches. SSH (SCP) Send Files from Windows to Your Linux Box Not all of us have the luxury of working both at home and at work on a UNIX based system. However that doesn't mean you can't transfer files safely and securely between the two systems. Free Microsoft Word Online Training Tutorial Resources Microsoft Word is one of the most popular office applications that provide many features such as word processing, web publishing and database creation. Tapping into these Word resources, however, is not always easy and straightforward, leaving users stumped and puzzled. Great Plains DOS Support - Notes for Consultant Great Plains Accounting, accounting package for mid-size and small companies was in its peak of popularity back in earlier 1990th. It first had DOS interface, later on migrated to classic Windows version (remember earlier event driven Windows and its strange and at the same time revolutionary programming model - guys who remember Borland C++ and Microsoft C++). A Case Study on Selecting Contract Management Software Professional services firm cuts costs and improves productivity with integrated software system."I could satisfy the government, but I couldn't give managers the information they needed to do their jobs," says Shannon Winston, Controller for Apex Environmental. Are You Waiting for Microsoft Longhorn Operating System I love new technology. I am still ready to wait long for Longhorn. Microsoft Great Plains Implementation in Russia - Overview for Consultant Microsoft Business Solutions Great Plains is very popular ERP platform in the USA, Canada (including French speaking Quebec/Montreal), U.K. Microsoft Great Plains Remote Support - Overview Microsoft Great Plains is now standard mid-market ERP application, serving the whole spectrum of businesses. In the case of mid-size business we usually see strong IT team with SQL querying skills plus accounting department is already trained to use Great Plains and needs minimal help in figuring out on how to use new Great Plains version and features. |
home | site map | contact us |