MSBI - Micorsoft Training

Training/Coaching/Tuition by Big Classes Hyderabad View Contact

Request Info

SQL Server 2008 Analysis Services

What Is Microsoft BI?

• Core concept – BI is the cube or UDM

• Example cube as seen using Excel pivot table

• MS BI is comprehensive – more than Analysis Services on SQL Server

• Demonstration of SQL Reporting Services with cube as data source

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

• Other types of modeling—data mining etc…

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

Intermediate SSAS

• 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, write back

• dimensions

• Modeling changing dimensions – Dimension Intelligence w/ Wizard

• Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence,

• account intelligence

Cube Storage and Aggregation

• Storage topics – basic aggregations, MOLAP

• Advanced Storage Design – MOLAP, ROLAP, HOLAP

• Partitions – relational and Analysis Services partitions

• Customizing Aggregation Design – Processing Design

• Rapidly changing dimensions / ROLAP dimensions

• Welcome to the Real Time – Proactive Caching

• Cube processing options

Beginning MDX

• Basic syntax

• Using the MDX query editor in SQL Server Management Studio

• Most-used Functions & Common tasks

• New MDX functions

Intermediate MDX

• Adding calculated members

• Adding scripts

• Adding named sets

• .NET Assemblies

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

Introduction to Data Mining

• What and why?

• Examples of using each of the 9 algorithms (MS Clustering, MS Decision Trees, Naïve Bayes, MS

• Sequence Clustering, MS Time Series, MS Association Rules, MS Neural Network)

• Data Mining dimensions

• Data Mining clients

• Processing mining models

Introduction to Reporting Clients

• Excel 2003 Pivot Tables

• SQL RS & Report Builder

• SPS RS web parts & .NET 2.0 report viewer controls

• Business Scorecards 2005 & ProClarity

Future Directions – Integration with Office 12

• SharePoint 12 and AS

• Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter

• Excel Services 12 and AS (Web Services)

SQL Server 2005 Integration Services

Introduction to SQL Server Integration Services

• Product History

• SSIS Package Architecture Overview

• Development and Management Tools

• Deploying and Managing SSIS Packages

• Source Control for SSIS Packages

SSIS for DBAs: Using SQL Server Management Studio

• The Import and Export Wizard

• Importing and Exporting Data

• Working with Packages

• Database Maintenance Plans

• Creating Database Maintenance Plans using SSMS

• Scheduling and Executing Plans

• Examining Database Maintenance Plan Packages

• Changes in SQL Server 2005 Service Pack 2

Business Intelligence Development Studio

• Launching BIDS

• Project templates

• The package designer

• The Toolbox

• Solution Explorer

• The Properties window

• The Variables window

• The SSIS menu

Introduction to Control Flow

• Control Flow Overview

• Precedence Constraints

• The Execute SQL Task

• The Bulk Insert Task

• The File System Task

• The FTP Task

• The Send Mail Task

Advanced Control Flow

• Containers – grouping and looping

• The Web Service Task

• The WMI tasks

• The Analysis Services tasks

• The Execute Process Task

• The Execute Package Task

Introduction to Data Flow

• Data Flow Overview

• Data Sources

• Data Destinations

• Data Transformations

• The Copy Column Transformation

• The Derived Column Transformation

• The Data Conversion Transformation

• The Conditional Split Transformation

• The Aggregate Transformation

• The Sort Transformation

• 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

• Configuration discipline

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

Advanced Data Flow

• Revisiting data sources and destinations

• The Lookup Transformation

• Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations

• The Multicast Transformation

• The Merge and Merge Join Transformations

• The Data Mining Query Transformation

• The Data Mining Model Training Destination

• The Slowly Changing Dimension Transformation

Extending SSIS through Custom Code

• Introduction to SSIS scripting

• The SSIS script editor

• The SSIS object model

• Script in Control flow: The Script Task

• Script in Data flow: The Script Component

• Introduction to SSIS component development

SSIS Package Deployment

• Configurations and deployment

• The deployment utility

• Deployment options

• Deployment security

• Executing packages – DTExec and DTExecUI

SSIS Package Management

• The SSIS Service

• Managing packages with DTUtil

• Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

SQL Server 2005 Reporting Services

Introduction to SQL Server Reporting Services

• Tour of 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

Advanced Reporting Services Programming

• Using the Reporting Services Web Service

• Working with Custom Assemblies

Snapshots and Subscriptions

• Caching and Snapshots

• Creating Standard Subscriptions

• Creating Data-Driven Subscriptions

• Managing Subscriptions

Ad-Hoc Reporting with Report Builder

• The Report Builder Architecture

• Creating Report Model Projects

• Running Report Builder

Course Overview

MS BI Online Training

During this Microsoft Business Intelligence [MSBI] online training, you’ll dive into planning ETL solution architecture exploitation Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL Server Integration  Services[SSIS].

Additionally, we are going to extensively cover a way to design Analysis solution design exploitation Microsoft SQL Server Analysis Services [SSAS] and Implement and Maintain Microsoft SQL Server Analysis Services [SSAS].

You’ll expand your data on MDX Queries and learn the way to make advanced reports using expressions, global collections, and conditional data formatting using SQL Server Reporting Services [SSRS] .

Microsoft Business Intelligence [MSBI] training will deep dive you into report server configurations, handling complex reports, Design report  models along with reports snapshots and report deliver through subscriptions.

Microsoft Business Intelligence [MSBI] course consists of all real time tasks that arise in day to day activities.

Each topic is roofed with distinctive case studies. Microsoft Business Intelligence [MSBI] course is split into three modules and totals quite 45 hours of instructor-led online training.

About Trainer

Trainer Information

• Working with Microsoft as SQL Server product consultant

• Having total of 7 years Real time experience

• 4.7 years of online training experience including corporate training

Big Classes

BigClasses.com is been into the IT market since a decade. We have started our career 10 years back as a class room training provider. After 5 years in the classroom training, as a part of expansion in 2008, we have moved to online training. We are offering the services globally with local and international standards with real time exposure. Now, after 10 years of expertise in software training, we are one of the best online training service portals of the industry. This shows our standards and commitment towards the software learners.

Since inception of BigClasses.com, it has evolved into a cherished and most reliable retail and Corporate Training Company.

BigClasses.com Training is one training institute where online interactive training is a common experience and many students in the past have learnt, mastered, got certified and landed excellent jobs on their way to their careers. Our training takes place with well-prepared training materials. We provide documentation and the best interview preparation materials for learners.

BigClasses.com has access to a faculty of esteemed and highly qualified consultants to deliver the courses. These instructors are not in any way academics, but rather specialists actively involved in consulting to business in their particular fields. This gives the learners a fuller insight of the needs and as well as knowledge about actual and future trends in the market, and makes the courses extremely practical and relevant.

We don’t just give training and leave you on your own but support you even after you get into the job. We are providing web based online training in major IT Courses, where you can sit at home in front of the system and learn without travel or relocate during the training program. You can practice exercises and real-time projects which are given by our esteemed instructors.

Training is conducted by experienced and certified Instructors. Prestigious clients are included in our Clientele list and 100% Successful placement for excellent candidates.

BigClasses.com Institute is an online provider of IT technologies training products for individual and for corporate groups our training manuals and programs are designed to be used in a self-study or home based training environment. This allows any student the ability to learn at their own pace and on their own schedule.

Self-paced training is a very effective method of training and can be used with any schedule and with no previous experience. Effective results can be achieved in as little as 15 minute blocks of time not hours or days as is common with seminars and schedule courses.

All our materials are available with instant download which means you can get started on your training within minutes. The result is that you can show noticeable improvement in less than a day with our training Bigclasses.com.

Our materials are designed to be used in a self-study or home based environment so anyone can fit this training into any schedule no matter how busy it may be. Self-study also allows an individual the ability to train at their own pace and not have to worry about missing any concepts or being forced to proceed too slow like what might happen in a class or schedule group class.

We are dedicated to providing the very best in Bigclasses.com training while providing quality training at affordable prices. Our goal is to product training that is within the budget of anyone who desires to improve their IT skills.

Corporate Group Training: For companies or large groups who wish to provide quality Customer Service training for their employees, Bigclasses.com online training Institute is proud to announce their Corporate! Under our Corporate Training Program, we offer our Training package at group rates. This course encompassing 6 training modules covering both basic fundamentals and advanced techniques.

Bigclasses.com Training Certificate Program: A complete course in Bigclasses.com Training from Basic fundamentals through advanced skills, this complete course offers a single source for all your requirements and needs. Each module is designed as either a stand lone module or as part of a complete series so the student can target their most pressing needs first for maximum benefit. Upon successful completion of the program and the passing of a short test, a full color Certificate of Completion will be issued to the student.