SQL
$1150
Per Participant
The two-day course allows students to continue learning the foundations of writing reports using SSRS and Report Designer of SQL Server. The focus is given on connecting to a database to create reports and manipulate presentation data such as parameter report creation, list reports creation, the addition of complex expression in reports, adding drill through and drill down functions, adding sub reports and images, and adding data bars, sparklines and indicators within the reports.
This training is designed based on the objectives of the course variant 55170A.
The key audience for the course is individuals new to the reporting environment using SSRS or Report Designer of SQL Server, users shifting from other reporting software and people who are currently Report builders and are report authors of SSRS. The other audience group who can take this course are the existing Report Builders (SSRS). The participants of the course could be Business Analysts, data analysts, programmer analysts, database admins and IT workers with possible but not mandatory hands-one experience with SSRS or Report Builder, Visual Basics and T-SQL.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module introduces the use of the parameter in report writing. Parameters allow a level of self-service reporting wherein the report audience can choose the data to view (date range, department, geography, etc.).
Lab: Creating Parameterized Reports
After completing this module, students will be able to:
This module introduces the list data region. List data regions allow report writers free-form control over their reports, whereas, table and matrix reports bind you to a table or matrix data presentation. This free-form feature affords the report writer the ability to truly customize the report.
Lab: Creating List Reports
After completing this module, students will be able to:
This module introduces several new report formatting techniques which allow the report writer better control over the data displayed in the report.
Lab: Enhancing Reports with Complex Expressions
After completing this module, students will be able to:
In this module, students will add images and reports (subreports) to reports, tour and students will be introduced to SSRS (SQL Server Reporting Services).
Lab: Working With Images and Subreports
After completing this module, students will be able to:
This module introduces the ToggleByItem and Action properties to incorporate drilldowns and drillthrough reporting.
Lab: Add Drilldown and Drillthrough Functionality to Reports
After completing this module, students will be able to:
This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.
Lab: Adding Sparklines, Data Bars, and Indicators to Reports
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA