guides to setting up for labs/project using dw with...
TRANSCRIPT
Guides to Setting Up for Labs/Project Using DW with OLAP
Phase 1: Preparation of Labs/Project
1. Downloads and Installations
1. Visual Studio 2012/2013 or higher
2. SQL Server 2012/2013 or higher
3. Microsoft SQL Server Data Tools (for Analysis Service) - Business Intelligence
(SSDT BI) for Visual Studio 2012/2013
4. Adventure Works (a Sample Data Warehouse) for SQL Server 2012/2014
For download and installation instructions: Downloading and Installation Guides and Set up Instructions are available on the class webpage. You can access each class webpage from my webpage: http://grail.csuohio.edu/~sschung/ Or To download SSDT-BI for Visual Studio https://msdn.microsoft.com/en-US/library/dn774148(v=sql.120).aspx Installation Guide for SSDT-BI https://msdn.microsoft.com/en-US/library/jj856966(v=sql.120).aspx
After successful installations, 1. Open Visual Studio
2. File -> New Project
3. You should see following BI add-ons which lets you create Data mining
projects.
a. Analysis Service
b. Integration Service
c. Reporting Service
Or
PHASE 2:
Downloading and Setting up a Sample Database/DW Adventure Works
2012 (or 2014) Data Warehouse for SQL Server 2012/2014
1. Go to Microsoft CodePlex site:
2. For Adventure Works DW Databases – 2012
http://msftdbprodsamples.codeplex.com/
3. For Adventure Works DW Databases – 2014
http://msftdbprodsamples.codeplex.com/releases/
4. Download Adventure Works DW Databases – 2012 or higher
Choose Either 2012 SQL Server DW 2012/2014
or 2012 SQL Server OLAP 2012/2014
5. Restore database in SQL Server 2012/2014.
6. There are two different ways to restore Adventure Works DW in your SQL Server
6-1) Simpler Way:
- When you downloaded Adventure Works DW 2012 and restoring the DW in SQL
Server 2012, See the instruction to follow at:
1) Attach the Adventure Work 2012
2) Download the zip file from this website
http://msftdbprodsamples.codeplex.com/releases/view/105902
3) After downloading, unzip the folder and then copy the .mdf file and .ldf file in this
directory - C:\Program Files\Microsoft SQL
Server\MSSQL11.SS2012\MSSQL\DATA (If you don’t put them in this
directory you will get an error when attaching the files).
Or
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA
4) Right click on the database and choose attach.
5) The attach database page appears
6) Click the Add button and then browse for adventure work file
7) Then Click OK
8) On the object explorer expand the Databases and then expand the
AdventureWorksDW2012. You will get:
7. After the step 6, you should see the following tables or the similar.
Step 6-2: A Professional Way:
- When you downloaded Adventure Works DW 2014 and restoring the DW in SQL
Server 2014 at:
http://msftdbprodsamples.codeplex.com/releases/
Download the following:
Adventure Works 2014 Warehouse Script.zip
Make sure you have instawdb.sql in the downloaded files.
Find the readme file below in the site and See the instruction (Readme file) to
follow at:
Readme for Adventure Works 2014 Sample Databases.docx
7. After the step 6, you should see the following tables or the similar.
References
• http://msftdbprodsamples.codeplex.com/releases/
• https://msdn.microsoft.com/en-us/library/ms143708(v=sql.120).aspx
• https://msdn.microsoft.com/en-us/library/mt204009.aspx
• http://msftdbprodsamples.codeplex.com/releases/view/105902
• http://www.codeproject.com/Articles/658912/Create-First-OLAP-Cube-in-SQL-Server-
Analysis-Serv
• http://www.codeproject.com/Articles/710387/Learn-to-Write-Custom-MDX-Query-
First-Time
• http://msdn.microsoft.com/en-IN/library/ms175595.aspx
• http://marktab.net/datamining/2010/08/21/mining-olap-cubes
• http://www.erpsoftwareblog.com/2014/04/using-ssas-sql-server-analysis-services-
data-mining-to-automate-marketing-analysis-part-1/
• http://msdn.microsoft.com/en-us/library/cc280440.aspx
• https://msdn.microsoft.com/en-us/library/cc879271.aspx
• https://msdn.microsoft.com/en-us/library/jj856966.aspx
• https://msdn.microsoft.com/en-us/library/mt204009.aspx