SSAS is one of the excellent tool for Planning, Design, Development & Management of SQL Server Data Warehouses - OLAP Databases used for Business level Data Analysis, Data Mining and Business level Forecasts. In our LIVE Training sessions, we discuss MDX, DMX and XMLA languages. Each session will be completely practical and Realtime. Daily tasks and a Case Study will also be provided during the course.
My training benefits
- My batch sizes are generally very small size 5-7 members OR 1 to 1 also, so students receive direct, hands-on training from us.
- 100% practical training only. It is not a slide show training program / theory class program. At the end of this class, definitely you will refer your colleagues / friends / relatives for my training.
- Conducting regularly online- training for US peoples in all time zones (PST,CST,EST,HST,MST)
- Installation of Softwares in your desktop / laptop will be done.
- Will be provided self evaluation testing software, exam simulator, dumps & books with this training.
- Continuous support is provided for any of your on-site problems. Placement assistance will be provided and you will be recommended to some of IT development firms.
For Corporate Training
- I will be more comfortable, if you could restrict the group not to exceed 20 persons.
- Training hours will be 40 Hrs/paper in view of 20 participants.
- Hardware for the required training should be provided by you, like Hall, Projector, and Furniture.
- I will be bringing my laptop for training purpose, which should be allowed in to your premises.
About Our Trainer
- As a Trainer, Yuvraj has over 8+ Years Working experience on SQL Server 2005, 2008 R2 and SQL Server 2012 Database Management and Business Intelligence competencies specifically into Marketing, Sales and Infrastructure domains. Holds MCP, MCDBA, MCITP and MCSA Certifications from Microsoft.
Currently working for a Leading MNC in Chennai as BI Consultant and Datawarehouse Archtect. Also involved in Database Consulting services on SQL Server 2014 with Azure for an Infrastructure Client based at Chennai, India.
Being proficient on SQL Server and related technologies in Health, Medicare and Sales-Retail Sector, I love sharing knowledge via Instructor Led LIVE Online / Classroom Trainings and offering training videos. Personally I enjoy answering doubts from the attendees and get involved in brain-storming sessions.
All Trainings are completely practical and real-time, paired with 24 X 7 LIVE Server Access and Real-time databases.
Courses Offered:
- SQL Server Training
- SQL DBA Training
- MSBI Training
- SQL BI and DWH [SSIS/SSRS/SSAS] Training
- DAX and Power View
- DQS and MDS with Powershell
Want a free career Advice or any career related queries? Reach him by
+91- 8939915572
Course Curriculum
Curriculum
Please find the Course Contents for SSAS Module:
SSAS Development
Advanced Cube Design
SSAS Management and Security
Introduction to SSAS
- Datawarehouse Concepts
- Analysis Services Architecture
- Introduction to SSAS 2008 R2 & 2012
Data warehouse Architecture
- Need for Cubes and Measures
- Identifying Facts and Dimensions
- Identifying Measures and Aggregates
- Identifying Attributes and Hierarchies
- Datawarehouse Design Principles
- Staging operations and usages
Basic SSAS Entities
- Data Source and Data Source Views
- Manipulating structures in DSV
- Computed and Named Queries
- Building Entity Relationships
- Deciding Datawarehouse Schema
Dimension Wizard
- Creating Dimensions and Builds
- Attributes and Member Names
- Choosing Dimension Templates
- Applying Time Dimensions
- Need for Hierarchies and Limitations
- Attribute Relations and Uses
- Building Levels and Hierarchies
- Need for Composite Attribute Keys
- Creating empty Dimensions
Cube Wizard
- Planning for Cube Design
- Identifying Cube Entries
- Measures and Additives
- Creating Measure Groups
- Cube Customizations and Options
- Empty Cubes and Enhancements
Cube Operations
- Dimension Usage and Flexible Cubes
- Building Fact Dimensions
- Calculations and Conditional Colors
- MDX Scripting for Calculations
- Calculation Sets and Options
- Defining KPIs and Goals
- Perspectives and Uses
- SSAS Actions and Coding
SSAS Partitions and Aggregations
- Need for Cube Partitions
- Local and Remote Partitions
- Need for Storage Models
- Generation of Aggregations
MDX Specifics and Functions
- Need of MDX Language
- Complex MDX Queries
- MDX Functions & Limitations
- PARALLELPERIOD specifics
- Conditional MDX JOINS
- Cube and Dimension Writebacks
- MDX Transactions & Limitations
Data Mining and Forecast
- Need for Data Mining Structures
- Data Mining Algorithms and Rules
- DMX Queries and Forecast Reports
- Data Mining Scope and Ranking
- Prediction Functions and Analysis
SSAS Deployment
- Deployment Pre-requisites
- Deployment Options and Tools
- Creating OLAP (SSAS) Databases
- Processing Options and stages
- Managing Deployment Process
SSAS Logging
- Benefits of SSAS Logging
- Choosing correct log providers
- Managing SSAS Log Providers
OLAP Database Management
- OLAP Database Backups
- Compressions and Encryptions
- Restore Options and Partitions
- Scripting Backups and XMLA
- Scheduling Backupsand Jobs
- DB Synchronizations and XMLA
- Managing Partitions & Aggregations
- DB Reports and Dashboards
- Monitoring Execution Plans
Usage Based Optimizations (UBO)
- Need for Optimizations and Audits
- Designing Aggregations using UBO
- OLAP Restore Options and XMLA
Managing Security
- SSAS Security Roles and Scope
- Object Level Access and MDX
- Drill-Through Security and MDX
- Item Level Security and MDX
- Dynamic Security Implementation
- Windows Level Authentications
- Security Audits and Query Logs
Schedules and Upgrades
- Using SSIS for DW Management
- Using SSIS for XMLA Operations
- MDX and DMX Operaitons in SSIS
- Scheduling SSAS operations
- Upgrading OLAP Databases (DW)
- Comparing SSAS 2008 R2 & 2012
- New SSAS Features in DENALI
Course Reviews
Related Courses
QUICK ENQUIRY
TOP COURSES
Our Reviews
Reviews 
5 out of 5 based on 52567 ratings.
Google
Facebook
UrbanPro
Sulekha
Yet5
Justdial
