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
• BI News
  • 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

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
• Difference: Dashboard vs Scorecard
• 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