This course will teach students to apply industry design patterns and best practices to create business reports and reporting solutions based on years of field experience with the product in a variety of industries and business scenarios. Students will learn to avoid common pitfalls and to apply effective design techniques to meet business requirements. This course is focused on business intelligence solutions, dashboards and analytical reports deployed to an integrated SharePoint business portal environment. SQL Server Reporting Services is the industry-standard reporting tool from Microsoft, available in the SQL Server product suite. It can be used to report on data from many different data sources and database platforms, for operational, business intelligence and analytical reporting. Many of the techniques and practices taught in this course can be applied to a variety of reporting styles and environments with and without SharePoint integration.