MS BI






HOME  |  SAP   |  JAVA  |  MICROSOFT  |  ORACLE  |  TESTING TOOLS  |  LINUX  |  DATA BASE  | PHP  |  SAP ONLINE SERVER



MICROSOFT

MS BI Course Curriculum

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 Data sources and Data source 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

QUICK CONTACT

PHONE NO :+91 9966126979
PHONE NO : +91 8885544979
Email id :
         saponlineclass@gmail.com
         assentsoft@gmail.com
Skype Id : assentsoft
Gtalk Id  : saponlineclass

DOWNLOADS

SAP GUI WINDOWS 7.30
SAP GUI WINDOWS 7.20
SAP GUI WINDOWS 7.10
SAP GUI MAC OS



ddd
dddd

No comments:

Post a Comment

Subscribe to: Posts (Atom)