7680001943 rrtechnosoft64@gmail.com @KPHB , Hyderabad.

MSBI Training


This real-time, practical MSBI Training Course includes Basic to Advanced Level of real-time implementations for Microsoft Business Intelligence (MSBI) Stack of Tools required for MSBI Developers, MSBI Admins and BI Consultants. This MSBI Classroom Training includes basic to advanced Business Intelligence, Data Warehouse (DWH) and Data Analytics (OLAP) concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). This MSBI Training course also includes MDX and DAX for Data Modelling and Big Data Analysis For Enterprise / Adhoc Reporting. This course also includes Real-time Integrations with Power BI and Azure Data Sources. Complete practical and realtime MSBI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.

Microsoft Business Intelligence (MSBI) is a powerful suite of Data Integration, Data Reporting and Information Analysis/Mining components enriched with technology 'touch', beautiful UI and easier eye-catchy way of design and development. MSBI applications can be used efficiently by any business or enterprise for data discovery, data collaboration and usage management capabilities with the backdrop of SQL Server.

This impeccable MSBI (SQL BI) course is carefully designed for aspiring BI Developers, Consultants and Architects. This MSBI Training includes basic to advanced Business Intelligence, Data Warehouse (DWH) and Data Analytics (OLAP) concepts on SQL Server Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). This MSBI Training course also includes Power Query & DAX for Data Modelling and MDX & DMX for Big Data Analysis and Reports along with Power BI Intergration and Azure Integration. Complete practical and realtime MSBI Training course with 24x7 LIVE server, Resume Guidance, ONE Real-time Project with Interview & Placement Assistance.

MSBI COURSE CONTENT


Duration : 45 Days


  • Product history
  • SSIS package architecture overview
  • Development &management tools
  • Source control for SSIS packages
  • The import &Export Wizard
  • Importing &Exporting Data
  • Working With Packages
  • Data Base Management Plans
  • Creating Database Maintenance Plans using SSMS
  • Launching Bids
  • Project Templates
  • The Package Designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The variables Window
  • SSIS Menu
  • Control Flow Overview
  • Precedence Constraints
  • The execute SQL Task
  • The Bulk Insert Task
  • The file system Task
  • The FTP Task
  • The send mail Task & other Control Flow Items
  • Case Study on Usage of Control Flow Items
  • Containers-grouping &looping
  • The analysis Service Task
  • The Execute Process Task
  • Case study on Usage of Execute Package Tasks
  • For Zipping & Unzipping files
  • Case study on Creation of Master & Child Packages using Execute package Task.
  • Data Flow Overview
  • Data sources
  • Data Destinations
  • Data transformations Overview
  • Commonly Used Transformations
  • Case Study for Using of Transformations & other Dataflow components
  • Variable overview
  • Variable scope
  • SSIS system variables
  • Using Variablesin control Flow
  • Using Variables in/data flow
  • Using Variables to Pass information between Packages
  • Examples of Usage of Variables&Usage of Expressions.
  • SSIS debugging overview
  • Break points inSSIS
  • SSIS Debugging window
  • ControlFlow: theOn Error event Handler
  • Data flow::Error Data Flow
  • Configuring package Logging
  • Revisiting data sources & Destinations
  • The Lookup Transformation
  • The Multicast Transformation
  • The merge &merge join Transformation
  • The Slowly changing Dimension Transformation.
  • Introduction to SSIS scripting
  • The SSIS object editor
  • Script in control flow: script Task
  • Script in data flow: the Script Component
  • Introduction to SSIS Component development
  • Configuration &deployment
  • The Deployment utility
  • Deployment options
  • Deploying &Managing SSIS Packages
  • Deployment Security
  • Executing Packages-DTExec & DTExecUI.

SQL Server Reporting Services

  • Tour of features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions
  • Taking Reporting Services for a Spin
  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch
  • Creating Expressions
  • Using the Global collections
  • Formatting Items
  • Conditional Formatting
  • Creating Groups
  • Calculating Totals &Percentages
  • Interactive Sorting
  • Creating Drill-Down Reports
  • Creating Report Parameters
  • Creating Drop-down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues
  • Creating a basic Matrix Report
  • Matrix subtotals
  • Creating a Basic Charts
  • Exploring the Charting Possibilities.
  • Expolded and Collected Pie Charts
  • Deploying Reports & Data Sources
  • Exporting Reports & printing
  • Using the web-Based Report Manager
  • Using SQL Server Management
  • Studio-based Reporting services Manager
  • Two Parts to Reporting Services
  • Security
  • Securing Access to Reports
  • Data sources Security
  • The Many Reporting Services APIS
  • Integrating Reporting Services into
  • Applications Using URL Access
  • Using the Report Viewer Controls
  • Using the Reporting services Web Service
  • Working with Custom Assemblies
  • Caching & snapshots
  • Creating standard subscriptions
  • Creating data-driven Subscriptions
  • Managing subscriptions
  • The Report Builder Architecture
  • Creating Report model Projects
  • Running Report builder

SQL Server Analysis Services

  • Modeling source schemas-stars & Snowflakes
  • Understanding Dimensional modeling-Dimensions or rapidly changing
  • Understanding fact & Cube Modeling
  • Understanding the development environment
  • Creating data sources & data source views
  • Creating cubes-using the UDM & the Cube Build Wizard
  • Refining Dimensions & Measures in BIDS
  • KPIs
  • Perspectives
  • Translations-cube metadata & currency localization
  • Actions-regular,drill-through & Reporting
  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M Dimensions, Fact Dimensions,Role-Playing Dimensions, write back dimensions
  • Modeling changing dimensions-dimension Intelligence wizard
  • Using the Add Business Intelligence Wizards-
  • Write-back,semi-additive measures,time intelligence,account intelligence
  • Storage topic-Basic Aggregations
  • Advanced Storage Design-MOLAP,ROLAP,HOLAP
  • Partitions-relational &Analysis Services Partitions
  • Customizing Aggregations design-processing design
  • Rapidly changing Dimensions/ROLAP dimensions
  • Welcome to the real time-proactive caching
  • Cube processing options
  • Audits& UBO
  • Basic syntax
  • Using the MDX query editor in SQL server Management Studio
  • Most-used functions& common tasks
  • New MDX functions
  • Adding calculated members
  • Adding Scripts
  • Adding named sets
  • Best practices-health monitoring
  • XMLA scripting
  • Other documentation methods
  • Security-roles and placement
  • Disaster Recovery –backup/restore.
  • Excel 2003 pivot Tables
  • SQL RS & Report Builder

SQL Server (T-SQL) Course contents

  • SQL Server 2012 & 2014 Installation
  • Services, Service Accounts and Usage
  • Authentication Modes, Security, Logins
  • Instance Configuration Options & Rules
  • SQL Server Components and Features
  • Configuration Tools, Services and Use
  • Naming Conventions & Collation Settings
  • Using Management Studio (SSMS) Tool
  • Post Installation Procedures and WMI
  • Table creation using T-SQL Scripts
  • SQL Server Tables and Filegroup Routing
  • DML Operations: INSERT, UPDATE, DELETE
  • Single Row and Multi-Row Insert Statements
  • Table Aliases, Column Aliases & Usage
  • Table creation with Schemas & Filegroups
  • DELETE Versus TRUNCATE Statements
  • SELECT Queries, Variants and Sub Queries
  • Schemas and Nested Queries with Aliases
  • Data Integrity and Normal Forms (BCNF)
  • Tables with Keys & Constraints (BCNF)
  • NULL and IDENTITY Properties – Usage
  • UNIQUE KEY Constraint and NOT NULL
  • PRIMARY KEY Constraint & Importance
  • FOREIGN KEY and REFERENCE Attributes
  • CHECK and DEFAULT Constraints, Usage
  • Duplicating Identity Property Values
  • Disabling Constraints & Composite Keys
  • SELECT Statements -IIF, SWITCH, CHOOSE
  • ORDER BY, GROUP BY, GROUPING, HAVING
  • Sub Queries, Nested Queries and EXISTS
  • DELETE from SELECT, UPDATE from SELECT
  • INSERT INTO ... SELECT & Data Copy
  • Inner Joins -Purpose and Performance
  • Outer Joins -Types, Advantages and Usage
  • Cross Joins -Advantages and Limitations
  • Self Joins, Merge Joins and Sub Queries
  • Benefits of Views -End User Access
  • Defining Views on Tables and Views
  • CHECK OPTION Usage & View level Cascades
  • SCHEMABINDING and ENCRYPTION Options
  • ALTER TABLE Issues and Solutions with Views
  • System Views & Management Views : Audits
  • Orphan Objects, Table Synchronizations
  • Joins and Nested Sub Queries in Views
  • Need for Indexes, Index Types & Usage
  • Indexing Table & View Columns
  • Index SCAN, SEEK and LOOP Operations
  • Composite Indexed Columns & Keys
  • Materializing Views (Indexed Views)
  • RIDs, KEYs and Column Constraints
  • PRIMARY KEYS and Non Clustered Indexes
  • INCLUDED Column Indexes & Tuning
  • Tuning Joined Data Sets: Tables/Views
  • Need for Stored Procedures & Syntax
  • Use of Variables and Query Parameters
  • Stored Procedures with Loops & IF.ELSE
  • SCHEMABINDING and ENCRYPTION Options
  • INPUT, OUTPUT & RESULTSET Parameters
  • System Stored Procedures and Nesting
  • Dynamic SQL Queries and Parameters
  • Stored Procedures , Data Validation Options
  • OUTPUT Parameters and Result set Options
  • Functions -Syntax, Usage and Importance
  • Scalar Valued Functions and Examples
  • Table Valued Functions and Examples
  • SCHEMABINDING and ENCRYPTION Options
  • System Functions and Joins -CROSSAPPLY
  • Date, Time and Conversion Functions
  • String Functions and Meta-data Functions
  • ROWCOUNT, GROUPING, ROLLUP Functions
  • Joining Functions and Tables / Views
  • Temp Tables and Procedures with Cursors
  • Common Table Expressions (CTE) and Queries
  • Stored Procedures with CTE : Tuning Options