MICROSOFT BI Online Training | MICROSOFT BI Online Course | Free demo on MICROSOFT BI
India:+91 (0)9848346149, USA: +1 973-619-0109, UK: +44 207-993-2319 Santosh@acutesoft.com
Select Page

MICROSOFT BI

MICROSOFT BI ONLINE TRAINING IN INDIA, USA & UK

MICROSOFT BI ONLINE TRAINING IN CANADA

MICROSOFT BI ONLINE TRAINING IN AUSTRALIA

MICROSOFT BI ONLINE TRAINING

MS BI COURSE CURRICULUM

Download [PDF]

  • MICROSOFT SQL SERVER 2008 R2 REPORTING SERVICES [SSRS]
      An Introduction to Reporting Services
      The role of SSRS in data warehousing/business intelligence
      Introduction to Business Intelligence Development Studio
      Creating Data sources and Datasets
      Creating Reports with Wizard
      Creating Basic reports
      Creating Tabular and Matrix reports
      Creating Parameterised reports
      Creating Sub Reports
      Creating Drill down and Drill through reports
      Creating Linked reports
      Creating Ad-Hoc reports Using report models
      Report Generation Using Cubes
      Creating Expressions
      Exporting Reports to different formats
      Usage of report Items like List,text boxes, charts, gauges, Image controls…
      UI designing and report Formatting
      Deploying reports
      Creating Normal and Datadriven subscriptions
      Reports Administration Using Report Manager
      Caching Reports and report Snapshots
      Report Security
  • MICROSOFT SQL SERVER 2008 R2 INTEGRATION SERVICES [SSIS]
      Course Introduction
      SSIS definition
      The role of SSIS in data warehousing/business intelligence
      Solutions & Projects
      Packages & Package objects
      Control Flow
      Data Flow
      Workflow
      Extracting data
      Data sources & data source views
      Connection managers
      Full & incremental data extraction
      Dimension table & Fact table & Cube processing
      Package execution & management
      Debugging & event handling
      Package configurations and deployment
      ETL processing & SSIS ETL features
      All Tasks Explanation
      Security
  • SQL SERVER
      Introducing SQL Server 2008
      SQL Server Editions
      Installing SQL Server
      Basics of Database Design
      Normalization
      Denormalization
      Introducing SQL Server Management Studio
  • MICROSOFT SQL SERVER 2008 R2 ANALYSIS SERVICES [SSAS]
      Business Intelligence overview
      An Introduction to Analysis Services (SSAS)
      The role of SSAS in data warehousing/business intelligence
      Difference between OLTP and OLAP databases
      Introduction to dimension tables * fact tables
      Introduction to star and snow flake schemas
      Introduction to Datasources and Datasource views
      Introduction to multidimensional cubes
      Dimension design ,Cubes
      Attribute hierarchies ,Dimension Usage
      User hierarchies and drill-down
      Attribute relationships
      Types of Dimensions
      Calculations
      Actions (drill-through and reporting)
      Partitions and aggregation design
      Perspectives
      Administration
      Deployment
      Backing up and restoring cubes
      Slowly-changing dimensions
      Incremental updates
      Security
  • Cube Processing and Types of Processing
      Creating a Database
      Adding Tables
      Creating Indexes and Constraints
      Building Relations
      DDL and DML Syntaxes and usage
      SELECT queries
      The SELECT Clause
      The FROM Clause
      The WHERE Clause
      The ORDER BY Clause
      Using GROUP BY and HAVING
      Using TOP N and TOP N PERCENT
      UNION Queries
      Joins
      Indexes
      Functions
      Stored Procedures
      Views
      Triggers

INTRODUCTION TO MICROSOFT BUSINESS INTELLIGENCE (MS BI)

Microsoft BI solutions leverage your existing technology investments in .NET, SQL Server and Office to develop rich integrated reporting and analytics experiences that empower users to gain access to accurate, up-to-date information for better, more relevant decision making. This unit provides an introduction to Business Intelligence and to Microsoft BI from a developer perspective.

Microsoft Dynamics AX provides a model driven approach for developing Business Intelligence (BI) applications that use the SQL Server Business Intelligence Development Studio (BIDS) development environment. Microsoft SQL Server Analysis Services provides online analytical processing (OLAP) functionality.

An OLAP query – called a cube – is a set of related measures and dimensions that is used to analyze data.

Cubes can be used as data sources for:

    • Integrating menu item reports and Role centers.
    • Integrating Web parts in Role centers.
    • Browsing aggregated data that uses Microsoft Excel 2007.

Application Object Tree Microsoft Dynamics AX cubes are defined in the AOT. You can specify measures and dimensions at different levels and on different objects in the AOT using the BI properties that appear in the Properties sheet. An OLAP perspective is used to identify the tables that contain the measures and dimensions for a cube.

BI tools in Microsoft Dynamics AX Microsoft Dynamics AX provides tools that are used to generate and update BI projects. On the Microsoft Dynamics AX menu, point to Tools, and then point to Business Intelligence (BI) Tools.

After creation of cubes in the AOT, you can generate a BI project so that you can work with the cubes in Business Intelligence Development Studio (BIDS). For example, in BIDS you can define calculations and Key Performance Indicators (KPIs) that can be used to further analyze the data.

To modify existing cubes. For example,To add measures or dimensions to an existing cube so that it contains additional data. The BI tools provided by Microsoft Dynamics AX allow to update an existing BI project.

Business Intelligence Development Studio

BIDS is Microsoft Visual Studio 2005 with additional project types that are specific to SQL Server 2005 business intelligence. BIDS provides a variety of designers, tools, and wizards to work with the objects in BI projects that are generated from cubes in the AOT. You can define or update cube features. For example, you may want to update the goals for the KPIs for an existing cube. You can deploy and process cubes from within BIDS.

SQL Server Analysis Server

SSAS is the core data layer of the Microsoft BI platform. SSAS provides online analytical processing (OLAP) functionality for BI applications. Cubes are deployed to a SSAS database. You can process cubes directly from an SSAS database.

DEMOS VIDEOS