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.

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

Analysis Services - Star Schema/Snowflake Schema

Part of Microsoft Analysis Services

ssas1 Analysis Services   Star Schema/Snowflake Schema SSAS Star Schema/Snowflake Schema

We are full speed ahead with our development work but its time to slow down and talk a little theory. Don’t worry it not too intrusive but has a critical aspect of any cube design. This is the Star Schema and Snowflake Schema.

What is a Star Schema or Snowflake schema?

A Star Schema has been created without you realising! 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 data source view.  So pretty straight forward, now let’s make this more interesting…

A Snowflake can be a little more complicated than a Star Schema; as no doubt your real life examples of cubes will have more than one fact table.  To lets image you have two fact tables which are completely independent from one another, for example HR payroll and Finance sales information.  Each fact table would have their own dimensions associated but there will be some dimensions which would/should be used on both fact tables.  For example a date dimension, a personnel dimension etc…

So when we talk about Snowflakes we are discussing the interrelationships between two or more fact tables and this is typically performed in a Snowflake schema.  This video will discuss how they work and more importantly how you can start getting useful information between different fact tables.

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

The Star Schema & Snowflake Schema example files

To obtain the sample files please click here: [/blockquote_left]

Related Posts

18 Comments

  1. pj says
    06 Jul 15 at 9:48am

    Where can I find the next video after star and snowflake schema ?

  2. wojciech says
    10 May 15 at 10:39pm

    Hi

    Thanx for this great tutorial. No continuation? :( Why? :(

  3. Jon Sommervold says
    01 Jan 15 at 11:34am

    Brilliant, thanks a lot for publishing these videos!!!

    Very unfortunate that your pc blew up, cause I´d really like to watch the rest of the series.

  4. Errol Tsql says
    09 Oct 14 at 5:27pm

    it’s never too late to continue the series

  5. Jane Shearer says
    29 Jun 14 at 11:23am

    Thanks for the great videos on Analysis Services. It left me wanting more. I hope you can continue these.

  6. musafir says
    11 May 14 at 3:55pm

    Quite an excellent series and much thank you for that. Just wondering if any chance to continue this?

  7. Dane Lemon says
    01 Sep 13 at 2:28am

    I have really enjoyed learning the content you share through the way you cover the subject. Teaching is about facilitating comprehension, not simply stating knowledge. Your work demonstrates that you have the skill to truly Teach.

  8. Puneeth says
    27 Aug 13 at 3:14am

    Each and every video of SSAS was simply superb!! These will help newbees a lot..Thank you for posting these.. Please continue the series.. It will be helpful to a lot of people..

  9. Nashmin says
    16 Jul 13 at 7:36am

    Your training videos are really helpful. Please do a favor and continue your training.

  10. THine says
    04 Jul 13 at 2:06am

    Sorry, but to me this video is simply describing the use of conformed/shared dimensions. My understanding of a snowflake schema is a star schema with one or more normalised dimensions. It has nothing to do with how many fact tables the dimension relates to…

    E.g. http://msdn.microsoft.com/en-us/library/ms175439.aspx

  11. sabrina.wolter says
    28 Jun 13 at 10:20am

    I enjoyed your SSAS tutorial immensely helpful! Please make more, I would just love to learn more about my squiggles! :)

  12. gggray says
    19 Jun 13 at 11:49pm

    What an excellent series! You have an excellent way of turning the complex into the simple. Thank you! I hope that you will continue this series.

  13. GMan says
    15 May 13 at 10:49pm

    Jon, are you still planning on continuing this series? The videos thus far have been very informative. Thank you!

  14. ThoLun says
    08 Jan 13 at 9:59pm

    I have also found this series extremely helpful, and I really hope you will continue.
    Thanks a lot for your effort.

  15. Thomas says
    08 Jan 13 at 9:48pm

    I have also really enjoyed this series, and I really hope you continue with it!
    It has been a great help.

  16. 27 Aug 12 at 6:24pm

    Hi Kash,
    I intend to I have just this second uploaded an SQL install video as my old PC blew up and I have had to build a new PC. So once I have all my data back I will be definatley continuing these videos. Thanks for your feedback and support!
    Jon

  17. Kash says
    23 Aug 12 at 1:31pm

    Thank you very much for these videos and I can’t tell you in words that how much these videos have helped me. Will you continue this series or this is it?

  18. mourad15 says
    30 Jun 12 at 11:16am

    Thanks for all you’re video.
    That helped me a lot.

    Thanks

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security