Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

24384 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Analysis Services

ssas-DataSourceCreation

Analysis Services - Data Source Creation

A Data Source is an object that allows a product such as SSAS/SSRS/SSIS to connect to a database system. Watch an overview of the database and how we would initially connect to the system...

ssas-DimensionParentChild

Analysis Services - Parent Child Dimensions

Parent Child Hierarchies are self referencing hierarchies which don't need a hierarchy structure setup the same way as discussed so far because between two fields contained in the dimension they define the structure without...

SSAS-StorgaeMode

Analysis Services - Dimension Storage

Dimension Storage is the means to instruct Analysis Services how to store the information on the cube. This is where the terms ROLAP & MOLAP come in.

ssas-attribute-relationships

Analysis Service - Dimension Attribute Relationships

They are the roadmap as to how aggregations are structured in cubes. Without them Analysis services would not know hoe to perform fast and accurate aggregations.

ssas-StartsVrsSnowflake

Analysis Services - Star Schema/Snowflake Schema

This is where one fact table would have one or more dimension tables connected to it. So simply put if you zoomed out on a diagram you would get a star appearing on your...

ssas-Datedimensionsand-hiearchies

Analysis Services - Dimension Hierarchies

The next step is to look at grouping our data together, this comes in the focus of a one to many within the one dimension table. For example let us use Dates as an...

ssas---Cube-Creation

Analysis Services - Cube Creation

The Microsoft textbook response is you can tackle Cube creation head on once you have established your Data Source and Data Source View. The Cube Wizard handles creating these dimensions for you. Albeit not...

ssas-dimensionFundamentals

Analysis Services - Dimension Fundamentals

Why call it a Dimension? Well the whole purpose of a cube is to identify aggregated values grouped by commonality such as year by customer, or region by product etc... By using one or...

SSAS-Discretization-Attributes

Analysis Services - Dimension Discretization

Dimension Discretization is the ability to review a value and put them into groups. An example of this is salaries, if you are doing any form of grouing of data on money quite oftern...

ssas--Datasourceviews

Analysis Services - Data Source Views | Data Source View

A Data Source View allows the developer to create a logic view of the data to be placed in to the cube. Watch this video to see how it all fits together.

SSAS-Course-material-Prereqs

Analysis Services - Prerequisite Guide | SSAS

Welcome to the start of a very exciting journey. You have chosen to discover how B.I. works from Microsoft viewpoint. The following video describes what SSAS prerequisite material you need to have on hand...

Valid XHTML 1.0 Transitional website security