Microsoft Business Intelligence - MSBI Training (LIVE, Instructor-Led)

This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. This MSBI Training Program includes basic to advanced Business Intelligence and Data Warehouse concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). Complete practical and realtime training course with 24x7 free LIVE server access and Lab.

MSBI (SSIS, SSAS, SSRS) Training Schedules

  PLAN A PLAN B
Description MSBI T-SQL with MSBI
Duration 7 Weeks 9 Weeks
Real-Time Project Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume Support Check-Symbol-for-Yes Check-Symbol-for-Yes
Mock Interviews Check-Symbol-for-Yes Check-Symbol-for-Yes
MCSA Certification Croos-symbol-for-Yes Croos-symbol-for-Yes
SQL Server & T-SQL Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 12,000/- INR 15,000/-
For Weekend / FastTrack Trainings Click Here

Schedules for Plan A : MSBI ( Trainer: Mr Sai Phanindra T )
  Timings (IST) Demo Date Start Date
1 7:30 AM to 8:45 AM Dec 5th Dec 6th Register
If above schedule does not work for you, please register for MSBI Training Videos

 

Schedules for Plan B : SQL Sever T-SQL + MSBI ( Trainer: Mr Sekhar )
Timings (IST) Free Demo Start Date  
1 6:30 AM to 8 AM Nov 30th Dec 1st Register
2 7 PM to 8:30 PM Nov 27th Nov 28th Register
3 7 AM to 10 AM (Wknd) Recently Started Register
Highlights : Basic to Adv. ETL Data Warehousing Data Cleaning DAX Basic to Adv. MDX Tabular Mode OLAP Custom Dashboards

MSBI Training (SSIS, SSAS, SSRS) Curriculum:

Module I: SQL Server & Design, Queries, Joins

Module II: T-SQL Queries, Tuning & Programming

CHAPTER 1: SQL SERVER (2016 / 2014) INSTALLATION

  • What is Data? What is Database? File Store Limitations?
  • Why Microsoft SQL Server? Advantages (Technical/Usage)
  • SQL Server - Career Options, Certifications, Projects
  • What is SQL? What is T-SQL? Differences. Why T-SQL?
  • MSBI Components and Real-time Activities
  • Versions and Editions of SQL Server - Overview
  • Session Wise Plan, Material and Real-time Project Details
  • LAB PLAN - 24x7 LIVE Server (Online Lab)
  • SQL Server 2016 Software - Server Installation Steps
  • SQL Server 2016 - Tools Installation and Verification
  • SQL Server 2014 / 2012 Software Installation Guidance
  • H/W & S/W Requirements. Server Configuration Options
  • Instance Types : Default and Named Instances. Instance IDs
  • SQL Server Tools - SQL Server Management Studio (SSMS)

CHAPTER 8: STORED PROCEDURES - LEVEL 1

  • Stored Procedures - Purpose, Syntax, Properties and Types
  • Compilation, Precompilation and Query Optimization (QO)
  • Variables - Usage and Data Types in Stored Procedures
  • Parameters - Usage and Data Types in Stored Procedures
  • Stored Procedure Executions - Syntax, Alternate Options
  • Stored Procedures for Data Validations & Missing Identity
  • Stored Procedures for Dynamic SQL Queries. Views & SPs
  • Stored Procedures for Data Reporting. Advantanges, Tuning
  • Important System Procedures For Metadata Access. Usage
  • Important Extended Procedures For Application Operations
  • IF.. ELSE, IF .. ELSE IF, IIF Conditions. PRINT statements
  • Error Handling Techniques in T-SQL: TRY, CATCH, THROW
  • Dynamic Parameters and Variables. Examples with Views
  • Default Parameter Values, Data Types and NULL Values
  • Batch Executions with Stored Procedures. Variants

CHAPTER 2: SQL BASICS - DDL, DML, SELECT

  • Basic SQL for Beginners. Introducing Databases, Tables
  • What is SQL? Why T-SQL? Basic SQL Queries in SSMS
  • DDL and DML Statements - Creating & Using Databases
  • Table Creation (Basic Level) - Columns and Data Types
  • Issues with Digital Data into Characters. Missing Values
  • INSERT / Store Data into SQL Server Tables - Options
  • Single Row and Multiple Row Inserts with NULL Values
  • SELECT Queries and Basic Operators : IN, BETWEEN
  • IS, UNION, UNION ALL, Other Basic SQL Operators
  • UPDATE Statements with / without Conditions. SET
  • DELETE Statements with Conditions. Logging Options
  • TRUNCATE Statement - DELETE Comparisons, Logging
  • SYSTEM DATABASES - Purpose and Importance. Resource
  • CLIENT - SERVER Architecture (TDS) & Client Statistics

CHAPTER 9: STORED PROCEDURES - LEVEL 2

  • Stored Procedures for Sub Queries, Dynamic Sub Queries
  • Stored Procedures for Recursive and Nested Queries
  • OUTPUT Parameters in Stored Procedures. Usage Options
  • Cursors - Benefits, Syntax. Using SProcs with Cursors
  • FORWARD_ONLY and SCROLL Cursors Types. Limitations
  • STATIC and DYNAMIC Cursors Types. ABSOLUTE Fetch
  • LOCAL and GLOBAL Cursor Types & Scope, Reusability
  • KEYSET DRIVEN Cursor Types & Performance Options
  • Embedding Cursors in Procedures and User Functions
  • SPs with Cursors @ Dynamic Data Loads, Data Formatting
  • Memory Limitations with Cursors with SP Recompilations
  • Using Extended Stored Procedures with User Procedures
  • Stored Procedures for Dynamic Values, Calendar Data
  • Unicode Data and Dynamic SQL Queries. sysname Data

CHAPTER 3: SQL SERVER DATABASE DESIGN

  • SQL Database Architecture - Logical and Physical View
  • Database Properties - Files - Types - Storage Options
  • Data Files : Purpose and Sizing. Detailed Architecture
  • Filegroups : Purpose and Grouping Options. Properties
  • Log files : Sizing, Placement & Detailed Architecture
  • Pages, Extents (Uniform, Mixed). Data Allocation Process
  • Write Ahead Log (WAL) and Log Sequence Number (LSN)
  • Virtual Log File (VLF) and MINI LSN. Operation Audits
  • Database Creation using GUI - Adding Files, Filegroups
  • Database File and Filegroup Options. GUI Limitations
  • Database Creation using T-SQL Scripts. SYNTAX Rules
  • Database with Filegrowth, Autogrowth, MAXSIZE Options
  • mdf, ndf, ldf and Custom Extensions. Dynamic Extensions
  • Planning and Designing Very Large Databases (VLDB)
  • CHAR versus VARCHAR Differences - Type, Size Allocations

CHAPTER 10: TRIGGERS - DML/DDL AUTOMATIONS

  • Triggers - Purpose and Types. Scope Of Usage
  • DML Triggers - Events, Types and Practical Usage
  • FOR / AFTER Triggers - Syntax, Usage and Importance
  • INSTEAD OF Triggers - Syntax, Usage and Importance
  • INSERTED & DELETED Memory Tables with DML Triggers
  • Memory Usage with INSERTED/DELETED Tables. Usage
  • Triggers for Disabling DML Operations. Trigger Priority
  • Triggers for DML Operation Audits and Data Sampling
  • Triggers for Data Distribution to Multiple Tables / Views
  • Database Triggers and Server Level Triggers
  • Triggers for Bulk Operations, Updatable Views (Indexed)
  • Triggers for Data Distribution and JOINS. Value Mapping
  • Real-time Considerations with Triggers - Precautions
  • Stored Procedures with Triggers and Advantages
  • Limitations with Triggers for DDL & DML Operations

CHAPTER 4: TABLE DESIGN & QUERIES

  • Table Design - Creation. Columns - Data Types, Length
  • Routing Tables to Database File Groups, Advantages
  • Schemas - Purpose, Creation and Usage with Tables
  • Table Design using T-SQL Scripts - Syntax, Examples
  • Data Types, Length, NULLs and Naming Conventions
  • UNION, UNION ALL Operators. Differences, Row Order
  • CREATE, ALTER, DROP -- INSERT, UPDATE, DELETE
  • SELECT Queries with Schema on Tables, Column Aliases
  • T-SQL Data Types and NULL Values. Computed Columns
  • Comparing DELETE and TRUNCATE - TLog Files
  • T-SQL Operators: IN, BETWEEN, IS, AND, OR, EXISTS
  • Default Schema and Default Filegroup for Table Design
  • Basic Sub Queries - SELECT, MIN/ MAX. Column Aliases
  • Temporary Tables : Purpose and Types. Local and Global
  • Synonyms : Purpose. Alternate Object Reference, Queries

CHAPTER 11: TRANSACTIONS & ISOLATION LEVELS

  • Need for Transactions, Transaction Scenarios
  • ACID Properties and Transaction Types. Atomic Property
  • EXPLICIT, IMPLICIT Transactions - Query Blocking
  • IMPLICIT Transactions - Usage, Database Settings
  • AUTOCOMMIT Transactions - Advantages, Examples
  • OPEN Transactions and Audits. OPENTRAN commands
  • Nested Transactions and COMMIT / ROLLBACK Rules
  • SavePoint Options with Explicit Transactions, Rollbacks
  • LOCK HINTS : READPAST, NOLOCK, HOLDLOCK - Usage
  • ReadCommitted & Read UnCommitted Isolation Levels
  • Snapshot Isolation, Serializable Isolation Levels
  • ReadCommitted Snapshot Isolation with Tempdb Usage
  • Choosing the Best Isolation Level in OLTP Environment
  • TRY..CATCH..THROW & Error Handling with Transactions
  • Real-world Considerations For Transactions

CHAPTER 5: CONSTRAINTS and KEYS

  • Constraints and Keys - Ensuring Table Data Integrity
  • Normal Forms - Types, Relational Database (RDB) Design
  • OLTP Database Model & BCNF - Relations with PK / UQ
  • NULL, NOT NULL and Default Nullability for Columns
  • UNIQUE KEY Constraints: Importance, Uniqueness, Nulls
  • PRIMARY KEY Constraint: Properties, Priority, Limitations
  • FOREIGN KEY Constraint: References, Relations & Usage
  • CHECK Constraints: Properties, Conditions and Usage
  • DEFAULT Constraints: Properties, Usage and Limitations
  • Relations with Tables across Multiple Schemas, Usage
  • Identity Property with / without PRIMARY KEY, Usage
  • Naming Conventions For Constraints, Columns and Tables
  • Normal Forms - Types, Purpose and Usage. With Examples
  • BCNF: Boycee-Codd Normal Form and Practical Usage

CHAPTER 12: INDEXES and QUERY TUNING OPTIONS

  • Indexes: Architecture (Page Level), Purpose and Types
  • Clustered Indexes - Architecture, Fragmentation Issues
  • Non Clustered Indexes - Architecture, Column References
  • Execution Plans and Query Optimization (QO) Techniques
  • Execution Plan - Table Scan, Index Scan and Index Seek
  • INCLUDED INDEXES - Index Seeks, Query Tuning
  • COLUMNSTORE Indexes - Advantages, Usage Examples
  • FILTERED Indexes & Online Indexes
  • Materialized Views / Indexed Views - Tuning Options
  • Query Optimizer (QO) Options for Index Pages, Data Pages
  • Limitations of Indexes - Impact on DML and SELECT
  • Primary Key Index, Composite Indexes and Precautions
  • RID and Index Key Concepts. Index Page - Data Page Arch"
  • Real-world Considerations For Indexes (Tables, Views)

CHAPTER 6: JOINS, SUB QUERIES & NESTED QUERIES

  • JOINS - Purpose and Types, Use Case Scenarios
  • JOIN - Types, Queries and Importance of Reports
  • CROSS JOIN in detail. Examples and Conditions @ WHERE
  • INNER JOIN in detail. Examples with WHERE and ON
  • Comparing INNER JOIN with CROSS JOIN for Conditions
  • OUTER JOINS in detail. LEFT, RIGHT and FULL Joins
  • SELF JOINS with INNER / OUTER Joins. Usage Scenarios
  • Working with Self Joins on non key columns, advantages
  • JOINS with more than 2 tables. Syntax, Precedence Order
  • Query Optimization Considerations with Schema References
  • Deciding the best Join Type, Order and Query Options
  • JOIN Queries with Options and UNION, UNION ALL Operators
  • Basic Sub Queries and Joins. Alternate Syntax & Queries
  • Using ON and WHERE for Join Conditions. Working with NULLs
  • Using SubQueries for Self Joins and Outer Joins
  • Working with Nested Queries and Nested Sub Queries
  • Using Sub Queries and Nested Sub Queries with Outer Joins
  • End User Access to SQL Databases - Reporting Tools, Options
  • A Real-world Case Study understanding Joins & Queries

CHAPTER 13: SQL SERVER ARCHITECTURE

  • Client - Server Architecture of SQL Server
  • SQL Server Tools - Connection Options, TDS Packets
  • Protocols : TCP / IP, Named Pipes, Shared Memory
  • SQL Native Client (SNAC) and OLE DB Drivers / Providers
  • ISO - OSI Model of Data Connections, Encrypted Data
  • Query Processing and Query Optimizer (QO) Components
  • SQL Server Architecture For Database Engine, LCM Options
  • Architecture - Query Processor and Storage Engine
  • Architecture - Query Parser, Optimizer, Mini LSN, MDAC
  • Architecture - SQL Engine, SQL Manager and Query Buffers
  • Architecture - Write Ahead Log (WAL), Lazy Writer Threads
  • Architecture - SQLOS Threads and Task Schedulers, CLR
  • SQL Database Architecture - RAID Levels (S/W, H/W)
  • Log Sequence Numbers (LSN) and Time Mapping. Audits
  • Log File Architecture - Virtual Log Files and Usage
  • Log File Architecture - Mini LSN & Degree Of Parallelism
  • DB Catalogs, CLR Integration and MDAC Components
  • LSN Timestamps and MINILSN. Background Threads @ SQL

CHAPTER 7: VIEWS - FUNCTIONS & QUERIES

  • Views on Tables - Stored SELECT Statements, Data Access
  • SCHEMABINDING and ENCRYPTION Options - Advantages
  • Cascaded Views and WITH CHECK OPTION, Advantages
  • Orphan Views - Scenarios and Realworld Solutions
  • Common System Views For Metadata Access, Object IDs
  • Functions: Types, Purpose and Usage. Return Values
  • Scalar Value and Inline Table Value Functions
  • Multi-Line Table Value Returning Functions - Usage
  • Table Variables and Parameters in SQL Server. Usage
  • ROLLUP and CUBE - Sub Totals, Grand Totals, Aggregates
  • ROLLUP of Table Data. Column Aggregations. ORDER BY
  • CUBE on Table Data - Purpose & Usage. Permutations
  • Queries with GROUPING() Option in SELECT, Using HAVING
  • HAVING versus WHERE Conditions - Usage Differences

CHAPTER 14: REAL-TIME PROJECT (BANKING)

  • End - to - to End Project Implemetation
  • Phase 1: Understanding Project Requirement - Banking
  • Phase 1: Database Design with FileGroups, Schemas
  • Phase 1: Table Design with FileGroups, Schemas
  • Phase 1: Defining Constraints, Relations, Synonyms
  • Phase 2: Views for Data Inserts, Joined Queries
  • Phase 2: Common Reporting Functions, User Access
  • Phase 2: INSERTS with PIVOT, Calculations, Sub Queries
  • Phase 3: End-to-End Implementation - Data Validations
  • Phase 3: Stored Procedures for Dynamic Data Inserts
  • Phase 3: Updatable Views and Triggers for DML, Indexes
  • Phase 3: DML Operations with PIVOT and Pagination
  • Phase 3: COMPLEX Stored Procedures in T-SQL
  • Phase 3: DB Documentation Tools, Deployment Options
  • Transaction Audits and Offline Query Logs for MSBI DEVs

CHAPTER 1: SSIS INTRODUCTION, INSTALLATION

  • SQL Server Integration Services (SSIS) & ETL / DWH
  • Advantages of SSIS for Data Loads, ETL, DataWarehouse
  • SSIS Tools : SSDT (SQL Server Data Tools), ETL Wizards
  • SSIS Design / Development & LIVE Environment
  • Understanding Data Warehouse (DWH) Design & ETL
  • DWH and ETL Structures, Implementations with MSBI SSIS
  • SSIS ETL Operations for Data Reads, Data Cleansing, DWH
  • Data Warehouse (DWH) Design Principles and Design Plan
  • SSIS 2016 and SSIS 2017 : SSIS Database Installations
  • SSIS Catalog DB Encryptions and CLR / Startup SPs
  • SSIS Database and Catalog Folders - Purpose, Passwords
  • SSIS 2016, 2017 Configuration and DB Catalog Encryptions
  • SSIS Catalog Database (SSIS DB) : Creation, Verification
  • SSDT Tool: SQL Server Data Tools - SSDT / Visual Studio
  • SSDT 2015 Installation and Verification of SSIS Templates
  • SSDT 2013 Installation and Verification of SSIS Templates
  • SSIS Package Environment and SSDT Project Creation
  • SSIS Solutions and Project Templates - Verifications
  • Version Control and SSIS Design Plan - Tools Usage
  • SSIS Online Training - Lab Plan, Resources & Databases

CHAPTER 7: LOOKUP, CUSTOM TRANSFORMATIONS

  • Working with Parity Bits, Conditional Lookup Transformation
  • Row Redirection Options & Lookup Match, NonMatch Output
  • OLE DB Command: SQL Statements and Input Parameters
  • Parameter Mapping and Dynamic SQL for Row Updates
  • Cache Transformation with Memory Loads, CAW Files (VM)
  • Need for Checksum Transformation in ETL Data Loads
  • Configuring Checksum Transformation : 2014, 2016 Versions
  • Checksum Transformation Logic & Parity Checks (CRC)
  • Generating Checksum Values @ Type I, Type II ETL Changes
  • DWH Dimension Tables With Checksum Transformation
  • Memory Connections and Reuse. Lookup with Cache Options
  • Tuning Lookup Transformation: Caching & Index Options
  • FULL CACHE : Usage Options. NO CACHE: Usage Options
  • PARTIAL CACHE : Precautions. Data Splits, Fast Loads
  • Cache Connection Manager, Performance Tuning @ ETL
  • Pre-ETL Data Load Operations with Memory Connections
  • Lookup with NOCACHE Options. Advantages, Precautions
  • Understanding Dependent Data Flow Tasks and Usage
  • SSIS Package Internal Parameters and Query Updates
  • OLEDB Command with Conditional Splits, Multi Row Updates

CHAPTER 2: SSIS PACKAGE DESIGN BASICS: ETL

  • SSIS Developer Environment (SSDT) Interface
  • Basic Vocabulary - SSIS, ETL, DWH, Data Flow, Data Buffer
  • Control Flow Tasks - Architecture, Purpose and Usage
  • Data Flow Tasks - Architecture, Purpose and Usage
  • Creating SSIS Packages For Basic Data Flow Operations
  • SSIS Solutions, Projects and Package Creation. Tasks
  • Need For Data Pipelines & Connections in Data Flow Tasks
  • Basic Data Extraction Drivers / Providers with Data Flow
  • Using OLE DB and SQL Server Connections - Usage
  • SSIS Package Creation Process - Using Control Flow Items
  • SSPI Interface Connections, Data Source, Initial Catalog
  • Using DTSX Files for SSIS Package Execution. Audits
  • SSIS Execution Context, SSIS Package Errors and Logs
  • Using Source Assistants, Destination Assistants in SSIS
  • DAT File Imports, Data Flow Options, Adding Annotations
  • Common SSIS Package Errors & Solutions in Real-time
  • SSIS Project Configuration Options - Debugging, Bit Config
  • SSIS 64 Bit and 32 Bit Configuration Settings and Options

CHAPTER 8: XML DATA, LOGGING, ERROR HANDLING

  • System.Data.SQLClient Managed Providers: Usage Options
  • Dynamic Connections and Loops with SSIS Expressions
  • SSIS Expressions with Variables For File Specifications
  • For Each Expressions - Dynamic File Types, Directories
  • Variable Mapping with Indexed Connections. Performance
  • XML Queries, Options @ Sub Queries. XML Data Imports
  • RAW Files - DTSPipeline Wrapper & RAW Adapters
  • Row Sampling and Percentage Sampling Options
  • SSIS Logging - Text Files and sysssislog Tables @ Audits
  • Package Logging and Container Events for Execution
  • SSIS Logging Options and Connections. Verifications
  • SSIS Data Profiler Tool, ADO.NET Connections and XML
  • SQL Data Profile Viewer Tool - Usage with XML Files
  • Nullability Checks and Fast Load Options @ Row Size
  • ADO.NET Connections for SQL Profiler Tool, Options
  • Time-Out Options for Quick Profile, Candidate Keys
  • Value and Length Distribution, Surrogate Key Detection
  • XML File Imports for SQL Profiler Viewer Tool, Options

CHAPTER 3: MERGE, UNION ALL, CONVERSIONS

  • Understanding ETL and DWH Implementations - Strategies
  • Bulk Load Operations and Data Import Options in SSIS
  • Bypass Prepare and Execution Options with SQL Task
  • Historical Data Loads (Type II) and Incremental Updates
  • Debugging Controls in SSIS - Variants and Limitations
  • Data Flow Debugging Controls and Data Viewer Options
  • Synchronous & Asynchronous Transformations, Data Loads
  • Row and Partial Blocking Transformations. Buffer Reuse
  • Fully Blocking Transformations - Buffer Reuse Restrictions
  • Examples to Avoid Fully Blocking Transformation in SSIS
  • Advanced Options and Input / Output with Excel Sources
  • Excel Connections, Sheets, & Memory References - Usage
  • MERGE Transformation and UNION ALL Transformation
  • SORT Transformation, NOSORT Options, Advanced Sort
  • Data Conversion Transformation and SSIS Expressions
  • Data Flow Transformation: Conditional Split, Expressions
  • Transactions & Batch Data Loads with SSIS Packages
  • Comparing Regular Loads and Fast loads in ETL / DW

CHAPTER 9 : SSIS CUSTOMIZATION WITH SCRIPT TASK

  • Script Task - Purpose and Working in SSIS Control Flow
  • Script Task - Usage with VB.NET Programs. Compilations
  • Script Task - Usage with C#.NET Programs. Compilations
  • Variables and Parameters with SSIS Script Task. Usage
  • Read Only and Read Write Variables. Expressions, Mapping
  • Namespace Options, Customizations : System.IO, DTS
  • Using VB.NET, C#.NET Scripting Programs with Parameters
  • Data Flow Limitations : Solutions with .NET Scripting
  • SSIS Variables and Parameters - Mapping Expressions
  • Understanding Control Flow - Sequence Containers, Usage
  • Using Control Flow File System Tasks and Limitations
  • Using .Net Scripting for SQL Server Data Reads/Writes
  • SQLDataAdapters & System.Data.SQLClient Connections
  • Script Task for Data Writes and Row Level Formatting
  • Adding DTS Packages to SSIS Projects (Data Tools)
  • Using Variables and Parameters for SSIS Script Task
  • Script Component in Data Flow Task - Usage Options
  • Using Script Task for Control Flow, Data Flow Limitations

CHAPTER 4: PIVOT, FUZZY LOOKUP, TRANSACTIONS

  • Importing Legacy Data, Need for Data Cleansing, Formatting
  • PIVOT Transformation, Data Reads, Connection Assistant
  • Pivot Usage Values - Purpose and Implementation
  • Lineage ID in SSIS - Purpose, Usage. Column Mappings
  • Data Exchange Operations with Pivot Keys and Pivot Values
  • Data Viewer (Debugging) for Data Transfer Verifications
  • Debugging with Detach/Attach, Buffer & Row Counts
  • Fuzzy Lookup Transformation, Reference Table Connections
  • Exact, Fuzzy, Nomatch Data Cleansing - Conditional Split
  • Index Creation, Maintenance - Faster Data Lookups
  • Data Conversion Transformation - Usage. Derived Columns
  • Data Conversion Transformation - NVARHAR, VARCHAR
  • Explicit Data Type Conversions. Error Redirections
  • SSIS Package/Project Conversions - Process and Options
  • Text Qualifiers and Data Loads with Flat File Sources (.dat)
  • SSIS Expressions and Package Debugging, Break Points
  • Transaction Options For SSIS Executables - Package Level
  • Precedence Constraints - Success/Failure/Completion

CHAPTER 10: FACT TABLE DESIGN, FACT LOADS (DWH)

  • Fact Table - Design and Implementation Rules, ER Model
  • Fact Table Design with STAR and SNOWFLAKE Schemas
  • Time Dimensions - Purpose, Usage and ETL Date / Time
  • Generating Time Dimensions for ETL, Load Identification
  • Linking Time Dimensions to Fact Loads, Lookup Operations
  • Caching Options in Lookup. Dimension Loads, Key Lookups
  • Parent-Child Packages for Dimension,Fact Table Loads
  • Master Package Design: Dimension, Fact Load Integration
  • Inferred Members and Status for NULLs in Dimensions
  • Parameter Mapping for ETL Updates, Component Properties
  • ETL Load Date IDs & Expressions for Dimension Keys
  • Error Handling & Event Handling with Master Packages
  • Project Connections, Parameters in Master-Child Packages
  • Key Based Dimension LOOKUPs and Indexes. Fast Loads
  • SCD Implementations with Legacy Data. ETL Load Types
  • Fact Load Design for Initial Loads, Incremental Updates
  • End-to-End Data Warehouse Design & .NET Scripts
  • STAR & SNOWFLAKE Schemas for DWH - Data Modeling

CHAPTER 5: SSIS with ETL, DWH. SCD TYPE 1, TYPE 2

  • Sales Scenario for OLTP Database to Historical Data Loads
  • Introduction to Datawarehouse (DWH) - Purpose, Access
  • Dimension Tables, Fact Tables and Inferred Members
  • TYPE1 and TYPE2 Changes. ETL Implementations
  • Type I Changes (SCD) for DWH in Sales Scenario
  • Dimensional Table Design for DWH using SCD - Type 1, 2
  • Data Loads with Legacy Files: DAT, TXT, CSV. Data Marts
  • Surrogate Keys and Alternate Business Keys - Purpose
  • Identity Columns, Key Values. Business Key Limitations
  • Changes to Fixed & Changing Attributes. Observations
  • Changes to Historical Attributes. Inferred Member Updated
  • ETL Date Fields, Row Status Values and Transformations
  • Naming Conventions For SSIS Entities & Reusability
  • Designing Dimensions for DW - Incremental, History Loads
  • OLE DB Connections for Incremental Loads in DWH
  • Identity Property, Attribute Keys in SCD, Limitations
  • Historical Attributes and Data Delta Identification
  • SSIS SCD Transformation Limitations and Real-time Issues
  • SCD Transformation with OLE-DB Command Transformation

CHAPTER 11: SSIS PROJECT DEPLOYMENT, UPGRADES

  • SSISDB Catalog Deployments - Process, ISPAC File Structure
  • SSIS Package Builds, Verification Techniques, Scripts
  • SSIS Project Deployment Wizard : Targets and Logging
  • SSIS Package Deployments - Need, Options and Tools
  • SSIS DB Catalog Folders - Creation, Usage. Properties
  • SSIS DB Catalog Projects For Project Deployments
  • SSIS Package Executions - Scripts, Reports, Messages
  • Package Validations - Scripts, Reports, 32/64 bit Options
  • Package Configurations - Parameter Management, Scripts
  • SSIS Package Jobs from SQL Server Agent. SSIS Job Steps
  • SSIS Job Schedules and Notifications: Windows Event Logs
  • SQLISPackage130 Events and Error Logs. Package Monitoring
  • Package Security Management - SSISDB Logins and Users
  • ssis_admin, ssis_failover_monitoring_agent, ssis_logreader
  • Folder Level and Project Level Security Implementation
  • Execute/Write/Folder Security Content Management Roles
  • Business Intelligence Development Studio: SSIS BIDS
  • Project Migration Utilities in SSIS, SSIS Project Passwords
  • Importing ISPAC Files, SSIS Projects. Re-Engineering

CHAPTER 6: CONTAINERS & LOOPS in SSIS

  • Threshold Values Selection, Search Delimiters
  • Data Pipeline with _Similarity & _Confidence Columns
  • ForEach Loop Container. File Connections, Variables
  • Defining Variables for Connections. DFT and Control Flow
  • Dynamic Connections with Variables. For Loop Container
  • Connection Iterations, Fetch, Index Mapping
  • Local and Global Connections. Naming Conventions
  • Post ETL, Derived Column and Fuzzy Transformations
  • SSIS Configurations, Usage. Dynamic Connection Values
  • SSIS Package Level Rollbacks and Restart Execution
  • Checkpoint Files and SSIS Logging - Package, Tasks
  • Checkpoint Options - Advantages and Limitations
  • Dynamic Connection Managers - Precedence Constraints
  • FailPackageOnFailure and Checkpoint Property Usage
  • Transaction Property : REQUIRED / (NOT)SUPPORTED
  • Parent - Child Package Design, Parameter Binding
  • Master Packages and Child Packages, Derived Columns
  • Defining Local and Global Variables / Parameters
  • Parameter Bindings with Parent - Child Packages

CHAPTER 12-13: REAL-TIME PROJECT @ ECOMMERCE

  • Advanced Connection Options - XML, DT_NTEXT Stream
  • XML Connections & Usage. Reading, Operating XML Data
  • Column Statistics and SSIS Data Profile Viewer Tool
  • Direct Data Loads and Data Stage Operations for DWH DBs
  • DML Audits using Change Data Capture (SQL Server)
  • Understanding CDC Tables with SQL Server Connections
  • DML Audits: Inserts, Deletes, Values before/after Updates
  • CDC Source Connections - Usage, ADO.NET Integration
  • CDC Control Flow Tasks and CDC State Tasks. Values
  • INITIAL LOAD START / END. PROCESSING RANGES
  • SSIS CDC Source Connections with Net Support Changes
  • Adding DTS, Older SSIS Packages & Package Upgrades
  • SSIS Packages, SMO Connection with BIDS. Project Builds
  • Command-Line Deployments For SSIS, Execution Utilities
  • Advantages of SSIS ETL/DW Procedures and Data Audits
  • SSIS Packages for Database Migrations - Online/Offline
  • Database Copy & Move Options. Pre, Post Migration Tasks
  • Package Refresh Options, Package Upgrade Properties
  • Using State Variables and Controls. Storing States

CHAPTER 1: MULTIDIMENSIONAL MODE - CONFIG

  • Installation and Configuration: SSAS 2014, 2016, 2017
  • Need for SSAS Component & Tools - Operation Modes
  • Multidimensional Mode : Purpose, Properties & Usage
  • Configuring Multidimensional Mode Instances, Verification
  • Understanding Multidimensional Databases (OLAP Databases)
  • SSAS Service Accounts & Usage. SQL Browser Service
  • SSDT Tool: SQL Server Data Tools - SSDT / Visual Studio Shell
  • SSDT 2015 Installation and Verification of SSAS Templates
  • SSDT 2013 Installation and Verification of SSAS Templates
  • Understanding SSAS Developer Environment (SSDT) Interface
  • SSAS Online Training - Lab Plan, Resources & Databases
  • Introduction to OLAP Database: Measure Groups, Measures
  • Attributes, Hierarchy Levels and Members. Cube, OLAP DB
  • Need for MDX : Multidimensional Expression Language
  • SSAS Workflow in Real-world. Sources to SSAS to Reports
  • SSAS Components and DO-MD Client. Server and Client Arch"
  • Data Source Configurations & DB Installations for Lab

CHAPTER 7: KPI DESIGN USING MDX

  • Key Performance Indicators (KPI) - Purpose, Design
  • KPI GOAL, VALUE, STATUS, TREND, WEIGHT
  • Data Driven Goals - Identification and MDX Expressions
  • Variance and Value Computations. Format, Scope
  • KPI Organizer, Calculation Tools. Metadata Refresh
  • Associated Measure Groups For KPIs. Time Members
  • KPI Design with MDX Expressions, Time Based Analysis
  • Parent - Child KPIs : Purpose and Design. Weights
  • Cube Design Options with KPI Calculations, Functions
  • FORMAT_STRING, MDX Expressions and Members
  • KPI Goal @ PARALLELPERIOD, CLOSINGPERIOD
  • MDX Expressions for Cube Design, SESSIONSCOPE
  • MEMBER Names and SOLVE_ORDER Expressions
  • Parent KPIs with Member Hierarchies, KPI Browser
  • Re-using KPIs in OLAP. Excel Pivot Reports - Drilldown
  • KPIs for Drill-Up, Drill-Down in MS Excel. Pivot Tables
  • Perspectives, Translations with KPIs, MDX Calculations

CHAPTER 2: BASIC CUBE DESIGN WITH SSAS

  • Identifying Analysis Entities in OLAP Database, Design Plan
  • Need for OLAP Databases and Cubes For Analysis - OLAP
  • Implementing Kimball & Inmon Methods Of BI - SSAS Design
  • Realworld Example - Sales Scenario for SSAS. Cube Design
  • Basic SSAS Database Entities. Sources, Destinations
  • Data Source, Data Source View and Cube Designer Wizard
  • Dimension Wizard and Attributes. BUILD, DEPLOYMENT
  • PROCESS of OLAP Cube. Options and Online Deployment
  • Excel Connections for SSAS and OLAP Cube Access
  • Excel PIVOT Tables and Basic Chart Report Design with SSAS
  • Piechart Reports and Attribute Filters. Usage Statistics
  • Using Microsoft Excel for OLAP Cube Access and Filters
  • Common Deployment Errors : Logon Failures @ OLAP Server
  • OLAP Deployment Warnings and Solutions. Impersonaltion
  • Data Source to SSDT : Issues, Solutions and Data Flow
  • OLAP Cube Design and Working : Access Methods
  • End to End Implementation of SSAS in Real-world

CHAPTER 8: TABULAR MODE CUBE DESIGN

  • Tabular Mode : Purpose, Properties and Usage (ROLAP)
  • PowerPivot Mode : Purpose, Properties and Usage
  • Configuring Tabular Modes Instances Purpose and Tests
  • Tabular Mode - Importance, Advantages. SSDT Templates
  • Workspace Server Architecture, Configuration Settings
  • Entity Identification Procedures and Design Constraints
  • Data Import Wizard and SQL / ODBC Connection Settings
  • Column Filters and Row Filters. Workspace Import Settings
  • Dimension Identification Technques in Tabular Mode
  • Working with Hierarchies, Attributes and Tabular Grids
  • Aggregated Measures & Measure Groups. KPI Generation
  • KPIs with Static and Dynamic Goals. Status, Trend Factors
  • Measure and Measure Group Identification Techniques
  • In-Memory and Direct Query Option for Cube Process
  • Direct Query with In-Memory Settings. Vicer Versa
  • Performance Advantages of Tabular Mode, In-Memory
  • Integrated Workspace and Dedicated Workspace - Usage

CHAPTER 3: CUBE DESIGN - ATTRIBUTES, HIERARCHIES

  • Cube Design with Attributes, Keys and Relations. Members
  • Data Source View : Entities, Related Objects, Filters
  • Database Dimensions : Identification and Purpose / Usage
  • Cube Dimensions: Identification and Purpose / Usage
  • Connection Strings for SQL Server Data Sources. Options
  • Named Queries and Calculations in Data Source View (DSV)
  • DSV Entities : Data Explore Options. Data Verifications
  • Expressions in DSV Entities. Named Calculations & Reports
  • Cube as a Subject Oriented OLAP Database Object. Browse
  • Cube Access Methods : Cube Browsers - SSMS and SSDT
  • Cube Access Methods: Excel, SSRS, Power BI, Tableau, etc.
  • MDX Filters (Browser Options). Pivot Reports @ MS Excel
  • Backend Access to Business Data. Frontend Access to Reports
  • Cube Browser - SSDT and SSMS Drilldown Differences
  • Hierarchies : Attribute Levels and Purpose. Easy Access
  • Defining Hierarchies for Easy Access. Drill-down Reports
  • Performance Warnings and Attribute Relations and Keys
  • Composite Attribute Keys, Member Name Columns, Hierarchies
  • Deployment Errors - Duplicate Attribute Keys: Solutions

CHAPTER 9: TABULAR CUBES WITH MDX

  • Named Query with Tabular Design, Entity Relations
  • Marking Time Tables and Date/Time Key Setttings
  • Time & Non-Time Hierarchies with Tabular Mode
  • Time Based Hierarchies and Keys in Tabular Mode
  • Partitions - Entity Level Partitions, SQL Scripts
  • Entity Conditions with Partions. Cloning Options
  • Freezing Columns, Pivot / Unpiviot Operatins
  • Connection Edits, SMDL (Semantic Definition Language)
  • Cube Design and STAR / SNOWLFLAKE Schemas
  • Virtual Cube Access and OLAP Cube Browsing Options
  • Cube Measure Goals, Status. Add/Remove Columns
  • ODC (Office Data Connections) & ROW / Column Filters
  • Partition & Perspectives in Tabular Mode. Browser
  • Goal Identification For KPIs. Static, Dynamic Goals
  • Issues and Solutions with Static and Dynamic Goals
  • KPI Design with Remote Measures and Abstract Values
  • Build & Deployment Options. Transactional Deploy
  • BUILD & Deployment in Tabular Mode. XMLA Scripts
  • Tabular Processing - InMemory & Direct Query Modes

CHAPTER 4: MDX QUERIES & EXPRESSIONS

  • MDX: Multidimensional Expression Language. Syntax Rules
  • MDX Syntax and Axis. Cube Data into ROWS, COLUMNS
  • Practical Advantages of MDX: Reports, Cube Writebacks
  • MDX Queries with Dimension Attributes, Members. Axis Levels
  • MDX Queries on Hierarchies, Levels and Attribute Keys
  • MEMBERS, CHILDREN, ALL MEMBERS: Aggregates
  • Reporting Multiple Measures / Attributes. Tuple & Set Values
  • MDX Joins using * and CROSSJOIN. Precautionary Measures
  • MDX ORDER, TOPCOUNT / HEAD, BOTTOMCOUNT/ TAIL
  • MDX Queries with WHERE, EXCEPT, RANGE, Operators
  • NONEMPTY, Multiple Member Values. Limitations with WHERE
  • PARENT and CHILDREN with MDX Hierarchies. Tuple Inverse
  • FILTERS in MDX - CURRENT MEMBER, EMPTY MEMBER
  • FILTER Expressions with AND / OR and LEFT / RIGHT Range
  • LEFT/RIGHT and Pattern Matching with MDX. Empty Axis
  • Exact and Closest Match Search Patterns, Operators in MDX
  • Working with NULL Values, Cascades and Cell Details in MDX
  • MDX Query Batches. ADOMD Client: MDX Query Processing
  • MDX Queries for Formatting Options. Member Name Binding
  • Attribute Keys for Member Value Access. Advantages, Usage

CHAPTER 10: DAX - FUNDAMENTALS & SYNTAX

  • Purpose of Data Analysis Expresssions (DAX)
  • Scope of Usage with DAX. Usabilty Options
  • DAX Context : Row Context and Filter Context
  • DAX Entities : Calculated Columns and Measures
  • DAX Data Types : Numeric, Boolean, Variant, Currency
  • Datetime Data Tye with DAX. Comparison with Excel
  • DAX Operators & Symbols. Usage. Operator Priority
  • CALCULATETABLE, FILTER, SUMMARIZE ADDCOLUMN
  • CROSSJOIN, GENERATE and GENERATEALL
  • CALCULATETABLE, FILTER, SUMMARIZE
  • Vertipaq Storage - Advantages. OLAP Backend Options
  • Direct Query Mode Settings. Modelling in Tabular
  • ENDOFYEAR, ENDOFQUARTER and ENDOFMONTH
  • FIRSTDATE, LASTDATE, DATESBETWEEN, COUNTALL
  • CLOSINGBALANCEYEAR, DATESYTD, DATESQTD
  • SAMEPERIOD and PREVIOUSMONTH, DATESMTD
  • TOPCOUNT, TOPCOUNTX, SUM, SMUX in DAX
  • Calcualted COlumns and Calculated Measures with DAX
  • DAX Expressions with Measures and Columns
  • DAX for Query Extraction, Data Mashup Operations

CHAPTER 5:TIME CALCULATIONS with MDX

  • MDX Calculations - Need & Advantages. UI Options
  • Calculations with MDX Scripts. Syntax Verification
  • Calculations Usage and Folders - Cube Browser Usage
  • Conditional Formats, Expressions. Verification @ MS Excel
  • TIME DIMENSIONS - Purpose and Advantages, Properties
  • Time Keys and Time Attributes - Calendar / Fiscal / ISO
  • Adding Hierarchies and Members to Time Dimensions. Usage
  • Dimension Enhancements - Purpose, Advantage, Usage Scope
  • Cube Enhancements - Purpose, Advantage and Usage Scope
  • Time Type Calculations with MDX Expressions, SCOPE
  • Identifying Attributes & Hierarchies For Time Enhancements
  • Time Calculations for Attributes & Hierarchies - Differences
  • MDX Scripting for Time Calculations. Verification Techniques
  • Attribute Calculation Sets and MDX Scripts. Grouping Options
  • Browsing Time Calculations in MDX Editor, Cube Browser
  • Time Calculations with User Defined Calculations - Options
  • Attribute Level Calculations and Members - Dimension Level
  • Measure Level Calculations and Granularity - Cube Level
  • Calculation Properties : Type, Scope, Format, Visibility
  • Associated Measure Groups & Parent Hierarchy, Non-empty
  • Using Calculations in FILTERS and Search Pattern - MDX
  • Slow running Queries with MDX: Need for Tuning Cubes

CHAPTER 11: TABULAR & MOLAP DEPLOYMENTS

  • SSAS Project Builds and SOlution Builds
  • Deployment Configuration Files & Contents
  • SSAS Deployment Wziard and XMLA Scripts
  • Partition Management and Schedules (OLAP Jobs)
  • Storage Modes in MOLAP and ROLAP
  • Multidimensional OLAP DB Management: Backups, Restores
  • Multidimensional OLAP DB Management: Detach, Attach
  • Multidimensional OLAP DB Management: DB Synchronize
  • Tabular OLAP DB Management: Backups, Restores
  • Tabular OLAP DB Management: Detach, Attach
  • OLAP Database Scripting and Cloning Options. Jobs
  • Cube Processing Jobs and Schedules with SQL Server
  • Comparing SSAS 2012, SSAS 2014 and SSAS 2016
  • Comparing Multidimensional and Tabular Modes
  • Usage Based Optimization (UBO): Aggregations
  • Storage Modes : Multidimensional, Relational and Hybrid
  • Flight Recorder Settings, SSAS Query Log Providers
  • Data Sampling Intervals and MDX Query Tuning Process
  • 100% Aggregations (FULL), CPU and Space Thresholds
  • Lazy Aggregations & UBO in Partitions, Performance
  • Security Roles with MDX and DAX
  • In-Memory Options and Deployment Scripts

CHAPTER 6: PARTITIONS, AGGREGATIONS, STORAGE

  • Partitions : Purpose and Architecture, Tuning Operations
  • Cube Partitions : Storage, Slice Options. Query Conditions
  • Query Binding and Table Binding Options in Partition Design
  • Aggregations - Purpose and Usage. Predefined Calculations
  • Aggregation Types: Full, Default, None and Unrestricted
  • Aggregation Design with Optimization Levels and Storage
  • Measure Properties and Default Aggregation Types in OLAP
  • Aggregations on Measures, Dimensions and Keys. Scope
  • Linking Aggregations and Partitions. Cube Slicing Options
  • Aggregation Reusability Options - Multiple Partitions
  • Additive and Semi-Additive Measures - Aggregation Options
  • MOLAP - Automatic Processing, Scheduled, Medium Latency
  • Low Latency Processing and Custom Scheduling Options
  • Proactive Caching Options and Silence / Override Interval
  • Cache Rebuild & Overwrite Options. Processing with Partitions
  • Perspectives - Purpose and Scenarios For Invalid Cube Access
  • Dimension Usage Tab for Dimension Relations. End User Access
  • Cube Deployments with Partitions, Aggregations, Perspectives

CHAPTER 12: REAL-TIME PROJECT : MOLAP, TABULAR

  • Writeback Partitions - Cube & Dimension Updates
  • MDX Expressions, Queries for Writeback. Advantages
  • Writeback & MDX Transactions - COMMIT / ROLLBACK
  • Subcube - Creation, Advantages. MDX Query Plans
  • Subcube - DESCANDANTS, PARENT, MEMBER Functions
  • Data Mining - Techniques and Forecast Operations
  • Mining Structures & Mining Models - Storage
  • CLUSTERING, DECISION TREES, NEURAL NETWORK
  • REGRESSION Techniques, Naive Bayes Mining Algorithms
  • Case Tables Identification and Nested Table For Relations
  • Attribute Data Types - DESCRETE & CONTINOUS
  • Training Sets, Testing Sets for Data Mining Accuracy
  • Dependency Rules, Classification Charts and Lift Chart
  • Mining Algorithms - Score and Prediction Analysis
  • DMX Queries - Forecasts, Prediction Expressions
  • Mining Model Comparison, DMX & Forecast Reports
  • XEvents support through SSMS, DBCC Commands
  • DAX performance with Super DAX - DBCC Commands

CHAPTER 1: SSRS INSTALLATION, CONFIGURATION

  • Need For Reporting Solutions (SSRS) and Tools
  • Reporting Engine Architecture and Report Databases
  • SSRS Installation, Tools and Database Configuration Process
  • SSRS 2016 : Installation and Report Databases
  • SSRS 2014 : Installation and Report Databases
  • Report Server URL - Purpose, Test Connection, Usage
  • Report Manager URL - Purpose, Test Connection, Usage
  • Report Portal URL in SSRS 2016 - Usage, Web Service
  • Three-Phase Report Life Cycle in Reports (End-End)
  • Report Server Database and Report TempDB Configuration
  • Virtual Directories (VD) in Web Services - Settings, Options
  • Communication Ports and Data Encryption For Web Portal URL
  • Report Design and Work Flow Diagram - Lab Plan, Data Sources
  • Report Design with Report Designer & Report Builder Tools
  • Report Builder Versus Report Designer - Basic Differences
  • SSDT (VS): SQL Server Data Tools Installation, Verification
  • SSDT 2015 and SSDT 2013 Installation, Test Connection
  • SSRS 2016 Report Portals and Accessibility

CHAPTER 6: REPORT DESIGN - V

  • Gauge Reports: Purpose and End User Access Options
  • Gauge Report Types - Radial and Linear Gauges
  • Adding Data to Gauge Report - Default Indicators
  • Gauge Data Versus Chart Data - Pointer Options
  • Scale Properties: Maximum, Minimum Dynamic Ranges
  • Browser Compatibility and Offline Report Access
  • Gauge Properties, Gauge Panel Properties and Filters
  • Master Reports and Detailed Reports - Sub Reports
  • Scale - Properties, Values and Label Options
  • Pointers - Properties, Scale Limits, Format Options
  • Ranges & Labels, Report Items, Properties, Needle Options
  • Adding Multiple Gauges - Dashboard Design, Dynamic Size
  • Parameterized Gauge Reports - Dataset Level and Filters
  • Indicator Reports : Value and State Expressions
  • Indicator Reports and Gauge Panel Options with Filters
  • 3D PieCharts and Aggregations with Excel Reports
  • ODBC Data Source Connection Reuse & Worksheets
  • Dynamic Report Parameters and Filter Expressions

CHAPTER 2: REPORT DESIGN - I

  • Working with Visual Studio - SQL Server Data Tools
  • Report Templates and Basic Usage. Project, Solution
  • Designing Basic Reports - Understanding Entities
  • Working with Report Project Wizard - Usage, Reports
  • Defining Data Source Connections, Source Databases
  • Query Designer Options, Query Builder & Import Options
  • Table Reports and Matrix Reports with Report Wizard
  • Layout and Format Options - Drilldown Reports, Blocks
  • Stepped Reports and Multi Field Drilldown Options
  • Report Project Template - Designing Dataset, Reports
  • Report Toolbox and ReportData Options, Textbox Usage
  • Table Headers, Formatting Options, MATH Expressions
  • Alternate Row Colors, Using Report Globals, Expressions
  • Report Formatting Styles, Expressions and Reusability
  • Reporting Functions: IIF, Format, Ceiling, Round, Concat
  • Alternate Row Colors and Dynamic Formatting Options
  • Textbox Properties - Date & Time Formats, Numbers, Styles
  • Report Timeout Options and Tool Box Options, Report Data
  • Initial Catalog For Report Sources, Static/Dynamic Properties
  • Query Timeouts and Connection Properties - Scaleout

CHAPTER 7: REPORT DESIGN - VI

  • Report Builder Tool - 2016, 2014, 2008 R2 Installation
  • Installation Verification Options, msi Configuration
  • DataSource and DataSet Creation with Report Builder
  • Local Report Specific Entities and RDL File Creations
  • Entity Browsing Options and Query Design Options
  • Dataset Design with Parameters and Filters. Usage
  • Query Designer with Report Builder, Table Selection
  • Column Aggregates and Auto Group BY. Query Edits
  • Adhoc Reports with Tabilx Wizard - Report Layouts
  • Report Design - Sub Totals, Drill-down Column Groups
  • Chart Report @ Report Builder - Line Reports
  • Dataset Design with Parameters and Filters. Usage
  • Line Reports and XValue using Report Builder Tool
  • Trend Analysis, Continuous Data Reports - OLTP / DWH
  • Map Reports - Map Layers, Map Report Items
  • Map Gallery, ESRI Share Files, SQL Server Spatial data
  • Geo Spatial Data for Business Analysis Dashboards
  • Working with Polygon, Tile, Line and Point Map Layers
  • Map Visualization Options and Bubble Map Reports Usage
  • Data Fields, Display Labels, Visualization Indicators

CHAPTER 3: REPORT DESIGN - II

  • Grouping Operations: Row Groups, Column Groups
  • Table Report - Row Groups, Parent - Child Groups
  • Adding Groups to Existing Rows and New Rows
  • Group Headers and Group Footers - Usage, Sub Totals
  • Group Field Visibility and Toggle Options @ Parent
  • Row Group Properties, Header/Footer Properties
  • Column Groups for Table Reports, Advanced Options
  • Repeat-On-New-Page Options and Report Properties
  • Column Groups for Matrix Reports, Data Grouping
  • Drill-down Reports using Row Groups and Visibility
  • Drill-down Reports using Column Groups, Visibility
  • Table Reports Vs Matrix Reports - Technical Differences
  • Adding Images to Reports. Tooltip and Size Options
  • Report Headers and Report Footers - Globals, Expressions
  • Merging Report Fields, Sub Totals and Grand Totals
  • Group Edits, Removing Group Totals, Adding Group Headers
  • Column Groups - Advance Mode - Fixed Attributes, Fields
  • Repeating Header on Every Page & RepeatPage Options
  • Working with Report Globals for Metadata, Report Properties
  • Report Properties and Report Page Options with Scripts

CHAPTER 8: SSRS DEPLOYMENT, SUBSCRIPTIONS

  • Report Deployment Options - Report Builds, Config Files
  • Data Source, Data Set Folders, Report Server URL Targets
  • Report Deployment - UI & Command Line. RSKey Config
  • Report Server URL and Report Manager (Web Portal) URL
  • Report Home, Site Settings & Properties. Report Settings
  • Data Sources: Properties, Security Options, Access Options
  • DataSets: Properties, Security Options, Dependent Items
  • Reports: Properties, Security Options, Edits, Downloads
  • Security Roles: Content Manager, Browser, Report Builder
  • MyReports, Report Publisher Role. Report User/Groups
  • Report Linking and Default/Hidden Parameter Options
  • Report Tuning: Caching Options, Cache Refresh - Cautions
  • Report Tuning: Snapshot Options and Snapshot Schedules
  • Report Tuning: Off-the-Shelf Reports and Linked Reports
  • Local and Global Schedules, History Management, Jobs
  • Report Builder Connections and Reusability Options
  • Report Parts and RS Storage Options. Paginated Reports
  • Report Delivery & Schedules, File Share Subscriptions
  • Accessing and Controlling Reports, Email Subscriptions
  • Encryption Keys & RS Config Files, RS Execution Accounts

CHAPTER 4: REPORT DESIGN - III

  • Report Parameters - Purpose, Benefits and Usage
  • Creating Parameters using Dataset Query Conditions
  • Creating Parameters using Report Properties, Report Data
  • Single Value Parameters and Multi Value Parameters
  • Dynamic Parameter Values, Dependency Options, Queries
  • Defining Datasets with Parameters, Dynamic Conditions
  • Dataset Links to Parameters, Value Options from List, Query
  • Multi-Value Parameter Options: Data Types, Null, Empty Values
  • Reports using Multiple Data Sets. Performance Issues
  • Advanced Options : Auto Refresh, Manual Refresh Options
  • Dataset Filters, Toolbox Filters - Purpose and Usage
  • Filters versus Parameters - Differences with Performance
  • Using Filter Condition at Dataset Level, Toolbox Level
  • Data Type Conversions with Filters, Expressions & Computations
  • Deciding Parameters and Filters - When to use which, why?
  • SSRS Expressions and Global Fields For Report Parameters
  • JOIN, FIELDS, LABEL and Formatting Options with Parameters
  • Linking Report Parameters to Dataset Parameters and Filters

CHAPTER 9: CUBE REPORTS, INTEGRATION

  • Scale-Out Deployments and Remote Report Databases
  • Remote Report Database Connections, Recovery Options
  • Scale-Out Joins and Waits. Report Configuration Keys
  • Multi-Report Server Configurations, Execution Accounts
  • Report Designer Versus Report Builder - Advantages
  • Cube Reports with SSRS - MDX Queries. Advantages
  • Cube Reports with MDX Parameters & Filters. Performance
  • Cube Reports with MDX Expressions, YTD, QTD
  • Reports with SSAS KPIs and Cube Aggregations - MOLAP
  • Cube Reports with Tabular Data Sources. Hierarchy Levels
  • Sub Reports, Dashboards, Actions with Report Builder
  • Drill-Up and Drill-Down Reports, Drill Through Reports
  • Report Actions @ SSAS 2016 OLAP Databases
  • Power BI Reports with SSRS - Desktop / Mobile Editions
  • Power BI PBX Reports with RDL Sources, Vice Versa
  • Power BI Reports with SSRS and SSAS Connections
  • Power View and Power Pivot Extensions, Usage Examples
  • New SSRS Tuning Features in 2016, Report Migrations

CHAPTER 5: REPORT DESIGN - IV

  • Chart Reports - Design Options, Properties and Usage
  • Report Categories with Series Groups - Differences, Usage
  • Data Visualization Types: Trend & Discrete Chart Reports
  • Clustered / NonClustered Legend Attributes. Position Options
  • Series Labels : Properties, Number Formatting Options, Visibility
  • Series Actions : Series Properties, Multi - Valued Parameters
  • Report Actions : URL / Reports, Setting for Report Filters
  • Axis Values - Possible Issues with Multiple Axis Items, Solutions
  • Dashboard Creations with Filters (Static, Parameterized)
  • Chart Series Properties and Options, Report Markers, Grids
  • Chart Areas with Multiple Toolbox Items, Properties & Limitations
  • 3-Dimensional Report Options - Properties, Visibility Options
  • Range & Pie Charts, Line Reports, Data Bars, Area Charts
  • Common Report Errors with DataSet / Report Filters, Solutions
  • Using Shared DataSources and Shared DataSets - Advantages
  • Data Bar Reports and Sparkline Reports - Stacked Reports

CHAPTER 10: REAL-TIME PROJECT @ SSRS

  • Design Requirements and Specifications
  • Design Reports with Divergent Colors
  • Table Bars and Tree Map Reports
  • Working with Excel and MS Access Data
  • Multiseries Charts, Dynamic Chart Size
  • Axis Display Control, Report Filter Joins
  • Report Actions with Parameter Values
  • Exploring Toolbox Filters
  • Type Conversions and SSRS Expressions
  • End User Report Delivery and Subscriptions
  • Report Navigations, Mobile Reports
  • RDL File Security and XML Edit Option
  • KPI Reports, Mobile Report Integration
  • Report Deployment Strategies & Security
  • Report Logging Options. System Databases
  • End - End Report Implementation
 
Participants may join for complete MSBI (SSIS, SSAS, SSRS) Course or for individual modules. Practical, Real-time.
 
New batch for MSBI Training (LIVE, Instructor Led) start every 15 days. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Wise Tasks and 24x7 LIVE Server.
 

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T

 
 
 
 
Register Today Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses