MSBI-SQL SERVER BI TOOLS

Microsoft SQL Server 2008 Analysis Services

Course Description: In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes, cube storage and aggregation designs to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes based upon measures and dimensions.

→ What is MS BI

  • What is MS BI
  • Defining Microsoft BI
  • Why Use OLAP
  • Understanding the UDM
  • Understanding the Cube
  • Dimensions and Measures
  • OLAP Schemas
  • Sample Databases
  • Deploying/Viewing Sample Cube
  • Deploy a Cube with BIDS
  • Demo: SSMS
  • Demo: BIDS in VS
  • Demo: SSMS Object Explorer

→ SSAS Client Overview

  • Viewing a Cube in Excel
  • Cubes in Reporting Services
  • Demo: Excel in RS
  • Demo: RS in SQL 08

→ OLAP Modeling

  • Before Creating a Cube
  • Selecting a Modeling Tool
  • Understanding OLAP Modeling
  • Required Components
  • Star Schema Models
  • Dimensional Modeling
  • Demo: Visio Modeling
  • Understanding Cube Modeling
  • Dimension Types
  • Modeling Fact Tables
  • Additional Modeling Decisions
  • Demo: Visio Model Cube

→ Modeling in BIDS

  • Understanding BIDS Interface
  • Modeling with BIDS
  • Demo: Modeling in BIDS
  • Demo: Cube
  • Demo: Create a new Database
  • Preparing Data

→ Using BIDS

  • Understanding BIDS
  • Offline vs. Online Mode
  • Demo: BIDS
  • Creating Data Sources
  • Creating Data Source Views
  • Demo: Data Source
  • Demo: Data Source View Designer

→ Creating a Cube

  • Creating a Cube
  • Refine the Cube
  • Refining Dimensions
  • Refining Measures
  • Define Dimension Usage
  • Demo: Cube Designer
  • Demo: Dimension Designer
  • Demo: Dimension Wizard
  • Demo: Dim to Measure Groups
  • Demo: Deploy Cube

→ Enhancing a Cube

  • Attribute Relationships
  • Demo: Relationships
  • Creating KPIs
  • Defining a KPI
  • Customizing KPI Samples
  • Demo: KPIs in a Cube
  • Demo: Growth KPI
  • Creating Perspectives
  • Demo: Perspectives

→ Translating An Action

  • Creating Translations
  • Demo: Translations
  • Localizing Measure Values
  • Currency Localization 
  • Config Currency Localization
  • Demo: Currency Conversions
  • Actions
  • Demo: Actions
  • Demo: Action Creation

→ Advanced SSAS

  • Multiple Fact Tables
  • Cube with Multiple Fact Tables
  • Modeling Separate Cubes
  • Linked Objects
  • Dimension Usage Config
  • Demo: Linked Objects
  • Advanced Dimension Types
  • Snowflake Dimensions
  • Degenerate Dimensions
  • Parent Child Dimensions
  • Many to Many Dimensions
  • Role Playing Dimensions
  • Writeback Dimensions
  • Demo: Dimension Types
  • Changing Dimensions

→ BI Wizard- Advanced Program

  • Using the BI Wizard
  • BI Wizard Dimension Options
  • Demo: BI Wizard
  • BI Wizard Cube Options
  • Demo: Cube Options
  • Demo: Browse Cube

→ Advanced Properties

  • Setting Advanced Properties
  • Cube Dimension Properties
  • Dimension Properties
  • Demo: Cube/Dim Properties
  • Hierarchy Properties
  • Attribute Properties
  • Demo: Hierarchy/Attributes
  • Cube Properties
  • Measure Group Properties
  • Demo: Cube/Measure

→ Storage And Aggregations

  • Basic Storage- SSAS Databases
  • SSAS Data and Metadata
  • About XMLA
  • Demo: XMLA
  • Three Storage Modes
  • MOLAP
  • ROLAP
  • HOLAP
  • Overview of Aggregations
  • Defining Aggregations
  • Viewing Aggregation Designs
  • Demo: Aggregation Designs

→ Advanced Aggregations

  • Customizing Aggregations
  • Usage-Based Optimization
  • Demo: Usage-Based Wizard
  • Using SQL Profiler
  • Demo: SQL Profiler

→ Advanced Storage

  • Advanced Storage
  • Storage Mode Settings
  • ROLAP Dimensions
  • Demo: Storage Modes
  • Implementing Proactive Caching
  • Defining Proactive Caching
  • Notification Settings Caching
  • Partitions/Advanced Storage
  • Partition Locations
  • Using Partitions-Where?
  • Demo: Partitions in a Cube
  • General Processing Options
  • Measure Groups+Partitions
  • Dimension Processing Options
  • Data Mining Processing Options
  • Processing Settings
  • Demo: Processing in BIDs

→ MDX Overview

  • Understanding MDX
  • Using MDX in BIDS
  • MDX Queries
  • MDX Expressions
  • MDX Structure Names
  • Demo: MDX Structure
  • MDX Syntax Rules
  • Writing MDX Query
  • Demo: Writing MDX Queries

→ MDX Queries

  • Members, Tuples, and Sets
  • Demo: Tuples and Sets
  • Familial Relationships
  • Navigational Functions
  • Demo: Navigtional Functions

→ MDX Functions

  • MDX Functions & Keywords
  • Demo: MDX Functions
  • Functions & Keywords (cont)
  • Demo: Functions (cont)
  • More Functions
  • Functions added to SSAS 05
  • Demo: More Functions

→ Calculated Members

  • Using MDX Expressions in BIDS
  • Demo: MDX in BIDS
  • Working with Calculations
  • The Calculations Subtab
  • Demo: Calculations Subtab
  • Examine Calculated Members
  • Why Use Calculated Members
  • Defining Calculated Members
  • Demo: Calculated Members

→ Script Commands & .NET

  • About MDX Scripts
  • Add MDX Commands
  • Demo: Script Commands
  • Demo: Break Points
  • Understand Named Sets
  • Creating Named Sets
  • Demo: Named Sets
  • About .NET Assemblies
  • Add .NET Assemblies
  • Why Assemblies?
  • Demo: Register a .DLL

→ Data Mining Overview

  • What is Data Mining
  • Data Mining Terminology
  • Demo: Mining Model
  • Business Questions
  • Algorithm Classifications
  • Implementing Data Mining

→ Implementing Data Mining

  • Mining Algorithms
  • Demo:Mining Models
  • DM Algorithms 1
  • DM Algorithms 2
  • DM Algorithms 3
  • DM Algorithms 4

→ Creating Mining Structures

  • Creating Mining Structures
  • Demo: Data Mining Wizard
  • Content Types
  • Data Types
  • Data Types (cont)
  • Finishing the Wizard
  • Demo: Wizard from Cube

→ Data Mining Designer

  • Mining Structure Subtab
  • Mining Models Subtab
  • Demo:Structure+Models Subtabs
  • Mining Model Viewers
  • Demo: Model Viewers

→ Validating Mining Models

  • Mining Accuracy Charts
  • Demo: Accuracy Charts
  • Cross Validation
  • Demo: Cross Validation
  • Mining Prediction Viewers
  • Working with the DMX
  • Demo: Query in BIDS
  • Demo: Query in SSMS
  • Mining Structure Processing

→ Securing SSAS

  • Implementing Security
  • Configuring SSAS Admin
  • Reducing the Attack Surface
  • Data Connection Methods
  • Demo: Configure Security
  • Implement Database Roles
  • Securing Dimensions
  • Security Considerations
  • Demo: Roles + Permissions

→ Scripting SSAS

Excel 2007
  • Implement XMLA Scripts
  • Demo: XMLA Script Templates
  • XMLA Schema Rowsets
  • OLE DB Schema Rowsets
  • OLE DB OLAP Rowsets
  • Data Mining Schema Rowsets
  • Demo: Data Mining Rowsets
  • Demo: Schema Rowsets

→ Managing SSAS

  • Deploy and Synchronizing
  • Deploying Using BIDS
  • Deployment Wizard
  • Database Synchronization
  • Demo:Database Deployment
  • Understand Backup/Restore
  • What to Backup
  • SSAS Database Backups
  • Demo: Backup and Restore
  • Demo: Backup to a Job

→ SSIS with SSAS

  • Using SSIS with SSAS
  • SSIS to Process Partitions
  • SSAS Processing Task
  • Other SSIS AS Tasks
  • Demo: SSIS tasks in AS

→ Availability and Scalability

  • Availability and Scalability
  • Understanding Clustering
  • Scale-up Solutions
  • Scale-Out with Read-only
  • Additional Scale-out Options
  • Adjust Instance Properties
  • Adjust Reporting Settings
  • Demo: Scalability Properties

→ Optimizing Performance

  • Optimization Overview
  • Design Efficiently
  • Retrieve Data Efficiently
  • Aggregate Appropriately
  • Optimize Attributes
  • Monitor Intelligently
  • Demo: Perfmon and Profiler
  • Query Efficiently
  • Excel 2007
  • Managing Connections in Excel
  • Excel PivotTable Reports
  • Demo: Excel Connections
  • Demo: Excel PivotTable
  • Excel PivotChart Reports
  • Demo: PivotCharts
  • OLAP Tools
  • Demo: OLAP Tools

→ Data Mining Add Ins

  • Excel as a Data Mining Client
  • Data Mining Add-ins Interface
  • Demo: DataMining Ribbon
  • Data Preparation
  • Demo: Data Preparation
  • Data Modeling
  • Accuracy and Validation
  • Demo: Data Modeling
  • Demo: Accuracy and Validation
  • Model Usage
  • Management, Connections
  • Demo:Management
  • Data Mining Template Visio
  • Demo: Data Mining Template

→ SSRS with SSAS

  • About SSRS
  • Demo: SSRS
  • SSRS-Designing Reports
  • SSRS and SSAS
  • Demo: SSRS with SSAS

→ SharePoint Integration

  • About MOSS
  • MOSS Sturucture & Terms
  • MOSS-Excel Services
  • Demo: SharePoint Report
  • MOSS Report Center
  • Demo: MOSS – KPIs

Microsoft SQL Server 2008 Integration Services

Course Description: This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

→ Understanding SSIS

  • What is ETL?
  • Integration Services Packages
  • Tools for Building IS Packages
  • IS Package Storage Options
  • Demo: Import-Export Wizard
  • Other Ways to Launch Wizard

→ BIDS

  • Demo: BIDS
  • Demo: Control Flow Tab
  • Demo: Data Flow Tab
  • Demo: Event Handler Tab
  • Demo: Package Explorer Tab

→ Building-Executing a Package

  • Demo:BIDS-New Project
  • Demo:Data Source Wizard
  • Demo: Package Design
  • Executing a Package in BIDS
  • Demo:Executing a Package
  • A Package Outside of BIDS
  • Demo:Execute Utility

→ Control Flow

  • Elements in a Control Flow
  • Tasks
  • Containers
  • Precedence Constraints
  • Control Flow Tasks
  • Workflow Tasks
  • Data Processing Tasks
  • Scripting Tasks
  • SQL Server Tasks
  • Analysis Services Tasks
  • Maintenance Tasks
  • Working with Workflow Tasks
  • The Execute SQL Task
  • Demo: Execute SQL Task

→ Workflow and Constraints

  • File System Task

Demo: File System Task

  • FTP Task
  • Demo: FTP task
  • Send Mail Task
  • Demo: Send Mail Task
  • Precedence Constraints
  • Why Use Constraints?
  • Implementing Constraints
  • More Options
  • Demo: Constraint Options

→ Data Flows

  • Data Flow Components
  • Data Flow Pipeline
  • Data Flow Sources
  • Connection Manager
  • Demo: Data Flow Task
  • Data Flow Destinations
  • Destination Types
  • Data Viewers
  • Demo: Data Viewers

→ Data Flow Transformations

  • Data Flow Transformations
  • Demo: Transformations

→ Variables

  • Variable Properties
  • Variable Data Types
  • Variable Scope
  • Where Can You Use Variables
  • Demo: Variables

→ Control Flow Variables

  • Execute SQL Task
  • File System Task
  • Constraint Expressions
  • Property Expressions
  • Flow Property Expressions
  • Send Mail Task
  • Foreach Loop Container
  • Script Task
  • Demo:Foreach Loop
  • Demo: Script Task

→ Data Flow Variables

  • Variables in Data Flow
  • Configurations
  • Using Configurations
  • Sample Path
  • Configuration Storage
  • Demo: Configurations
  • Variables + Configurations
  • Demo: Configuration Path

→ Containers

  • Using Containers
  • Container Types
  • Container Properties
  • Task Host Container
  • Sequence Container
  • Foreach Loop Container
  • Demo: Foreach Loop

→ For Loop Containers

  • For Loop Container
  • Demo: For Loop Container
  • Grouping Container
  • Demo: Grouping Container

→ Transaction Support

  • Transaction Properties
  • Types of Transactions
  • Demo: Transactions
  • Demo: Sequence Container

→ Checkpoints + Handling Errors

  • Checkpoints
  • Implementing Checkpoints
  • How It Works
  • Demo: Checkpoint
  • Errors and Debugging
  • Error Handling in Constraints
  • Demo: Handling in Constraints

→ Outputs + Breakpoints

  • Error Actions
  • Demo: Error Actions
  • Breakpoints
  • Demo: Breakpoints

→ Package Logging

  • Demo: Package Logging
  • Configuring Package Logging
  • Log Providers
  • Demo: Log Providers
  • Demo: Windows Event Log

→ Event Handling

  • Event Handling
  • Using Event Handlers
  • Demo: Event Handler

→ Advanced Data Flow

  • Synchronous Transformations
  • Asynchronous Transformation
  • Using Advanced Transformations
  • Demo: Conditional Split

→ Slowly Changing Dimensions

  • Slowly Changing Dimensions
  • Demo: Changing Dimensions

→ Deploying Packages

  • Deployment Steps
  • Deployment Challenges
  • Deployment-Sensitive
  • Utilities That Can Help
  • Create a Deployment Utility
  • Utility Properties
  • Deployment Folder
  • Deployment Manifest
  • Demo: Deployment

→ Installing Packages

  • Installation Wizard
  • Deploy to the File System
  • Demo:Package Installation
  • Deploy to SQL Server
  • Demo:Deploy to SQL Server
  • Using Management Studio
  • Demo:Using Management Studio
  • SQL Server or File System?

→ Managing Packages

  • Managing IS Packages
  • Managing Packages with DTUtil
  • DTUtil Exit Codes
  • DTUtil Samples
  • With Management Studio
  • Demo:Manage Packages with MS
  • Executing Packages
  • DTExecUI
  • Demo: DTExecUI
  • DTExec
  • Demo: DTExec

→ Packages and Security

  • Demo:Schedule Packages
  • Integration Services Security
  • Integration Services Threats
  • Protecting Package Information
  • Sensitive Information
  • Protection Level
  • ProtectionLevel Property
  • Demo:ProtectionLevel
  • Controlling Packages in SQL
  • Integration Services Roles
  • Authorizing IS users in SQL
  • Demo:Security in SSMS

→ Scripting

  • Integration Services Scripting
  • Adding Code to a Package
  • Custom Component
  • What Can Scripting Do?
  • When Should I Script?
  • When Should I not Script?
  • IS Object Model
  • VS Tools for Script Editor
  • Demo:Implementing Scripts
  • Scripting in Control Flows
  • Global Dts object
  • Variables
  • Variables Collection
  • Accessing Variables
  • VariableDispenser Object
  • Demo:Variables in Script Code
  • Beyond Built-In Tasks

→ Data Flow Scripting

  • Input and Output Columns
  • Script Component Types
  • Script Component as Source
  • Component as Destination
  • Component as Transformation
  • Demo:Transformation
  • Synchronous and Asynchronous
  • Built-in Synchronicity
  • Synchronicity in the Script
  • Types of Asynchronous
  • Building Asynchronous
  • Beyond Built-In Data Flow
  • Custom IS Components
  • Custom Component Develop
  • Demo: Custom Components
  • Third-Party IS Components
  • Demo: Third-Party Components

→ Design Best Practices

  • Keep it Simple
  • Best Practices
  • Development Standards
  • Annotations
  • Naming Conventions
  • Package Templates
  • Source Control
  • Demo:Best Practices
  • Package Design Best Practices
  • Modular Design
  • Demo:Modular Package
  • Package Best Practices
  • Error Handling and Logging
  • Auditing ETL

→ Data Flow Best Practices

  • Data Flow Source Performance
  • Limit Columns
  • Convert Only When Necessary
  • Make Use of the Database
  • Data Flow Transformations
  • Demo:Data Flow Best Practice
  • Data Flow Destinations
  • Tune for Bulk Loads
  • Data Flow Destinations Too
  • SSIS Engine Best Practices
  • Deployment and Management
  • Deployment Best Practices
  • Prepare the Package
  • Security Best Practices
  • Management Best Practices
  • Back Up Packages
  • Demo:Management Best Practices

→ Maintaining SQL Server

  • Migrating and Maintaining
  • SQL Server Transfer Tasks
  • Demo:Transfer Tasks
  • SQL Server Maintenance Plans
  • Maintenance Plan Tasks
  • Demo:PlanTasks

→ Analysis Services and WMI

  • Working with Analysis Services
  • Working with WMI
  • WMI Data Reader Task
  • WMI Event Watcher Task
  • Demo:Data and Event Watcher

Microsoft SQL Server 2008 Reporting Services

Course Description: In this course, you will learn how to use SQL Server 2008 Reporting Services. Explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You will then explore tabular and list reports that employ datasets and data regions. As you progress you will learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You will then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you will be building Matrix reports and charts then explore the use of Reporting Services gauges.

→ Tour of Features

  • Tour of Features
  • Feature Overview
  • Supported Report Types
  • Tabular Reports
  • Matrix Reports
  • Charts and Graphs
  • Additional Report Types
  • Supported Output Formats
  • Data Sources
  • Program Reporting Services
  • Deployment - Admin Features
  • What"s New in SSRS 08 Part 1
  • Demo:New Features Part 1
  • What"s New in SSRS 08 Part 2
  • Demo:New Features Part 2
  • What"s New in SSRS 08 Part 3
  • Demo:New Features Part 3

→ SSRS Architechure

  • SSRS Architechture
  • Report Server
  • Report Server Database
  • Report Designer
  • Report Manager
  • Demo:Report Manager
  • SSRS Configuration Tool
  • SSRS Command-Line Utilities
  • Demo:Configuration Tool
  • Report Builder
  • Model Designer
  • Demo:Model Designer
  • SSRS and SharePoint
  • Why Use SharePoint Integrated
  • Not Supported in Integrated
  • Alternative to Integrated
  • Integrated vs. Native

→ Reporting Server Projects

  • Report Server Projects
  • Creating Data Sources
  • Why Use Shared Data Source
  • Demo: Shared Data Source
  • Ways to Create a Report
  • Using the Report Wizard
  • Demo:Report Wizard
  • Importing Access Reports
  • Demo:Importing Access Reports
  • Access Features Not Imported
  • Creating a New Blank Report
  • Demo:Creating a Blank Report
  • Using Visual Studio Designer
  • Data Regions
  • Mixing and Matching Regions
  • Report Execution Options
  • Output Options
  • Demo: Execute a Report

→ Creating Tabular Report

  • What is a Tabular Report?
  • Creating Tabular Report
  • Demo: Creating Tabular Report
  • Datasets and Data Regions
  • Adding Dataset to a Report
  • Adding Data Region to a Report
  • Associating Region to Dataset
  • Demo:Associating Region to Set

→ Adding Controls

  • Adding Fields to a Data Region
  • Other Report Item Types
  • Static Images to Reports
  • Demo: Static Images
  • Bound Images to Reports
  • Fixup for Bound Images
  • Demo:Fixup for Bound Images
  • Is it a Table or a Tablix?
  • Adjusting Tablix Properties
  • Repeating Table Headers
  • Demo:Tablix Properties
  • Adding Page Headers+Footers
  • Adjusting Report Properties
  • Add Rows+Columns to Tablix
  • Merging and Splitting Cells
  • Demo:Add, Adjusting, Merge

→ Creating List Report

  • Creating a List Report
  • Demo: List Data Region
  • Working with Rich Text
  • Text Box Controls
  • Enable Rich text Support
  • Working with Placeholders
  • Formatting Rich Text
  • Demo: Rich Text in SSRS
  • Using HTML Rich Text
  • Enabling HTML Rich Text
  • Creating Rich Text HTML
  • Formatting with HTML Tags
  • Demo: Rich Text HTML

→ Creating Expressions

  • Creating Expressions
  • Where to Place Expressions
  • Expression Rules
  • Using the Expression Editor
  • Expression Editor Five Panes
  • Building Code Expressions
  • Expressions Using Item Panes
  • Demo: Code Expressions
  • Mathematical Calculations
  • Demo: Math Expression
  • String Expressions
  • Conditional Tests
  • Demo: Conditional Tests
  • Null Handling
  • Other Built-In Functions
  • SSRS Specific Functions
  • Demo:Nulls and Functions
  • Creating Custom Functions
  • The Code Window
  • Referencing Code
  • Demo:Custom Function

→ Global Collections

  • Using Global Collections
  • Fields Collection
  • Globals Collection
  • User Collection
  • Demo:Interactive Sorting
  • Creating Drill-Down Reports
  • Group Properties Dialog
  • Demo:Drill-Down Report

→ Creating Parameters

  • Creating Report Parameters
  • Parameters and Procedures
  • Demo:Stored Procedures
  • Report vs. Dataset Parameters
  • Report Parameters
  • Dataset Parameters
  • Reordering Report Parameters
  • Parameter Values on Report
  • Demo:Parameters
  • Parameters with Ad-Hoc SQL
  • Using Unbound Parameters
  • Demo:Ad-Hoc SQL Parameters
  • Demo:Unbound Parameters

→ Drop Down List Parameters

  • Dropdown List Parameters
  • Displaying Parameters
  • Demo:Dropdown List
  • Cascading Parameters
  • Demo:Cascading Parameters

→ Parameter Sorting

  • Parameterized Sorting
  • Demo:Parameterized Sorting
  • Show Columns using Parameters
  • Demo:Show Columns
  • Multivalued Parameters
  • Report Multivalued Parameter
  • Referring Multivalued Parameter
  • Demo:Multivalued Parameter
  • Debugging Parameter Issues
  • Debugging Other Parameters

→ Creating Matrix Reports

  • Creating a Matrix Report
  • Steps to Create Matrix Report
  • To Group or Not to Group
  • Demo:Matrix Report
  • Accessorizing Matrix Reports
  • Available Summary Statistics
  • Adding Row Group
  • Demo: Adding Row Group
  • Adding Column Group
  • Deleting Row or Column Group
  • Demo:Column Group
  • Working with Totals
  • Removing a Total
  • Demo:Row and Column Totals
  • Adding Data Cells
  • Demo:Adding Data Cells
  • Data Cell Above or Below
  • Demo:Data Cell Above/Below
  • Adding Data Cell Labels
  • Demo:Adding Data Cell Labels

→ SSRS 2008 Matrix Features

  • Tablix Data Region
  • Adding Dynamic Columns
  • Demo:Dynamic Columns
  • Adding Static Columns
  • Demo:Adding Static Columns
  • Adding Percentage to Matrix
  • Demo:Adding Percentage

→ Creating A Chart

  • Creating a Chart
  • Basic Steps to Create a Chart
  • Demo: Creating a Chart
  • SQL 2008 Chart Changes
  • Chart Anatomy
  • Formatting a Chart
  • Demo:Formatting a Chart
  • Adding a Series to a Chart
  • Demo:Adding a Series Field
  • Chart Talk
  • Chart Types
  • Demo:Chart Types
  • Charting Tips

→ Adding Gauges

  • Gauge Data Region
  • Adding Gauges to a Report
  • Demo:Adding a Gauge
  • Gauge Anatomy
  • Demo:2 Gauges
  • Add Gauge to Existing Report
  • Demo:Gauge to Existing Report

→ Deploy Reports

  • Planning for Deployment
  • Setting Active Configuration
  • Creating Custom Configurations
  • Demo:Active+Custom
  • Configuring Report Project
  • Deploying RS Project
  • Redeploying Shared Data
  • Demo:Deploying Project
  • Exporting Reports + Printing
  • Exporting Reports
  • Demo:Exporting Reports
  • Client-Side Printing
  • Client-Side Printing Setup
  • More Client-Side Printing
  • Demo:Client-Side Printing

→ Report Manager

  • Managing Reports
  • Displaying or Hiding Details
  • Navigating Report Manager
  • Running Reports
  • Demo:Report Manager
  • Managing Folders and Files
  • Reports and Data Sources
  • Generic Site Settings
  • Demo:Folders, Files + Settings
  • Creating Linked Reports
  • Creating a Linked Report
  • Demo:Creating Linked Report

→ Reporting Services Security

  • Reporting Services Security
  • Securing Access to Reports
  • Authorizing At Home Level
  • Authorizing Users
  • Demo:Authorizing Users
  • Authorizing at Project Level
  • Demo:Project Level
  • Managing RS Roles
  • Demo:Managing RS Roles
  • RS and Basic Autherntication
  • Configuring Autherntication
  • Demo:Config Autherntication

→ SSL

  • RS and SSL
  • Securing to Report Server
  • Demo: Setup SSL
  • Securing to Report Manger
  • Demo: Securing Report Manager
  • Requiring SSL
  • Demo: Requiring SSL
  • Data Source Security
  • Data Security from VS
  • Shared Data Properties
  • Four Choices for Credentials
Demo:Security Shared Data

→ Data Source Security

  • Local Storing Credentials
  • Storing Credentials in RS
  • Demo:Storing Credentials
  • Overwriting Data Sources
  • Demo:Overwriting Data
  • SQL Permissions Needed
  • Demo:Users Run Reports
  • Managing Data Security RM
  • Demo:Security from RM

→ Reporting Services APIs

  • Reporting Services APIs
  • URL Access
  • Report with No Parameters
  • Report with Parameters
  • Demo:Report with URL Access
  • Report to Output Format
  • Render Formats
  • Demo:Render to Formats
  • Rendering PDF Custom Margins
  • Customizing Data Rendering
  • Demo:Rendering to CSV
  • Integrating Report to Web App
  • Demo:Report to Web App

→ Report Viewer Controls

  • Report Viewer Controls
  • Server vs. Local reports
  • Web Report Viewer Control
  • Steps to Use Web Report Viewer
  • Demo:ASP with Report Viewer

→ Web Service

  • RS Web Services
  • A Tale of Two Endpoints
  • Why Use the Web Service
  • Wny Not Use Web Service API
  • Using RS Web Service
  • Adding Web Reference
  • Demo:Add Web Reference
  • ReportService2005 Classes
  • ReportService2005 Methods
  • Programming RS2005
  • CallReportServiceVB.aspx
  • Drilling into the Code
  • Demo:CallReportServiceVB

→ Web Service Subscription

  • Creating Subscriptions
  • Drilling into the Code
  • Demo:Report Subscriptions
  • More Drilling into the Code
  • Demo:More Report Subscriptions

→ Custom Assemblies

  • Custom Assemblies
  • Custom Assembly Example
  • Creating Custom Assembly
  • Demo:Custom Assembly
  • Creating Custom Assembly-2
  • Demo:Creating Continued
  • Creating Custom Assembly-3
  • Demo:Running Assembly
  • Security + Custom Assemblies

→ Report Caching

  • Warning!
  • Report Caching
  • Demo:Report Caching
  • Creating Expiration Schedules
  • Creating Shared Schedule
  • Demo:Schedules
  • How Caching Works
  • Parameterized Reports
  • Cache Invalidation
  • Demo:Parameters
  • Report Snapshots
  • Creating a Snapshot
  • Demo:Creating a Snapshot
  • Snapshots and Parameters
  • Demo:Snapshot with Parameter
  • Report History
  • Configuring Report History
  • Snapshot Retention
  • Viewing Report History
Demo:Create History

→ Subscriptions

  • Creating Subscriptions
  • Parts of Subscription
  • Creating Standard Subscription
  • Demo:Creating Subscription
  • Subscriptions and Parameters
  • Maintaining Subscriptions
  • Demo:Subscriptions
  • Data-driven Subscriptions
  • Data-driven Query
  • File Share Data-driven
  • Demo:File Share Data-driven
  • Email Data-driven Subscription
  • Demo:Email Data-driven
  • Null Delivery Data-driven
Demo:Null Delivery

→ Two Report Builders

  • Two Report Builders
  • Report Builder 1.0
  • Report Builder 2.0
  • Which Report Builder to use?
  • Launching Report Builder 2.0
  • Report Manager Link
  • Update Report Builder Link
  • Demo:Report Builder 1.0 + 2.0
  • Report Builder Data Sources
  • Login, Shared Data, Folder
  • Creating Report Builder Folder
  • Demo:Creating Info
  • Getting Started RB 2.0
  • New Table or Matrix Wizard
  • Demo:New Table or Matrix
  • Using New Chart Wizard
  • Demo:Chart Wizard

→ Creating Reports

  • Constructing a Report
  • Tour Around Report Builder
  • Report Builder Button
  • Report Design Surface
  • Ribbon Bar
  • Report Data Pane
  • Properties Window
  • Grouping Pane
  • Creating a Tabular Report
  • Demo:Tabular Report
  • Adding a Group to a Report
  • Demo:Adding a Group
  • Creating Matrix Reports
  • Demo:Create Matrix Report
  • Adding Totals to a Report
  • Demo:Adding Totals to Groups
  • Creating Charts
  • Demo:Create Chart
Online Courses Videos