|
|
Learn table and matrix report design, interactive OLAP reporting, executive dashboard & scorecard architecture for enterprise performance management applications, and effective delivery of Business Intelligence to end users though data visualization, interactivity, sub reports and report linking.
Report Authoring: · Learn the basics of report design with Table Reports. · Find out how to set up a database, Excel, OLAP Analysis Services data sources and datasets. · Create easy to navigate reports by adding single-values or multi-valued prompts, adding drill-downs, document maps and drill throughs. · Learn best practices to create page, report, and table headers and footers. · Use expressions in a variety of report design situations: aggregating data, creating conditional formatting, and adding custom fields. · Explore new features such as working with expressions, multi-value drop-down cascading report parameters, interactive sorting, and floating headers.
Discover Data Regions: · Learn how to use table, matrix, list, subreport, and chart data regions as well as the practical application of each for delivering Business Intelligence.
Manipulating Datasets: · Build parameterized reports using query and stored procedure parameters and filters. · Discover how to use stored procedures and user defined functions to build dynamic reports. · Learn to build reports that display recursive hierarchies. · Create a report from an Analysis Services OLAP cube. · Design multi-dimensional drill-down matrix and KPI Reports. · Learn model design for the ad-hoc query builder tool. · Master report deployment, publishing, subscription, email and shared folder distribution.
CD-ROM 1 - BI DELIVERY 1. Welcome to SQL Server Reporting Services 2. SSRS Architecture: Tour of Features 3. Report Server Components & Operation 4. Traditional & Interactive Web-based Reports 5. RS Vital Part of MS Business Intelligence Platform 6. Reporting Services Installation & Configuration 7. Report Builder - End User Authoring Tool 8. Navigating Reporting Services Design Studio 9. Report Designer's Report Wizard 10. Data Sources: SQL Server, OLAP, & OLE DB 11. Report Layouts & Various Rendering Formats 12. Enterprise BI: Executive Scorecard & Dashboard 13. Matrix Reports for OLAP Cube Reporting 14. Business Intelligence Development Studio 15. Reporting Services Report Manager 16. SQL Server Management Studio
CD-ROM 2 -REPORTING BASICS 1. BIDS Report Designer Tool 2. Developing a Reporting Solution 3. Evaluating Business Requirements 4. Designing for Reporting Services 5. Identifying Users & Preparing Specifications 6. Managing Shared & Private Data Sources 7. Designing Basic Reports from Scratch 8. Building Table Reports with Report Wizard 9. Experimenting with Formatting Options 10. Adding Table Headers and Footers 11. Adding Page Headers and Footers 12. Subtotals, Totals, Grand Totals & Formulas 13. Creating Chart Reports of Various Types 14. Lists - Free Form Data Presentation 15. Improving Usefulness with Paging & Sorting 16. Designing Reports from a Report Specification
CD-ROM 3 - FORMATTING REPORTS 1. Report Items and Graphical Elements 2. Basic Expressions & Global Collections 3. Including Custom VB Code in Reports 4. Formatting Fields & Conditional Formatting 5. Grouping, Static & Interactive Sorting 6. The Magic of Interactive Drill-Down Reports 7. Calculating Totals and Percentages 8. BI Dashboards for Data Visualization 9. Performance Management Scorecards 10. Advanced Report Features, Web Farm Deployment 11. Drill-Through Reports & Report Metadata 12. Linked Reports & Complex Expressions 13. Subreports & Report Definition Language 14. Configuring Document Maps & Bookmarks 15. Organizational Chart (Recursive) Reports 16. Top 10 Report Formatting Tips
CD-ROM 4 - REPORT PARAMETERS 1. Creating Simple Parameter Reports 2. Binding Report Parameters to Dataset Parms 3. Setting Up Defaults & Drop-Down Parameters 4. Multivalued Parameters with Checkmark Drop-Down 5. Architecting Reports with Multi-Select Parameters 6. Designing Reports with Cascading Parameters 7. Parameters Passing in Drillthrough Reports 8. Report Parameters Dialog Box 9. Configuring Stored Procedures with Parameters 10. Configuring Functions (UDF) with Parameters 11. Debugging Reports, Troubleshooting & Error Logs 12. Enhancing Performance with Filters 13. Multiple Criterion Report Filtering 14. Filters vs. Query Parameters 15. Parameters as Interactive BI Report Features 16. Top 10 Report Parameter Tips
CD-ROM 5 - MATRIX REPORTS 1. Delivering BI with Matrix (Crosstab) Reports 2. Classifying Data into Dimensions & Measures 3. Matrix Page, Columns, Rows & Details Setup 4. Matrix Subtotals, Totals & Grand Totals 5. Applying Aggregate Functions to Measures 6. Designing Interactive Drill-Down Matrix Reports 7. Creating Basic & Complex Matrix Charts 8. Matrix Reports with Time Dimensions 9. Matrix Reports with Multi-Level Dimensions 10. Matrix Reports with Mixed Dimensions 11. Matrix Reports with Multi-Measures 12. Matrix Reports with Multi-Aggregates 13. Adding Static & Dynamic Columns and Rows 14. Architecting Drillthrough Matrix Reports 15. Matrix Reports for OLAP (AS) Cube Reporting 16. OLAP Performance Management Matrix Reports
CD-ROM 6 - PUBLISHING & MANAGING 1. SSMS Reporting Services Management 2. Deploying Reports and Data Sources 3. RS Security: Managing Roles & Data Sources 4. Setting up Folders & Permissions for Users 5. Managing with Report Manager 6. Managing with Management Studio 7. Standard & Data-Driven Subscriptions 8. Automating Report Creation and Delivery 9. Snapshot Reports & Storing Report Histories 10. Report Caching & Fast Stored Procedures 11. Rendering Reports in Excel, XML or PDF 12. Managing Reports Builds and Deployments 13. Reports, Projects, Solutions & Data Sources 14. ReportServer & ReportServerTempDB Databases 15. Managing Models Builds and Deployments 16. Publishing Report Builder Reports
CD-ROM 7 - ADVANCED REPORTING 1. Key Performance Indicators (KPIs) Reports 2. Importing Reports from Microsoft Access 3. Adding Multiple Regions to a Report 4. Nested Lists & Green Bar Reports 5. Architecting Master-Detail Business Reports 6. Building Reports on Analysis Services Cubes 7. Generating MDX Using the MDX Builder 8. Mastering OLAP Reports: Drop-Down Parameters 9. Cascading Prompts for OLAP Cube Reports 10. Report Builder Model Designer 11. Creating Reports with Report Builder 12. Deploying Report Builder to End Users 13. Infinite Drillthrough Report Builder Reports 14. SQL Query Builder & DSV (Data Source Views) 15. Designing Matrix Reports with Report Builder 16. Top 10 Reporting Services Success Secrets
|