This course introduces Microsoft’s SQL Server Reporting Services 2014 (SSRS) utility but is also applicable to Microsoft SQLserver Reporting Services 2016 as well as SQL Server 2008 R2 release and later versions. This course is for anyonewho wants to develop reports and has no prior experience with SQL Server Reporting Services. I will walk you through how to use the development tools effectively to create, enhance and present reports. The course starts off by setting up the environment which includes the installation of Microsoft SQL Server, SQL server Data Tools, Microsoft Visual Studio and also the download and installation of AdventureWorks 2014 sample database. WeWill then explore the SQL Server Reporting Services Configuration which is configuration tool used to configure SSRS. Whether youre new to reporting services, or experienced with earlier versions, well show you how to design and build reports and Leverage SSRS to extract business intelligence from your data. We will create dataset from our data source and use T-SQL to create aliases, aggregate functions, table-joins, grouping data with the having clause. Topics include: Configuration of SQL Server Reporting ServicesGranting user access to the Reporting Services ServerCreating a Report ServerDefining a data sourceDefining a DatasetCustomizing report parametersFormatting ReportsGrouping Data in ReportsAdding Totals to ReportsPublishing and Deploying Reports through Report ServerBy the end of the course, youll have developed a complete reporting solution and be ready to analyse and visualize your own business data with SQL Server Reporting Services.
