topic AdventureWorks Database in QlikView

AdventureWorks Database

Sat, 20 Oct 2012 16:24:18 GMT

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.

Re: AdventureWorks Database

swuehl — Sun, 21 Oct 2012 11:17:58 GMT

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/

Re: AdventureWorks Database

Sun, 21 Oct 2012 11:25:03 GMT

Thanks swuehl! I will look into those!

Re: AdventureWorks Database

alan_richmond — Fri, 20 Jun 2014 00:11:59 GMT

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);

Re: AdventureWorks Database

Anonymous — Fri, 20 Jun 2014 01:55:47 GMT

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