ETL-Tools.Info

Business Intelligence - Data warehousing - ETL

• ETL Tools Info
• Data Warehouse
• ETL process
• Data Warehousing ETL tutorial




• Pentaho Tutorial
• SAS ETL Guide


• Excel Crosstab guide
• Excel crosstabs FAQ
• BI resources

Excel crosstabs, pivot tables FAQ and best practices

1. Excel crosstabs and OLAP cubes development

1.1. Modify source connection parmeters of Excel Crosstab

1.2. Modify source SQL statement of Excel Pivot Table

1.3. Oqy Excel cube configuration file contents

2. Excel crosstabs and cubes solutions and examples

2.1. Excel olap cube example

2.2. Excel crosstab refresh