Tutorials And Trainings

ETL Data warehousing tutorial
ETL Data warehousing tutorialThe ETL tutorial demonstrates the real-life data warehousing scenarios with sample solutions. The course depicts typical datawarehousing problems and shows many ways to handle and...
Informatica PowerCenter tutorial
Informatica PowerCenter tutorialThis Informatica Powercenter tutorial provides a step-by-step walkthrough of the most relevant topics related to Informatica ETL tool. Majority of the tutorial lessons describe...
Microstrategy online video tutorials
Microstrategy online video tutorialsFree Microstrategy online tutorials section provide informative online videos which helps learn the basics of MicroStrategy. The videos aim bith towards the business and the...
Database and Data Warehouse Tuning Principles
Database and Data Warehouse Tuning PrinciplesDatabase and Data Warehouse Tuning principles, experiments and troubleshooting techniques is an over 200 slides presentation in the form of tutorial on how to tune the DWH system....
Data warehousing articles
Data warehousing articlesThis knowledge base provides an overview of Data Warehousing and Business Intelligence topics with articles covering Data Integration, data migration and quality management,...

SAP Business Warehousing tutorial
SAP Business Warehousing tutorialThe SAP Business Warehousing tutorial shows how SAP BW consolidates the external and internal data sources into a single repository and provides preconfigured data that helps the...
Starring Sakila - Datawarehousing mini tutorial
Starring Sakila - Datawarehousing mini tutorialThis site provides a recording of a webinar Roland Bouman gave for MySQL University. In this 1 hour presentation, he demonstrates how to use the popular MySQL Sakila sample...
SAP BusinessObjects
SAP BusinessObjectsSAP Business Objects business intelligence information portal which provides a good, descriptive overview of the BO applications in the area of strategy management and enterprise...
SQL Lion
SQL LionThe SQL Lion webpage provides information on programming microsoft sql server integration services (ssis), optimizing and monitoring tempdb for better performance and best...
IBM Infosphere tutorial
IBM Infosphere tutorialThe IBM Infosphere Datastage and Qualitystage Enterprise Edition (a part of IBM Information Server) tutorial provides learning materials and discusses the architecture of IBM...
QlikView tutorial for developers
QlikView tutorial for developersThe QlikView tutorial available on QlikTech pages is a self paced learning document which walks users through the features of QlikView. The material is very detailed and includes...
Sybase tutorial
Sybase tutorialThe basic sybase tutorial provides a few articles including an overview of Sybase database, a set of Sybase DBA Tasks Unix Scripts and Sybase DDL Overview. The Sybase DDL SQL...
DWHLabs Informatica ETL Tutorial
DWHLabs Informatica ETL TutorialDWHlabs portal is exclusively designed for Data warhouse developers. Most of the content relates to data warehousing and ETL products with main emphasis on Informatica. The site...
Datastage modify stage video
Datastage modify stage videoThe Video tutorial presented by Andy Sorrell shows how to use modify stage in datastage to manipulate the data in a job. The tutorial points out the advantages of using Modify...
Crystal Reports 2008 Users Guide
Crystal Reports 2008 Users GuideCrystal Reports users guide PDF available on SAP Business Objects pages. Provides new features of CR 2008, an installation overview, basic report design concepts, provides...
Integration Services Tutorials
Integration Services TutorialsFree Microsoft SQL Server 2005 Integration Services technical tutorials on microsoft pages. Currently there are three tutorial lessons available: Creating a Basic Package Using...
MSSQL Server 2005 tutorial
MSSQL Server 2005 tutorialThe Microsoft SQL Server 2005 tutorial provides lessons which help learn basic concepts of MSSQL Server database architecture. The tutorial provides 16 lessons which cover such...
Integrating Crystal Reports with IBM Rational Application Developer
Integrating Crystal Reports with IBM Rational Application DeveloperThe tutorial article provides step-by-step instructions on how to use the Embedded Crystal Report Designer in IBM Rational Application Developer (RAD). It explains how to embed...
Pentaho Dashboard Documentation
Pentaho Dashboard DocumentationPentaho BI Server Documentation page provides the latest Pentaho Documentation and how to documents on the installation and configuration of Pentaho. The dashboard provides a...
Cognos training space
Cognos training spaceCognos training space provides Cognos 8 BI Query Studio and Report Studio CBT (computer based training) - an online introduction to the Query Studio and Report Studio - ad hoc...
SQL Down Under
SQL Down UnderSQL Down Under is a podcast (audio show) for MS SQL Server professionals. In each show, Greg Low interviews a well-known identity from the Microsoft SQL Server community. Each...
SAP Business Warehouse interview questions
SAP Business Warehouse interview questionsA total of 50 technical interview topics related to SAP Business Information Warehouse. The website provides a very basic answers to the SAP BW interview questions. The site...
SAP BW Technical Interview
SAP BW Technical InterviewA list of approximately 30 SAP BW interview questions with simple and accurate answer proposals. It covers such potential interview areas as: SAP and ERP systems SAP BW...
Business Objects documentation
Business Objects documentationBusinessObjects documentation with product guides of all BI products offered by Business Objects, including Business Objects Data Integrator (BODI), Business Objects Enterprise...
Data warehouse real-world examples
Data warehouse real-world examplesThe data warehousing tutorial illustrates two real Data Warehousing scenarios. The first business case is a design of a real world data warehouse for Levis Strauss. Another is a...
Hyperion Financial Reporting tutorial
Hyperion Financial Reporting tutorialThe Hyperion blog provides rich information and a free online training on Hyperion reporting tools. The Hyperion Financial Reporting tutorial shows how to generate a simple report...
Online Cognos ReportNet tutorials
Online Cognos ReportNet tutorialsFree online Cognos ReportNet tutorials presented in Flash. The site provides more than 20 helpful guides and sample uses of Cognos ReportNet to provide BI...
SQL Server Integration Services ETL Platform
SQL Server Integration Services ETL PlatformThe article examines some of the most useful features of Microsoft SSIS to build ETL applications. It contains a guide on how to build a simple package using the key SSIS...
Data Transformation Services (DTS) in SQL Server 2000
Data Transformation Services (DTS) in SQL Server 2000Microsoft SQL Server 2000 Data Transformation Services (DTS) ETL tool overview article introduces the DTS tools available for creating and executing DTS packages in SQL server...
SQLDTS Data Transformation Services portal
SQLDTS Data Transformation Services portalThe Microsoft Data Transformation Services resource portal provides many interesting technical articles and tutorials about Microsoft DTS. It provides an experts FAQ which shows...
Teradata MultiLoad Guide
Teradata MultiLoad GuideThe Teradata MLoad tutorial guides through the process of importing, updating and deleting data on Teradata RDBMS using Teradata MultiLoad loading tool. The tutorial recommends...
Teradata TPump Tutorial
Teradata TPump TutorialThe Teradata tutorial presentation of using Teradata TPump in an Active Data Warehouse Environment shows the use, features and architecture of using TPump in great detail. It...
Practical Example of Data Transformation Using Kettle
Practical Example of Data Transformation Using KettleA great Pentaho Data Integration (Kettle) tutorial which shows a real life example of ETL process for an entertainment vendor. It illustrates how to deal with a set of flat, tab...
Hyperion reporting and analysis Documentation
Hyperion reporting and analysis DocumentationReporting and Analysis section of the online Hyperion Enterprise Performance Management System Documentation. There are many documents in HTML and PDF format on various Hyperion...
Oracle SQL Hints
Oracle SQL HintsA good guide on SQL query optimization by using SQL Hints in an Oracle database. The tutorial shows why the hints are useful and when Oracle hints should be used instead of the...
Dashboard Building
Dashboard Building The tutorial shows how to create dashboards using the Pentaho BI Suite. It describes the sample dashboard provided with the Pentaho Demo server (it works both in JSP and PHP...
MySQL and Pentaho samples
MySQL and Pentaho samplesThe MySQL Samples For Pentaho tutorial shows how to use MySQL to leverage functionality offered by Pentaho. The sample guide shows how to implement reporting, ETL process,...
Informatica Interview Questions
Informatica Interview QuestionsOver 500 interview questions related to Informatica and its Data Warehousing solutions. Reading those questions and answers should not be considered only as a preparation for an...
Ask Tom Oracle Questions and Answers
Ask Tom Oracle Questions and AnswersAskTom is a rich knowledge base for working with Oracle databases. People ask questions related to Oracle or describe problems they are facing. Tom answers those questions which...
How to avoid database explosion
How to avoid database explosionThe author of that article points to a potential problem of Exploding multidimensional databases in the OLAP architectures. The article helps understand the problem of a database...
BIRT for Eclipse
BIRT for EclipseIntroduction and overview of the Open Source Business Intelligence and Reporting Tools - BIRT. BIRT provides core reporting features under Eclipse development framework for Java...
How to create an Oracle Analytic Workspace
How to create an Oracle Analytic WorkspaceThe tutorial shows how to populate a samle OLAP Analytic Workspace with dimensions and cube objects using Analytic Workspace Manager - Oracle AWM. The tutorial is based on a...
Hyperion Essbase
Hyperion EssbaseA very good Hyperion Essbase guide on wikipedia. It provides a brief introduction to Essbase, its history, interesting facts and main features. Great attention is paid to the...
Excel Pivot Tables tutorial and FAQ
Excel Pivot Tables tutorial and FAQThe tutorial points out the major pros and cons of using Excel crosstabs and includes a step by step guide on how to create a Microsoft Excel crosstab based on a real business...
ETL Package creation in SSIS
ETL Package creation in SSISThe tutorial shows how to create a simple ETL Package using graphical tools and wizards of SSIS Designer - Microsoft SQL Server 2005 Integration Services. The tutorial illustrates...
Getting Started with Discoverer
Getting Started with DiscovererThe getting started with Oracle Discoverer tutorial is a great site to start learning Oracle Business Intelligence. The tutorial uses a small database that contains information...
Hyperion Essbase Tips
Hyperion Essbase Tips The tutorial contains a number of Hyperion Essbase tips divided into Calcultion Script, Database Design and Excel Essbase Addin sections. We especially recommend reading tips...
Hyperion Information
Hyperion InformationThe first part of that Hyperion Enterprise tutorial contains posts and FAQ's which help understand the idea which stands behind Hyperion and its way of operation. There are around...
Hyperion Enterprise Tutorial
Hyperion Enterprise TutorialThis Hyperion Tutorial shows the way data is stored and accessed in Hyperion Enterprise. It is divided into a Data Elements section, Data Address, Entities and Organizations,...
Data warehouse architecture training articles
Data warehouse architecture training articlesData warehousing training and tutorial articles on the pages of Kimball Group. The data warehouse architecture articles cover all the relevant areas a data warehouse architect...