Free Data Mining Add-in for Ms Excel 2010 & 2013.

Microsoft release new data mining add-in for ms excel 2010 and 2013 both.These data mining add-ins work with SSAS (sql server nalysis services) and create predictive models.These add ins work well with big data all so and visualize data in ms visio.

Click on link for download Data Mining Add-in.

After you download these add in now open ms excel you can see the data mining tab click on this data mining tab,now you see the connection button click on this button beacuse these add in work with SSAS Ms SQL Server .

 Connect to SSAS new window open write the server name and select catalog name is the default database where you data sets and data models deploy and process.

No comments

Posted at 3:03 PM |  by Unknown

Free Download and Install MS SQL server 2012 Adventure works 2012 Database.

Adventure works 2012 Database is a sample database which is mostly use for learning purpose .These databases is updating by Microsoft along with the new release of MS SQL Server come.

Click on Links to download Adventure works Databases.

AdventureWorks2012_Database.zip

AdventureWorksDW for SQL Server 2012..zip

AdventureWorksLT2012_Database.zip

Attach AW databases to MS SQL Server step by step.

1. first to login with sql server instance.

2. Then right click on databases.

3. click the add button and a new window will open and locate  a AW databases files (save AW database files where you install ms sql server for fast performence other wise you allso save this data base file in other drive or use smoothly) . and click on ok botton.

 Note: during attach datafiles only shows .mdf files not log file beacuse it create .log file automatecully.

4. finsh process.

No comments

Posted at 4:08 AM |  by Unknown