Home/Courses/Microsoft Data & Power BI/Microsoft SQL Server Report Builder Level 1: Write & Format …
Microsoft Data & Power BIMicrosoft SQL Server Report Builder Level 1: Write & Format Reports with SSRS (55123)
Create and format reports with SQL Server Report Builder.
2 daysFoundation7 modules55123
About this course
Create and format reports with SQL Server Report Builder. You will build table and matrix reports, write expressions, sort, filter and group data, and add charts and formatting.
What you'll learn
- Navigate the Report Builder interface and tools
- Create table and matrix reports
- Write basic and advanced expressions
- Sort, filter, and group report data
- Add visual elements like charts
- Format reports for printing and export
Curriculum
7 modules
- Introduction to the interface
- Working with existing reports
- Lab: Navigating Report Builder
- Creating data sources and datasets
- Using the Tablix data region
- Lab: Building table reports
- Report formatting basics
- Sorting, filtering, and adding fields
- Writing basic and complex expressions
- Lab: Formatting reports and expressions
- Grouping data manually and with expressions
- Creating subgroups and aggregates
- Lab: Reports with grouping and totals
- Creating matrix layouts
- Adding and modifying column groups
- Lab: Designing matrix reports
- Creating chart wizard reports
- Adding charts to existing layouts
- Customizing chart types and properties
- Lab: Creating and enhancing chart reports
- Print options and setup
- Exporting to PDF, Excel, Word, and other formats
- Lab: Outputting and sharing reports
Who it's for
Analysts and report writers new to Report Builder.
Before you start
- Familiarity with Windows.
- Creating and navigating folders.
- Opening programs.
- Manipulating windows.
- Copying and pasting objects.
- Formatting text.
- Saving files.
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.