SSAS-SSRS Chennai Statistical

Module 1


Building and Modifying an OLAP Cube

Designing a Unified Dimension Model (UDM)

Identifying measures and their suitable granularities

Adding new measure groups and creating custom measures

Module 2

Creating dimensions

Implementing a Star and Snowflake Schema

Managing Slow Changing Dimensions (SCD)

Identifying role

Play dimensions

Module 3

Extending the Cube with Hierarchies

Creating hierarchies

Building natural hierarchies

Many to many hierarchies

Creating attribute relationships

Distinguishing between ragged, balanced and unbalanced hierarchies

Clusters and Equal Areas Algorithms

Module 4

Parent-child relationships

Defining parent and key attributes

Generating level captions with the Naming Template feature

Removing repeated entries with the MembersWithData property

Module 5

Exploiting Advanced Dimension Relationships

Storing dimension data in fact tables

Building a degenerate dimension

Configuring fact relationships

Module 6

Saving space with referenced dimension relationships

Identifying candidates for referenced relationships

Utilizing the Dimension Usage tab to configure referenced relationships

Module 7

Including dimensions with many-to-many relationships

Implementing intermediate measure groups and dimensions

Reporting on many to many dimensions without double counting

Module 8

Designing Optimal Cubes

Assembling cube components

Selecting the appropriate fact tables

Adding cube dimensions

Distinguishing between additive, semiadditive and nonadditive measures

Module 9

Designing storage and aggregations

Choosing between ROLAP, MOLAP and HOLAP

Partitioning cubes for improved performance

Designing aggregations with the Aggregation Design Wizard

Leveraging the Usage-Based Optimization Wizard

Module 10

Automating processing

Exploiting XMLA scripts and SSIS

Refreshing cubes with Proactive Caching

Module 11

Performing Advanced Analysis with MDX

Retrieving data with MDX

Defining tuples, sets and calculated members

Querying cubes with MDX

Navigating hierarchies with MDX and utilizing set functions

Module 12

Monitoring business performance with KPIs

Building goal, status and trend expressions

Using PARALLELPERIOD to compare with past time periods

Module 13

Creating calculations with MDX

Adding runtime calculations to the cube

Comparing MDX calculations with DSV calculated columns

Module 14

Securing Cube Data

Securing data and simplifying the user interface

Distinguishing between perspective feature and security

Creating roles for administrative privileges

Securing dimension data

Implementing cell level security

Module 15

Gaining Business Advantage with Data Mining

Determining the correct model

Identifying business tasks for data mining

Training and testing data mining algorithms

Accuracy chart and Classification matrix

Optimizing returns with the Profit Chart

Module 16

Performing real-world predictions

Decision Trees, Neural Network and Naive Bayes Algorithms

Predicting with the Time Series algorithm


Deploying models

Predicting new cases with algorithms

Utilizing DMX to perform batch and singleton predictions

Exploring results with data mining viewers



Introduction to SQL Server 2008 Reporting Services

Identifying deployment: native, integrated or single server

Managing Web farm deployment with/without SharePoint

Module 17

Developing Reports

Designing fundamental reports

Connecting to relational and multidimensional data sources

Generating a Tablix reporting structure

Building an interactive chart

Creating reports with richly formatted text

Module 18

Composing expressions

Computing custom fields

Managing built in collections

Linking expressions to properties

Employing conditional formatting

Module 19

Arranging and sorting data

Multiple level grouping and categorizing the results

Applying aggregate functions

Module 20

Producing various outputs from a Tablix

Creating parallel dynamic group report formats

Combining dynamic and static columns

Module 21

Integrating Parameters and Filters

Incorporating parameters into reports

Yielding subsets of data with query parameters

Aligning report parameters to query parameters

Constructing cascading report parameters

Transmitting parameters to stored procedures

Handling multivalued parameters

Module 22

Applying filters to report data

Augmenting performance with filters

Determining filters vs query parameters

Module 23

Implementing Interactive Features

Combining multiple data regions in one report

Applying sequential and nested regions

Creating master/detail reports and linking subreports

Module 24

Executing advanced data visualizations

Applying the radial and linear gauge

Customizing charts with scale breaks

Charting KPIs from Analysis Services

Module 25

Showing robust data with relevant detail

Drilling through report detail and drilling down report data

Navigating reports with document maps

Reporting with hierarchical rows and dynamic headers

Module 26

Deploying and Delivering Reports

Deploying reports to the server

Publishing reports and configuring project properties

Verifying results with Report Manager

Module 27

Identifying delivery options

Electing on demand or via subscription

Enhancing performance with cached instances and snapshots

Configuring snapshot history

Formatting different outputs

Module 28

Dispatching subscription reports

Publishing reports via e-mail and fileshare

Seamlessly delivering reports by data driven subscriptions

Module 29

Integrating reports with SharePoint

Deploying reports to SharePoint

Viewing results in Report Center and Data Connections libraries

Module 30

Safeguarding Reporting Services


Structuring content security

Leveraging existing Windows authentication

Establishing permission levels on report items

Module 31

Ensuring the RS system

Instituting varying levels of administrative roles

Allowing and withdrawing system

level permissions

Module 32

Empowering Users with Ad Hoc Reporting

Module 33

Designing models for users

Building personalized reports with Model Designer

Defining data source views

Creating and refining models

Module 34

Designing reports with Report Builder

Launching Report Builder to users across the enterprise

Dragging and dropping entities onto charts and tabular reports

Exploiting Analysis Services cubes as report models

Module 35

Delivering Reports to Users

Accessing and controlling reports using URLs

Leveraging RS Web services

Embedding reports in applications with the Report Viewer

Delivering reports through SharePoint