Analyzing and Visualizing Data with SQL Server Reporting Services

Analyzing and Visualizing Data with SQL Server Reporting Services

Microsoft DAT214x-LAAS

Free of Charge

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.

Course 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 will learn

  • Designing visually appealing, meaningful and accurate reports and dashboards from business data
  • Authoring and publishing paginated reports, mobile reports, and key performance indicators (KPIs)
  • Using SQL Server Reporting Services features such as parameters, expressions, charts, scorecards and dashboards

What’s included

Module 1: Report and Dashboard Solutions
This module introduces report concepts, authoring roles, and tools available to create reports and dashboards.
 
Module 2: Basic Report Design
This module presents the reporting design and deployment ecosystem and lifecycle, report design techniques, and the expressions language of SQL Server Reporting Services.
 
Module 3: Visual and Interactive Reporting
This module introduces charts, scorecards and dashboards, and how to author analytic reports using data stored in multidimensional cubes and in-memory tabular models.
 
Module 4: Mobile Report Solutions
This module introduces mobile reports, including layouts and deployment, and how to add key performance indicators (KPIs) to your report environment.
 
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.
Write Your Own Review

Only registered users can write reviews. Please Sign in or create an account

Free of Charge

Analyzing and Visualizing Data with SQL Server Reporting Services

Module 1

E-Learning

Analyzing and Visualizing Data with SQL Server Reporting Services

Microsoft DAT214x
Free of Charge
Microsoft
Open edX
60 days

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.

See more See less

* Required Fields