SQL Server Reporting Services (Server and End-User) Core Skills (2 days)


SQL Server Reporting Services is Microsoft's premier reporting tool. This course is designed to take you through the most important components of SSRS, with just the right amount of depth, within two days.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

On the first day, you'll see how you can use SQL Server Reporting Services to provide pre-prepared server-based reports, how to secure the reports, and how end-users can use Report Builder to create their own reports. On the second day, the course looks at how the Power BI tools (such as Power Pivot, Power View, Power Query, Power Map, Power Q&A, and Power BI Sites) can provide self-service BI options in conjunction with Microsoft Excel and/or Sharepoint.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

 



DAY 1 RS201 INTRODUCING SERVER-BASED REPORTING SERVICES
Server-based Reporting Fundamentals
Creating Reports
Common Report Items
Deploying Reports
LAB: Creating and Deploying Reports
DAY 1 RS202 WORKING WITH COMMON REPORT ELEMENTS AND CREATING DYNAMIC REPORTS
Additional Common Report Elements
Creating Dynamic Reports Using Parameters
Creating Dynamic Reports Through Links and Document Maps
LAB: Creating Dynamic Reports
DAY 1 RS203 MANAGING REPORT EXECUTION AND SECURITY
Extending Reports with Custom Logic
Reporting from Analysis Services
Optimising Report Execution
Securing Report Server Items and Data
Delivering Reports with Subscriptions
LAB: Managing Report Execution and Security
DAY 1 RS204 END-USER REPORTING WITH REPORT BUILDER
Introduction to Report Builder
Creating Map-Based Reports
Data-Feeds as Data Sources
LAB: Report Builder Self-service Reporting
DAY 2 PB201 OVERVIEW OF POWER BI
Why Implement a BI Solution?
Introduction to Power BI
Earlier Versions of Power BI
Current Power BI Toolset
LAB: Installing and Configuring Power BI Tools
DAY 2 PB202 DISCOVERING AND PREPARING DATA WITH POWER QUERY IN POWER BI DESKTOP
Using Content Packs and Apps
Acquiring Data using Power Query
Transforming Data using Power Query
Managing Queries and Data Sources
LAB: Discovering and Preparing Data with Power Query in Power BI Desktop
DAY 2 PB203 CREATING AND ENHANCING DATA MODELS USING POWER PIVOT IN POWER BI DESKTOP
Creating a Power Pivot Data Model
Adding Measures and Calculations to Power Pivot Data Models using DAX
Enhancing a Power Pivot Data Model
LAB: Creating and Enhancing Data Models using Power Pivot in Power BI Desktop
DAY 2 PB204 CREATING AND QUERYING DASHBOARDS WITH THE POWER BI SITE AND POWER Q&A
Working with the PowerBI.com Site
Creating Datasets, Reports, and Dashboards
Interacting with Data Using Power Q&A
Accessing On-Premises Data via Gateways
LAB: Enhancing Power Pivot Data Models