Microsoft Contoso BI Demo Dataset for Retail Industry

    Select Language:
    A fictitious retail demo dataset used for presenting Microsoft Business Intelligence products.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.

      Version 2.1

      File Name:



      Date Published:


      File Size:

      626.5 MB

      433.4 MB

        The Contoso BI Demo dataset is used to demonstrate DW/BI functionalities across the entire Microsoft Office product family. This dataset includes C-level, sales/marketing, IT, and common finance scenarios for the retail industry and support map integration. In addition, this dataset offers large volumes of transactions from OLTP and well-structured aggregations from OLAP, along with reference and dimension data.
    • Supported Operating System

      Windows 7, Windows Server 2003, Windows Server 2008, Windows Vista

        Microsoft SQL Server 2008
      • To download the product:
        • Click the links below and save the two executable files to your hard disk.
        - ContosoBIdemoBAK.exe
        - ContosoBIdemoABF.exe

        To extract the components:
        1. Double-click each executable file to run the extraction process. Each time, you will be prompted to choose a location for the contents. Make sure that you save all of the components to the same directory on your hard disk.
        2. To start the extraction, click OK.
        3. After the extraction has completed, click OK.

        To restore and process the Contoso BI Demo dataset:
        1. Open SQL Server Management Studio, and select Database Engine.
        2. Enter the Server name and click Restore Database….
        3. Restore ContosoRetailDW.bak file to ContosoRetailDW database.
        5. Connect to Analysis Services in SQL Server Management Studio and restore ContosoRetail.abf backup file to Contoso_Retail OLAP database.
        6. Verify Data Sources of Contoso_Retail is connecting to ContosoRetailDW,
        7. Click Process.

    Popular downloads

      • 01

        Microsoft® SQL Server® 2012 Express

        Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 03

        Microsoft® SQL Server® 2008 Management Studio Express

        Microsoft SQL Server 2008 Management Studio Express is a free, integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server, as well as combining a broad group of graphical tools and rich script editors that provide access to SQL Server to developers and administrators of all skill levels.

      • 04

        Microsoft® SQL Server® 2014 Express

        Microsoft SQL Server 2014 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.

      • 05

        Microsoft Power Query for Excel

        Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial