Course Batch Starts, Timing, Price & Enroll

Program Duration Batch Starts Time Price # Enroll Book free demo
Weekdays
75 Hrs Weekdays Morning-Batch USD 800
INR 34999
Enroll Now Book free demo class

# Cloud lab charges will be extra. Our technical consultant will share actual lab charges with you.

CURRICULUM

MSBI

  • 1.1 SSIS Architecture and DW Concepts
  • - Need of SSIS for ETL Operations
  • - Data Warehouse Design and SSIS
  • - DW Components and SSIS Tools
  • - SSIS Configuration and Catalog DB
  • - Control Flow Tasks Architecture
  • - Data Flow Tasks Architecture
  • - Data Pipelines and Buffer Usage
  • - SSIS Data Types and Conversions
  • - SSIS Local & Global Variables
  • - Dynamic Precedence Constraints
  • - Dynamic Connection Managers
  • - Data Flow Transformations usage
  • - Handling Enumerations in SSIS
  • - Expressions and Iterations
  • - SCRIPT Task usage in SSIS
  • 1.2 SSIS Expressions & Debugging
  • - Conditional Precedence Expressions
  • - SSIS Parameters Usage and Variable
  • - Control Flow Breakpoints
  • - Data Flow Data Viewers and Audits
  • 1.3 Data Flow Transformations
  • - Row and Column Transformations
  • - Combining and splitting datasets
  • - Performing database operations
  • - MERGE Vs UNION ALL Transformations
  • - Lookup, Fuzzy Grouping, OLE-DB Command
  • - SORT Vs AGGREGATE Transformations
  • - Custom Code Handling in DW
  • - Event Notifications and Emails
  • - Data Sampling and Data Delta
  • - Type I and Type II SCDs
  • - Performing PIVOT operations
  • - SSIS Transactions & Isolation Levels
  • - CHECKSUM Transformation in DW
  • - Iterating XML nodes and Data
  • - CACHE Transformation & Performance
  • - Applying Configuration Options
  • - Parent – Child Parameters & Options
  • 1.4 Event Logging and Event Handling
  • - Configurations and benefits
  • - System Events and Audits
  • - Package Event Handling
  • - Limitations of Event Handling
  • - Event Bubbling Escalations
  • - Benefits of SSIS Logging
  • - Environment Variables Usage
  • - Windows Event Logs and SSIS
  • - SQL Server Logging Limitations
  • - Choosing correct log providers
  • - Package Execution Audits
  • 1.5 Deployment Procedures
  • - Deployment Versioning & Options
  • - SSIS Deployment Phases & Manifest Files
  • - Project Packaging and ISPAC Files
  • - Validation & Verification Techniques
  • - SSIS Checkpoints and Usage
  • - Data Analytics and Debugging
  • - Data Profiler & ADO Connections
  • 1.6 Deployment Options & Utilities
  • - Package Execution Options
  • - File System Security Limitations
  • - SSIS Deployment & DB Engine
  • - SSIS Catalog Project Files
  • - Package Migration Utilities
  • - Command-Line Deployments
  • - TDS Sizing and Tuning Options
  • 1.7 SSIS Package Security and Upgrades
  • - Encrypting SSIS Catalogs
  • - Package Store and SSISDB
  • - Security Audits and Reports
  • - Container and Package Logging
  • - DTS packages to SSIS migration
  • - Upgrading 2008 Packages to 2012
  • - MSDB and SSIS Catalog Files
  • - Comparing SSIS 2008 R2 & 2012
  • - ISPAC Files & Package Migrations
  • 2.1 Introduction to SSAS and DW Storage
  • - Need of OLAP Databases and DW Store
  • - Tabular & Multidimensional Modes
  • - Need for Cubes and Measures
  • - Identifying Facts and Dimensions
  • - Identifying Measures and Aggregates
  • - Identifying Attributes and Hierarchies
  • 2.2 SSAS Design Entities & Cube Usage
  • - Data Source and Data Source Views
  • - Computed and Named Queries
  • - Building Entity Relationships
  • - Deciding Data Warehouse Schema
  • - Creating Dimensions and Builds
  • - Attributes and Member Names
  • - Choosing Dimension Templates
  • - Applying Time Based Dimensions
  • - Need for Hierarchies and Limitations
  • - Attribute Relations and Uses
  • - Building Levels and Hierarchies
  • - Need for Composite Attribute Keys
  • 2.3 KPI Calculations and Partitioned Aggregations
  • - Identifying Cube Entries for FASMI Rules
  • - Measures and Additives (Full and Semi)
  • - Defining Measure Groups and Measures
  • - Cube Customizations and Options
  • - BI Enhancements and Granularity
  • - Building Fact Less Cube Dimensions
  • - Calculations and Conditional Colors
  • - MDX Scripting for Calculations
  • - Defining KPIs and Goals using MDX
  • - Perspectives using MDX Expressions
  • - SSAS Actions with MDX and XMLA
  • - Need for Cube Partitions and Query Binding
  • - Local and Remote Server Partitions
  • - Need for Storage Models – MOLAP and ROLAP
  • - Generation of Aggregations on Partitions
  • - Storage Modes and Proactive Caching
  • - Hierarchies and Relations in Tabular Mode
  • - TIME Dimensions in Tabular Mode
  • 2.4 MDX Functions, FILTERS and JOINS
  • - MDX Language Syntax & Statements
  • - MDX Functions & JOINS
  • - Complex MDX Queries & FILTERS
  • - PARALLELPERIOD, TIME Functions
  • - Conditional FILTERED JOINS in MDX
  • - Cube and Dimension Write backs
  • - MDX Transactions & Limitations
  • 2.5 Data Mining and Forecast
  • - Need for Data Mining Structures
  • - Data Mining Algorithms and Rules
  • - DMX Queries and Forecast Reports
  • - Data Mining Scope and Ranking
  • - Prediction Functions and Analysis
  • 2.6 Deployment (Tabular & Multidimensional)
  • - Deployment Options and Tools
  • - Creating OLAP (SSAS) Databases
  • - Processing Options and stages
  • - SSAS Database and Cube Audits
  • - Managing SSAS Log Providers
  • - OLAP & Tabular Database Backups
  • - Restore Options and Partitions
  • - Scripting DB Backups and XMLA
  • - Scheduling Backups and Jobs
  • - DB Synchronizations and XMLA
  • - Managing Partitions & Aggregations
  • 2.7 OLAP Management (Tabular & Multidimensional)
  • - Need for Optimizations and Audits
  • - Designing Aggregations using UBO
  • - OLAP Restore Options and XMLA
  • - SSAS Security Roles and Scope
  • - Object Level Access and MDX
  • - Drill-Through Security and MDX
  • - Item Level Security and DAX Filters
  • - Dynamic Security Implementation
  • - Security Audits and Cube Access Logs
  • - Upgrading OLAP Databases (DW)
  • - OLAP DB Synchronization Script
  • 3.1 Reporting Services Architecture
  • - Introduction to Reporting Services
  • - Three-Phase Report Life Cycle
  • - Reporting Engine Architecture
  • - SSRS 2012 and Web Service URLs
  • - SSRS 2012 Configuration & Ports
  • 3.2 Report Design with Data Sets & Aggregates
  • - Report Designer Usage and Scope
  • - Report Builder Usage and Scope
  • - Report Manager and Options
  • - Report Delivery & Layout Planning
  • - Enterprise and Ad-hoc Reports
  • - Working with Multiple DataSets
  • - Configuring Dynamic DataSets
  • 3.3 Sub Reports – Parameters & Filters
  • - Designing Wizard based Reports
  • - Designing Custom Reports
  • - Using Tables and Matrix
  • - Chart Based Reports and Images
  • - Using SSRS Expressions & Global Fields
  • - Sub Reports and Report Options
  • - Report Testing and auto Refresh
  • - BUILD and DEPLOY Options
  • - Parameters and Dynamic Populations
  • - Report Filters in Data Sets
  • - Sub Reports and Nested Reports
  • - Gauge Reports, Indicator Reports
  • - Pie Charts and Data Bars
  • - Exporting Reporting Data
  • 3.4 Cube Reports and Report Models
  • - Designing Reports using OLAP DBs
  • - Identifying KPIs and Measures
  • - MDX Queries in Cube Reports
  • - Report Models and parameters
  • - Identifying Report Entities
  • - Identifying different Attributes
  • - Aggregations Based Expressions Calculations
  • - Remote Data Sources & Data Sets
  • - Linked Reports and Graphs
  • 3.5 Report Builder Usage & Schedules
  • - Using Report Builder Wizards
  • - Map Reports with UI and Site Settings
  • - Report Parts and Web Services
  • - Report Designer Vs Report Builder
  • - Report Server Configurations Tools
  • - Report Migrations and Precautions
  • 3.6 Delivering SSRS Reports
  • - Report Delivery Options & Schedules
  • - Accessing and controlling reports
  • - Leveraging RS Web services
  • - Choosing between Rendering Formats
  • 3.7 Managing Reports
  • - Report Manager Configurations
  • - Managing Data Sources Security
  • - Exporting and Importing Reports
  • - Creating Global Schedules – Site Level
  • - Snapshot Management & Schedules
  • - Regenerating Snapshots for Tuning Options
  • - ReportServerTempdb Usage
  • - Tuning Reports with Caching Options
  • 3.8 Scheduling and Subscriptions
  • - Creating Standard Subscriptions
  • - Data-Driven Subscriptions
  • - Subscription & Logging Options
  • 3.9 SSRS Report Security
  • - Report Data Source Security
  • - Report Server Security Levels
  • - Report Server DB Security
  • 3.10 SSRS Configurations
  • - Report (RDL) Configurations
  • - Email Based Report Subscriptions
  • - Managing Configurations Files
  • - Choosing correct Configuration Values
  • - RDL Reports Upgrades & Downloads
  • - Scale-out Deployments in SSRS
  • - Execution Accounts and SSRS Schedules

Exam & Certification


Select Trainer for Demo


Dharmesh Shah
Certification: SAP BO , Microsoft Certified Database Administrator (MCDBA) , MCSE , MCSD
From
Professional Experience
Training Experience

Qualification
Graduate Engineer in Computer Science

Skills
IBM Cognos, SAP BI, SAP BO, SAP Crystal Reports, Tableau, SAP BusinessObjects Lumira, SAP Predictive Maintenance and Service, Tableau 9.0, Tableau 9.1, Tableau 9.2, Tableau 9.3, Data Warehousing,

Profile
Around 19 years of data warehousing implementation experience. Trained more than 1500 individuals from around 85 companies, with consistent average rating of 4 plus (on 5 point scale) for participants from fresher and junior executive to senior developers, team lead, project manager and architect. Read More...
RATING & REVIEWS
Jagdeep Singh
Certification:
From
Professional Experience
Training Experience

Qualification
MBA

Skills
Business Intelligence, MCSA, MCSE, Microsoft SQL Server , Microsoft SSRS, SQL,

Profile
A Microsoft Certified Professional with 8 + years of work experience in the Training/Consulting,Design,Modeling, Development, Implementation and Support of SQL Server 2005/2008/2012. Specialties: SQL Server T-SQL Microsoft Sql Bussiness Intelligence SQL Server Reporting Services SQL Server Analysis Services SQL Server Integration Services MDX Power BI Power Query Power Map Power Pivot Power View Read More...
RATING & REVIEWS
Disclaimer

**

* Money Back Guarantee till demo and 1st class of the course.

* All trademarks and logos appearing on this website are the property of their respective owners.


Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US