Business Intelligence Tutorial, Data Warehouse guide

• 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