Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
SSRS (SQL Server Reporting Services)
Overview

This course applies to SQL Server 2012 and level of this courses is 300/400 (Intermediate to Advanced )

Prerequisites

Knowledge on Fundamentals of SQL Server Database, Basic T-SQL Queries

Target Audience

RDBMS Developers, BI Developers, Novice Data base Administrators, .Net Programmers, Entry Level Engineers

Course duration

5 Days

Course outline

Reporting Services Architecture

  • The Reporting Life Cycle
  • Reporting Services Tools
  • Reporting Services Web Service
  • Reporting Services Application Databases
Advanced Report Design
  • Headers and Footers
  • Creating Report Templates
  • Creating Composite Reports
  • Designing Sub Reports
  • Navigating Reports
  • Reporting On Recursive Relationships
BI Semantic Models
  • INTRODUCTION TO DATA MODELING
  • THE BI SEMANTIC MODEL
Reporting with Analysis Services
  • USING REPORTING SERVICES WITH ANALYSIS SERVICES DATA
  • WORKING WITH MULTIDIMENSIONAL EXPRESSION LANGUAGE
  • ADDING NONADDITIVE MEASURES
  • DRILL-THROUGH REPORTS
OLAP Reporting Advanced Techniques
  • CUBE DYNAMIC ROWS
  • CUBE RESTRICTING ROWS
  • CUBE METADATA
  • CUBE BROWSER
Tabular Models
  • INTRODUCTION TO POWERPIVOT
  • IMPORTING DATA INTO POWERPIVOT
  • POWERPIVOT WINDOW
  • ANALYZING AND ENRICHING DATA
Visual Analytics with Power View *
  • INTRODUCTION TO POWER VIEW
  • POWER VIEW ARCHITECTURE
  • PREPARING A MODEL AND CONNECTION FOR A TUTORIAL
  • VISUAL ANALYTICS WITH POWER VIEW
  • CONFIGURING DATA SOURCE CONNECTIONS
Report Builder Solution Strategies
  • REPORT BUILDER AND SEMANTIC MODEL HISTORY
  • PLANNING A SELF-SERVICE REPORTING ENVIRONMENT
  • USER REPORT MIGRATION STRATEGIES
Managing Report Projects
  • Solutions and projects
  • Version control
  • Synchronizing content
  • Managing server content
  • Using Azure Reporting
Report Solutions, Patterns,and Recipes
  • Designing super reports
  • Report recipes
  • Dashboard solutions
  • Designing a KPI scorecard
  • Designing an interactive sparkline report
  • Maps with navigation
  • Using report parts
  • Dynamic colors
  • Tables with dynamic columns
Native Mode Server Administration
  • Security
  • Backup and recovery
  • Configuration files
  • Monitoring and logging
  • Performance counters and server management reports
  • Memory management
Integrating Reports into Custom Applications
  • URL access
  • Programmatic Rendering
  • Using the Report Viewer Control
Using Embedded and Referenced Code
  • Building advanced expressions
  • Using custom code to extend formatting
  • Using custom code to apply business logic



 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy