Quick Enquiry Form

×

    MSBI Course Syllabus

    MSBI Training Syllabus

    Our MSBI Course Syllabus enhances business intelligence skills through the utilization of tools in real-time project practices. Get expertise in data mining querying with our modernized MSBI Course Curriculum that contains concepts such as cube storage, aggregation, MDX syntax, MDX scripts, health monitoring practices, data mining practices, integration of Office 12, SSIS for DBA integrations, and SQL Server Management studio implementation.

    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 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
    Conclusion

    Climb up your career ladder faster through our MSBI Training in Chennai. Our trainers are experienced and experts in framing coursework for MSBI Course Syllabus to offer the best coaching on business intelligence with satisfying hands-on practice.

    1
    Softlogic-Academy