Adventure Works Sample Data Warehouse. The following sections provide more information about the data warehouse itself and about the scenarios that it supports Adventure. Program Check Motherboard Model: Software Free Download. Works. DW2. 00. 8R2 contains a subset of the tables from the OLTP database, in addition to financial information that is pulled from a separate data source. The data is kept in synch with the OLTP database to support typical Integration Services scenarios such as loading and updating the data warehouse. The AWData. Warehouse. Install Sample Database Report Wizard Launch Create Data. We will use the AdventureWorksLT sample database as the data source for the reports we build in this. Adventureworks sample database launched with SQL Server 2012 and you can download it from the codeplex. Install Sample Database Adventureworks in SQL Server 2012. Windows Server 2012 resources Programs. AdventureworksLT 2014. AdventureworksLT 2014 database for practice Other sample databases and tutorials included with Adventure Works for SQL Server 2012 can be found at httpmsftdbprodsamples. Windows-Live-Writer/46ab1e3ba96e_C4D4/clip_image003_2.png' alt='Adventureworks Database Sql 2012' title='Adventureworks Database Sql 2012' />Refresh Package sample demonstrates how to use an Integration Services package to load data into Adventure. Works. DW2. 00. 8R2 from the Adventure. Works. 20. 08. R2 OLTP database. Adventure. Works. DW2. 00. 8R2 contains two subject areas, finance and sales, which are described in the following sections. Additionally, the data warehouse contains views that are used to support the data mining scenarios that are described later in this topic. Finance. The finance subject area of the data warehouse is broken down into two schemas that have the following characteristics Finance. It seems the LT version is no longer available. The 2012 wont work with 2008R2Express due to version differences. Where can I get the LT version Finding the Correct Version of the AdventureWorks SQL Server. AdventureWorksLT. Through the. Contains finance data for Adventure Works corporate and its subsidiaries. Contains data in the local currency of the organization to which it is associated. Supports the Analysis Services Finance measure group. Currency Rates. Contains currency conversion data, including daily average rates and end of day rates in relationship to the United States Dollar USD. Supports the Analysis Services Currency Rates measure group. Sales. The sales subject area is broken down into four schemas with the following characteristics Reseller Sales. OuBbEPJctQ/T32_1qOt5DI/AAAAAAAAAGc/DrAC9nDnQ1U/s1600/attach.png' alt='Adventureworkslt 2014 Download' title='Adventureworkslt 2014 Download' />Contains sales only to resellers. Contains only shipped orders. Contains data in USD and tracks original currency. Supports the Analysis Services Reseller Sales measure group. Sales Summary. Contains a summary view of the reseller and Internet sales data. Has reduced dimensionality compared to the reseller and Internet sales schemas. Internet Sales. Contains individual customer Internet sales order and detail data. Sql Sample DatabaseContains only shipped orders. Contains data in USD and tracks original currency. Supports the Analysis Services Internet Sales measure group. Sales Quota. Contains sales quota data for sales representatives. Supports the Analysis Services Sales Quota measure group. The Internet sales tables have been trended to support data mining scenarios, whereas the other tables have been trended to support OLAP scenarios. Back to Top. The trending in the Adventure. Works. DW2. 00. 8R2 database supports the following data mining scenarios Forecasting Supports the scenario of an analyst investigating the growth of bicycle models by time and region. New-Picture-1.jpg' alt='Adventureworkslt 2012' title='Adventureworkslt 2012' />Targeted Mailing Campaign Supports the scenario of an analyst applying various data mining algorithms to Adventure Works customer and Internet sales data to determine the demographic attributes of customers who are likely to purchase a bicycle. The analyst can then apply the data mining model to a list of potential customers in order to determine which customers are most likely to respond to a targeted mailing that promotes Adventure Works bikes. Market Basket Analysis Supports the scenario of a developer creating a market basket solution that suggests a product based on other products that already exist in a customers shopping cart. Sequence Clustering Supports the scenario of an analyst investigating the sequence in which customers put items in a shopping cart. These scenarios and the trending in the data warehouse are demonstrated in the Data Mining Tutorial in SQL Server Books Online and in the Adventure Works DW sample project. For More Information Basic Data Mining Tutorial. Back to Top. The trending in the Adventure Works DW database supports the following data mining scenarios Financial Scenarios. Financial Reporting Supports the scenario of reporting income statements and balance sheets that include all subsidiaries. Also supports the ability to report the financial data in a specified local currency. Actual versus Budget Supports the scenario of analyzing actual expenses against budgeted expenses. Sales Scenarios. Product Profitability Analysis Supports the scenario of analyzing the product sales margin by tracking costs, discounts, and selling prices. Sales Force Performance Supports the scenario of tracking the variance between sales quotas and actual sales. Trend and Growth Analysis Supports the scenario of analyzing how the current period compares to prior periods in terms of sales. Promotion Effectiveness Supports the scenario of analyzing how promotions affect sales performance. These scenarios and the trending in the data warehouse are demonstrated in the Analysis Services Tutorial in SQL Server Books Online and in the Adventure. Golden Ratio Face Mask Program. Works. DW2. 00. 8R2 sample project.