Live Help (Start Chat)

SSAS Introductory Course

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

Course Modules
Videos
  • SSAS Introduction
    Preview 51 Mins : 0


Documents

What you will Learn

  • 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.

......

Enquiry

Frequently Asked Questions:

Does Best DotNet Training offers Any Live Projects?

Yes, with every course we have a sample project document along that contains complete source code. We also provide a special course on developing live project which will help you to learn the process involved in all the stages of application development.For more details please check" Live Projects "page.

What do I get When I take Subscription?

You will be able to do following things for each of the module
  1. Video Access for the perios mentioned in the subscription
  2. Course Material in PDF format - you can download and save them for future references
  3. Assignments-For you to practise the subject learnt over a period of time. We also provide solutions for most of the assignments
  4. InterviewQuestions - In every module we provide you with a set of interview questions
  5. Online Exam - You can evaluate yourself and you can do the same for each and every module
  6. Tech Support - For any kind of questions you may have while practising the subject

What are the Software Requirements for online classes?

You need to have latest version of Visual Studio .NET i.e:VS.NET 2017 installed on your machine and no additional software is required.You can download the trial version from here. Links for downloading the required software (Some are free and some are free trials) Visual C#.Net 2010 Express
Visual Basic 2010 Express
Visual Web Developer 2010 Express
Visual Studio 2010 Express All-In-One ISO
Microsoft Visual Studio 2010 Professional Trial-ISO
SQL Server Express
SharePoint 2010
Windows Server 2008 R2
SQL Server 2008 R2
SharePoint Server 2010
SharePoint Designer 2010
Search Server 2010 Express
MS-Office 2010
© Copyright 1997 - 2019 | www.bestdotnettraining.com | www.deccansoft.com | All Rights Reserved.
 
Bestdotnet google plus