SQL SERVER ANALYSYS
SERVICES
1.
Introduction to Data Warehousing
Concepts
i.
What
is Data Warehousing?
ii.
Need
for Data warehousing
iii.
OLTP
Databases Vs DW
iv.
Multi-dimensionality
v.
Star
Schema
2.
Introduction to Analysis Services
i.
Need
for SSAS
ii.
Fundamentals
of Analysis Services 2005 and 2008
iii.
Architecture
of SSAS
iv.
FASMI
Rules
v.
Configuration
of SSAS
vi.
SSAS
and SQL Server Browser Service
vii.
Integration
with SQL Server Components
viii.
Analysis
Services Components Overview
3.
Designing Analysis Services Projects
i.
Data
Preparation
ii.
Starting
an Analysis Services Project
iii.
Hierarchies
and Attributes
iv.
Dimension
Design
v.
Cube
Design
vi.
Basic
Browsing
4.
Advanced SSAS Design
i.
MDX
Queries
ii.
Creation
of Sub Cubes
iii.
Partitions
iv.
Aggregations
v.
Analysis
Actions
vi.
Slowly
Changing Dimensions (SCD)
vii.
Perspectives
viii.
Permissions
and Roles
ix.
Security
over Cubes and Dimensions
5.
MDX and
Cube Analysis
i.
Basic MDX
·
Multi-dimensional
expressions
·
MDX
queries
·
Creating
calculations
ii. Advanced
MDX
·
Defining
named sets
·
Basic
scripting
·
Defining
actions
6.
Key Performance Indicators
i.
What
are KPIs
ii.
Use
and Variants of KPIs
iii.
Browsing
KPIs using UI and MDX
iv.
KPIs
and XMLA
7.
Managing Analysis Services
i.
Analysis
Services Configuration
ii.
Deployment
Options
iii.
Processing
Types
iv.
Browsing
Cubes
v.
Security
Management
vi.
Usage
Based Optimizations (UBO)
vii.
Importing
SSAS Project
8.
Performance Counters
i.
SQL
Server Profiler
ii.
Performance
Counters
9. Comparison with Analysis Services of SQL Server 2000
10. Migrating SSAS 2005 Projects to 2008
i.
New
features in SQL Server 2008
ii.
Performance
benefits over MSAS 2005
iii.
Dimension and Cube Extensions
iv.
Mining Extensions in SSAS 2008
v.
Attribute Relationships and Properties
vi.
Type I and Type II SCDs
11. Generation of Reports from SSAS Cubes
12. Best Practices and Conclusion
Phone: 3185003479
| BA | QA | JAVA | HADOOP | SQL | ORACLE | SELENIUM |
| Java/J2EE|
.NET/BA/Project Manager (PMP)/QA/ Lead/ SCCM/Citrix Administrator/Oracle
Lead/Middleware Admin/Regression/Test Lead/Sr. Informatica/Data
Analyst/Modeler/Project Manager / C++ Developer/Oracle Pl/SQL developer/Power
Builder/Mainframe/Web Sphere Admin/VMWare Admin/ Network Engineer/Linux
Engineer/Windows Admin/Active Directory/Build Engineer/ System Admin |
"Training & Job
Placement + Profile Marketing Help |
