SQL Server Reporting (Server and EndUser) Core Skills
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 2016, 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 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

Course Price
Early Bird Price
19 Feb - 20 Feb 2018
$1190+GST if paid by Feb 6
Introducing Server-Based Reporting Services
- Server-based Reporting Fundamentals
- Creating Reports
- Common Report Items
- Deploying Reports
- LAB: Creating and Deploying Reports
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
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
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
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
Discovering and Preparing Data with Power Query in Power BI Desktop
- Using Content Packs
- 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
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
Creating and Querying Dashboards with the Power BI Site and Power Q&A
- Working with the 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
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement