Key concepts

…Key concepts.…The mining structure.…The mining structure defines the type of data from which mining models are built.…It specifies source data view, the number and…types of columns and an optional partition into training and testing sets.…A single mining structure can support multiple mining models that…share the same problem domain.…The most basic part of a data mining question is the attribute.…Which is a single piece of information about an example.…

Examples include a customer's gender, age, marital status.…A product's category, volume, color, et cetera.…Other attributes can be whether the customer purchased a particular product,…or even how much of that product they bought, or how much they liked it.…When choosing attributes for data mining, you should be careful to…choose attributes that are likely to be relevant to your question.…And provide information that can be used by the data mining algorithm.…Many attributes are not suitable for…data mining at least, not in the form that they exist within your data.…

Resume Transcript Auto-Scroll

Author

Released

8/20/2014

You've gone over the fundamentals. It's time to get into the Microsoft business intelligence (BI) stack in depth, in this course with Ron Davis. Ron starts in SQL Server Analysis Services, explaining both the traditional multidimensional mode and the new tabular mode for viewing your business's data. Then he moves on to enriching and analyzing your data with Excel's PowerPivot tool, and sharing your Excel workbooks in SharePoint. Finally, Ron covers PerformancePoint Services, which allows you to build dashboards for your data warehouses and other data sources, and explores designing diagrams and data visualizations with Visio Services and data mining with Microsoft BI.

Topics include:

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