Microsoft BI

Microsoft’s business Intelligence is a complete solution that is capable to develop corporate level Data management and Decision Support Systems. Microsoft BI has a significant role in day to day operations of SOL Saver professionals. It caters to the data warehousing, analysis and reporting of corporate level.

It is based on the Microsoft Visual Studio development environment, but customized with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports, ETL data flows, OLAP cubes and data mining structure.

Analysis

    • OLAP Modeling
    • SSAS in BIDS
    • Intermediate SSAS
    • Advanced SSAS
    • Cube Storage and Aggregation
    • Beginning MDX
    • Intermediate MDX
    • SSAS Administration
    • Data Mining
    • Reporting Clients

Integration

    • Introduction to SQL Server Integration Services
    • SSIS for DBAs: Using SQL Server Management Studio
    • Business Intelligence Development Studio
    • Introduction to Control Flow
    • Advanced Control Flow
    • Introduction to Data Flow
    • Variables and Configurations
    • Debugging, Error Handling and Logging
    • Advanced Data Flow
    • Extending SSIS through Custom Code
    • SSIS Package Deployment
    • SSIS Package Management

Reporting

    • Introduction to SQL Server Reporting Services
    • Creating Reports
    • Calculations and Formatting
    • Grouping and Sorting
    • Report Parameters
    • Creating Matrix Reports and Charts
    • Managing Reporting Services
    • Reporting Services Security
    • Programming Reporting Services
    • Advanced Reporting Services Programming
    • Snapshots and Subscriptions
    • Ad-Hoc Reporting with Report Builder