BI790 – SQL Server 2016 Reporting Services (SSRS) …

1 AudienceThis course is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2016 Reporting attending this course, students must have: A general familiarity with databases prior to the class. Additionally, working knowledge of Microsoft SQL Server or Microsoft Office applications is addition, it is recommended, but not required that students have completed course: SQL101: Introduction to Transact-SQL OR SQL250: Transact-SQL for DevelopersWHAT YOU WILL LEARN After completing this course, students will be able to: Use ssrs tools Work with solutions and projects Design basic reports Enhance reports with formatting, images and charts Effectively group and summarize data Work with parameterized reports Incorporate charts and custom maps Work with drillthrough reports Manage reports Utilize Report BuilderBI790 SQL Server 2016 Reporting Services ( ssrs )

2 For Report DevelopersDuring this course, attendees will learn how to use ssrs tools, work with solutions and projects, design basic reports, enhance reports with formatting, images, and charts, effectively group and summarize data, work with parameterized reports, incorporate charts and custom maps, work with drillthrough reports, manage reports, and to utilize Report Server 2016 / 2014 / 2012(course outline on back side)Can t make it to class in person?Attend many classes online with RemoteLive. Call 602-266-8585 today for a live demo. 2017 Interface Technical Training All rights reserved Interface is amazing! I ll definitely come back for any training I need. Interface StudentPhoenix, AZ$ 4-day course SA Voucher EligibleRegister Today! OUTLINE BI790 SQL Server 2016 Reporting Services ( ssrs ) for Report DevelopersModule 1: ssrs Overview and Tools Reporting Services Features Tools Available with SQL Server 2016 SQL Server DocumentationModule 2: Working with Solutions and Projects Working with SQL Server Data Tools Understanding Solutions and Projects Working with the Visual Studio Interface Lab 1: Working with Solutions and Projects (Optional)Module 3: Creating Basic Reports What is a Data Source?

3 What is a Dataset? Using the Report Wizard What is Tablix? Creating a Tabular Report Creating a List Report What is a Matrix? Deploying a Project Lab 1: Creating Basic ReportsModule 4: Formatting Reports Working with Text Boxes Rich Text Formatting Managing Text Boxes Drawing Lines and Boxes Images Page Headers and Footers Adding a Document Map Rendering Reports Lab 1: Formatting ReportsModule 5: Custom Expressions Understanding Expressions Defining Expressions Working with Report Variables Understanding Lookup, LookupSet, and Multilookup Functions Expression Samples Lab 1: Custom ExpressionsModule 6: Summarizing and Sorting Creating Groups Parent/Child vs. Adjacent Groupings Adding Totals and Aggregations Creating Aggregates of Aggregates Lab 1: Summarizing and SortingModule 7: Add Flexibility with Parameters Adding Parameters to a Report Report Parameters vs.

4 Query Parameters Manage Report Parameter Properties Use Parameters with SQL Queries and Stored Procedures Work with Cascading Parameters Sort Based on a Parameter Setting Filtered Reports Lab 1: Add Flexibility with ParametersModule 8: Enhanced Report Items Charts Gauges Add a Map to a Report Data Bar, Indicator, and Sparkline Report Items Nesting Data Regions Subreports and Drillthrough Reports Working with Drillthrough Reports Lab 1: Enhanced Report ItemsModule 9: Using Report Manager Deployment Navigating Report Manager Understanding Permissions Viewing Reports Working with Shared Data Sources Managing Reports Lab 1: Using Report ManagerModule 10: Using Report Builder for SQL Server 2016 ClickOnce vs. Stand-alone Installing the Stand-alone Version Using the Report Builder Tool Creating Datasets Creating Reports Creating Reports Using Wizards Creating Reports Without a Wizard Opening Existing Reports Working with Report Parts Lab 1: Using Report Builder for SQL Server 2016 Register by phone at 602-266-8585, or online at 2017 Interface Technical Training All rights reserved.

5 V033017