SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting
Course: SSRS1
Duration: 5 Days
Level: I
Course Summary
This course teaches the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. This course is designed for students who want to implement the features of Microsoft SQL Server 2012 or later that will allow them to provide quality visual reports.
« Hide The Details
Topics Covered In This Course
SSRS Overview
- Sharing Business Intelligence
- Report Authoring Architecture
- Report-Serving Architecture
Report Authoring
- Database Basics
- Database Structure
- Trilogy Delivery Services
- Querying Data
- On to the Reports
The Report Wizard
- Obtaining the Trilogy Database
- Getting Started with the Authoring Environment
- Creating the First Report
- An Interactive Table Report
- Creating Matrix Reports
- Report Parameters
Building Basic Reports
- The Tablix and Data Regions
- Graphical Reporting options
Graphic Expression: Using Charts, Images, and Gauges
- Gauging the Results
- Using Images
- From Graphical to Geo-graphical
Geography Lesson: Using Maps and Spatial Data Types
- Colors and Bubbles: Representing Quantities on Maps
- Building Higher
Intermediate Reporting
- Putting the Report Template to Use
- Data Caching During Preview
Advanced Reporting
- Speaking in Functions
- Reports within Reports
- Interacting with Reports
- A Few Surprises
Warehouse Considerations
- Overview
- SSAS Big Picture
- SQL Deep Dive
- Cubes and MDX
- Tabular models ? Small, Medium, and Large with DAX
Integrating Reporting Services
- Using Reporting Services without the Report Manager
- New Capabilities and Enhancements including Power View and SharePoint
- PowerPivot into Analysis Services to Support Corporate BI Applications
- Power View for Self-Service Business Intelligence
- Building PowerPivot Workbooks to get the most from Power View
Best Practices
- Report-Authoring Practices
- Report Deployment Practices
What You Can Expect
At the end of this course, students will be able to:
- Retrieve data with SELECT queries
- Generate reports using the Report Wizard and from scratch
- Enhance reports with charts, images, gauges, and maps
- Add value to reports through summarizing, totaling, and interactivity
- Build reusable report templates
- Enable end-user access to reports via the Report Server and its Report Manager web interface
- Integrate SSRS reports with personal websites and custom applications
- Understand what is new in Microsoft SQL Server 2012 Analysis Services Tabular, Power View, and PowerPivot
- Understand the difference between SQL (Structured Query Language), MDX (Multidimensional Expressions) , and DAX (Data Analysis Expressions)
Who Should Take This Course
This course is designed for Business professionals with no SQL experience.
Recommended Prerequisites
Basic Web and Windows usage is required.
Training Style
Instructor led with 50% lecture and50% lab.
« Hide The Details
Related Courses
Code |
Course Title |
Duration |
Level |
|
SSQFD |
Microsoft SQL Server: Querying Data for Report Developers |
3 Days |
I |
Details |
SSASTM |
SQL Server Analysis Services 2014/2012 - Tabular model with DAX |
3 Days |
I |
Details |
SSASBI |
Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions |
5 Days |
I |
Details |
SSIS |
SQL Server 2012 Business Intelligence and Data Warehouses using SSIS |
5 Days |
I |
Details |
SSASAO |
SQL Server Analysis Services 2014/2012 - Advanced Data Analysis and Optimization |
3 Days |
II |
Details |
SSRSXP |
SQL Server Reporting Services 2014/2012 - Extensions and Programming |
3 Days |
II |
Details |
SSRPT |
Microsoft SQL Server 2008 Reporting Services |
3 Days |
II |
Details |
SSRSJM |
SQL Server Reporting Services 2014/2012 - Jedi Master Level |
2 Days |
III |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|