Introduction To SQL Server Reporting Services -SSRS
What you'll learn
- Configure SQL Server Reporting Services
- Grant users access to the Reporting Services Server
- Create a Report Server Project
- Define a data source
- Define a Dataset
- Customize report parameters
- Format Reports
- Group Data in Reports
- Add Totals to Reports
- Publish and Deploy Reports through Report Server
- Basic Understanding of Relational Databases
- Basic working knowledge of SQL Server Management Studio
- Basic T-SQL
- Basic SQL
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 anyone
who 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. We
Will then explore the SQL Server Reporting Services Configuration which is configuration tool used to configure SSRS.
Whether you’re new to reporting services, or experienced with earlier versions, we’ll 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.
Configuration of SQL Server Reporting Services
Granting user access to the Reporting Services Server
Creating a Report Server
Defining a data source
Defining a Dataset
Customizing report parameters
Grouping Data in Reports
Adding Totals to Reports
Publishing and Deploying Reports through Report Server
By the end of the course, you’ll have developed a complete reporting solution and be ready to analyse and visualize your own business data with SQL Server Reporting Services.
Who this course is for:
- Database programmers
- Novice Database Administrators -DBA
- Data Analyst
- Data mining Analyst
- Data Scientist
- Project Managers
- Business Analyst
Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .
Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.