Data Warehouses and OLAP

After you install the program, you can create a standard data warehouse with the Blackbaud Data Warehouse Deployment Wizard. The data warehouse copies data from your source database and places it in a data warehouse to allow you to conduct complex reporting and analysis. For information about the deployment wizard, see the Installation Guide.

After you create the data warehouse, options appear in Administration for the Extract, Transform, and Load (ETL) process. The ETL process extracts records from the source database, transforms them for optimal loading into the OLAP cube, and loads them in the data warehouse. From Administration, you can access the Reporting data warehouse page to monitor ETL activity, schedule business processes to coincide with the ETL process, and manually start an ETL refresh.

When the deployment wizard creates the standard data warehouse, it also creates an OLAP cube to conduct complex reporting and analysis on the data in the data warehouse. The cube increases your ability to manipulate data from the source database, and it allows you to perform advanced reporting. With the OLAP Explorer, you can build pivot tables and charts based on the OLAP cube. The program also includes Microsoft Excel report templates so that you can use subsets of the data in the OLAP cube to create reports in Excel.