Join Ron Davis for an in-depth discussion in this video Microsoft data-mining examples, part of Microsoft Business Intelligence Stack in Depth.
- View Offline
…Let's take a look at some samples that Microsoft provides us.…I am in SQL Server Management Studio and I in the Sample Database >…AdventureWorksDW and within it, I am looking at the Mining Structures and…you are not going to understand all of the charts that we go through in…these mining structures but you should get a good flavor for what we are doing.…So we have mining models down here, and customer clusters.…And if I right click it and…say browse, it'll take a second to build and out pops the customer clusters.…
If you remember, when we talked about clusters, what we said was.…A clustering algorithm does not necessarily return information that…may be very useful to us.…But then again, maybe it is.…It's one of the things we tend to look at.…So here we have clusters of customers, and…it took the attributes, and put them into a grouping.…Before you come over here, there's Cluster 1 compared to.…It's complement which is Cluster 2, and if I go to Cluster Characteristics you can…see, when I go to 1, see that popped way out.…
- 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.