MSBI


Introduction to Data warehousing
 Data warehousing Overview
 Architecture of Data warehousing
 Data warehousing Terminologies
 Dimensional Modeling

Introduction to SQL Server BIDS / SQL Server Data Tools
 BIDS / Data tools Overview
 Launching BIDS
 Project templates

Introduction to SQL Server Integration Services
 Product History
 SSIS Package Architecture Overview
 Packages
Introduction to Control Flow
 Control Flow Overview
 Precedence Constraints
 Control Flow Tasks
 Advanced Control Flow

Introduction to Data Flow
 Data Flow Overview
 Data Sources
 Data Destinations
 Data Transformations
 Data Viewers
Variables and Configurations
 Variables Overview
 Variable scope
 SSIS system variables
 Using variables in control flow
 Using variables in data flow
 Using variables to pass information between packages
 Property expressions
 Configuration Overview
 Configuration options
Debugging, Error Handling and
Logging
 SSIS debugging overview
 Breakpoints in SSIS
 SSIS debugging windows
 Control Flow: The OnError event handler
 Data Flow: Error data flow
 Configuring Package Logging
 Built-in log providers

SSIS Package Deployment
 Configurations and deployment
 The deployment utility
 Deployment options
 Deployment security
 Executing packages – DTExec and DTExecUI

Introduction to SQL Server Analysis Services

OLAP Modeling
 Modeling source schemas-stars and snowflakes
 Understanding dimensional modeling-Dimensions (Type 1, 2, or 3) or rapidly changing
 Understanding fact (measures) and cube modeling
Using SSAS in BIDS
 Understanding the development environment
 Creating Data Sources and Data Source Views
 Creating cubes – using the UDM and the Cube Build Wizard
 Refining Dimensions and Measures in BIDS
 KPIs , Perspectives, Translations – cube metadata and currency localization
 Actions – regular, drill-through and Reporting
Advanced SSAS
 Using multiple fact tables
 Modeling intermediate fact tables
 Modeling M:M dimensions, Fact(degenerate) dimensions, Role-playing dimensions
 Modeling changing dimensions –Dimension Intelligence Wizard
 Using the Add Business Intelligence Wizards – write-back, semi-additive measures,
time intelligence, account intelligence

Cube Storage and Aggregation
 Storage Modes MOLAP ROLAP, HOLAP
 Customizing Aggregation Design -Processing Design
 Partitions – relational and Analysis Services partitions
 Welcome to the Real Time – ProactiveCaching

Beginning MDX (All Basics)
 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

SSAS Administration
 Best practices – health monitoring
 XMLA scripting (SQL Mgmt Studio)
 Other Documentation methods
 Security – roles and permissions
 Disaster Recovery – backup / restore
 Clustering – high availability

Introducing SQL Server Reporting Services
 SSRS Features
 Reporting Services Architecture
 Reporting Services Terminology
 Reporting Services Editions
 Taking Reporting Services for a Spin
Creating Reports
 Deconstructing Reporting Services
 Shared Data Sources
 Creating Reports from Scratch
Calculations and Formatting
 Creating Expressions
 Using the Global Collections
 Formatting Items
 Conditional Formatting
Grouping and Sorting
 Creating Groups
 Calculating Totals and Percentages
 Interactive Sorting
 Creating Drill-Down Reports
Report Parameters
 Creating Report Parameters
 Creating Drop-Down Parameters
 Multi-Valued Parameters
 Debugging Parameter Issues
Creating Matrix Reports and Charts
 Creating a Basic Matrix Report
 Matrix Subtotals
 Creating a Basic Chart
 Exploring the Charting Possibilities
Managing Reporting Services
 Deploying Reports and Data Sources
 Exporting Reports and Printing
 Using the Web-Based Report Manager
 Using SQL Server Management
 Studio-based Reporting Services Manager
Reporting Services Security
 Two Parts to Reporting Services Security
 Securing Access to Reports
 Data Source Security
Programming Reporting Services
 The Many Reporting Services APIs
 Integrating Reporting Services into Applications using URL Access
 Using the Report Viewer Controls

Ad-Hoc Reporting with Report Builder
 The Report Builder Architecture
 Creating Report Model Projects
 Running Report Builder

Nagendra KG
Phone no:9600089782
Email id : nage8kg@gmail

 

Keywords: Online Msbi training in Hyderabad,Online Msbi training in Chennai, classroom training  Msbi in Hyderabad,classroom training  Msbi in Chennai.