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 - Data Source Creation

ssas1 Analysis Services   Data Source Creation  SSAS Data Source Creation


So, our first stop is to get to know the database we will be creating a cube from and also understand how we connect to it through Analysis Services.

What is a Data Source ?

A Data Source is an object that allows a product such as SSAS/SSRS/SSIS to connect to a database system. The database can even been client based such as Microsoft Access or even Microsoft Excel, anyone how deals with databases may be familiar these terms, however there is a line in the sand that never really gets mentioned but most people know it’s there. When does our ETL (Extract, Transform & Load) stop and Cubes start, this is more of an art form than an exacting science. I would however recommend that when dealing with Data Sources in SSAS you should already be at a point where your data is in a highly “denormalised” state.

This then bring us on to the terms “Normalised” versus “Denormalised”, this is inherently the same as saying OLTP and OLAP. Now if these statements leaves you feeling confused or slightly scared, don’t be.  These are terminologies that need to be addressed and this video will tell you how!

So sit back with your first cup of coffee and watch an overview of the database and how we would initially connect to the system ready for cube magic.

This video is one of many SSAS tutorials on this site click here for more.

The Data Source example files

To obtain the sample files please click here:

Related Posts

5 Comments

  1. Kris Maly says
    13 Apr 15 at 9:58am

    I enjoyed watching this video and recommend others to watch.
    Thanks for educating the community and appreciate your volunteer-ship.

    Narrator of this video know the topic very well and he is a nice teacher.

    Please keep publishing some videos on SSAS SQL Server 2012 or 2014

    Thanks a bunch

  2. Jon Garaux says
    19 Aug 14 at 6:43pm

    Outstanding presentation. You present the material in a clear concise manner, and you speak clearly at a pace that is comfortable for the listener. One of the best video tutorials that I have viewed.

    Thanks for a great effort.

  3. Kalpana Ganesan says
    13 Sep 12 at 10:40pm

    Informatics Outsourcing is an Offshore Clinical Research Company providing best Pharma and Biotechnology services like Bioinformatics Services, Chemical Informatics Services, Bio Information Technology, Data Analysis Services, Scientific Data Management Systems, Drug Discovery Services Worldwide with affordable price.

  4. 30 Jul 12 at 11:17am

    Avaiable wonderful

  5. owais says
    07 Mar 12 at 5:38pm

    Great effort….

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security