In practice, we create random samples in order to analyze a smaller amount of data for our model. Read below if you are unable to view the video walkthrough. Our goal is to create a random sample and to oversample the bike buyer source data. You will also need to attach the AdventureworksDW2012 data file to SQL Server which can be downloaded here: The assumption of this post is that you have already installed the data mining add-in for Excel and configured the add-in to be pointed at an instance of SQL Server with Analysis Services to which you have access rights.įor the example, we will be using a tutorial spreadsheet that can be found on Codeplex at: Today, I’m going to show you how to randomly sample and oversample data in less than 5 minutes with the Microsoft Excel data mining add-in. Excel at Data Mining – How to Randomly Sample Your DataĮxcel at Data Mining – How to Sample Your Data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |