MSBI Online Training

Key Features of MSBI

  • What is Microsoft BI
  • OLAP Modeling
  • Using SSAS in BIDS
  • Intermediate SSAS
  • Advanced SSAS

What you will learn MSBI

  • Certified and expert teachers
  • Extensive doumentation provided
  • Became an exepert few days

ABOUT MSBI:

MSBI stands for Microsoft Business Intelligence tool. MSBI suite is composed of tools which provides best solutions for Business Intelligence and Data mining Queries. MSBI uses visual studio with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in the organization. Microsoft SQL Server Reporting Services (SSRS) is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. It supports various data sources like two dimensional and multi-dimensional.

COURSE OBJECTIVES:

  • What is Microsoft BI
  • OLAP Modeling
  • Using SSAS in BIDS
  • Intermediate SSAS
  • Advanced SSAS
  • Cube storage and Aggregation
  • Beginning MDX
  • Intermediate MDX
  • SSAS Administration
  • Introduction to Data mining
  • Introduction to Reporting Clients
  • Future Directions-Integration with office 12
  • Ad-Hoc Reporting with Report Builder

  • WHO SHOULD LEARN MSBI

    Those who are having the knowledge of .Net can learn. It’s easy for fresher’s to learn. Today’s software market is fully dependent on MSBI. There are more opportunities for fresher’s as well as experienced people. Our trainers help you for resume preparation, interview skills and project development. There will be 24*7 technical support for all the learners.


    PRE-REQUISITES FOR ANDROID

    There are no such pre-requisites for MSBI, but those who are having the knowledge of .Net, will gain the subject easily. It’s a best option for fresher’s and experienced one. RizeTrainings is the best training institute in Hyderabad to learn MSBI online training. We provide services all over the world.

    Course Details:
    SQL Server 2005 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
    he 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
    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

    RIZE Trainings offers wide range of courses belonging to business, IT, students, developers, data and working professionals, freshers etc; We regulate training about your expected courses and help you to advance your career. RIZE come up with numerous courses and offer training throughout the world like France, United states, China, India, Singapore, Germany, Australia, Canada etc; by using interface like webex and GoToMeeting.

    RIZE trainers assist in developing Real time experience of the required course and also improving interview skills, knowledge, communication, content of the course, innovative project ideas, future scope etc,. This makes our students are becoming future experts and working as professionals in top rated companies.

    The course begins in a few days, and I still do not have my login information. What do I do?
    Once your registration for a course is completed, we will send activation link to start your sessions.

    What happens if I miss my training date, do I have any options?
    In case you miss training date, we will send recorded sessions to you. Otherwise, we assign for next live batch.

    How does the online training work?
    All of our online courses are live instructor led online courses. You will have the ability to interact directly with the trainer. Once registered for a class you will receive detailed instructions on how to access your class.

    How do I receive the course materials?
    You receive a link to download the course materials when you register. Our trainers assist you in your assessments, case studies, sample projects, interview skills etc;

    Will I be able to view the sessions again at a later time?
    Yes, We provide recorded sessions.

    Who are your trainers?
    All our trainers are working professionals from the Industry and have at least 10-12 yrs of relevant experience in various domains. They are subject matter experts. So that participants get a great learning experience.

    Can I get the same in-class experience at home or work?
    Yes. You can attend courses anywhere that has an Internet connection. If you choose to participate from your home or workplace, you must validate your own equipment to ensure it meets the required specifications.

    What should I bring to class?
    You need to have your course materials, Internet, computer headset and the Link to your Rizetrainings classroom e-mail, which contains the link and LOGIN credentials you need to take your course.

    Where can I get more information?
    If you need more information, please call us at +91-970 39 767 53 or send mail to contact@rizetrainings.com . Rize Trainings Advisors will be happy to assist you.

    Do you offer placements?
    We help our customers for preparing their resumes, work on sample live projects and provide assistance for interview preparation. We don't offer any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

    What happens if I have technical problems during my class?
    If you have technical difficulties, you call us at +91-970 39 767 53 . Our support team will resolve any issues you might encounter.

    ENQUIRY FORM HERE :
    Back to top