AdventureWorks Database

[#1]

I am new to Qlikview and was wondering if the adventureworks.xls database is available to download somewhere? I would like to try and recreate the Sales Management and Customer Analysis Demo as a tool for learning this wonderful software.

[swuehl]

I am not sure if there is a Excel file called adventureworks,  I think you are referring to the Microsoft sample / demo database that ships with their MSSQL products.

You can download the demo DB from

http://msftdbprodsamples.codeplex.com/

see also

http://blog.sqlauthority.com/2010/05/01/sql-server-what-is-adventureworks/

There is also a free version of MSSQL server (Express) which you can download from the MS site.

http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Hope this helps,

Stefan

[#3]

Thanks swuehl! I will look into those!

[alan_richmond]

Hi no-one seems to be anwering this question and its been asked in a number of places.  The Sales Management and Customer Analysis demo uses both the Adventureworks database, easy to find at codeplex but also uses Adventureworks.xls as below.  Where can we download the Adventureworks.xls?

LOAD
  ProductCategoryID,
     Name as ProductCategoryName
FROM
[..\Database\AdventureWorks.xls]
(biff, embedded labels, table is ProductCategory$)
WHERE EXISTS(ProductCategoryID);

[Anonymous]

Hi,

Just want to share my thoughts here. I am always utilizing Qlik Demo in two different ways for my internal customer demonstration.

1) Create two copy of the demo, use one copy as a binary load, change the data by using mapping load and resident load which suits our customer needs.

2) If there are few tables in the demo, export those tables in excel, change the data as per customer requirement, replace the existing demo qvd/db table with newly created excel.

Of course, I have to change or add few things as well e.g logo, label, introduction but this is saving lots of my time.

Satya