Skip to content
Skip to main navigation
Skip to columns
What is data warehousing, What is data mining, What is BI?
Home
ETL
Mining
OLAP
Sitemap
Home
ETL
Comparison - Datastage vs Informatica
Jitterbit - Open source ETL tool review
Talend Open Studio - Open source ETL tool review
Pentaho Kettle - Open source ETL tool review
Leading Open source ETL tools
ETL process best practices
ETL performance optimization tips
Challenges for Real time ETL
Four layered ETL architecture design
ETL - Data warehousing project life cycle
Real-life execution ETL life cycle
Where does ETL fits in Data Warehousing?
Mining
Difference: Text mining vs Data mining
Text Analytics - Tools & Techniques
Text mining applications & Uses
Text mining software - Commercial & Open source tools
BioNLP - Biomedical text mining
History of Text Data mining
What is text mining?
Purpose of data mining
Microarray data mining - Challenges & Future
OLAP
Multi-Dimensional Analysis - Real life uses
Multi Dimensional Database - Challenges & Benefits
ETL Tools
SSIS Tutorial
SSIS best practices - Use logging only where it is necessary
SSIS best practices - Use partitionaing feature
SSIS best practices - Perform tasks ONLY where it performs better
SSIS Optimization - Optimum use of data types
SSIS Optimization - Adjust the packet-size
SSIS Optimization - Source & Destination connections, Lookup transformation
SSIS best practices - Baselining source extract speed
SSIS best practices - Optimum resource utilization
SSIS best practices - Fitting transformations in memory
Informatica
Informatica Tips: Set based implementation
Informatics optimization: SQL*Loader mappings
Informatics optimization: PL/SQL mappings
Informatica best practices
IBM Datastage
Datastage performance tuning tips
Debugging DataStage parallel jobs
Handling external reference tables in datastage
Programatically generating sequential keys in Datastage
Generating Sequential Keys in Datastage
Clearing user record locks in Universe Database in Datastage
Datastage best practices - Job design TIPS
Abinitio tutorial
Ab Initio ETL best practices
Ab Initio - Performance optimization
Ab initio - Tips to Improve Performance of graphs
Pentaho Kettle
Pentaho Kettle - Data Integration - Tips to handle BIG data sets
What is business intelligence(BI)?
What is data warehouse?
What is data mining?
What is ETL process?
Who are top BI vendors?
Define: Facts, Dimensions table
What is data modeling?
What is star schema?
What is snowflake schema?
What are BI scorecards?
Difference: OLTP vs OLAP
Difference: KPI vs Dashboard
Difference: Dashboard vs Scorecard
Database vs Data Warehouse
Data warehousing vs Data mining
Data warehouse vs Datamart
Star schema vs Snowflake schema
Analytics Vs Data mining
What is the use of BI & DW technologies?
Meta Menu
Sitemap
OLAP Jargons
Aggregate or Consolidate or Roll-ups - Definition & meaning
Calculated Member - Definition & meaning
Cell or Member Combination - Definition & meaning
Children - Definition & meaning
Cross Dimensional - Definition & meaning
Dense - Definition & meaning
Derived Data or Pre-calculated data - Definition & meaning
Dimension - Definition & meaning
Drill down / Drill up - Definition & meaning
Formula - Definition & meaning
Level - Definition & meaning
Member - Definition & meaning
Multi-dimensional Array, Cube, Hypercube - Definition & meaning
Multidimensional Analysis - Definition & meaning
Multidimensional Query Language - Definition & meaning
OLAP Client - Definition & meaning
OLAP Server - Definition & meaning
Page Dimension - Definition & meaning
Page Display - Definition & meaning
Parent - Definition & meaning
Pivot or Rotate - Definition & meaning
Scoping - Definition & meaning
Selection - Definition & meaning
Slice - Definition & meaning
Slice and Dice - Definition & meaning
Sparce - Definition & meaning
BI news archive
Oracle unveils finance data warehouse
Jaspersoft rearchitects BI stack
Self-service BI, SaaS, real-time analytics will dominate 2011 agenda
Emerging tech: Business intelligence apps go mobile
IBM adds assessment tools to data center service offerings
Data analytics requirements push database tech to limits
Sybase IQ updated for parallel processing
Researchers turn to data analytics tools to help stroke victims
Microsoft's Bob Muglia details cloud strategy
Q&A on Emerging Tech: Analyzing the Voice of Your Customer
Planned Netezza deal further defines IBM's analytics plans
SAP rolls out real-time business analytics apps
BI firm takes iPads over laptops
SAP partner launches cloud-based mobile app service
SAS rolls out predictive analytics for business users
Agile Meets Integration at TDWI Conference
Cloud computing offers speedy path to business innovation, report says
Under the Hood of Oracle's Revamped BI Suite
An Imperative to Build, Not Buy, Agile BI
JReport 10 Enhances Agile BI with Rich Visualization
Memphis cops use predictive analytics to fight crime
Quantivo 4 Enables One-step Query Analysis to Behavioral Marketing
DePaul University to offer grad degree in predictive analytics
Harnessing the Power of PowerPivot in the Enterprise
Q&A: Creating a More Agile Organization
BI Trends: LyzaSoft Champions Social Media
Top Tips for Effective DI
Indianapolis launches $16M ERP project
IBM Embraces MapReduce for Big Data Analytics
Attivio Releases Active Intelligence Engine 2.1
Berners-Lee explains his 'linked open data' idea
Composite Software Updates Data Virtualization Platform
SAP quiet on its plans for Sybase
Strategies for Organizing Business Analysts
Understanding Kalido's Diversity
Rapidly Expanding Birst Partner Program Delivers New Source of Easy-to-Deploy : BIS
SAP to Acquire Sybase, Inc.
IBM points predictive analytics at social Web
Sharp stock market drop likely human, computer error
Making the Case for Agile BI
DW Guide
Fundamentals
Difference: OLAP system Vs. BI Vs. Decision Support Systems
Operational Daata Store(ODS) Vs. Data mart Vs. Data warehouse
Dimension modeling and Data normalization
Fundamentals - Types of data modeling
Fundamentals - What is data profiling?
Legacy systems vs OLTP systems
DW fundamentals - Types of Data Marts
Data warehouse Vs. Data warehousing Vs. Enterprise datawarehouse
Fundamentals - Building blocks of Data WareHousing
Architecture
Data Warehouse Architecture - Kimbal's Bottom-Up approach
Data Warehouse Architecture - Top down approach
Benefits of having a data warehouse architecture
Factors that affect Data warehouse Architecture
Data warehouse architecture - ETL layered approach
Data modeling
Metadata repository in Data Warehousing
Indexing in data warehouse
What is Surrogate Key? Surrogate Key Vs. Natural Key
Dimensional data modeling - Types of dimension tables
Dimensional data modeling - Types of fact tables
Dimensional modeling - Olap data modeling tutorial
ETL Process
Management
Database capacity planning for a Data Warehouse
ETL Project - Prioritizing the requirements
ETL Project - Requirements gathering process
Home
Sitemap
Latest blogs & articles
Pentaho Kettle - Data Integration - Tips to handle BIG data sets
Database capacity planning for a Data Warehouse
ETL Project - Prioritizing the requirements
ETL Project - Requirements gathering process
Metadata repository in Data Warehousing
Data Warehouse Architecture - Kimbal's Bottom-Up approach
ETL Tools
SSIS Tutorial
Informatica
IBM Datastage
Abinitio tutorial
Pentaho Kettle
DW Guide
Fundamentals
Architecture
Data modeling
ETL Process
Management
BI & DW - Interview questions
|
Insomnia articles
|
Job interview questions with answers
Sitemap
OLAP Jargons
BI news archive
BI & DW - Quickstart tutorial
Free tutorials on fundamental concepts of business intelligence and data warehousing:
What is business intelligence(BI)?
Who are the leading BI technology vendors?
What are BI scorecards(balanced scorecard)?
Difference: Data mining vs Analytics
What is the use of BI & DW technologies?
Basics - Data warehousing
What is data warehouse?
What is data mining?
What is ETL process?
What is data modeling?
Data warehouse vs Datamart
Data warehousing vs Data mining
Database vs Data Warehouse
OLAP - Beginners guide
Define: Facts, Dimensions table
Difference: OLTP vs OLAP
What is star schema?
What is snowflake schema?
Star schema vs Snowflake schema
Difference: KPI vs Dashboard
Dashboard vs Scorecard