Creating BI Reports with SQL Server Reporting Services

Enrollment in this course is by invitation only

About this course

In this computer science course, you will learn to build reports with SQL Server Reporting Services, which includes new visualization features and mobile capabilities. You will learn to create reporting solutions, mobile reports and dashboards.

Whether you're new to reporting services, or experienced with earlier versions, we'll show you how to build tables, matrices, advanced visualizations, and dashboards with key performance indicators. You'll design and deploy compelling, interactive reports for smartphones, tablets, and browsers.

By the end of the course, you'll have developed a complete reporting solution and be ready to analyze and visualize your own business data with SQL Server Reporting Services.

Note: To complete the hands-on elements in this course, you will require an Azure subscription. You can sign up for a free Azure trial subscription (a valid credit card is required for verification, but you will not be charged for Azure services). Note that the free trial is not available in all regions. It is possible to complete the course and earn a certificate without completing the hands-on practices.

Prerequisites

Familiarity with database concepts and basic SQL query syntax.

Familiarity with the reporting and analytics needs of users.

A willingness to learn actively and persevere when troubleshooting technical problems is essential.

What you'll learn

In this course, you’ll learn theory and techniques for:

Designing visually appealing, meaningful and accurate reports and dashboards from business data

Final Exam
The final exam accounts for 40% of your grade and will be combined with the weekly quizzes to determine your overall score. You must achieve an overall score of 70% or higher to pass this course and earn a certificate.

Meet the instructors

Chris Randall

Senior Content Developer, Microsoft Learning Experiences
Microsoft

Chris is a trainer, consultant, and author with 25 years of industry experience, specializing in SQL Server and the Microsoft data platform. He is a Microsoft Certified Solutions Expert for the SQL Server Data Platform and Business Intelligence, and works in the Microsoft Learning Experiences team as a senior content developer, where he plans and creates content for developers and data professionals who want to get the best out of Microsoft technologies.

Paul Turley

Microsoft

Paul is a Microsoft Data Platform MVP, an independent BI consultant and a Mentor with SolidQ. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the author of Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports and 14 other titles.