Join Ron Davis for an in-depth discussion in this video The tabular model, part of Microsoft Business Intelligence Stack Essential Training.
…The tabular model of SQL server analysis services.…The tabular model is designed to support personal business intelligence and…team business intelligence.…What we're going to look at is we're to go in and look at the different views.…We're going to look at the grid view and the diagram view and compare…the similarities of those used, to tools such as Excel and a relational database.…Then we're going to go in and…look at data sources and see where we can retrieve data into the tabular model.…
We'll explore relationships.…Relationships can be one of two types.…They can exist in the underlying data already,…being primary key foreign keys, in which case the tabular model will…automatically discover those relationships, and bring them in.…Or we can create our own relationships so…that we could bring in tables from different sources and join those together.…Measures, calculated columns.…A measure is what we all a fact in multi-dimensional mode.…Measures are calculated.…
Whereas a calculated column is calculated once for each row in a column.…
- 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
Learning Microsoft Business Intelligence Stackwith 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.