SSRS is an excellent tool for Authoring, Managing and Delivering Enterprise Reports required for Business Analysts, Clients and novice End-Users. In our LIVE Online Training sessions, we deal with complete SSRS methodologies including Adhoc Reports,SMDL Reports, Charts, Maps and Report Audits. Each sessions will be completely practical with daily tasks, weekly Cases and PPTs for reference.
My training benefits
- My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
- 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
- Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
- Installation of Softwares in your desktop / laptop will be done.
- Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
- Continuous support is provided for any of your on-site problems. Placement assistance will be provided and you will be recommended to some of IT development firms.
For Corporate Training
- I will be more comfortable, if you could restrict the group not to exceed 20 persons.
- Training hours will be 40 Hrs/paper in view of 20 participants.
- Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
- I will be bringing my laptop for training purpose, which should be allowed in to your premises.
About Our Trainer
- As a Trainer, Yuvraj has over 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft.
Currently working for a Leading MNC in Chennai as BI Consultant and Datawarehouse Archtect. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Chennai, India.
Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions.
All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.
Courses Offered:
- SQL Server Training
- SQL DBA Training
- MSBI Training
- SQL BI and DWH [SSIS/SSRS/SSAS] Training
- DAX and Power View
- DQS and MDS with Powershell
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
SSRS TRAINING COURSE CONTENT
Please find the Course Contents for SSRS Module:
SSRS Development
Advanced Reports Designt
Managing Reports
Introduction to SSRS
- Need For Reporting Solutions
- Introduction to Reporting Services
Reporting Services Architecture
- Three-Phase Report Life Cycle
- Reporting Engine Architecture
- SSRS 2012 and Web Services
- Configuring SSRS 2008 and 2008 R2
- Configuring SSRS 2012 Report Server
Introduction to SSRS Tools
- Report Designer Usage and Scope
- Report Builder Usage and Scope
- Report Manager and Usage
- RSCONFIG Tool and Limitations
Report Planning and Design
- SSRS Report Planning
- Enterprise and Ad-hoc Reports
- Optimizing Data Sources
Report DataSets
- Working with Multiple DataSets
- Configuring Dynamic DataSets
Report Designs
- Designing Wizard based Reports
- Designing Custom Reports
- Using Tables and Matrix
- Chart Based Reports and Images
- Using SSRS Expressions & Globals
- Sub Reports and Report Options
- Report Testing Options
- BUILD and DEPLOY Options
Using Report Designer
- Parameters and Dynamic Populations
- Report Filters in Data Sets
- Sub Reports and Nested Reports
- Guage Reports, Indicator Reports
- Pie Charts and Data Bars
- Exporting Reporting Data
SSRS using OLAP Sources
- Designing Reports using OLAP DBs
- Identifying KPIs and Measures
- Coding MDX Queries
Report Models
- Need for Report Models
- Identifying Report Entities
- Identifying different Attributes
- Numerical Aggregations
- Time Calculations and Measures
- Managing Data Source Statistics
- Understanding SMDL Entries.
Delivering Reports
- Report Delivery
- Accessing and controlling reports
- Leveraging RS Web services
Report Builder
- Using Report Builder 3.0
- Using Report Builder 4.0
- Report Designer Vs Report Builder
Monitoring Reports
- Report Server Configurations Tools
- Report Migration Wizard Usage
Managing Reports
- Report Manager Configurations
- Managing Data Sources Security
- Exporting and Importing Reports
- Creating Global Schedules
- Snapshot Management & Schedules
- ReportServerTempdb Usage
- Managing Reporting Engine
- System Events and Audits
- Fine-Tuning Reports
SSRS Logging
- Benefit of SSRS Logging (Server
- SSRS 2012 Logging Options
- Report Execution Audits
Scheduling and Subscriptions
- Creating Standard Subscriptions
- Data-Driven Subscriptions
- Subscription & Logging Options
SSRS Security
- Report Data Source Security
- Report Server Security Levels
- Report Server DB Security
SSRS Configurations
- Configuration Options
- Managing Configurations Files
- Choosing correct Config Values
Server Upgrades
- Upgrading SSRS Reports
- Upgrading SSRS Databases
- Scale-out Deployments