SQL Service Analysis Service (SSAS)

Subscribe Now

SQL SERVER Analysis Services SSAS in the technology form Microsoft Business Intelligence stack and is used to develop online analytical processing (OLAP) solutions.

Course Modules

1. OLAP Introduction

1 Videos (46 Mins)

Videos
OLAP Introduction

46 Mins
Course Material
- OLAP Introduction
  
  Course Material
Interview Questions | Test Your Skills |

2. SSAS Introduction

1 Videos (51 Mins)

Videos
SSAS Introduction

51 Mins
Course Material
- SSAS Introduction
  
  Course Material
Interview Questions | Test Your Skills |

3. DSV and Cube Wizard

1 Videos (53 Mins)

Videos
Dsv and Cube Wizard

53 Mins
Course Material
- DSV and Cube Wizard
  
  Course Material
Interview Questions | Test Your Skills |

4. MDX

2 Videos (110 Mins)

Videos
MDX

96 Mins
Cube Browser

14 Mins
Course Material
- MDX
  
  Course Material
Interview Questions | Test Your Skills |

5. Calculations

1 Videos (40 Mins)

Videos
Calculations

40 Mins
Course Material
- Calculations
  
  Course Material
Interview Questions | Test Your Skills |

6. Dimension Designs

4 Videos (137 Mins)

Videos
Dimension Design - Part1

48 Mins
Dimension Design - Part2

16 Mins
Dimension Design - Part3

37 Mins
Dimension Design - Part4

36 Mins
Course Material
- Working With Dimension
  
  Course Material
Interview Questions | Test Your Skills |

7. Cube Design

2 Videos (70 Mins)

Videos
Cube Design - Part1

25 Mins
Cube Design - Part2

45 Mins
Course Material
- Working With Cube Design
  
  Course Material
Interview Questions | Test Your Skills |

8. Translation Perspective and Action

3 Videos (51 Mins)

Videos
Translation

18 Mins
Perspective

7 Mins
Actions

26 Mins
Course Material
- Translation and Perspective
  
  Course Material
Interview Questions | Test Your Skills |

9. KPI

1 Videos (45 Mins)

Videos
KPI

45 Mins
Course Material
- KPI
  
  Course Material
Interview Questions | Test Your Skills |

10. Deployment and Processing

4 Videos (59 Mins)

Videos
Deployment Using SSDT

18 Mins
Deployment Wizard

19 Mins
Deployment Using SSMS

12 Mins
Backup Restore

10 Mins
Course Material
- Deployment and Processing
  
  Course Material
Interview Questions | Test Your Skills |

11. Partition

4 Videos (95 Mins)

Videos
Partition - Part1

36 Mins
Partition - Part2

19 Mins
Storage Modes

20 Mins
Proactive Caching

20 Mins
Course Material
- Partitions
  
  Course Material
Interview Questions | Test Your Skills |

12. Aggregation

4 Videos (75 Mins)

Videos
Aggregation Concept

21 Mins
Aggregation Design

17 Mins
Query Processing

21 Mins
UBO

16 Mins
Course Material
- Aggregation
  
  Course Material

13. Security

2 Videos (63 Mins)

Videos
Security - Part1

40 Mins
Security - Part2

23 Mins
Course Material
- Security
  
  Course Material
Interview Questions | Test Your Skills |

Career Guidance

Mr. Sandeep Soni

CEO & Founder of Deccansoft Software Services

9849001840 / 9849001840

Email: sandeepsoni@deccansoft.com

Course Overview

SQL Server Analysis Services (SSAS) is a component of Microsoft SQL Server.

It is used to develop OLAP(Online Analytical Processing) Solutions. It is used for storing and retrieving large amount of data which can be used for analysis.

This extensive SSAS training Course is provided for participant to have in depth knowledge of developing OLAP Solution.

Why Bestdotnettraining.com? Our USP…

Get an idea of the quality and quantity of the subjects by watching online videos provided.
For any technical issues/queries relating to the online training videos, we provide technical support by Subject Matter Experts (SMEs)
The course material is simple and organized and can be used for learning and as a reference material.
Includes job related training to help participants face an interview confidently.
Microsoft Certification Guidance and any subject related questions will be answered by Mr Sandeep Soni (MCT).
Every course is accompanied by a live project training with a step-by- step guide and complete source code.

WHAT YOU'LL LEARN / COURSE OBJECTIVE

Understand need of OLAP.
Learn basic concepts related to OLAP like Cube, Dimension, Measures, Dimension Table, Fact Table, Hierarchies etc.
Understand Star and Snow Flake Schema.
Use SSDT (SQL Server Data Tools) to develop OLAP Database.
Work with Data Source and data Source View.
Develop Cube using Cube Wizard.
Create Dimensions using Wizard and Designer.
Work with Regular, Snow Flake and Time Dimension.
Configure Attribute properties, Understand Natural Hierarchies and Unnatural Hierarchies.
Work with attribute relationship, Role playing dimension.
Work with measure group, adding removing measures.
Understand relationships like Fact relationship, referenced relationship etc.
Work with Calculation, Named Query and Named Calculation.
Work with KPI, Perspective, Translation.
Work with Partition, Aggregation.
Understand different storage modes like ROLAP, MOLAP and HOLAP.
Work with Security, Roles.
Understand Processing and Deployment.
Learn MDX (Multidimensional Expressions Language).

Pre-requisites

Participants should have knowledge on SQL Server.

Instructor

A well known trainer at Deccansoft for more than 6 years, she is a specialist in SQL Server 2008 and has taught well over many students. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries with no difficulty at all. Her class sessions are also now available as videos, targeting students who want to learn the course at their own pace and convenience. An avid learner, she has now trained herself in Microsoft Business Intelligence suite of products (SSIS, SSAS and SSRS), a must for everyone specializing in Business Intelligence and will soon be launching the classes which will definitely enhance one's knowledge in SQL Server.

......

Premium Edition Membership (Duration: 6 months)
hover here Video tutorials can be viewed unlimited number of times.
Hover over me Tooltip text

Actual Price

$175 / ₹12250

Offered Price

$100 / ₹7000

Pay Now
- Watch Online - Anytime, Anywhere learning.
- Video tutorials can be viewed unlimited no. of times.