Wenso Training objective is to offer quality job oriented training in the most popular IT skills.

Book Now

SSAS & SSIS Training Course Deliverables

Created with Snap MICROSOFT BUSINESS INTELLIGENCE CONCEPTUAL

  • Microsoft BI Introduction
  • Conceptual of cube & Unified Dimensional Modeling
  • cube using Excel pivot table
  • SQL Reporting forming cube as source of data
  • Introducing Star and Snowflake Schema
  • Explore Types of Dimensions

Created with Snap SQL SERVER ANALYSIS SERVICES – BEGINNER TO ADVANCE LEVEL

  • Microsoft BI Development Studio Introduction
  • Form Data Source and develop Data Source View
  • Explore Cube Build Wizard
  • Step by Step for creating Cube with Wizard
  • Recheck measures and dimensions in BI Development Studio
  • Add KPI to SSAS
  • Build Perspectives and Translations
  • Work with Multiple Fact Tables
  • Work on Modeling and Modeling Changing Dimensions

Created with Snap ADMINISTER SQL SERVER ANALYSIS SERVICES

  • Best practices of SSAS Administration
  • Concept of Health monitoring
  • XMLA scripting
  • Documentation Guide
  • Infuse Security with roles and permissions defined
  • Work on Disaster Recovery Techniques : backup, restore
  • ROLAP dimensions
  • Cube relational, Analysis Services partitions
  • Tailor-Made Aggregation Design
  • Proactive Caching in Practice

Created with Snap CUSTOM CODE FOR SSIS ENHANCEMENT, SSIS MANAGEMENT & DEPLOYMENT AS PACKAGE

  • SSIS Service
  • SSIS scripting Basics, Editor, Object model
  • Script Task in Control Flow
  • Script Component in Data Flow
  • SSIS component development Environment
  • Configure & deploy

Created with Snap DATA MINING CONCEPTUAL

  • Purpose of Data Mining and Way to do it
  • Explore the most usable 9 Algorithms
  • Implement Sequence Clustering, MS Neural Network, MS Association Rules, MS Time Series
  • Dimensions of Data Mining
  • Client Overview for Data Mining

Created with Snap REPORT BUILDER AND OFFICE INTEGRATION

  • Report Center
  • Dashboard Types, Filter, Excel Web, Reports, KPIs
  • Explore Excel 2003 Pivot Tables
  • SPS RS web parts & .NET 2.0 report viewer controls
  • SQL RS & Report Builder
  • Business Scorecards 2005 & Pro Clarity
  • SharePoint & Excel Services in BI

We are technology experts and can make you ahead of your competitors

Book Now

At the end of the course you will achieve


Why us?

Face To Face and Practical Hands on Training

Face-to-Face and practical hands on training with highly expertised trainers with over 10 years of experience with MNC’s.

Team of Experts

IT professional and consultants are exposed to large projects and work on Live production Servers.

Why MSBI

MSBI i.e. the Microsoft Business Intelligence is a collection of tools that gives us with solutions of Business Intelligence along with solutions on the problems of data mining. With the company of the Visual studio and SQL, it helps us in taking great decisions in our business activities.

Importance of MSBI

1. Leading and mentoring other IT consultants within the practice and across business units
2. Supporting business development and ensuring high levels of client satisfaction during delivery

We are technology experts and can make you ahead of your competitors

Book Now

Commercials

SSAS & SSIS Classroom Training

£1500 £1199+VAT

  • Course Duration-3 Days

SSAS & SSIS Online Training

£1300 £1099+VAT

  • Course Duration-3 Days

You are only one step away to choose an expert Training

Fill out this form and we'll get back to you soon!


we will call youyour details please!!

Get In Touch + 44 330 223 3579

About Us

Wenso Training is a part of Wenso an IT, Web and Mobile Application development company with headquarters in Manchester, UK. Wenso Solutions defines and delivers world class IT, Web and Mobile Application services and solutions to renowned companies around the world.


Social

Contact US

Manchester:

 
Suite 2, Ground Floor, No. 5 Universal Square Devonshire Street Manchester, M12 6JH

Call Us

Tel: +44 - 330 223 3579

Email Us

Email: info@wensotraining.co.uk

© WensoTraining 2017 All rights reserved.

Quick Contact