Join Ron Davis for an in-depth discussion in this video Star and snowflake schemas, part of Microsoft Business Intelligence Stack in Depth.
…There's basically two types of schemas that you're going to run into.…The star schema, which I have up here,…a star schema is so-called because in the center, we have a fact table and…then one off from the fact table is each dimension table.…Don't let this confuse you that we have three arrows.…All that means is that we have three relationships.…We still have the fact table that is one off from the date table.…
So, all of the dimension tables surround the fact table.…The star schema is the most popular schema in large data warehouses.…It's most popular because it's the fastest to update.…So what we can do is come down there and update, say Sales Territory dimension,…update the facts that we needed to update relating to this sales territory and…we're ready to go.…
If we use the snowflake schema, that is not the way it would work.…I'll show you that in just a second.…But I want you to understand the downside of a star schema…is that referential integrity is not maintained by the schema.…What all of that means is that it's really easy to…
- Working with data sources and data views in SQL
- Understanding the star and snowflake database schemas
- Working with the SQL 2012 semantic model (aka tabular mode)
- Using Data Analysis Expressions (DAX)
- Using Excel Web Parts to connect to spreadsheets
- Building dashboards with key performance indicators (KPIs) and reports
- Understanding the Microsoft data-mining process
Skill Level Intermediate
Microsoft Business Intelligence Stack Fundamentalswith Ron Davis43m 39s Intermediate
1. The Traditional Multidimensional Model
2. The New Tabular Model
3. Basic Power Pivot
4. SharePoint Excel Services
5. Basic PerformancePoint
6. SharePoint Visio Services
7. Data Mining and Predictive Analytics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.