Business Intelligence Tutorial, Data Warehouse guide
Skip to content
Home
ETL Tutorial
Data mining
OLAP Guide
You are here:
Home
Sitemap
Sitemap
Home
ETL Tutorial
Data mining
Text Analytics
Text mining applications
Text mining tool and text mining software
BioNLP - Biomedical text mining
History of Text Data mining
Text mining
Purpose of data mining
Microarray data mining
OLAP Guide
Multi-Dimensional Analysis
Multidimensional Database
Quickstart BI
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
Database vs Data Warehouse
Data warehousing vs Data mining
Data warehouse vs Datamart
Star schema vs Snowflake schema
Where does ETL fits in Data Warehousing?
ETL life cycle
ETL - Data warehousing project life cycle
ETL architecture
Real time ETL - needs & challenges
ETL performance optimization tips
ETL design best practices
Introduction: Open source ETL tools
Pentaho Kettle - Open source ETL tool review
Talend Open Studio - Open source ETL tool review
Jitterbit - Open source ETL tool review
Datastage vs Informatica
ETL Software Tutorials
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 tutorial
Informatica Tips: Set based implementation
Informatics optimization: SQL*Loader mappings
Informatics optimization: PL/SQL mappings
Informatica best practices
Datastage tutorial
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 tutorial
ETL Software Tutorials
SSIS Tutorial
Informatica tutorial
Datastage tutorial
Abinitio tutorial
Pentaho Kettle tutorial
OLAP Jargons
Quickstart BI Tutorial
Business intelligence and Data warehousing basics for beginners:
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
Database vs Data Warehouse
Data warehousing vs Data mining
Data warehouse vs Datamart
Star schema vs Snowflake schema
Interview Questions
Data minining blog