Question about Chapter 4 of MacLennan et al book Data Mining w/ MS SQL Server 2008

Question

I'm a novitce with both Visual Studio and SQL Server - have both installed and going through MacLennan book - got through Chapter 1-3 and 5 - stuck on 4

cannot find a way to "1. Launch BI Dev Studio." - page 131 - I can launch Dev Studio ok but cannot find any reference to BI Dev Studio

on page 137 is says: "1. Download the MovieClick database and install it as described in Appendix A." - I downloaded the Chapter4.zip file ok and put it into its own directory since nowhere does it say where to put it - in spite of the directions, there are no instructions in Appendix A of how to "... install it ..." - I did extract all the files in the .zip file and was able to use Visual Studio (not the BI part that I can tell) to navigate to a MovieClick.dwproj file and open it which allowed me to eventually open the Solution Explorer window - however, I would like to walk through the book since this kind of ad hoc exploring often missing some imprortant ideas and procedures

so questions 1: how do I launch BI Dev Studio?
question 2: how do I download and install the Movie Click database?

thanks - peter j

Answer 1

Actually, I lied - I did not get through Chapter 3 ok - got stuck on page 109 - downloaded the query but cannot find a way to execute it - when it is loaded verbatim into a query window I get syntax errors and cannot find a way to resolved them - mpeterj

Answer 2

BI Dev Studio appears in the Microsoft SQL Server 2008 folder in the Program Menu.  If you launch Dev Studio after installing the SQL Server client components, you can follow the exact same instructions after launching Dev Studio (BI Dev Studio is just a set of extensions)

Apologies that the instructions aren't as clear as they could be.  Visit the wiley site as described in the book to download the database, which is provided as a SQL Server Backup file.  Use SQL Server Management Studio to connect to your relational database instance, and right click on the databases folder under your server name in Object Explorer.  Select Restore.  In the Restore Database dialog you need to select the "From Device" option, and then browse to select the backup file.

HTH
-Jamie

---

-- Jamie MacLennan -- SQL Server Data Mining -- http://blogs.msdn.com/jamiemac

Answer 3

Hi Jamie - I have got to Chapter 3 - page 95 - of your Sql Server 2008 book - and I cannot find the download for Chapter 3 on the Wiley web-site i.e. http://www.wiley.com/go/data_mining_sql_2008 returns: Page Not Found. I have looked on your web-site: http://www.sqlserverdatamining.com/ssdm/ and I cannot find it there either. Do you know where I can get this Chapter3.zip file from, please? Thanks. Cheers.

---

AB

Answer 4

Hi, Andy

Apparently, some of the URLs are not redirected properly. The complete list of downloads is available here
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470277742,descCd-DOWNLOAD.html

---

bogdan crivat [sql server data mining] / http://www.bogdancrivat.net/dm

Answer 5

Thanks Bogdan - I have checked that the URL works - downloaded the Chapter 3 zip file, restored the relational database and executed the DMX statements against a new SSAS database. Cheers.

---

AB

Answer 6

Hi, Jamie:

  Are the instructions on Page 137 of the book meant to be for a brand new blank project where there is no Analysis Service Database for the MovieCilck yet? And, therefore, we will have to be in offline mode initially to set up the data source?

Thank you,

Jorge