Carmel Gunn is a Data Management Specialist from Prodata. Let her show you Excel as an enterprise-grade BI client in this short video, in which she builds a fully fledged enterprise dashboard—in under 30 minutes!—and then shares it with others, even on mobile devices, such as an iPad, iPhone, Android, or a Surface.

Clustering is a popular data mining technique, often used for segmentation. Rafal introduces it in this short video, focusing on the reasons why it is useful for finding non-traditional segments. In the demo, you will see a clustering model, and we will use it to categorise new data in Excel.

Decision Trees are the most useful Microsoft data mining technique: they are easy to use, simple to interpret, and they work fast, even on very large data sets. At heart, a decision tree is just a tree of nodes. Each node represents a logical decision, which you can just think of as a choice of a value of one of your inputs that would make the most profound difference to the output that you wish to study. This almost 2-hour, in-depth video by Rafal starts with an explanation of the three key uses of decision trees, which are: data classification, regression, and associative analysis, and then takes you on a comprehensive tour of this data mining algorithm, covering it in slides and detailed, hi-def demos, which you can follow. Once you try a decision tree a few times, you will realise how easy, and useful they are to help you understand any sets of data.

This 1-hour-20-minute video discusses the entire lifecycle of a Data Mining Model. You will learn how to build models and mining structures, starting by creating a Data Source and Data Source View, how to train it with your data, and how to view the results. Most importantly, you will also understand how to verify a model’s validity, by applying tests of accuracy, reliability, and usefulness. You will understand, and you will also see being used, such key verification techniques as: a Lift Chart, Profit Chart, Classification Matrix, and Cross Validation. Finally, you will see how to predict unknown outcomes using your model. Not only will you hear in-depth explanations, but you will also see 11 live demos, showing you all the aspects of working with Data Mining Models, including using SQL Server Data Tools (SSDT), and Microsoft Excel, for predicting (scoring) sales to future, potential customers, based on their demographic characteristics, and their shopping habits, just discovered using a Decision Tree, and a simple mining model.