Data Mining Models in Excel Hands-On Examples

Data mining is about finding hidden patterns and associations in data. A large number of analyses that can only be performed by a human in a reasonable time if the amount of data is small, can be done by a computer in a very short time. Before Excel 2016, it was possible to install an add-in (called Data Mining) that was packed with different methods and models that could be used, mostly as black boxes, to get insights and discover information in any dataset. Microsoft then changed its policy and started migrating this capability to the cloud, first to Office 365 and, most recently, to Azure. It is also possible to calculate many things in Excel, with built-in functions and even with the help of macros programmed in Visual Basic Applications (VBA). Here, we will show two cases where data mining can help us find important information...