Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
5 Day with 08 hours per day
-
Mon 22 Feb 09:00 - Fri 26 Feb 17:00
-
HRDF SBL Claimable
-
Certificate of Attendance available
-
5 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
10990: Analyzing Data with SQL Server Reporting Services
WHAT YOU WILL LEARN
This five-day
instructor-led course teaches students how to implement a SQL Server 2016
Reporting Services solution for data analysis in an organization. The course
discusses how to use the Reporting Services development tools to create and
manage reports and implement self-service BI solutions.
AUDIENCE
The
primary audience for this course is database professionals who need to fulfil a
BI developer role to create reports. Primary responsibilities will include
implementing reports and mobile reports.
The secondary audiences for this course are power information workers.
PREREQUISITES
Before attending this course, students must have:
·
Basic knowledge of the Microsoft Windows operating system and its core
functionality.
·
Working knowledge of Transact-SQL, such as that taught in 20761C.
METHODOLOGY
This program will be
conducted with interactive lectures, PowerPoint presentation, discussion and practical
exercise.
COURSE OBJECTIVES
After completing this course, students will be able to:
·
Describe reporting services and it’s components
·
Describe reporting services data sources
·
Implement paginated reports
·
Work with reporting services data
·
Visualize data with reporting services
·
Aggregate report data
·
Share reporting services reports
·
Administer reporting services
·
Expand and integrate reporting services
·
Describe mobile reports
·
Develop mobile reports.
Modules
This module introduces Microsoft SQL Server
Reporting Services, its components, and the tools used to work with it.
Lessons
- Introduction
to reporting services
- Reporting
services components
- Reporting
services tools
Lab : Exploring reporting services
- Exploring
reports
- Reporting
services configuration
After completing this module, students will be able to:
- Give
a context for Reporting Services.
- Describe
the components of Reporting Services.
- Explain
Reporting Services tools.
Almost every report that you publish by using
SQL Server Reporting Services (SSRS) will be built using data that’s obtained
from one or more source systems. This lesson explains how to configure SSRS to
interact with source data systems by working with data sources.
Lessons
- Data
sources
- Connection
strings
- Datasets
Lab : Configuring data access with report builder
- Configuring
data access with report builder
Lab : Configuring data access with report designer
- Configuring
data access with report designer
After completing this module, you will be able to:
- Describe
data sources.
- Work with connection strings.
- Describe datasets.
Now that you have learned about BI and data
modelling, and how to access data from Report Designer and Report Builder, you
need to learn how to create reports. This module shows you how to create
different types of reports in both applications, in addition to using the
Report Wizard.
Lessons
- Creating
a report with the report wizard
- Creating
a report
- Publishing
a report
Lab : Creating reports
- Use
the report wizard – report designer
- Use
the report wizard – report builder
- Creating
and publishing a report – report designer
- Creating
and publishing a report – report builder
After completing this module, you will be able to:
- Create
a report with the report wizard.
- Create a report using report builder or report designer.
- Publish a report to reporting services.
It is common for business requirements to
change regarding the information they need and how they want data presented. On
viewing a detailed report, senior management might ask for higher level,
summarized, or filtered versions of the same report. Report Builder and Report
Designer support these scenarios via filtering, sorting, drilldowns, grouping
and the parameterizing of reports. In this module, you will see how to use
filters and parameters to make reports more dynamic and useful to business
users.
Lessons
- Data
filters
- Report
parameters
- Implementing
report filters and parameters
Lab : Create a parameterized report
- Using
parameters in report designer
- Using
parameters in report builder
After completing this module, students will be able to:
- Filter
data in reports
- Use
parameters in reports
As the amount of data being generated
continues to grow, the need to make sense of its meaning increases. You use
data visualization to make data easier to understand, and faster to interpret.
Data visualizations highlight comparisons, show trends, and convey scale much
faster than a table of numbers could. The detail is important, but
visualizations are a highly effective way of conveying meaning and insights
quickly and accurately.
Lessons
- Formatting
data
- Images
and charts
- Databars,
sparklines, indicators, gauges, and maps
Lab : Manage formatting
- Report
designer
- Report
builder
After completing this module, you will be able to:
- Format
data in reports.
- Use
images and charts in your reports.
- Use databars, sparklines, and indicators in reports.
- Explain what a KPI is and how it’s used.
As the amount of data we need to deal with
increases, so does the requirement to manage data by grouping and summarizing.
In this module, you will learn how to create group structures, summarize data,
and provide interactivity in your reports, so that users see the level of
detail or summary that they need.
Lessons
- Sorting
and grouping
- Report
sub-reports
- Drilldown
and drill through
Lab : Summarizing report data
- Sorting
and grouping in report builder
- Sorting
and grouping in report designer
After completing this module, students will be able to:
- Group
and sort data in reports.
- Create
report sub-sections.
- Use
drill down and drill through.
When you have published a Reporting Services
report, users can view the report interactively. In some situations, it can be
advantageous to run reports automatically, either to improve performance
through caching and snapshots, or to deliver reports to users—by using e-mail
or other mechanisms. To run reports automatically, you need to understand how
Reporting Services manages scheduling. This module covers report scheduling,
caching and the report life cycle, and automatic subscription and delivery of
reports.
Lessons
- Schedules
- Report
caching, snapshots, and comments
- Report
subscription and delivery
Lab : Sharing reporting services reports
- Create
a shared schedule
- Configure
caching
- Subscribe
to a report
After completing this module, students will be able to:
- Explain
schedules.
- Describe
report caching, report snapshots, and report comments.
- Configure
report subscriptions.
System administrators take responsibility for
the configuration and day-to-day operations of IT systems. In SQL Server
Reporting Services (SSRS), administrative tasks include the configuration of
the web portal and web service, branding the web portal, and ensuring that
access to sensitive reports is carefully controlled. Administrators also
monitor and optimize performance.
Lessons
- Administering
reporting services
- Reporting
services configuration
- Reporting
services performance
Lab : Administering reporting services
- Authorize
access to reports
- Web
portal branding
After completing this module, students will be able to:
- Secure
access to reports by using authentication, permissions, and SSL
encryption.
- Use report services configuration manager to reconfigure SSRS servers.
- Monitor and optimize the performance of SSRS on a given set of server hardware.
Although Reporting Services is a powerful
tool, its built-in capabilities might not always meet your needs. This module
covers the methods for extending the functionality of Reporting Services with
expressions and custom code. You will also learn about the methods for working
with Reporting Services programmatically, and integrating Reporting Services
reports into other applications.
Lessons
- Expressions
and embedded code
- Extending
reporting services
- Integrating
reporting services
Lab : Extending and integrating reporting services
- Custom
code – report designer
- Custom
code – report builder
- URL
access
After completing this module, students will be able to:
- Work
with expressions and embedded code.
- Extend reporting services functionality with external assemblies.
- Integrate reporting services with other software.
This module introduces the design and
publication of reports that are intended for consumption on mobile devices,
such as smartphones and tablets. Microsoft SQL Server Reporting Services (SSRS)
includes support for mobile reports, although the tools that are used to design
and publish mobile reports are different to the tools used for the paginated
reports discussed in the earlier modules of this course.
Lessons
- Overview
of mobile reports
- Preparing
data for mobile reports
- Mobile
report publisher
Lab : Introduction to mobile reports
- Format
data for a mobile report
- Create
a mobile report
- Create
KPIs
After completing this module, students will be able to:
- Describe
considerations for mobile reports.
- Prepare
data for publication in mobile reports.
- Use
SQL Server mobile report publisher to create mobile reports.
In this module, you will learn about the
element types that you can add to your Microsoft SQL Server Reporting Services
mobile reports. You will also learn about working with dataset parameters, and
how to add drillthrough actions to your reports.
Lessons
- Designing
and publishing mobile reports
- Drillthrough
in mobile reports
Lab : Developing mobile reports
- Add
a dataset with parameters
- Design
a mobile report
- Publish
a mobile report
- Add
a drillthrough to a custom URL
After completing this module, students will be able to:
- Describe
how to design and publish mobile reports.
- Explain
how to drillthrough from mobile reports.
Gerald Hoong Seng Kah
Gerald
has 19 years of information technology experience and on community service and
event experiences, he excels impressively. He was invited as a speaker for 3
break-out sessions for Microsoft TechED SEA 2008 on SQL Server 2008 at Kuala
Lumpur Convention Center.
He even
participated at the “Ask-The-Expert" booth for Microsoft Visual Studio 2008 and Microsoft SQL Server 2008 at
the Heroes Launch 2008 and conducted a Microsoft Visual Studio Team System
2008, formerly code-named “Orcas" Metro workshop for Microsoft Certified
Partners and independent software vendors (ISVs).
He was
invited as a speaker on various occasions such as during the 2 break-out
sessions and 3 instructor-led sessions at Microsoft TechED SEA 2007 on SQL
Server 2008 and Office SharePoint Server 2007 respectively at Kuala Lumpur
Convention Center. He was also a speaker for an instructor-led session at
Microsoft TechEd SEA 2006 on development of web parts using Windows SharePoint
Services Version 3.0 at Kuala Lumpur Convention Center.
He
conducted a few Microsoft Office 2007 Touchdown workshops for Microsoft
Certified Partners and independent software vendors and Microsoft Windows Vista
Beta 1 Touchdown workshop and Microsoft Windows Vista Beta 1 Touchdown workshop
for Microsoft Certified Partners and ISVs. He also conducted a Microsoft
Windows Server code-named “Longhorn" Touchdown workshop and Microsoft Visual
Studio Team System workshop for Microsoft Certfied Partners and ISVs.
He was
invited as a guest speaker on Microsoft Office 2007 development for the MIND
community, which is an active IT community under the helm of Microsoft. He is a
committee member of SQL Practitioners Alliance Network (SPAN).
He was the co- speaker and tag team presenter at
the recently concluded World SharePoint Conference 2014 at Las Vegas, USA. He was the only Malaysian presenter among
the other presenters from Asia.
In March 2014, he participated as co-speaker and tag team presenter at the World SharePoint Conference 2014 at Venetian Hotel and Resorts, Las Vegas, USA.
Recently, he conducted a specialized Microsoft SharePoint training and consultancy for a team of 17 people from Carlsberg Group at Carlsberg & Jacobsen Brewhouse in Copenhagen, Denmark.
Read MoreRicky Chan Chee Ho
Ricky have extensive knowledge in software application, management skills, leading edge technology planning and implementation as well as superior strategic thinking & communication skills.His expertise are in Exchange Server, SQL Server 2000, 2005, 2008, 2012, Windows 2000, Microsoft Windows Server 2003, 2008, 2012, Window XP, Vista, 7, 8, Window NT server, Microsoft offices 2003, 2007, 2010, Microsoft Project 2013, 2007 and 2010.
Cheah Keng Kean
Cheah has more than 23 years of experience in the IT industry and 17 years in computer training. He has 5 years of experience as an analyst programmer in a Singapore manufacturing company where he gained knowledge and analytical skill to develop and handle different systems. He also gained a reputation of providing high quality of training and of sharing his knowledge and experience.

Daryl Soong Choo Keong
Daryl Soong has been working in the IT industry since 1996. As such, he has had ample exposure and experience relating to all manners of businesses and problem scenarios faced by IT personnel of different levels. He understands the importance of business value, infrastructure efficiency and user productivity.He has a passion for Microsoft server systems, messaging infrastructure, database server implementation & administration, windows & web programming, as well as Cisco routing and switching. He specializes in the fields of databases, server & web development.He has successfully managed and implemented several local projects related to his area of expertise. His key areas of work have been on various platforms using Microsoft Windows Servers and Active Directory, Microsoft Exchange Servers, Cisco Routers and Switches. Read More
Renganathan Palanisamy
Renganathan
Palanisamy has extensive experience in both the academic and corporate training
arena. This enables him to incorporate best practices in ensuring delivery of
his training is effective and relevant.
This is further strengthened by his involvement in various technology
related collaboration with renowned players in the industry such as Microsoft,
Sun Microsystems and Oracle. During his
service as a programme leader in KDU College Sdn Bhd, he was responsible for
coordination, collaboration and delivery of courses offered by Sun Microsystems
in partnership with Guidance View. He worked with Oracle under its Workforce
Development Programme and Microsoft through its MSDN Academic Alliance
Programme.
He started his
involvement in the IT industry with a strong inclination towards Java
technology and object oriented design and development practices. He was able to share his in-depth knowledge
of the technology via several academic courses and workshops that he conducted
for students and academic staff. Later
he ventured into database design and development with Oracle and eventually
expanded to include Microsoft SQL Server.
Currently
his main focus is on delivering Microsoft development and database tracks which
strongly complements his exposure to non Microsoft related technologies. He has strong understanding of .NET
technologies and tools. He is highly
sought after as evident in his presence at premier events such as Microsoft
TechEd and his involvement in the review team for upcoming Microsoft
courses. His technical skills coupled
with know-how of training delivery techniques have earned him recognition
amongst his peers and attendees of his training sessions. His specialty includes the ability to relate
concepts derived from various technologies and to ensure the smooth transition of
trainees migrating to different technologies.
Resourcefulness is his trademark and this helps enhance the training
experience of the attendees.
Renganathan is
a dynamic and versatile individual. He
is willing to take up new learning challenges and has the ability to apply new
skills in a short span of time. His other
strengths include good time management, analytical skills, ability to present
ideas in innovative ways and most importantly, a sense of responsibility.
Course Reviews
0
0 Ratings