MICROSOFT BI

  • 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 Parameterized 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 Data driven 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
  • Demoralization
  • 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

Course Video

The Course Videos Section.

Course Overview

The Course Overview Section.