Business Intelligence Developer

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server, implement ETL with SQL Server Integration Services, validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services, and implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services. The course is intended for database professionals who need to create and support a data warehousing and business intelligence solution.

• Leverage SSRS to extract Business Intelligence from your data
• Produce reports with enhanced visualization features
• Integrate parameters, filters and interactive components into reports
• Deploy reports through Report Server
• Extract, Transform and Load (ETL) data
• Deploy packages to an SSIS server
• Solve data management problems by migrating and processing data
• Converting data among heterogeneous sources
• Manipulating package variables with scripting
• Handling errors and managing exception rows
• Administering the storage, security and execution of packages
• Writing data to multiple destinations with multicasting
• Profile data to ensure source data quality
• Extract, transform and load operational data
• Create OLAP cubes and automate maintenance
• Extend hierarchies and exploit advanced dimension relationships
• Make smarter business decisions with data-mining techniques
• Deploy and maintain a data warehousing project
• Apply dimensional modeling of the business process to evaluate data
• Employ Business Intelligence (BI) tools to slice and dice data
• Explore data-mining techniques to provide business value