|
Data Warehousing and Business Intelligence
- Designing, developing, and implementing data
warehouses with Microsoft SQL Server, Integration
Services, Analysis Services, and Reporting Services
- Designing, developing, and implementing business
intelligence (BI) system architecture
- Designing, developing, and implementing ETL processes
- Extracting data from source systems with SQL Server
Integration Services (SSIS)
- Transforming and loading data with SSIS
- Designing and developing OLAP dimensions, cubes,
unified dimensional models (UDM), and other objects
- Designing and developing reports using both SQL
and MDX for retrieving data
- Automating installation and administration of BI systems,
including use of DSO, AMO, XMLA, and SSIS
| |